PREVIEW / etf_1hour / 2006-12-12

all etf 1-hour files

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

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-12 04:00:00	SPY	ETF	141.87	141.87	141.87	141.87	1800.0
2006-12-12 06:00:00	SPY	ETF	141.71	141.71	141.71	141.71	1400.0
2006-12-12 07:00:00	SPY	ETF	141.7	141.75	141.7	141.73	20000.0
2006-12-12 08:00:00	SPY	ETF	141.76	141.79	141.65	141.74	514100.0
2006-12-12 09:00:00	SPY	ETF	141.76	141.76	141.59	141.69	3956000.0
2006-12-12 10:00:00	SPY	ETF	141.68	141.87	141.55	141.69	7547600.0
2006-12-12 11:00:00	SPY	ETF	141.68	141.81	141.49	141.52	6428200.0
2006-12-12 12:00:00	SPY	ETF	141.52	141.72	140.89	141.18	15592400.0
2006-12-12 13:00:00	SPY	ETF	141.18	141.35	141.14	141.25	4923000.0
2006-12-12 14:00:00	SPY	ETF	141.25	141.73	141.07	141.57	22115500.0
2006-12-12 15:00:00	SPY	ETF	141.57	141.73	141.42	141.62	10408200.0
2006-12-12 16:00:00	SPY	ETF	141.65	141.77	141.64	141.65	1796400.0
2006-12-12 17:00:00	SPY	ETF	141.65	141.68	141.65	141.68	800.0
2006-12-12 18:00:00	SPY	ETF	141.65	141.66	141.62	141.62	3700.0
2006-12-12 19:00:00	SPY	ETF	141.6	141.61	141.6	141.6	5300.0
2006-12-12 09:00:00	QQQ	ETF	44.03	44.13	43.93	44.07	8985900.0
2006-12-12 10:00:00	QQQ	ETF	44.07	44.08	43.83	43.94	16311000.0
2006-12-12 11:00:00	QQQ	ETF	43.93	43.98	43.82	43.86	6341200.0
2006-12-12 12:00:00	QQQ	ETF	43.86	43.87	43.56	43.64	20782600.0
2006-12-12 13:00:00	QQQ	ETF	43.65	43.73	43.63	43.7	4610600.0
2006-12-12 14:00:00	QQQ	ETF	43.69	43.95	43.61	43.82	33222800.0
2006-12-12 15:00:00	QQQ	ETF	43.78	43.86	43.7	43.81	12568100.0
2006-12-12 08:00:00	IWM	ETF	78.9	79.03	78.9	78.98	35100.0
2006-12-12 09:00:00	IWM	ETF	78.96	79.02	78.83	78.88	2013600.0
2006-12-12 10:00:00	IWM	ETF	78.87	78.89	78.65	78.7	4965600.0
2006-12-12 11:00:00	IWM	ETF	78.69	78.78	78.43	78.52	3117600.0
2006-12-12 12:00:00	IWM	ETF	78.51	78.53	78.05	78.2	7143700.0
2006-12-12 13:00:00	IWM	ETF	78.19	78.27	78.13	78.19	2485500.0
2006-12-12 14:00:00	IWM	ETF	78.19	78.73	77.89	78.388	12374800.0
2006-12-12 15:00:00	IWM	ETF	78.37	78.58	78.29	78.46	6243600.0
2006-12-12 16:00:00	IWM	ETF	78.47	78.55	78.4	78.5	2834700.0
2006-12-12 17:00:00	IWM	ETF	78.5	78.5	78.437	78.437	6002300.0
2006-12-12 19:00:00	IWM	ETF	78.47	78.47	78.47	78.47	300.0
2006-12-12 08:00:00	DIA	ETF	123.33	123.33	123.25	123.3	22800.0
2006-12-12 09:00:00	DIA	ETF	123.31	123.33	123.15	123.19	528800.0
2006-12-12 10:00:00	DIA	ETF	123.18	123.27	123.11	123.12	517700.0
2006-12-12 11:00:00	DIA	ETF	123.12	123.2	123.04	123.1	2218000.0
2006-12-12 12:00:00	DIA	ETF	123.1	123.11	122.54	122.77	1538200.0
2006-12-12 13:00:00	DIA	ETF	122.77	122.98	122.74	122.92	363700.0
2006-12-12 14:00:00	DIA	ETF	122.92	123.29	122.7	123.15	2305000.0
2006-12-12 15:00:00	DIA	ETF	123.15	123.31	123.05	123.19	1398600.0
2006-12-12 16:00:00	DIA	ETF	123.19	123.25	123.15	123.15	41000.0
2006-12-12 08:00:00	GLD	ETF	62.71	62.71	62.3	62.35	97300.0
2006-12-12 09:00:00	GLD	ETF	62.35	62.54	62.3	62.34	453000.0
2006-12-12 10:00:00	GLD	ETF	62.34	62.49	62.23	62.33	503100.0
2006-12-12 11:00:00	GLD	ETF	62.33	62.48	62.28	62.28	301100.0
2006-12-12 12:00:00	GLD	ETF	62.2699	62.35	62.19	62.27	483000.0
2006-12-12 13:00:00	GLD	ETF	62.29	62.32	62.2	62.25	130700.0
2006-12-12 14:00:00	GLD	ETF	62.2599	62.49	62.17	62.41	616400.0
2006-12-12 15:00:00	GLD	ETF	62.43	62.56	62.41	62.52	419700.0

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

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