PREVIEW / etf_1hour / 2001-12-31

all etf 1-hour files

  file:    by_date/etf_1hour/2001/2001-12-31.parquet
  size:    13 KB
  rows:    293

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
2001-12-31 09:00:00	SPY	ETF	116.15	116.39	116.01	116.32	1421000.0
2001-12-31 10:00:00	SPY	ETF	116.29	116.31	115.66	115.98	2650500.0
2001-12-31 11:00:00	SPY	ETF	115.99	116.04	115.79	115.96	1047400.0
2001-12-31 12:00:00	SPY	ETF	115.96	116.07	115.75	115.84	1019300.0
2001-12-31 13:00:00	SPY	ETF	115.85	116.24	115.78	116.22	1805700.0
2001-12-31 14:00:00	SPY	ETF	116.22	116.24	115.75	115.77	722400.0
2001-12-31 15:00:00	SPY	ETF	115.8	115.96	114.85	114.89	3139900.0
2001-12-31 16:00:00	SPY	ETF	114.85	115.06	114.2	114.37	2321100.0
2001-12-31 17:00:00	SPY	ETF	114.23	114.3	114.2	114.3	400.0
2001-12-31 18:00:00	SPY	ETF	114.31	114.44	114.31	114.44	700.0
2001-12-31 09:00:00	QQQ	ETF	40.31	40.45	40.14	40.4	6084100.0
2001-12-31 10:00:00	QQQ	ETF	40.4	40.44	39.83	40.01	7199800.0
2001-12-31 11:00:00	QQQ	ETF	40.03	40.05	39.9	40.02	3161500.0
2001-12-31 12:00:00	QQQ	ETF	40.03	40.11	39.93	40.0	3646500.0
2001-12-31 13:00:00	QQQ	ETF	40.0	40.09	39.95	40.04	1823500.0
2001-12-31 14:00:00	QQQ	ETF	40.03	40.05	39.7	39.74	5977100.0
2001-12-31 15:00:00	QQQ	ETF	39.74	39.85	39.21	39.21	14188100.0
2001-12-31 16:00:00	QQQ	ETF	39.25	39.85	38.91	39.07	3846800.0
2001-12-31 17:00:00	QQQ	ETF	39.07	39.2	39.02	39.15	38200.0
2001-12-31 18:00:00	QQQ	ETF	39.15	39.17	39.1	39.17	4800.0
2001-12-31 09:00:00	IWM	ETF	49.125	49.125	48.65	48.935	191600.0
2001-12-31 10:00:00	IWM	ETF	48.91	48.925	48.45	48.675	346200.0
2001-12-31 11:00:00	IWM	ETF	48.695	48.94	48.605	48.94	508600.0
2001-12-31 12:00:00	IWM	ETF	48.865	48.96	48.81	48.94	317800.0
2001-12-31 13:00:00	IWM	ETF	48.94	49.015	48.86	49.0	35800.0
2001-12-31 14:00:00	IWM	ETF	49.0	49.085	48.95	49.04	266600.0
2001-12-31 15:00:00	IWM	ETF	48.99	49.2	48.45	48.45	326600.0
2001-12-31 16:00:00	IWM	ETF	48.4	48.5	48.175	48.175	349000.0
2001-12-31 09:00:00	DIA	ETF	101.34	101.47	101.2	101.39	373700.0
2001-12-31 10:00:00	DIA	ETF	101.36	101.4	100.95	101.12	367900.0
2001-12-31 11:00:00	DIA	ETF	101.18	101.22	100.95	101.13	80800.0
2001-12-31 12:00:00	DIA	ETF	101.1	101.22	100.88	100.92	104800.0
2001-12-31 13:00:00	DIA	ETF	100.9	101.24	100.88	101.21	191000.0
2001-12-31 14:00:00	DIA	ETF	101.16	101.23	100.83	100.83	48700.0
2001-12-31 15:00:00	DIA	ETF	100.85	101.0	100.18	100.24	298100.0
2001-12-31 16:00:00	DIA	ETF	100.23	100.67	99.65	99.88	258300.0
2001-12-31 17:00:00	DIA	ETF	95.75	95.75	95.75	95.75	500.0

> showing 37 of 293 rows — these rows as CSV

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