PREVIEW / etf_1hour / 2004-04-02

all etf 1-hour files

  file:    by_date/etf_1hour/2004/2004-04-02.parquet
  size:    26 KB
  rows:    735

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
2004-04-02 08:00:00	SPY	ETF	113.64	114.91	113.64	114.68	1515300.0
2004-04-02 09:00:00	SPY	ETF	114.69	114.88	114.28	114.609	11167800.0
2004-04-02 10:00:00	SPY	ETF	114.6	114.63	113.91	114.28	8485700.0
2004-04-02 11:00:00	SPY	ETF	114.29	114.47	114.13	114.36	4150000.0
2004-04-02 12:00:00	SPY	ETF	114.37	114.65	114.17	114.6	3313000.0
2004-04-02 13:00:00	SPY	ETF	114.58	114.59	114.25	114.46	2524700.0
2004-04-02 14:00:00	SPY	ETF	114.47	114.54	113.95	114.07	6270200.0
2004-04-02 15:00:00	SPY	ETF	114.05	114.47	114.01	114.42	6853100.0
2004-04-02 16:00:00	SPY	ETF	114.42	114.67	114.34	114.6	2383000.0
2004-04-02 17:00:00	SPY	ETF	114.57	114.64	114.52	114.52	12800.0
2004-04-02 18:00:00	SPY	ETF	114.53	114.53	114.53	114.53	2200.0
2004-04-02 19:00:00	SPY	ETF	114.55	114.55	114.55	114.55	500.0
2004-04-02 08:00:00	QQQ	ETF	36.11	36.92	36.11	36.74	3568600.0
2004-04-02 09:00:00	QQQ	ETF	36.74	37.0	36.68	36.83	29484500.0
2004-04-02 10:00:00	QQQ	ETF	36.828	36.84	36.52	36.7	24536300.0
2004-04-02 11:00:00	QQQ	ETF	36.697	36.79	36.62	36.77	11174500.0
2004-04-02 12:00:00	QQQ	ETF	36.77	36.95	36.7	36.9	15578100.0
2004-04-02 13:00:00	QQQ	ETF	36.901	36.97	36.8	36.97	11513500.0
2004-04-02 14:00:00	QQQ	ETF	36.95	37.04	36.76	36.89	15709300.0
2004-04-02 15:00:00	QQQ	ETF	36.89	37.0	36.83	37.0	17429500.0
2004-04-02 16:00:00	QQQ	ETF	37.0	37.16	36.841	37.08	5549100.0
2004-04-02 17:00:00	QQQ	ETF	37.08	37.1	37.03	37.05	312100.0
2004-04-02 18:00:00	QQQ	ETF	37.05	37.09	37.04	37.09	24600.0
2004-04-02 19:00:00	QQQ	ETF	37.09	37.1	37.04	37.09	11600.0
2004-04-02 08:00:00	IWM	ETF	60.015	60.27	59.985	60.2	154800.0
2004-04-02 09:00:00	IWM	ETF	60.215	60.47	59.95	60.2	3223400.0
2004-04-02 10:00:00	IWM	ETF	60.2	60.275	59.805	59.89	2474800.0
2004-04-02 11:00:00	IWM	ETF	59.91	60.105	59.88	60.08	868600.0
2004-04-02 12:00:00	IWM	ETF	60.08	60.175	60.0	60.105	786200.0
2004-04-02 13:00:00	IWM	ETF	60.11	60.15	60.0	60.13	878200.0
2004-04-02 14:00:00	IWM	ETF	60.145	60.17	59.855	59.955	1182800.0
2004-04-02 15:00:00	IWM	ETF	59.945	60.25	59.905	60.175	1661600.0
2004-04-02 16:00:00	IWM	ETF	60.19	60.235	60.06	60.18	380600.0
2004-04-02 19:00:00	IWM	ETF	60.165	60.22	60.165	60.22	5800.0
2004-04-02 08:00:00	DIA	ETF	104.05	105.24	104.05	104.98	224800.0
2004-04-02 09:00:00	DIA	ETF	105.05	105.2	104.62	104.91	2635600.0
2004-04-02 10:00:00	DIA	ETF	104.87	104.93	104.4	104.77	1323300.0
2004-04-02 11:00:00	DIA	ETF	104.76	104.86	104.61	104.8	469300.0
2004-04-02 12:00:00	DIA	ETF	104.78	104.99	104.65	104.96	564400.0
2004-04-02 13:00:00	DIA	ETF	104.94	104.96	104.65	104.83	329600.0
2004-04-02 14:00:00	DIA	ETF	104.84	104.9	104.4	104.53	692300.0
2004-04-02 15:00:00	DIA	ETF	104.52	104.91	104.46	104.85	869700.0
2004-04-02 16:00:00	DIA	ETF	104.85	105.1	104.84	105.1	109900.0
2004-04-02 17:00:00	DIA	ETF	105.13	105.13	105.13	105.13	200.0
2004-04-02 18:00:00	DIA	ETF	105.05	105.05	105.05	105.05	100.0
2004-04-02 19:00:00	DIA	ETF	105.05	105.05	105.0	105.0	1200.0
2004-04-02 08:00:00	TLT	ETF	88.84	88.84	86.5	87.0	35900.0
2004-04-02 09:00:00	TLT	ETF	87.05	87.13	86.87	87.0	1198000.0
2004-04-02 10:00:00	TLT	ETF	87.0	87.06	86.75	86.86	453000.0
2004-04-02 11:00:00	TLT	ETF	86.95	86.95	86.6	86.67	213200.0

> showing 50 of 735 rows — these rows as CSV

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