PREVIEW / etf_30min / 2008-10-16

all etf 30-min files

  file:    by_date/etf_30min/2008/2008-10-16.parquet
  size:    182 KB
  rows:    6,377

schema

  timestamp    TIMESTAMP
  symbol       VARCHAR
  asset_type   VARCHAR
  open         DOUBLE
  high         DOUBLE
  low          DOUBLE
  close        DOUBLE
  volume       DOUBLE

sample rows

timestamp	symbol	asset_type	open	high	low	close	volume
2008-10-16 04:00:00	SPY	ETF	91.16	91.4	91.02	91.02	3800.0
2008-10-16 04:30:00	SPY	ETF	90.89	91.78	90.83	91.78	1200.0
2008-10-16 05:00:00	SPY	ETF	91.34	91.45	91.25	91.25	2700.0
2008-10-16 05:30:00	SPY	ETF	90.95	90.97	89.98	89.98	6095.0
2008-10-16 06:00:00	SPY	ETF	90.0	91.52	90.0	91.52	23600.0
2008-10-16 06:30:00	SPY	ETF	91.02	91.67	90.82	91.66	201199.0
2008-10-16 07:00:00	SPY	ETF	91.64	91.75	90.88	91.36	760981.0
2008-10-16 07:30:00	SPY	ETF	91.28	91.54	90.07	90.34	1246807.0
2008-10-16 08:00:00	SPY	ETF	90.48	91.31	88.8	90.45	1991028.0
2008-10-16 08:30:00	SPY	ETF	90.45	92.83	90.45	92.2	9760571.0
2008-10-16 09:00:00	SPY	ETF	92.18	92.49	90.84	91.29	9161162.0
2008-10-16 09:30:00	SPY	ETF	91.29	92.59	89.78	91.71	74945460.0
2008-10-16 10:00:00	SPY	ETF	91.7	91.76	88.71	89.05	71152334.0
2008-10-16 10:30:00	SPY	ETF	89.03	91.2699	87.74	87.82	56677166.0
2008-10-16 11:00:00	SPY	ETF	87.82	88.71	86.54	87.3907	48730747.0
2008-10-16 11:30:00	SPY	ETF	87.4	89.84	87.39	89.25	45587312.0
2008-10-16 12:00:00	SPY	ETF	89.23	92.09	88.52	90.54	64332106.0
2008-10-16 12:30:00	SPY	ETF	90.54	91.601	89.47	89.68	44315766.0
2008-10-16 13:00:00	SPY	ETF	89.68	92.56	89.38	90.02	41906148.0
2008-10-16 13:30:00	SPY	ETF	90.02	91.992	89.05	90.7201	35052357.0
2008-10-16 14:00:00	SPY	ETF	90.73	90.94	89.21	89.67	30810206.0
2008-10-16 14:30:00	SPY	ETF	89.68	91.69	87.8	91.07	36215175.0
2008-10-16 15:00:00	SPY	ETF	91.06	93.55	90.76	93.06	52388828.0
2008-10-16 15:30:00	SPY	ETF	93.0699	94.77	92.09	94.41	56433568.0
2008-10-16 16:00:00	SPY	ETF	94.41	94.67	89.5877	93.97	14969377.0
2008-10-16 16:30:00	SPY	ETF	93.93	93.97	90.8226	93.9	6822182.0
2008-10-16 17:00:00	SPY	ETF	93.9	94.17	93.88	94.11	1478253.0
2008-10-16 17:30:00	SPY	ETF	94.08	94.25	94.02	94.19	1103331.0
2008-10-16 18:00:00	SPY	ETF	94.19	94.37	94.14	94.27	84330.0
2008-10-16 18:30:00	SPY	ETF	94.26	94.44	94.26	94.36	45686.0
2008-10-16 19:00:00	SPY	ETF	94.38	94.41	94.27	94.28	67455.0
2008-10-16 19:30:00	SPY	ETF	94.32	94.36	94.02	94.2	94862.0
2008-10-16 04:30:00	QQQ	ETF	30.48	30.73	30.48	30.73	700.0
2008-10-16 05:00:00	QQQ	ETF	30.72	30.74	30.45	30.45	13850.0
2008-10-16 05:30:00	QQQ	ETF	30.38	30.38	30.06	30.21	3700.0
2008-10-16 06:00:00	QQQ	ETF	30.3	30.6	30.3	30.52	10126.0
2008-10-16 06:30:00	QQQ	ETF	30.51	30.67	30.46	30.67	40400.0
2008-10-16 07:00:00	QQQ	ETF	30.63	30.68	30.5	30.59	65148.0
2008-10-16 07:30:00	QQQ	ETF	30.59	30.68	30.21	30.29	202985.0
2008-10-16 08:00:00	QQQ	ETF	30.26	30.41	30.2	30.3	652356.0
2008-10-16 08:30:00	QQQ	ETF	30.31	31.15	30.31	30.93	3921031.0
2008-10-16 09:00:00	QQQ	ETF	30.93	31.03	30.61	30.82	2929092.0
2008-10-16 09:30:00	QQQ	ETF	30.82	31.33	30.4	31.07	52732309.0
2008-10-16 10:00:00	QQQ	ETF	31.07	31.08	29.88	29.95	51275023.0
2008-10-16 10:30:00	QQQ	ETF	29.94	30.26	29.61	29.76	35959640.0
2008-10-16 11:00:00	QQQ	ETF	29.77	29.94	29.25	29.74	32982352.0
2008-10-16 11:30:00	QQQ	ETF	29.74	30.64	29.73	30.43	32366674.0
2008-10-16 12:00:00	QQQ	ETF	30.43	31.43	30.17	30.9	42242401.0
2008-10-16 12:30:00	QQQ	ETF	30.9	31.13	30.48	30.57	25326549.0
2008-10-16 13:00:00	QQQ	ETF	30.57	30.99	30.36	30.6899	22586700.0

> showing 50 of 6,377 rows — these rows as CSV

> unlock the full archive -- $79 one-time