PREVIEW / etf_1hour / 2006-12-06

all etf 1-hour files

  file:    by_date/etf_1hour/2006/2006-12-06.parquet
  size:    57 KB
  rows:    1,810

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-12-06 06:00:00	SPY	ETF	141.94	141.95	141.94	141.95	30000.0
2006-12-06 07:00:00	SPY	ETF	141.9	141.9	141.83	141.88	3200.0
2006-12-06 08:00:00	SPY	ETF	141.86	142.02	141.67	141.82	715100.0
2006-12-06 09:00:00	SPY	ETF	141.8	141.89	141.57	141.66	7824800.0
2006-12-06 10:00:00	SPY	ETF	141.65	141.98	141.5	141.76	12181700.0
2006-12-06 11:00:00	SPY	ETF	141.76	141.97	141.75	141.76	5153900.0
2006-12-06 12:00:00	SPY	ETF	141.75	142.04	141.68	141.95	6276300.0
2006-12-06 13:00:00	SPY	ETF	141.95	142.07	141.75	141.86	4405600.0
2006-12-06 14:00:00	SPY	ETF	141.86	141.94	141.73	141.82	4793700.0
2006-12-06 15:00:00	SPY	ETF	141.81	141.83	141.58	141.76	9531700.0
2006-12-06 16:00:00	SPY	ETF	141.76	141.79	141.69	141.78	1281600.0
2006-12-06 17:00:00	SPY	ETF	141.79	141.8	141.69	141.71	293600.0
2006-12-06 18:00:00	SPY	ETF	141.71	141.74	141.62	141.63	72300.0
2006-12-06 19:00:00	SPY	ETF	141.73	141.73	141.66	141.68	1900.0
2006-12-06 09:00:00	QQQ	ETF	44.29	44.31	44.07	44.19	14529200.0
2006-12-06 10:00:00	QQQ	ETF	44.18	44.34	44.1	44.19	20694400.0
2006-12-06 11:00:00	QQQ	ETF	44.19	44.31	44.19	44.22	5096600.0
2006-12-06 12:00:00	QQQ	ETF	44.21	44.38	44.18	44.34	5272000.0
2006-12-06 13:00:00	QQQ	ETF	44.34	44.4	44.26	44.3	5222400.0
2006-12-06 14:00:00	QQQ	ETF	44.29	44.33	44.27	44.27	4801800.0
2006-12-06 15:00:00	QQQ	ETF	44.27	44.27	44.14	44.26	13705700.0
2006-12-06 08:00:00	IWM	ETF	79.22	79.33	79.07	79.2	9375400.0
2006-12-06 09:00:00	IWM	ETF	79.17	79.26	78.84	78.95	4111800.0
2006-12-06 10:00:00	IWM	ETF	78.94	79.34	78.79	79.14	5886300.0
2006-12-06 11:00:00	IWM	ETF	79.13	79.37	79.11	79.27	1950100.0
2006-12-06 12:00:00	IWM	ETF	79.26	79.47	79.15	79.43	5493100.0
2006-12-06 13:00:00	IWM	ETF	79.42	79.49	79.28	79.39	3614400.0
2006-12-06 14:00:00	IWM	ETF	79.3992	79.49	79.29	79.36	1698400.0
2006-12-06 15:00:00	IWM	ETF	79.36	79.37	79.11	79.19	4873000.0
2006-12-06 16:00:00	IWM	ETF	79.16	79.16	79.07	79.14	245600.0
2006-12-06 18:00:00	IWM	ETF	79.08	79.08	79.08	79.08	1700.0
2006-12-06 08:00:00	DIA	ETF	123.28	123.44	123.2	123.3	21300.0
2006-12-06 09:00:00	DIA	ETF	123.27	123.33	123.13	123.17	562200.0
2006-12-06 10:00:00	DIA	ETF	123.17	123.4	123.03	123.22	855400.0
2006-12-06 11:00:00	DIA	ETF	123.22	123.35	123.17	123.18	540200.0
2006-12-06 12:00:00	DIA	ETF	123.18	123.33	123.13	123.28	488300.0
2006-12-06 13:00:00	DIA	ETF	123.27	123.35	123.12	123.2	448500.0
2006-12-06 14:00:00	DIA	ETF	123.2	123.25	123.13	123.17	313300.0
2006-12-06 15:00:00	DIA	ETF	123.16	123.16	122.97	123.12	959900.0
2006-12-06 16:00:00	DIA	ETF	123.14	123.19	123.07	123.16	26000.0
2006-12-06 17:00:00	DIA	ETF	123.14	123.14	123.14	123.14	700.0
2006-12-06 18:00:00	DIA	ETF	123.1	123.1	123.1	123.1	100.0
2006-12-06 04:00:00	GLD	ETF	63.3	63.3	63.3	63.3	200.0
2006-12-06 07:00:00	GLD	ETF	63.19	63.28	63.19	63.28	1100.0
2006-12-06 08:00:00	GLD	ETF	63.29	63.29	62.89	62.99	181000.0
2006-12-06 09:00:00	GLD	ETF	62.98	63.31	62.98	63.22	739000.0
2006-12-06 10:00:00	GLD	ETF	63.21	63.45	63.12	63.4	1395300.0
2006-12-06 11:00:00	GLD	ETF	63.4	63.41	63.1	63.13	458000.0
2006-12-06 12:00:00	GLD	ETF	63.1324	63.22	62.96	63.1001	549700.0
2006-12-06 13:00:00	GLD	ETF	63.11	63.1286	62.29	62.48	1404800.0

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

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