PREVIEW / etf_1hour / 2005-01-25

all etf 1-hour files

  file:    by_date/etf_1hour/2005/2005-01-25.parquet
  size:    28 KB
  rows:    807

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
2005-01-25 08:00:00	SPY	ETF	116.97	117.01	116.94	116.98	63300.0
2005-01-25 09:00:00	SPY	ETF	116.95	117.39	116.84	117.21	18426200.0
2005-01-25 10:00:00	SPY	ETF	117.23	117.47	117.14	117.28	11640300.0
2005-01-25 11:00:00	SPY	ETF	117.27	117.45	117.11	117.2	5526700.0
2005-01-25 12:00:00	SPY	ETF	117.21	117.3	117.07	117.16	4812200.0
2005-01-25 13:00:00	SPY	ETF	117.16	117.46	117.15	117.23	5186100.0
2005-01-25 14:00:00	SPY	ETF	117.26	117.31	116.95	117.15	6867300.0
2005-01-25 15:00:00	SPY	ETF	117.13	117.18	116.72	116.87	11527100.0
2005-01-25 16:00:00	SPY	ETF	116.91	117.05	116.83	117.04	2559200.0
2005-01-25 17:00:00	SPY	ETF	117.06	117.11	116.99	117.01	84700.0
2005-01-25 18:00:00	SPY	ETF	117.01	117.05	116.99	117.05	37000.0
2005-01-25 19:00:00	SPY	ETF	117.07	117.07	117.05	117.05	2200.0
2005-01-25 09:00:00	QQQ	ETF	36.77	36.97	36.75	36.92	18762300.0
2005-01-25 10:00:00	QQQ	ETF	36.92	37.09	36.89	37.01	19966200.0
2005-01-25 11:00:00	QQQ	ETF	37.01	37.06	36.86	36.91	13062300.0
2005-01-25 12:00:00	QQQ	ETF	36.91	36.94	36.81	36.86	11748700.0
2005-01-25 13:00:00	QQQ	ETF	36.87	37.01	36.84	36.92	8135400.0
2005-01-25 14:00:00	QQQ	ETF	36.92	36.94	36.72	36.82	15473300.0
2005-01-25 15:00:00	QQQ	ETF	36.83	36.91	36.66	36.71	21447400.0
2005-01-25 08:00:00	IWM	ETF	60.64	60.65	60.58	60.64	4600.0
2005-01-25 09:00:00	IWM	ETF	60.63	60.935	60.525	60.82	5396400.0
2005-01-25 10:00:00	IWM	ETF	60.815	61.1	60.77	60.885	2714400.0
2005-01-25 11:00:00	IWM	ETF	60.88	60.9	60.365	60.405	4297600.0
2005-01-25 12:00:00	IWM	ETF	60.405	60.745	60.23	60.37	1990400.0
2005-01-25 13:00:00	IWM	ETF	60.375	60.635	60.375	60.49	1040800.0
2005-01-25 14:00:00	IWM	ETF	60.495	60.525	60.36	60.42	1602000.0
2005-01-25 15:00:00	IWM	ETF	60.425	60.56	60.255	60.355	4208400.0
2005-01-25 16:00:00	IWM	ETF	60.375	60.55	60.345	60.545	521000.0
2005-01-25 08:00:00	DIA	ETF	104.12	104.13	104.12	104.13	500.0
2005-01-25 09:00:00	DIA	ETF	104.12	104.7	104.05	104.59	2119600.0
2005-01-25 10:00:00	DIA	ETF	104.59	104.88	104.55	104.73	1571800.0
2005-01-25 11:00:00	DIA	ETF	104.73	104.86	104.66	104.74	785200.0
2005-01-25 12:00:00	DIA	ETF	104.73	104.85	104.63	104.77	735800.0
2005-01-25 13:00:00	DIA	ETF	104.78	105.01	104.75	104.85	607400.0
2005-01-25 14:00:00	DIA	ETF	104.87	104.89	104.55	104.73	1632800.0
2005-01-25 15:00:00	DIA	ETF	104.73	104.76	104.39	104.54	1756800.0
2005-01-25 16:00:00	DIA	ETF	104.56	104.75	104.56	104.75	18100.0
2005-01-25 17:00:00	DIA	ETF	104.78	104.78	104.72	104.72	500.0
2005-01-25 18:00:00	DIA	ETF	104.74	104.74	104.74	104.74	1000.0
2005-01-25 09:00:00	GLD	ETF	42.53	42.56	42.48	42.51	200400.0
2005-01-25 10:00:00	GLD	ETF	42.51	42.53	42.27	42.31	268700.0
2005-01-25 11:00:00	GLD	ETF	42.29	42.35	42.11	42.15	332400.0
2005-01-25 12:00:00	GLD	ETF	42.15	42.25	42.1	42.15	177300.0
2005-01-25 13:00:00	GLD	ETF	42.17	42.21	42.13	42.18	82200.0
2005-01-25 14:00:00	GLD	ETF	42.18	42.21	42.17	42.21	74800.0
2005-01-25 15:00:00	GLD	ETF	42.2	42.25	42.15	42.24	95700.0
2005-01-25 08:00:00	TLT	ETF	91.43	91.43	91.41	91.41	10200.0
2005-01-25 09:00:00	TLT	ETF	91.51	91.51	91.26	91.35	123900.0
2005-01-25 10:00:00	TLT	ETF	91.32	91.36	90.906	90.96	344800.0
2005-01-25 11:00:00	TLT	ETF	90.97	90.99	90.59	90.68	414500.0

> showing 50 of 807 rows — these rows as CSV

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