PREVIEW / etf_1hour / 2006-01-12

all etf 1-hour files

  file:    by_date/etf_1hour/2006/2006-01-12.parquet
  size:    39 KB
  rows:    1,190

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
2006-01-12 04:00:00	SPY	ETF	129.22	129.22	129.22	129.22	200.0
2006-01-12 06:00:00	SPY	ETF	129.25	129.25	129.2	129.2	900.0
2006-01-12 07:00:00	SPY	ETF	129.19	129.19	129.1	129.11	67000.0
2006-01-12 08:00:00	SPY	ETF	129.13	129.24	129.1	129.17	801800.0
2006-01-12 09:00:00	SPY	ETF	129.15	129.2	129.05	129.13	3305300.0
2006-01-12 10:00:00	SPY	ETF	129.13	129.28	129.0	129.23	4715200.0
2006-01-12 11:00:00	SPY	ETF	129.23	129.27	129.01	129.2	3083100.0
2006-01-12 12:00:00	SPY	ETF	129.19	129.24	129.06	129.1	2783800.0
2006-01-12 13:00:00	SPY	ETF	129.1	129.2	128.75	128.87	4682100.0
2006-01-12 14:00:00	SPY	ETF	128.87	128.88	128.51	128.6	9915500.0
2006-01-12 15:00:00	SPY	ETF	128.6	128.71	128.44	128.59	9625000.0
2006-01-12 16:00:00	SPY	ETF	128.6	128.81	128.56	128.71	518600.0
2006-01-12 17:00:00	SPY	ETF	128.74	128.79	128.74	128.78	8100.0
2006-01-12 18:00:00	SPY	ETF	128.76	128.77	128.75	128.77	2000.0
2006-01-12 19:00:00	SPY	ETF	128.75	128.77	128.75	128.77	16000.0
2006-01-12 09:00:00	QQQ	ETF	43.16	43.22	42.5	43.16	9926400.0
2006-01-12 10:00:00	QQQ	ETF	43.17	43.28	43.09	43.23	10038300.0
2006-01-12 11:00:00	QQQ	ETF	43.22	43.28	43.14	43.25	5941200.0
2006-01-12 12:00:00	QQQ	ETF	43.24	43.29	43.2	43.23	3875800.0
2006-01-12 13:00:00	QQQ	ETF	43.23	43.25	43.04	43.09	8850800.0
2006-01-12 14:00:00	QQQ	ETF	43.09	43.1	42.85	42.93	16743200.0
2006-01-12 15:00:00	QQQ	ETF	42.93	43.0	42.88	42.99	18676500.0
2006-01-12 08:00:00	IWM	ETF	70.51	70.53	70.43	70.48	8000.0
2006-01-12 09:00:00	IWM	ETF	70.48	70.69	70.44	70.55	2987400.0
2006-01-12 10:00:00	IWM	ETF	70.54	70.65	70.32	70.51	5686000.0
2006-01-12 11:00:00	IWM	ETF	70.51	70.67	70.4	70.62	1745100.0
2006-01-12 12:00:00	IWM	ETF	70.63	70.74	70.57	70.67	1385500.0
2006-01-12 13:00:00	IWM	ETF	70.68	70.7	70.35	70.38	2328900.0
2006-01-12 14:00:00	IWM	ETF	70.38	70.61	70.05	70.1	5971200.0
2006-01-12 15:00:00	IWM	ETF	70.09	70.29	70.08	70.19	3776400.0
2006-01-12 16:00:00	IWM	ETF	70.19	70.35	70.19	70.27	345400.0
2006-01-12 07:00:00	DIA	ETF	110.25	110.25	110.25	110.25	100.0
2006-01-12 08:00:00	DIA	ETF	110.22	110.26	110.14	110.17	25800.0
2006-01-12 09:00:00	DIA	ETF	110.21	110.23	110.07	110.11	450300.0
2006-01-12 10:00:00	DIA	ETF	110.12	110.21	110.04	110.17	869200.0
2006-01-12 11:00:00	DIA	ETF	110.16	110.18	109.95	110.07	728000.0
2006-01-12 12:00:00	DIA	ETF	110.08	110.1	109.94	109.96	519800.0
2006-01-12 13:00:00	DIA	ETF	109.95	110.05	109.74	109.8	2362700.0
2006-01-12 14:00:00	DIA	ETF	109.79	109.8	109.55	109.6	708900.0
2006-01-12 15:00:00	DIA	ETF	109.61	109.7	109.51	109.65	486400.0
2006-01-12 16:00:00	DIA	ETF	109.66	109.8	109.59	109.69	144300.0
2006-01-12 08:00:00	GLD	ETF	54.65	54.65	54.25	54.25	27900.0
2006-01-12 09:00:00	GLD	ETF	54.25	54.43	54.15	54.26	431600.0
2006-01-12 10:00:00	GLD	ETF	54.25	54.41	54.01	54.38	1247400.0
2006-01-12 11:00:00	GLD	ETF	54.37	54.55	54.35	54.48	699400.0
2006-01-12 12:00:00	GLD	ETF	54.49	54.57	54.38	54.55	252700.0
2006-01-12 13:00:00	GLD	ETF	54.54	54.6399	54.53	54.58	205000.0
2006-01-12 14:00:00	GLD	ETF	54.58	54.61	54.42	54.5	351200.0
2006-01-12 15:00:00	GLD	ETF	54.51	54.52	54.35	54.42	380800.0
2006-01-12 16:00:00	GLD	ETF	54.4	54.42	54.4	54.42	400.0

> showing 50 of 1,190 rows — these rows as CSV

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