PREVIEW / etf_1hour / 2001-08-01

all etf 1-hour files

  file:    by_date/etf_1hour/2001/2001-08-01.parquet
  size:    11 KB
  rows:    221

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-08-01 09:00:00	SPY	ETF	121.97	122.0	121.55	121.96	1250700.0
2001-08-01 10:00:00	SPY	ETF	121.97	122.47	121.85	122.19	1576100.0
2001-08-01 11:00:00	SPY	ETF	122.24	122.52	122.18	122.35	2015100.0
2001-08-01 12:00:00	SPY	ETF	122.36	122.7	122.32	122.55	919300.0
2001-08-01 13:00:00	SPY	ETF	122.57	122.58	122.22	122.3	911400.0
2001-08-01 14:00:00	SPY	ETF	122.29	122.3	121.57	121.68	1790300.0
2001-08-01 15:00:00	SPY	ETF	121.68	122.15	121.59	121.96	2263300.0
2001-08-01 16:00:00	SPY	ETF	121.95	122.14	121.95	122.12	963400.0
2001-08-01 17:00:00	SPY	ETF	122.13	122.13	122.1	122.1	400.0
2001-08-01 18:00:00	SPY	ETF	122.3	122.3	122.18	122.18	1000.0
2001-08-01 09:00:00	QQQ	ETF	42.63	42.85	42.41	42.83	8149200.0
2001-08-01 10:00:00	QQQ	ETF	42.84	43.19	42.7	42.94	10668800.0
2001-08-01 11:00:00	QQQ	ETF	42.95	43.21	42.92	43.13	4873600.0
2001-08-01 12:00:00	QQQ	ETF	43.15	43.5	43.09	43.36	5434600.0
2001-08-01 13:00:00	QQQ	ETF	43.37	43.39	43.01	43.1	5729700.0
2001-08-01 14:00:00	QQQ	ETF	43.14	43.15	42.66	42.73	7033000.0
2001-08-01 15:00:00	QQQ	ETF	42.75	43.17	42.72	43.05	6513800.0
2001-08-01 16:00:00	QQQ	ETF	43.04	43.22	43.0	43.18	1203900.0
2001-08-01 17:00:00	QQQ	ETF	43.19	43.22	43.09	43.18	41500.0
2001-08-01 18:00:00	QQQ	ETF	43.24	43.24	43.17	43.17	2800.0
2001-08-01 09:00:00	IWM	ETF	48.525	48.525	48.225	48.495	38000.0
2001-08-01 10:00:00	IWM	ETF	48.5	48.695	48.5	48.64	15600.0
2001-08-01 11:00:00	IWM	ETF	48.64	48.825	48.64	48.79	40200.0
2001-08-01 12:00:00	IWM	ETF	48.85	48.9	48.85	48.9	4400.0
2001-08-01 13:00:00	IWM	ETF	48.8	48.85	48.65	48.73	250200.0
2001-08-01 14:00:00	IWM	ETF	48.63	48.795	48.555	48.555	14000.0
2001-08-01 15:00:00	IWM	ETF	48.6	48.795	48.525	48.795	56800.0
2001-08-01 16:00:00	IWM	ETF	48.75	48.85	48.75	48.85	7600.0
2001-08-01 09:00:00	DIA	ETF	105.78	105.78	105.27	105.64	357400.0
2001-08-01 10:00:00	DIA	ETF	105.6	106.0	105.5	105.71	305300.0
2001-08-01 11:00:00	DIA	ETF	105.71	105.98	105.7	105.83	151200.0
2001-08-01 12:00:00	DIA	ETF	105.84	106.06	105.79	105.88	156800.0
2001-08-01 13:00:00	DIA	ETF	105.91	105.91	105.59	105.62	220900.0
2001-08-01 14:00:00	DIA	ETF	105.62	105.62	105.0	105.1	368700.0
2001-08-01 15:00:00	DIA	ETF	105.08	105.46	104.87	105.06	368000.0
2001-08-01 16:00:00	DIA	ETF	105.15	105.39	105.15	105.3	130100.0

> showing 36 of 221 rows — these rows as CSV

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