PREVIEW / etf_1hour / 2002-04-23

all etf 1-hour files

  file:    by_date/etf_1hour/2002/2002-04-23.parquet
  size:    14 KB
  rows:    306

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
2002-04-23 09:00:00	SPY	ETF	111.09	111.48	110.73	111.4	2943800.0
2002-04-23 10:00:00	SPY	ETF	111.41	111.48	110.85	111.31	2757700.0
2002-04-23 11:00:00	SPY	ETF	111.27	111.45	111.0	111.09	1255000.0
2002-04-23 12:00:00	SPY	ETF	111.06	111.31	110.75	110.89	2537900.0
2002-04-23 13:00:00	SPY	ETF	110.9	111.35	110.85	111.08	1404600.0
2002-04-23 14:00:00	SPY	ETF	111.1	111.27	110.81	111.05	1320000.0
2002-04-23 15:00:00	SPY	ETF	111.04	111.05	110.17	110.38	3091700.0
2002-04-23 16:00:00	SPY	ETF	110.36	110.59	110.28	110.55	1030300.0
2002-04-23 17:00:00	SPY	ETF	110.55	110.63	110.55	110.6	3900.0
2002-04-23 18:00:00	SPY	ETF	110.57	110.7	110.57	110.7	4200.0
2002-04-23 09:00:00	QQQ	ETF	33.59	33.78	33.41	33.73	8506600.0
2002-04-23 10:00:00	QQQ	ETF	33.74	33.77	33.36	33.59	11495400.0
2002-04-23 11:00:00	QQQ	ETF	33.59	33.66	33.44	33.47	4059900.0
2002-04-23 12:00:00	QQQ	ETF	33.46	33.55	33.17	33.24	7821000.0
2002-04-23 13:00:00	QQQ	ETF	33.25	33.4	33.18	33.24	4319600.0
2002-04-23 14:00:00	QQQ	ETF	33.24	33.38	33.1	33.22	6072400.0
2002-04-23 15:00:00	QQQ	ETF	33.22	33.25	32.7	32.86	26981500.0
2002-04-23 16:00:00	QQQ	ETF	32.88	33.02	32.76	32.96	2107400.0
2002-04-23 17:00:00	QQQ	ETF	32.96	33.5	32.95	33.04	138000.0
2002-04-23 18:00:00	QQQ	ETF	33.04	33.12	33.04	33.12	42600.0
2002-04-23 09:00:00	IWM	ETF	50.8	51.0	50.73	51.0	301000.0
2002-04-23 10:00:00	IWM	ETF	50.95	51.04	50.86	51.01	298600.0
2002-04-23 11:00:00	IWM	ETF	51.01	51.02	50.9	50.96	28200.0
2002-04-23 12:00:00	IWM	ETF	50.96	50.99	50.81	50.855	68400.0
2002-04-23 13:00:00	IWM	ETF	50.87	51.035	50.865	50.945	48400.0
2002-04-23 14:00:00	IWM	ETF	51.0	51.0	50.88	51.0	47000.0
2002-04-23 15:00:00	IWM	ETF	50.995	50.995	50.7	50.8	95600.0
2002-04-23 16:00:00	IWM	ETF	50.865	50.95	50.79	50.79	905600.0
2002-04-23 09:00:00	DIA	ETF	101.55	101.8	100.96	101.78	855400.0
2002-04-23 10:00:00	DIA	ETF	101.72	101.88	101.26	101.66	520100.0
2002-04-23 11:00:00	DIA	ETF	101.71	101.82	101.47	101.6	153100.0
2002-04-23 12:00:00	DIA	ETF	101.56	101.85	101.3	101.42	167200.0
2002-04-23 13:00:00	DIA	ETF	101.42	101.72	101.3	101.46	757300.0
2002-04-23 14:00:00	DIA	ETF	101.46	101.73	101.3	101.57	258600.0
2002-04-23 15:00:00	DIA	ETF	101.52	101.6	100.72	100.93	553900.0
2002-04-23 16:00:00	DIA	ETF	100.93	101.86	100.87	101.2	150900.0
2002-04-23 17:00:00	DIA	ETF	101.08	101.08	101.08	101.08	200.0

> showing 37 of 306 rows — these rows as CSV

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