PREVIEW / etf_1hour / 2006-08-10

all etf 1-hour files

  file:    by_date/etf_1hour/2006/2006-08-10.parquet
  size:    50 KB
  rows:    1,557

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-08-10 04:00:00	SPY	ETF	126.21	126.21	126.21	126.21	800.0
2006-08-10 05:00:00	SPY	ETF	126.53	126.53	126.53	126.53	100.0
2006-08-10 06:00:00	SPY	ETF	126.44	126.47	126.29	126.31	27200.0
2006-08-10 07:00:00	SPY	ETF	126.31	126.51	126.2	126.27	339600.0
2006-08-10 08:00:00	SPY	ETF	126.3	126.62	126.16	126.62	1995400.0
2006-08-10 09:00:00	SPY	ETF	126.63	126.79	126.36	126.71	10277200.0
2006-08-10 10:00:00	SPY	ETF	126.68	126.84	126.28	126.74	12787000.0
2006-08-10 11:00:00	SPY	ETF	126.73	127.14	126.63	126.91	8426400.0
2006-08-10 12:00:00	SPY	ETF	126.91	127.03	126.78	126.94	4552100.0
2006-08-10 13:00:00	SPY	ETF	126.95	127.28	126.73	127.11	6828600.0
2006-08-10 14:00:00	SPY	ETF	127.11	127.45	127.0	127.09	9286600.0
2006-08-10 15:00:00	SPY	ETF	127.08	127.5	126.93	127.28	8753000.0
2006-08-10 16:00:00	SPY	ETF	127.28	127.38	127.23	127.35	2628900.0
2006-08-10 17:00:00	SPY	ETF	127.36	127.37	127.29	127.33	160700.0
2006-08-10 18:00:00	SPY	ETF	127.33	127.36	127.33	127.35	1800.0
2006-08-10 19:00:00	SPY	ETF	127.3	127.31	127.3	127.31	1600.0
2006-08-10 09:00:00	QQQ	ETF	36.46	36.61	36.31	36.53	18311700.0
2006-08-10 10:00:00	QQQ	ETF	36.53	36.64	36.36	36.54	17780600.0
2006-08-10 11:00:00	QQQ	ETF	36.53	36.73	36.52	36.7	14364500.0
2006-08-10 12:00:00	QQQ	ETF	36.7	36.75	36.63	36.68	8796900.0
2006-08-10 13:00:00	QQQ	ETF	36.68	36.77	36.59	36.72	10645200.0
2006-08-10 14:00:00	QQQ	ETF	36.72	36.88	36.66	36.72	12239100.0
2006-08-10 15:00:00	QQQ	ETF	36.71	36.82	36.64	36.77	10348300.0
2006-08-10 07:00:00	IWM	ETF	67.2	67.26	67.1	67.1	28000.0
2006-08-10 08:00:00	IWM	ETF	67.1	67.35	66.98	67.35	205000.0
2006-08-10 09:00:00	IWM	ETF	67.35	67.65	67.03	67.58	8892100.0
2006-08-10 10:00:00	IWM	ETF	67.59	67.93	67.27	67.6	9926400.0
2006-08-10 11:00:00	IWM	ETF	67.61	67.96	67.48	67.91	6333800.0
2006-08-10 12:00:00	IWM	ETF	67.92	67.98	67.77	67.92	3664900.0
2006-08-10 13:00:00	IWM	ETF	67.91	68.4	67.72	68.29	9917000.0
2006-08-10 14:00:00	IWM	ETF	68.3	68.61	68.05	68.17	5865800.0
2006-08-10 15:00:00	IWM	ETF	68.16	68.47	68.01	68.26	7325300.0
2006-08-10 16:00:00	IWM	ETF	68.25	68.3	68.16	68.25	1700200.0
2006-08-10 17:00:00	IWM	ETF	68.25	68.25	68.2	68.2	300.0
2006-08-10 18:00:00	IWM	ETF	68.26	68.26	68.2	68.24	1500.0
2006-08-10 19:00:00	IWM	ETF	68.21	68.3	68.2	68.3	1800.0
2006-08-10 06:00:00	DIA	ETF	110.63	110.63	110.63	110.63	100.0
2006-08-10 07:00:00	DIA	ETF	110.53	110.53	110.5	110.5	300.0
2006-08-10 08:00:00	DIA	ETF	110.42	110.91	110.4	110.87	571300.0
2006-08-10 09:00:00	DIA	ETF	110.85	110.98	110.6	110.84	1273600.0
2006-08-10 10:00:00	DIA	ETF	110.84	111.02	110.5	110.9	1723600.0
2006-08-10 11:00:00	DIA	ETF	110.91	111.19	110.83	111.03	862900.0
2006-08-10 12:00:00	DIA	ETF	111.03	111.07	110.9	110.98	471000.0
2006-08-10 13:00:00	DIA	ETF	110.99	111.3	110.86	111.22	485000.0
2006-08-10 14:00:00	DIA	ETF	111.22	111.53	111.07	111.15	802700.0
2006-08-10 15:00:00	DIA	ETF	111.15	111.38	111.01	111.26	1051600.0
2006-08-10 16:00:00	DIA	ETF	111.25	111.31	111.15	111.28	228800.0
2006-08-10 19:00:00	DIA	ETF	111.25	111.25	111.24	111.24	300.0
2006-08-10 07:00:00	GLD	ETF	64.68	64.76	64.68	64.72	4600.0
2006-08-10 08:00:00	GLD	ETF	64.7	64.88	63.85	64.13	127900.0

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

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