PREVIEW / etf_1hour / 2004-02-04

all etf 1-hour files

  file:    by_date/etf_1hour/2004/2004-02-04.parquet
  size:    25 KB
  rows:    705

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-02-04 08:00:00	SPY	ETF	113.21	113.26	113.13	113.15	34800.0
2004-02-04 09:00:00	SPY	ETF	113.22	113.4	113.14	113.21	3619500.0
2004-02-04 10:00:00	SPY	ETF	113.22	113.73	112.95	113.6	9424800.0
2004-02-04 11:00:00	SPY	ETF	113.6	113.69	113.36	113.47	3002900.0
2004-02-04 12:00:00	SPY	ETF	113.47	113.67	113.41	113.501	2002000.0
2004-02-04 13:00:00	SPY	ETF	113.51	113.67	113.22	113.25	3211000.0
2004-02-04 14:00:00	SPY	ETF	113.24	113.31	112.79	112.96	7489300.0
2004-02-04 15:00:00	SPY	ETF	112.95	113.37	112.89	113.03	5902200.0
2004-02-04 16:00:00	SPY	ETF	113.05	113.09	112.79	112.83	2293400.0
2004-02-04 17:00:00	SPY	ETF	112.83	112.87	112.8	112.85	9500.0
2004-02-04 18:00:00	SPY	ETF	112.82	112.86	112.74	112.83	287200.0
2004-02-04 19:00:00	SPY	ETF	112.81	112.83	112.81	112.81	4600.0
2004-02-04 08:00:00	QQQ	ETF	36.67	36.69	36.6	36.63	397600.0
2004-02-04 09:00:00	QQQ	ETF	36.64	36.74	36.59	36.69	11254600.0
2004-02-04 10:00:00	QQQ	ETF	36.7	36.864	36.51	36.723	19635000.0
2004-02-04 11:00:00	QQQ	ETF	36.73	36.775	36.61	36.69	9722100.0
2004-02-04 12:00:00	QQQ	ETF	36.69	36.795	36.65	36.69	8305500.0
2004-02-04 13:00:00	QQQ	ETF	36.69	36.791	36.58	36.59	7883400.0
2004-02-04 14:00:00	QQQ	ETF	36.59	36.63	36.329	36.4	25782300.0
2004-02-04 15:00:00	QQQ	ETF	36.43	36.56	36.33	36.404	18349800.0
2004-02-04 16:00:00	QQQ	ETF	36.4	36.43	36.32	36.35	4595100.0
2004-02-04 17:00:00	QQQ	ETF	36.35	36.39	36.33	36.36	729200.0
2004-02-04 18:00:00	QQQ	ETF	36.38	36.39	36.35	36.37	61200.0
2004-02-04 19:00:00	QQQ	ETF	36.36	36.39	36.3	36.38	36600.0
2004-02-04 08:00:00	IWM	ETF	57.215	57.235	57.215	57.235	5000.0
2004-02-04 09:00:00	IWM	ETF	57.26	57.405	57.035	57.045	2411600.0
2004-02-04 10:00:00	IWM	ETF	57.095	57.2	56.675	57.005	1540600.0
2004-02-04 11:00:00	IWM	ETF	57.0	57.015	56.8	56.93	486600.0
2004-02-04 12:00:00	IWM	ETF	56.94	56.955	56.825	56.855	395000.0
2004-02-04 13:00:00	IWM	ETF	56.8515	56.935	56.72	56.72	558200.0
2004-02-04 14:00:00	IWM	ETF	56.74	56.755	56.3595	56.47	2175800.0
2004-02-04 15:00:00	IWM	ETF	56.4755	56.74	56.15	56.185	2930200.0
2004-02-04 16:00:00	IWM	ETF	56.18	56.3	56.15	56.3	813000.0
2004-02-04 18:00:00	IWM	ETF	56.21	56.27	56.181	56.27	3400.0
2004-02-04 19:00:00	IWM	ETF	56.19	56.19	56.175	56.175	3800.0
2004-02-04 08:00:00	DIA	ETF	104.74	104.74	104.6	104.67	5700.0
2004-02-04 09:00:00	DIA	ETF	104.7	104.93	104.65	104.8	593700.0
2004-02-04 10:00:00	DIA	ETF	104.8	105.44	104.61	105.33	2162600.0
2004-02-04 11:00:00	DIA	ETF	105.34	105.37	105.04	105.15	949500.0
2004-02-04 12:00:00	DIA	ETF	105.14	105.36	105.11	105.2	415900.0
2004-02-04 13:00:00	DIA	ETF	105.19	105.37	104.94	104.99	1126500.0
2004-02-04 14:00:00	DIA	ETF	104.99	105.05	104.67	104.84	1300300.0
2004-02-04 15:00:00	DIA	ETF	104.83	105.22	104.8	104.92	1102100.0
2004-02-04 16:00:00	DIA	ETF	104.901	104.95	104.73	104.75	141200.0
2004-02-04 17:00:00	DIA	ETF	104.8	104.8	104.8	104.8	1900.0
2004-02-04 18:00:00	DIA	ETF	104.74	104.74	104.7	104.73	3600.0
2004-02-04 19:00:00	DIA	ETF	104.74	104.74	104.72	104.73	600.0
2004-02-04 09:00:00	TLT	ETF	86.79	86.86	86.71	86.74	88800.0
2004-02-04 10:00:00	TLT	ETF	86.78	86.78	86.48	86.52	218900.0
2004-02-04 11:00:00	TLT	ETF	86.52	86.7	86.52	86.64	74800.0

> showing 50 of 705 rows — these rows as CSV

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