PREVIEW / etf_1hour / 2004-06-24

all etf 1-hour files

  file:    by_date/etf_1hour/2004/2004-06-24.parquet
  size:    25 KB
  rows:    692

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-06-24 08:00:00	SPY	ETF	114.73	114.76	114.51	114.51	119600.0
2004-06-24 09:00:00	SPY	ETF	114.5	114.78	114.46	114.73	5332800.0
2004-06-24 10:00:00	SPY	ETF	114.74	114.84	114.6	114.72	5357100.0
2004-06-24 11:00:00	SPY	ETF	114.72	114.93	114.69	114.75	5989200.0
2004-06-24 12:00:00	SPY	ETF	114.75	114.88	114.71	114.8	2778900.0
2004-06-24 13:00:00	SPY	ETF	114.81	114.84	114.54	114.6	3001400.0
2004-06-24 14:00:00	SPY	ETF	114.61	114.7	114.35	114.37	4353200.0
2004-06-24 15:00:00	SPY	ETF	114.37	114.57	114.26	114.42	5198100.0
2004-06-24 16:00:00	SPY	ETF	114.42	114.6318	114.33	114.46	2062800.0
2004-06-24 17:00:00	SPY	ETF	114.46	114.48	113.0	114.47	4133400.0
2004-06-24 18:00:00	SPY	ETF	114.45	114.45	114.45	114.45	5100.0
2004-06-24 19:00:00	SPY	ETF	114.5	114.5	114.42	114.42	600.0
2004-06-24 08:00:00	QQQ	ETF	37.12	37.14	37.02	37.02	365700.0
2004-06-24 09:00:00	QQQ	ETF	37.02	37.21	36.99	37.14	11934600.0
2004-06-24 10:00:00	QQQ	ETF	37.146	37.23	37.06	37.18	12137800.0
2004-06-24 11:00:00	QQQ	ETF	37.178	37.35	37.17	37.26	12605700.0
2004-06-24 12:00:00	QQQ	ETF	37.27	37.32	37.216	37.269	7673900.0
2004-06-24 13:00:00	QQQ	ETF	37.26	37.3	37.12	37.133	12051000.0
2004-06-24 14:00:00	QQQ	ETF	37.134	37.14	36.97	36.992	13663000.0
2004-06-24 15:00:00	QQQ	ETF	36.992	37.12	36.92	37.024	16714300.0
2004-06-24 16:00:00	QQQ	ETF	37.024	37.09	37.0	37.04	3640600.0
2004-06-24 17:00:00	QQQ	ETF	37.04	37.06	37.04	37.05	52000.0
2004-06-24 18:00:00	QQQ	ETF	37.05	37.08	37.046	37.08	14400.0
2004-06-24 19:00:00	QQQ	ETF	37.06	37.07	37.06	37.07	8100.0
2004-06-24 08:00:00	IWM	ETF	57.99	58.0	57.99	57.99	12800.0
2004-06-24 09:00:00	IWM	ETF	57.94	58.3	57.93	58.215	1445200.0
2004-06-24 10:00:00	IWM	ETF	58.22	58.24	58.015	58.145	1100000.0
2004-06-24 11:00:00	IWM	ETF	58.105	58.255	58.05	58.125	531200.0
2004-06-24 12:00:00	IWM	ETF	58.1	58.17	58.05	58.1	219800.0
2004-06-24 13:00:00	IWM	ETF	58.105	58.155	58.005	58.015	476200.0
2004-06-24 14:00:00	IWM	ETF	58.005	58.045	57.725	57.725	1119400.0
2004-06-24 15:00:00	IWM	ETF	57.73	57.905	57.685	57.685	883600.0
2004-06-24 16:00:00	IWM	ETF	57.675	57.795	57.605	57.775	2252400.0
2004-06-24 08:00:00	DIA	ETF	104.85	104.89	104.8	104.8	6300.0
2004-06-24 09:00:00	DIA	ETF	104.78	104.96	104.64	104.89	656300.0
2004-06-24 10:00:00	DIA	ETF	104.92	104.99	104.79	104.85	411300.0
2004-06-24 11:00:00	DIA	ETF	104.85	105.05	104.8	104.82	675400.0
2004-06-24 12:00:00	DIA	ETF	104.82	104.94	104.79	104.87	157400.0
2004-06-24 13:00:00	DIA	ETF	104.86	104.92	104.72	104.73	167200.0
2004-06-24 14:00:00	DIA	ETF	104.75	104.87	104.56	104.59	615000.0
2004-06-24 15:00:00	DIA	ETF	104.63	104.73	104.47	104.58	1316300.0
2004-06-24 16:00:00	DIA	ETF	104.59	104.8188	104.57	104.7	45600.0
2004-06-24 17:00:00	DIA	ETF	104.72	104.72	104.72	104.72	500.0
2004-06-24 08:00:00	TLT	ETF	83.15	83.15	83.15	83.15	1000.0
2004-06-24 09:00:00	TLT	ETF	83.15	83.26	83.15	83.19	69100.0
2004-06-24 10:00:00	TLT	ETF	83.22	83.34	83.14	83.25	614700.0
2004-06-24 11:00:00	TLT	ETF	83.27	83.34	83.2	83.21	83800.0
2004-06-24 12:00:00	TLT	ETF	83.21	83.22	83.04	83.11	31800.0
2004-06-24 13:00:00	TLT	ETF	83.12	83.12	82.9	83.01	43100.0
2004-06-24 14:00:00	TLT	ETF	83.0	83.11	82.91	83.04	58600.0

> showing 50 of 692 rows — these rows as CSV

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