PREVIEW / etf_1hour / 2002-03-05

all etf 1-hour files

  file:    by_date/etf_1hour/2002/2002-03-05.parquet
  size:    14 KB
  rows:    311

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-03-05 09:00:00	SPY	ETF	115.33	115.75	115.15	115.7	2770300.0
2002-03-05 10:00:00	SPY	ETF	115.72	116.4	114.97	115.07	7168500.0
2002-03-05 11:00:00	SPY	ETF	115.14	115.6	115.11	115.37	1826100.0
2002-03-05 12:00:00	SPY	ETF	115.37	115.92	115.16	115.57	1506200.0
2002-03-05 13:00:00	SPY	ETF	115.59	115.8	115.27	115.48	1868900.0
2002-03-05 14:00:00	SPY	ETF	115.5	115.73	115.07	115.19	1785000.0
2002-03-05 15:00:00	SPY	ETF	115.19	115.55	114.97	115.21	3622500.0
2002-03-05 16:00:00	SPY	ETF	115.22	115.43	115.1	115.3	1282600.0
2002-03-05 17:00:00	SPY	ETF	115.29	115.34	115.22	115.32	24400.0
2002-03-05 18:00:00	SPY	ETF	115.17	115.17	115.17	115.17	500.0
2002-03-05 09:00:00	QQQ	ETF	36.93	37.5	36.81	37.45	14037300.0
2002-03-05 10:00:00	QQQ	ETF	37.46	37.87	36.99	37.09	29415400.0
2002-03-05 11:00:00	QQQ	ETF	37.09	37.43	37.04	37.21	8162200.0
2002-03-05 12:00:00	QQQ	ETF	37.25	37.74	37.16	37.53	7843700.0
2002-03-05 13:00:00	QQQ	ETF	37.54	37.64	37.23	37.44	7664200.0
2002-03-05 14:00:00	QQQ	ETF	37.41	37.6	37.15	37.19	7532300.0
2002-03-05 15:00:00	QQQ	ETF	37.19	37.48	37.06	37.27	11215100.0
2002-03-05 16:00:00	QQQ	ETF	37.29	37.57	37.13	37.33	1537500.0
2002-03-05 17:00:00	QQQ	ETF	37.28	37.33	37.18	37.19	97600.0
2002-03-05 18:00:00	QQQ	ETF	37.19	37.25	37.18	37.22	24700.0
2002-03-05 09:00:00	IWM	ETF	48.49	48.645	48.435	48.645	174600.0
2002-03-05 10:00:00	IWM	ETF	48.665	48.915	48.35	48.35	336200.0
2002-03-05 11:00:00	IWM	ETF	48.355	48.57	48.355	48.5	30000.0
2002-03-05 12:00:00	IWM	ETF	48.51	48.775	48.5	48.645	93200.0
2002-03-05 13:00:00	IWM	ETF	48.75	48.75	48.56	48.635	176400.0
2002-03-05 14:00:00	IWM	ETF	48.6	48.7	48.5	48.5	89600.0
2002-03-05 15:00:00	IWM	ETF	48.55	48.65	48.42	48.61	407600.0
2002-03-05 16:00:00	IWM	ETF	48.56	48.56	48.56	48.56	15000.0
2002-03-05 09:00:00	DIA	ETF	105.35	105.77	105.25	105.65	612300.0
2002-03-05 10:00:00	DIA	ETF	105.56	106.2	104.8	104.88	2792800.0
2002-03-05 11:00:00	DIA	ETF	104.86	105.21	104.84	105.01	1406600.0
2002-03-05 12:00:00	DIA	ETF	105.01	105.44	104.83	105.1	672600.0
2002-03-05 13:00:00	DIA	ETF	105.1	105.28	104.7	104.95	755100.0
2002-03-05 14:00:00	DIA	ETF	104.88	105.17	104.5	104.5	1245200.0
2002-03-05 15:00:00	DIA	ETF	104.55	104.9	104.34	104.6	2736200.0
2002-03-05 16:00:00	DIA	ETF	104.58	104.78	104.53	104.75	76800.0
2002-03-05 17:00:00	DIA	ETF	104.7	104.78	104.7	104.78	3000.0
2002-03-05 18:00:00	DIA	ETF	104.78	104.78	104.78	104.78	100.0

> showing 38 of 311 rows — these rows as CSV

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