PREVIEW / etf_1hour / 2006-01-05

all etf 1-hour files

  file:    by_date/etf_1hour/2006/2006-01-05.parquet
  size:    37 KB
  rows:    1,191

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-05 06:00:00	SPY	ETF	127.14	127.14	127.14	127.14	500.0
2006-01-05 07:00:00	SPY	ETF	127.22	127.27	127.14	127.14	14500.0
2006-01-05 08:00:00	SPY	ETF	127.23	127.25	127.09	127.2	865100.0
2006-01-05 09:00:00	SPY	ETF	127.19	127.49	127.15	127.25	6180700.0
2006-01-05 10:00:00	SPY	ETF	127.25	127.59	126.9	127.08	9559800.0
2006-01-05 11:00:00	SPY	ETF	127.08	127.4	127.05	127.37	7942200.0
2006-01-05 12:00:00	SPY	ETF	127.37	127.48	127.06	127.1	4651500.0
2006-01-05 13:00:00	SPY	ETF	127.1	127.29	127.08	127.2	2693200.0
2006-01-05 14:00:00	SPY	ETF	127.2	127.21	126.88	127.11	5723400.0
2006-01-05 15:00:00	SPY	ETF	127.09	127.25	127.03	127.23	8037200.0
2006-01-05 16:00:00	SPY	ETF	127.23	127.42	127.18	127.39	889100.0
2006-01-05 17:00:00	SPY	ETF	127.4	127.42	127.35	127.35	8000.0
2006-01-05 18:00:00	SPY	ETF	127.36	127.36	127.36	127.36	2000.0
2006-01-05 19:00:00	SPY	ETF	127.4	127.41	127.4	127.41	4000.0
2006-01-05 09:00:00	QQQ	ETF	41.75	41.91	41.73	41.76	12844500.0
2006-01-05 10:00:00	QQQ	ETF	41.76	41.99	41.43	41.83	19832600.0
2006-01-05 11:00:00	QQQ	ETF	41.83	41.99	41.82	41.97	8880200.0
2006-01-05 12:00:00	QQQ	ETF	41.97	42.0	41.84	41.85	7284500.0
2006-01-05 13:00:00	QQQ	ETF	41.84	41.95	41.84	41.91	4397700.0
2006-01-05 14:00:00	QQQ	ETF	41.91	41.92	41.8	41.89	11364800.0
2006-01-05 15:00:00	QQQ	ETF	41.88	41.95	41.86	41.92	7496800.0
2006-01-05 08:00:00	IWM	ETF	68.35	68.4	68.29	68.4	622600.0
2006-01-05 09:00:00	IWM	ETF	68.4	68.6	68.37	68.4	2581700.0
2006-01-05 10:00:00	IWM	ETF	68.4	68.68	68.25	68.36	5736600.0
2006-01-05 11:00:00	IWM	ETF	68.37	68.67	68.36	68.64	3379000.0
2006-01-05 12:00:00	IWM	ETF	68.65	68.78	68.51	68.51	3038300.0
2006-01-05 13:00:00	IWM	ETF	68.51	68.71	68.49	68.64	2093000.0
2006-01-05 14:00:00	IWM	ETF	68.64	68.75	68.51	68.7	2310300.0
2006-01-05 15:00:00	IWM	ETF	68.68	68.78	68.64	68.71	3531200.0
2006-01-05 16:00:00	IWM	ETF	68.7001	68.85	68.68	68.8	126200.0
2006-01-05 08:00:00	DIA	ETF	108.46	108.56	108.46	108.53	23000.0
2006-01-05 09:00:00	DIA	ETF	108.57	108.81	108.5	108.64	406300.0
2006-01-05 10:00:00	DIA	ETF	108.65	109.02	108.47	108.62	1902200.0
2006-01-05 11:00:00	DIA	ETF	108.6105	108.9	108.61	108.88	427700.0
2006-01-05 12:00:00	DIA	ETF	108.88	108.93	108.62	108.63	241800.0
2006-01-05 13:00:00	DIA	ETF	108.63	108.79	108.58	108.65	327700.0
2006-01-05 14:00:00	DIA	ETF	108.65	108.65	108.36	108.56	759600.0
2006-01-05 15:00:00	DIA	ETF	108.56	108.74	108.5	108.73	688900.0
2006-01-05 16:00:00	DIA	ETF	108.75	108.9	108.75	108.87	20700.0
2006-01-05 19:00:00	DIA	ETF	108.85	108.85	108.85	108.85	200.0
2006-01-05 07:00:00	GLD	ETF	52.67	52.7	52.65	52.65	7000.0
2006-01-05 08:00:00	GLD	ETF	52.77	52.9	52.5	52.54	13800.0
2006-01-05 09:00:00	GLD	ETF	52.61	52.62	52.13	52.3	1303300.0
2006-01-05 10:00:00	GLD	ETF	52.3	52.63	52.1	52.51	1163500.0
2006-01-05 11:00:00	GLD	ETF	52.5	52.72	52.45	52.59	3671700.0
2006-01-05 12:00:00	GLD	ETF	52.63	52.69	52.33	52.48	433900.0
2006-01-05 13:00:00	GLD	ETF	52.4807	52.6	52.4	52.44	472200.0
2006-01-05 14:00:00	GLD	ETF	52.44	52.44	52.25	52.3	202900.0
2006-01-05 15:00:00	GLD	ETF	52.31	52.36	52.25	52.34	386400.0
2006-01-05 16:00:00	GLD	ETF	52.34	52.34	52.34	52.34	300.0

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

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