PREVIEW / etf_1hour / 2005-12-15

all etf 1-hour files

  file:    by_date/etf_1hour/2005/2005-12-15.parquet
  size:    37 KB
  rows:    1,186

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-12-15 07:00:00	SPY	ETF	127.65	127.65	127.63	127.65	56000.0
2005-12-15 08:00:00	SPY	ETF	127.66	128.0	127.63	127.77	1069800.0
2005-12-15 09:00:00	SPY	ETF	127.8	128.0	127.71	127.71	5891700.0
2005-12-15 10:00:00	SPY	ETF	127.72	127.99	127.18	127.41	17853900.0
2005-12-15 11:00:00	SPY	ETF	127.41	127.62	127.28	127.57	4456700.0
2005-12-15 12:00:00	SPY	ETF	127.57	127.7	127.47	127.64	4083700.0
2005-12-15 13:00:00	SPY	ETF	127.64	127.73	127.44	127.7	4037000.0
2005-12-15 14:00:00	SPY	ETF	127.7	127.77	127.28	127.36	7535600.0
2005-12-15 15:00:00	SPY	ETF	127.36	127.57	127.31	127.53	7686300.0
2005-12-15 16:00:00	SPY	ETF	127.53	127.53	127.35	127.4	781600.0
2005-12-15 17:00:00	SPY	ETF	127.4	127.6	127.4	127.58	542500.0
2005-12-15 18:00:00	SPY	ETF	127.5	127.59	127.49	127.58	450600.0
2005-12-15 19:00:00	SPY	ETF	127.55	127.55	127.53	127.53	5900.0
2005-12-15 09:00:00	QQQ	ETF	42.02	42.07	41.98	41.99	7755800.0
2005-12-15 10:00:00	QQQ	ETF	41.98	42.03	41.61	41.74	20650200.0
2005-12-15 11:00:00	QQQ	ETF	41.74	41.95	41.69	41.93	9966800.0
2005-12-15 12:00:00	QQQ	ETF	41.94	41.97	41.84	41.92	6355800.0
2005-12-15 13:00:00	QQQ	ETF	41.92	41.94	41.82	41.92	4606300.0
2005-12-15 14:00:00	QQQ	ETF	41.92	41.96	41.8	41.83	5428400.0
2005-12-15 15:00:00	QQQ	ETF	41.82	41.97	41.8	41.97	7613200.0
2005-12-15 07:00:00	IWM	ETF	68.7	68.72	68.7	68.72	7000.0
2005-12-15 08:00:00	IWM	ETF	68.71	68.86	68.7	68.74	529500.0
2005-12-15 09:00:00	IWM	ETF	68.76	68.84	68.24	68.29	3765100.0
2005-12-15 10:00:00	IWM	ETF	68.28	68.42	67.73	68.1	8622300.0
2005-12-15 11:00:00	IWM	ETF	68.09	68.26	67.94	68.23	3866800.0
2005-12-15 12:00:00	IWM	ETF	68.23	68.31	68.11	68.14	2542800.0
2005-12-15 13:00:00	IWM	ETF	68.14	68.19	67.94	68.15	2922000.0
2005-12-15 14:00:00	IWM	ETF	68.15	68.17	67.87	67.98	2999400.0
2005-12-15 15:00:00	IWM	ETF	67.97	68.2	67.9	68.14	4217300.0
2005-12-15 16:00:00	IWM	ETF	68.13	68.25	68.11	68.12	259200.0
2005-12-15 17:00:00	IWM	ETF	68.18	68.25	68.18	68.25	16300.0
2005-12-15 08:00:00	DIA	ETF	108.88	109.08	108.88	108.93	225900.0
2005-12-15 09:00:00	DIA	ETF	108.99	109.24	108.92	109.09	805700.0
2005-12-15 10:00:00	DIA	ETF	109.07	109.5	108.9	108.97	3168200.0
2005-12-15 11:00:00	DIA	ETF	108.97	109.04	108.81	108.97	1307400.0
2005-12-15 12:00:00	DIA	ETF	108.95	109.05	108.86	108.99	384300.0
2005-12-15 13:00:00	DIA	ETF	109.0	109.06	108.84	109.02	355800.0
2005-12-15 14:00:00	DIA	ETF	109.02	109.09	108.7	108.8	714000.0
2005-12-15 15:00:00	DIA	ETF	108.78	108.92	108.73	108.88	1089600.0
2005-12-15 16:00:00	DIA	ETF	108.87	108.91	108.74	108.76	171600.0
2005-12-15 17:00:00	DIA	ETF	108.72	108.85	108.72	108.8	500.0
2005-12-15 18:00:00	DIA	ETF	108.8	108.8	108.8	108.8	200.0
2005-12-15 19:00:00	DIA	ETF	108.8	108.8	108.8	108.8	200.0
2005-12-15 07:00:00	GLD	ETF	50.1	50.24	50.1	50.24	3400.0
2005-12-15 08:00:00	GLD	ETF	50.14	50.3	49.95	50.3	443400.0
2005-12-15 09:00:00	GLD	ETF	50.3	50.61	50.25	50.5	1050500.0
2005-12-15 10:00:00	GLD	ETF	50.48	50.57	50.24	50.56	768700.0
2005-12-15 11:00:00	GLD	ETF	50.56	50.79	50.53	50.59	678400.0
2005-12-15 12:00:00	GLD	ETF	50.59	50.67	50.4101	50.59	400800.0
2005-12-15 13:00:00	GLD	ETF	50.59	50.62	50.11	50.22	564700.0

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

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