PREVIEW / etf_1hour / 2001-07-23

all etf 1-hour files

  file:    by_date/etf_1hour/2001/2001-07-23.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-07-23 09:00:00	SPY	ETF	121.8	121.88	121.36	121.51	835500.0
2001-07-23 10:00:00	SPY	ETF	121.48	121.74	119.75	119.76	1347000.0
2001-07-23 11:00:00	SPY	ETF	119.81	120.23	119.7	120.17	1093100.0
2001-07-23 12:00:00	SPY	ETF	120.15	120.3	120.02	120.15	581400.0
2001-07-23 13:00:00	SPY	ETF	120.08	120.29	119.84	120.19	597900.0
2001-07-23 14:00:00	SPY	ETF	120.16	120.39	119.96	120.16	337700.0
2001-07-23 15:00:00	SPY	ETF	120.13	120.15	119.22	119.36	2156500.0
2001-07-23 16:00:00	SPY	ETF	119.39	119.4	118.95	119.35	762700.0
2001-07-23 17:00:00	SPY	ETF	119.01	119.24	119.01	119.24	400.0
2001-07-23 18:00:00	SPY	ETF	119.2	119.2	119.15	119.15	2000.0
2001-07-23 09:00:00	QQQ	ETF	42.24	42.4	41.91	42.02	6470900.0
2001-07-23 10:00:00	QQQ	ETF	42.0	42.23	41.01	41.05	12717100.0
2001-07-23 11:00:00	QQQ	ETF	41.05	41.36	40.89	41.3	8405800.0
2001-07-23 12:00:00	QQQ	ETF	41.3	41.38	41.08	41.29	4969900.0
2001-07-23 13:00:00	QQQ	ETF	41.31	41.5	41.12	41.4	3587900.0
2001-07-23 14:00:00	QQQ	ETF	41.39	41.47	41.06	41.2	3614600.0
2001-07-23 15:00:00	QQQ	ETF	41.17	41.2	40.55	40.64	9511800.0
2001-07-23 16:00:00	QQQ	ETF	40.62	40.75	40.57	40.69	2547200.0
2001-07-23 17:00:00	QQQ	ETF	40.71	40.71	40.58	40.66	111900.0
2001-07-23 18:00:00	QQQ	ETF	40.66	40.7	40.55	40.65	13900.0
2001-07-23 09:00:00	IWM	ETF	48.825	48.825	48.525	48.64	84000.0
2001-07-23 10:00:00	IWM	ETF	48.75	48.75	48.05	48.06	157600.0
2001-07-23 11:00:00	IWM	ETF	48.15	48.325	48.065	48.2	127600.0
2001-07-23 12:00:00	IWM	ETF	48.325	48.395	48.18	48.395	84200.0
2001-07-23 13:00:00	IWM	ETF	48.255	48.41	48.255	48.41	34400.0
2001-07-23 14:00:00	IWM	ETF	48.41	48.45	48.255	48.45	309400.0
2001-07-23 15:00:00	IWM	ETF	48.45	48.45	48.01	48.01	165400.0
2001-07-23 16:00:00	IWM	ETF	48.2	48.385	48.0	48.385	433200.0
2001-07-23 09:00:00	DIA	ETF	106.22	106.33	105.46	105.64	133600.0
2001-07-23 10:00:00	DIA	ETF	105.65	105.85	104.43	104.54	321400.0
2001-07-23 11:00:00	DIA	ETF	104.55	104.86	104.5	104.8	187800.0
2001-07-23 12:00:00	DIA	ETF	104.75	104.94	104.7	104.89	189600.0
2001-07-23 13:00:00	DIA	ETF	104.77	104.93	104.57	104.86	45400.0
2001-07-23 14:00:00	DIA	ETF	104.84	105.09	104.77	104.99	195200.0
2001-07-23 15:00:00	DIA	ETF	104.92	104.95	104.24	104.25	529300.0
2001-07-23 16:00:00	DIA	ETF	104.38	104.38	103.7	103.7	188200.0

> showing 36 of 221 rows — these rows as CSV

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