PREVIEW / etf_30min / 2008-05-23

all etf 30-min files

  file:    by_date/etf_30min/2008/2008-05-23.parquet
  size:    165 KB
  rows:    5,785

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-05-23 04:00:00	SPY	ETF	138.93	139.01	138.88	138.88	5800.0
2008-05-23 04:30:00	SPY	ETF	138.84	138.84	138.84	138.84	500.0
2008-05-23 05:00:00	SPY	ETF	138.98	138.98	138.98	138.98	600.0
2008-05-23 05:30:00	SPY	ETF	139.0	139.0	139.0	139.0	50600.0
2008-05-23 06:00:00	SPY	ETF	139.06	139.09	139.01	139.01	50100.0
2008-05-23 06:30:00	SPY	ETF	138.98	139.0	138.85	138.99	332300.0
2008-05-23 07:00:00	SPY	ETF	138.98	139.13	138.85	138.9	298719.0
2008-05-23 07:30:00	SPY	ETF	138.91	139.17	138.87	139.17	190424.0
2008-05-23 08:00:00	SPY	ETF	139.17	139.18	138.89	139.02	1554213.0
2008-05-23 08:30:00	SPY	ETF	139.02	139.09	138.91	138.97	1199091.0
2008-05-23 09:00:00	SPY	ETF	138.97	139.05	138.95	139.03	468323.0
2008-05-23 09:30:00	SPY	ETF	139.05	139.2	138.4	138.56	18797800.0
2008-05-23 10:00:00	SPY	ETF	138.5695	138.77	138.27	138.29	17345809.0
2008-05-23 10:30:00	SPY	ETF	138.29	139.14	137.98	138.27	17919292.0
2008-05-23 11:00:00	SPY	ETF	138.27	138.28	137.68	137.89	12511232.0
2008-05-23 11:30:00	SPY	ETF	137.89	138.09	137.63	138.06	11582821.0
2008-05-23 12:00:00	SPY	ETF	138.05	138.21	137.93	138.022	6268050.0
2008-05-23 12:30:00	SPY	ETF	138.02	138.095	137.57	137.63	7930403.0
2008-05-23 13:00:00	SPY	ETF	137.62	137.96	137.6	137.845	8034904.0
2008-05-23 13:30:00	SPY	ETF	137.85	138.11	137.67	137.71	11187354.0
2008-05-23 14:00:00	SPY	ETF	137.7	139.6631	137.63	138.07	11686754.0
2008-05-23 14:30:00	SPY	ETF	138.05	138.32	137.87	138.092	10006104.0
2008-05-23 15:00:00	SPY	ETF	138.1	138.26	137.6	138.14	11214431.0
2008-05-23 15:30:00	SPY	ETF	138.14	138.38	137.8	137.87	17700696.0
2008-05-23 16:00:00	SPY	ETF	137.87	138.1	137.48	137.5	9158848.0
2008-05-23 16:30:00	SPY	ETF	137.5	137.6	137.42	137.49	302843.0
2008-05-23 17:00:00	SPY	ETF	137.47	137.55	137.43	137.47	85991.0
2008-05-23 17:30:00	SPY	ETF	137.49	137.61	137.4	137.46	57985.0
2008-05-23 18:00:00	SPY	ETF	137.58	137.65	137.56	137.56	12185.0
2008-05-23 18:30:00	SPY	ETF	137.65	137.65	137.57	137.63	1850.0
2008-05-23 19:00:00	SPY	ETF	137.6	137.68	137.6	137.66	1892.0
2008-05-23 19:30:00	SPY	ETF	137.67	137.67	137.66	137.67	2864.0
2008-05-23 04:00:00	QQQ	ETF	48.1	48.1	48.09	48.09	200.0
2008-05-23 06:00:00	QQQ	ETF	48.2	48.21	48.17	48.17	25000.0
2008-05-23 06:30:00	QQQ	ETF	48.13	48.14	48.11	48.11	4700.0
2008-05-23 07:00:00	QQQ	ETF	48.13	48.21	48.13	48.18	122949.0
2008-05-23 07:30:00	QQQ	ETF	48.16	48.28	48.15	48.28	205225.0
2008-05-23 08:00:00	QQQ	ETF	48.26	48.29	48.18	48.2	286924.0
2008-05-23 08:30:00	QQQ	ETF	48.2	48.2	48.16	48.16	295172.0
2008-05-23 09:00:00	QQQ	ETF	48.16	48.21	48.15	48.17	451170.0
2008-05-23 09:30:00	QQQ	ETF	48.18	48.31	48.13	48.17	14741114.0
2008-05-23 10:00:00	QQQ	ETF	48.17	48.35	48.12	48.23	9918775.0
2008-05-23 10:30:00	QQQ	ETF	48.2399	48.24	48.0	48.14	10682742.0
2008-05-23 11:00:00	QQQ	ETF	48.14	48.18	47.92	47.96	10190875.0
2008-05-23 11:30:00	QQQ	ETF	47.96	48.1	47.82	48.01	11986949.0
2008-05-23 12:00:00	QQQ	ETF	48.0	48.14	48.0	48.05	5377822.0
2008-05-23 12:30:00	QQQ	ETF	48.05	48.05	47.83	47.86	8899720.0
2008-05-23 13:00:00	QQQ	ETF	47.86	48.01	47.84	47.97	5052433.0
2008-05-23 13:30:00	QQQ	ETF	47.97	48.14	47.97	47.98	6655008.0
2008-05-23 14:00:00	QQQ	ETF	47.98	48.2	47.95	48.19	5291711.0

> showing 50 of 5,785 rows — these rows as CSV

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