PREVIEW / etf_1hour / 2005-01-03

all etf 1-hour files

  file:    by_date/etf_1hour/2005/2005-01-03.parquet
  size:    30 KB
  rows:    850

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-03 08:00:00	SPY	ETF	121.6	121.6	121.52	121.55	427400.0
2005-01-03 09:00:00	SPY	ETF	121.54	121.76	121.45	121.52	6222000.0
2005-01-03 10:00:00	SPY	ETF	121.53	121.64	120.7	120.84	15904800.0
2005-01-03 11:00:00	SPY	ETF	120.84	121.56	120.49	120.83	5900800.0
2005-01-03 12:00:00	SPY	ETF	120.83	121.52	120.57	120.69	2833300.0
2005-01-03 13:00:00	SPY	ETF	120.68	120.69	120.26	120.32	4529900.0
2005-01-03 14:00:00	SPY	ETF	120.33	120.56	120.24	120.28	5658100.0
2005-01-03 15:00:00	SPY	ETF	120.27	120.41	119.9	120.06	11635400.0
2005-01-03 16:00:00	SPY	ETF	120.05	120.7	119.98	120.27	1038900.0
2005-01-03 17:00:00	SPY	ETF	120.26	120.31	120.12	120.25	248400.0
2005-01-03 18:00:00	SPY	ETF	120.28	120.3	120.28	120.3	4200.0
2005-01-03 19:00:00	SPY	ETF	120.31	120.32	120.31	120.31	1400.0
2005-01-03 09:00:00	QQQ	ETF	40.07	40.29	40.06	40.13	13154100.0
2005-01-03 10:00:00	QQQ	ETF	40.13	40.21	39.37	39.57	33573700.0
2005-01-03 11:00:00	QQQ	ETF	39.58	39.7	39.42	39.64	11182600.0
2005-01-03 12:00:00	QQQ	ETF	39.64	39.68	39.54	39.68	6380300.0
2005-01-03 13:00:00	QQQ	ETF	39.68	39.68	39.52	39.57	6468300.0
2005-01-03 14:00:00	QQQ	ETF	39.57	39.73	39.55	39.6	8438700.0
2005-01-03 15:00:00	QQQ	ETF	39.61	39.67	39.41	39.49	14164800.0
2005-01-03 08:00:00	IWM	ETF	65.16	65.16	65.135	65.155	9400.0
2005-01-03 09:00:00	IWM	ETF	65.155	65.21	64.915	64.975	2031800.0
2005-01-03 10:00:00	IWM	ETF	64.955	64.985	63.75	64.065	3979600.0
2005-01-03 11:00:00	IWM	ETF	64.07	64.215	63.895	64.15	2053000.0
2005-01-03 12:00:00	IWM	ETF	64.15	64.275	64.06	64.195	921400.0
2005-01-03 13:00:00	IWM	ETF	64.195	64.195	63.84	63.91	1047400.0
2005-01-03 14:00:00	IWM	ETF	63.9	64.125	63.885	63.895	1362200.0
2005-01-03 15:00:00	IWM	ETF	63.895	63.985	63.57	63.795	3905400.0
2005-01-03 16:00:00	IWM	ETF	63.77	63.945	63.76	63.93	429400.0
2005-01-03 17:00:00	IWM	ETF	63.95	63.985	63.875	63.91	34600.0
2005-01-03 18:00:00	IWM	ETF	63.9	63.9	63.9	63.9	400.0
2005-01-03 08:00:00	DIA	ETF	108.14	108.17	108.07	108.17	16500.0
2005-01-03 09:00:00	DIA	ETF	108.16	108.59	108.05	108.44	1978800.0
2005-01-03 10:00:00	DIA	ETF	108.43	108.51	107.75	107.89	2641600.0
2005-01-03 11:00:00	DIA	ETF	107.89	107.91	107.51	107.82	973700.0
2005-01-03 12:00:00	DIA	ETF	107.81	107.83	107.6	107.68	770900.0
2005-01-03 13:00:00	DIA	ETF	107.68	107.68	107.23	107.28	1348300.0
2005-01-03 14:00:00	DIA	ETF	107.28	107.52	107.25	107.31	924800.0
2005-01-03 15:00:00	DIA	ETF	107.28	107.4	106.93	107.13	2468200.0
2005-01-03 16:00:00	DIA	ETF	107.07	107.38	107.07	107.36	79400.0
2005-01-03 17:00:00	DIA	ETF	107.18	107.265	107.18	107.265	331100.0
2005-01-03 18:00:00	DIA	ETF	107.35	107.35	107.35	107.35	700.0
2005-01-03 09:00:00	GLD	ETF	42.98	43.09	42.89	43.09	687800.0
2005-01-03 10:00:00	GLD	ETF	43.1	43.17	42.88	42.89	1106300.0
2005-01-03 11:00:00	GLD	ETF	42.91	43.03	42.82	42.94	499500.0
2005-01-03 12:00:00	GLD	ETF	42.92	42.97	42.75	42.9	348000.0
2005-01-03 13:00:00	GLD	ETF	42.89	43.0	42.74	42.94	1600700.0
2005-01-03 14:00:00	GLD	ETF	42.94	43.05	42.93	43.02	115000.0
2005-01-03 15:00:00	GLD	ETF	43.01	43.07	42.95	43.04	129800.0
2005-01-03 16:00:00	GLD	ETF	43.0	43.0	43.0	43.0	100.0
2005-01-03 08:00:00	TLT	ETF	88.14	88.2	88.14	88.2	29000.0

> showing 50 of 850 rows — these rows as CSV

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