PREVIEW / etf_1hour / 2006-04-05

all etf 1-hour files

  file:    by_date/etf_1hour/2006/2006-04-05.parquet
  size:    40 KB
  rows:    1,233

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-04-05 06:00:00	SPY	ETF	130.54	130.57	130.54	130.54	13300.0
2006-04-05 07:00:00	SPY	ETF	130.6	130.6	130.56	130.6	15500.0
2006-04-05 08:00:00	SPY	ETF	130.59	130.62	130.53	130.62	631700.0
2006-04-05 09:00:00	SPY	ETF	130.62	130.9	129.83	130.8	6411500.0
2006-04-05 10:00:00	SPY	ETF	130.8	130.97	130.5	130.55	9094400.0
2006-04-05 11:00:00	SPY	ETF	130.55	130.76	130.39	130.64	7801200.0
2006-04-05 12:00:00	SPY	ETF	130.64	130.96	130.56	130.91	4916500.0
2006-04-05 13:00:00	SPY	ETF	130.92	131.12	130.77	130.95	6894600.0
2006-04-05 14:00:00	SPY	ETF	130.96	131.12	130.82	131.1	4460800.0
2006-04-05 15:00:00	SPY	ETF	131.08	131.28	130.89	131.06	7358800.0
2006-04-05 16:00:00	SPY	ETF	131.06	131.1	130.99	131.08	684300.0
2006-04-05 17:00:00	SPY	ETF	131.08	131.08	131.01	131.05	6400.0
2006-04-05 18:00:00	SPY	ETF	131.04	131.08	131.04	131.06	1600.0
2006-04-05 19:00:00	SPY	ETF	131.06	131.06	131.06	131.06	600.0
2006-04-05 09:00:00	QQQ	ETF	42.3	42.5	42.29	42.42	14340900.0
2006-04-05 10:00:00	QQQ	ETF	42.42	42.48	42.28	42.33	15687300.0
2006-04-05 11:00:00	QQQ	ETF	42.33	42.4	42.21	42.29	10765100.0
2006-04-05 12:00:00	QQQ	ETF	42.29	42.5	42.29	42.47	10240900.0
2006-04-05 13:00:00	QQQ	ETF	42.47	42.59	42.46	42.53	12806300.0
2006-04-05 14:00:00	QQQ	ETF	42.54	42.6	42.49	42.6	8346200.0
2006-04-05 15:00:00	QQQ	ETF	42.59	42.67	42.49	42.6	14252600.0
2006-04-05 08:00:00	IWM	ETF	75.7	75.81	75.7	75.81	35100.0
2006-04-05 09:00:00	IWM	ETF	75.83	76.01	75.73	75.78	2681400.0
2006-04-05 10:00:00	IWM	ETF	75.76	75.96	75.55	75.57	5445600.0
2006-04-05 11:00:00	IWM	ETF	75.58	75.64	75.27	75.47	5641700.0
2006-04-05 12:00:00	IWM	ETF	75.47	75.9	75.44	75.86	4410300.0
2006-04-05 13:00:00	IWM	ETF	75.85	76.01	75.79	75.93	2417400.0
2006-04-05 14:00:00	IWM	ETF	75.94	76.11	75.84	76.11	2559300.0
2006-04-05 15:00:00	IWM	ETF	76.11	76.2	75.96	76.06	3599600.0
2006-04-05 16:00:00	IWM	ETF	76.05	76.19	76.0	76.02	384900.0
2006-04-05 17:00:00	IWM	ETF	76.05	76.07	75.99	75.99	2000.0
2006-04-05 18:00:00	IWM	ETF	76.04	76.05	76.04	76.05	1100.0
2006-04-05 08:00:00	DIA	ETF	112.05	112.05	111.96	111.99	412000.0
2006-04-05 09:00:00	DIA	ETF	112.03	112.31	111.94	112.2	861700.0
2006-04-05 10:00:00	DIA	ETF	112.18	112.35	111.79	111.83	1254100.0
2006-04-05 11:00:00	DIA	ETF	111.83	111.92	111.59	111.82	826900.0
2006-04-05 12:00:00	DIA	ETF	111.82	112.17	111.77	112.12	761900.0
2006-04-05 13:00:00	DIA	ETF	112.13	112.27	112.03	112.17	1020700.0
2006-04-05 14:00:00	DIA	ETF	112.17	112.33	112.05	112.27	1101700.0
2006-04-05 15:00:00	DIA	ETF	112.24	112.47	112.12	112.32	1317000.0
2006-04-05 16:00:00	DIA	ETF	112.31	112.38	112.3	112.35	97700.0
2006-04-05 19:00:00	DIA	ETF	112.27	112.27	112.24	112.24	1000.0
2006-04-05 07:00:00	GLD	ETF	58.25	58.28	58.22	58.22	6000.0
2006-04-05 08:00:00	GLD	ETF	58.33	58.73	58.3	58.69	938100.0
2006-04-05 09:00:00	GLD	ETF	58.66	58.71	58.3	58.51	1413300.0
2006-04-05 10:00:00	GLD	ETF	58.51	58.56	58.0	58.24	1212900.0
2006-04-05 11:00:00	GLD	ETF	58.24	58.54	58.2	58.48	1527600.0
2006-04-05 12:00:00	GLD	ETF	58.48	58.63	58.46	58.52	397200.0
2006-04-05 13:00:00	GLD	ETF	58.52	58.56	58.4	58.51	355800.0
2006-04-05 14:00:00	GLD	ETF	58.5192	58.66	58.49	58.64	313700.0

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

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