PREVIEW / etf_1hour / 2002-05-06

all etf 1-hour files

  file:    by_date/etf_1hour/2002/2002-05-06.parquet
  size:    14 KB
  rows:    318

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-05-06 09:00:00	SPY	ETF	107.64	107.99	107.28	107.7	4090500.0
2002-05-06 10:00:00	SPY	ETF	107.7	107.93	107.36	107.66	2676200.0
2002-05-06 11:00:00	SPY	ETF	107.64	107.87	107.37	107.51	1243800.0
2002-05-06 12:00:00	SPY	ETF	107.51	107.63	107.3	107.42	717000.0
2002-05-06 13:00:00	SPY	ETF	107.46	107.66	106.94	107.07	2348500.0
2002-05-06 14:00:00	SPY	ETF	107.06	107.19	106.72	106.8	2061100.0
2002-05-06 15:00:00	SPY	ETF	106.79	106.9	105.51	105.62	6098100.0
2002-05-06 16:00:00	SPY	ETF	105.62	105.63	105.31	105.59	3062700.0
2002-05-06 17:00:00	SPY	ETF	105.53	105.53	105.49	105.5	6300.0
2002-05-06 18:00:00	SPY	ETF	105.53	105.53	104.71	104.71	275200.0
2002-05-06 09:00:00	QQQ	ETF	29.63	29.98	29.37	29.76	17519600.0
2002-05-06 10:00:00	QQQ	ETF	29.76	29.9	29.49	29.7	20956100.0
2002-05-06 11:00:00	QQQ	ETF	29.7	29.89	29.65	29.81	6471700.0
2002-05-06 12:00:00	QQQ	ETF	29.8	29.9	29.71	29.84	4714700.0
2002-05-06 13:00:00	QQQ	ETF	29.85	29.98	29.55	29.65	8557500.0
2002-05-06 14:00:00	QQQ	ETF	29.64	29.69	29.4	29.48	9822100.0
2002-05-06 15:00:00	QQQ	ETF	29.48	29.54	28.85	28.9	24091600.0
2002-05-06 16:00:00	QQQ	ETF	28.91	28.98	28.88	28.92	2676700.0
2002-05-06 17:00:00	QQQ	ETF	28.93	28.94	28.87	28.88	135500.0
2002-05-06 18:00:00	QQQ	ETF	28.87	28.92	28.86	28.9	22200.0
2002-05-06 09:00:00	IWM	ETF	50.995	51.16	50.9	51.055	134400.0
2002-05-06 10:00:00	IWM	ETF	51.055	51.065	50.915	50.915	94400.0
2002-05-06 11:00:00	IWM	ETF	50.95	50.995	50.84	50.9	130400.0
2002-05-06 12:00:00	IWM	ETF	50.915	50.915	50.81	50.855	107000.0
2002-05-06 13:00:00	IWM	ETF	50.815	50.875	50.67	50.735	154400.0
2002-05-06 14:00:00	IWM	ETF	50.73	50.735	50.5	50.54	398800.0
2002-05-06 15:00:00	IWM	ETF	50.475	50.48	50.0	50.0	720800.0
2002-05-06 16:00:00	IWM	ETF	49.99	50.07	49.975	50.07	976800.0
2002-05-06 09:00:00	DIA	ETF	99.96	100.34	99.74	100.1	415700.0
2002-05-06 10:00:00	DIA	ETF	100.13	100.19	99.7	99.94	359600.0
2002-05-06 11:00:00	DIA	ETF	99.9	100.1	99.76	99.89	104200.0
2002-05-06 12:00:00	DIA	ETF	99.9	99.94	99.64	99.73	123900.0
2002-05-06 13:00:00	DIA	ETF	99.74	99.98	99.38	99.52	436000.0
2002-05-06 14:00:00	DIA	ETF	99.46	99.54	99.2	99.31	618400.0
2002-05-06 15:00:00	DIA	ETF	99.3	99.33	98.06	98.26	2188200.0
2002-05-06 16:00:00	DIA	ETF	98.15	98.25	97.96	98.1	421900.0
2002-05-06 17:00:00	DIA	ETF	98.2	98.2	98.15	98.15	1200.0
2002-05-06 18:00:00	DIA	ETF	98.17	98.17	98.17	98.17	15000.0

> showing 38 of 318 rows — these rows as CSV

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