PREVIEW / etf_1hour / 2005-09-16

all etf 1-hour files

  file:    by_date/etf_1hour/2005/2005-09-16.parquet
  size:    31 KB
  rows:    961

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-09-16 07:00:00	SPY	ETF	123.1	123.28	123.05	123.18	504500.0
2005-09-16 08:00:00	SPY	ETF	123.08	123.26	123.05	123.12	1321700.0
2005-09-16 09:00:00	SPY	ETF	123.13	123.33	122.9	123.06	16411400.0
2005-09-16 10:00:00	SPY	ETF	123.06	123.37	123.01	123.14	12838000.0
2005-09-16 11:00:00	SPY	ETF	123.14	123.2	122.99	123.07	6222100.0
2005-09-16 12:00:00	SPY	ETF	123.07	123.21	122.87	123.14	4960700.0
2005-09-16 13:00:00	SPY	ETF	123.14	123.3	123.08	123.25	4310400.0
2005-09-16 14:00:00	SPY	ETF	123.26	123.51	123.21	123.4688	6660100.0
2005-09-16 15:00:00	SPY	ETF	123.47	123.74	123.43	123.7	12073000.0
2005-09-16 16:00:00	SPY	ETF	123.66	123.7	123.5	123.55	4642900.0
2005-09-16 17:00:00	SPY	ETF	123.55	123.6	123.51	123.51	1584000.0
2005-09-16 18:00:00	SPY	ETF	123.57	123.57	123.56	123.56	1700.0
2005-09-16 19:00:00	SPY	ETF	123.54	123.62	123.54	123.54	10200.0
2005-09-16 09:00:00	QQQ	ETF	39.25	39.29	39.15	39.2	9289900.0
2005-09-16 10:00:00	QQQ	ETF	39.21	39.29	39.17	39.18	9516000.0
2005-09-16 11:00:00	QQQ	ETF	39.19	39.21	39.11	39.18	8351400.0
2005-09-16 12:00:00	QQQ	ETF	39.18	39.21	39.11	39.2	7699500.0
2005-09-16 13:00:00	QQQ	ETF	39.19	39.22	39.13	39.2	3873000.0
2005-09-16 14:00:00	QQQ	ETF	39.21	39.3	39.19	39.29	8055800.0
2005-09-16 15:00:00	QQQ	ETF	39.29	39.46	39.28	39.4	17079200.0
2005-09-16 07:00:00	IWM	ETF	66.47	66.53	66.47	66.53	55100.0
2005-09-16 08:00:00	IWM	ETF	66.45	66.57	66.45	66.55	1524700.0
2005-09-16 09:00:00	IWM	ETF	66.58	66.7	66.52	66.57	3402000.0
2005-09-16 10:00:00	IWM	ETF	66.58	66.68	66.38	66.4	2980300.0
2005-09-16 11:00:00	IWM	ETF	66.4	66.48	66.34	66.37	3137000.0
2005-09-16 12:00:00	IWM	ETF	66.36	66.55	66.35	66.54	2588000.0
2005-09-16 13:00:00	IWM	ETF	66.53	66.66	66.47	66.63	821200.0
2005-09-16 14:00:00	IWM	ETF	66.64	66.84	66.57	66.83	2809700.0
2005-09-16 15:00:00	IWM	ETF	66.84	67.0	66.8	66.81	5091000.0
2005-09-16 16:00:00	IWM	ETF	66.81	67.01	66.8	66.91	400000.0
2005-09-16 17:00:00	IWM	ETF	66.97	66.97	66.85	66.85	2000.0
2005-09-16 07:00:00	DIA	ETF	105.82	105.91	105.82	105.91	8900.0
2005-09-16 08:00:00	DIA	ETF	105.9	105.9	105.77	105.8	17100.0
2005-09-16 09:00:00	DIA	ETF	105.85	106.1	105.78	105.86	1374000.0
2005-09-16 10:00:00	DIA	ETF	105.87	106.12	105.83	105.89	1006400.0
2005-09-16 11:00:00	DIA	ETF	105.89	105.99	105.8	105.89	615300.0
2005-09-16 12:00:00	DIA	ETF	105.89	105.95	105.65	105.89	1286800.0
2005-09-16 13:00:00	DIA	ETF	105.91	106.07	105.86	106.03	371000.0
2005-09-16 14:00:00	DIA	ETF	106.05	106.23	106.02	106.19	516100.0
2005-09-16 15:00:00	DIA	ETF	106.17	106.38	106.15	106.28	1087000.0
2005-09-16 16:00:00	DIA	ETF	106.28	106.34	106.19	106.22	212200.0
2005-09-16 17:00:00	DIA	ETF	106.23	106.23	106.23	106.23	162400.0
2005-09-16 19:00:00	DIA	ETF	106.22	106.22	106.22	106.22	900.0
2005-09-16 07:00:00	GLD	ETF	45.85	45.85	45.85	45.85	500.0
2005-09-16 08:00:00	GLD	ETF	45.8	45.81	45.54	45.8	119800.0
2005-09-16 09:00:00	GLD	ETF	45.73	45.82	45.6	45.62	779100.0
2005-09-16 10:00:00	GLD	ETF	45.61	45.74	45.55	45.73	699900.0
2005-09-16 11:00:00	GLD	ETF	45.74	45.82	45.7	45.8	290000.0
2005-09-16 12:00:00	GLD	ETF	45.79	45.86	45.71	45.73	346500.0
2005-09-16 13:00:00	GLD	ETF	45.74	45.88	45.74	45.82	214700.0

> showing 50 of 961 rows — these rows as CSV

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