PREVIEW / etf_1hour / 2006-12-05

all etf 1-hour files

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

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-05 07:00:00	SPY	ETF	141.32	141.37	141.24	141.32	63600.0
2006-12-05 08:00:00	SPY	ETF	141.3	141.74	141.23	141.57	1275300.0
2006-12-05 09:00:00	SPY	ETF	141.58	141.63	141.26	141.46	6579100.0
2006-12-05 10:00:00	SPY	ETF	141.45	141.96	141.45	141.7	18523000.0
2006-12-05 11:00:00	SPY	ETF	141.71	141.86	141.56	141.6	9888800.0
2006-12-05 12:00:00	SPY	ETF	141.62	141.78	141.48	141.74	8568700.0
2006-12-05 13:00:00	SPY	ETF	141.74	141.82	141.59	141.73	3405200.0
2006-12-05 14:00:00	SPY	ETF	141.72	141.95	141.65	141.81	9076800.0
2006-12-05 15:00:00	SPY	ETF	141.82	141.9	141.67	141.89	8667700.0
2006-12-05 16:00:00	SPY	ETF	141.9	141.94	141.84	141.87	3913800.0
2006-12-05 17:00:00	SPY	ETF	141.88	141.95	141.88	141.92	45200.0
2006-12-05 18:00:00	SPY	ETF	141.94	141.98	141.91	141.98	6400.0
2006-12-05 19:00:00	SPY	ETF	141.94	141.94	141.89	141.9	2800.0
2006-12-05 09:00:00	QQQ	ETF	44.4	44.42	44.19	44.3	13445400.0
2006-12-05 10:00:00	QQQ	ETF	44.3	44.55	44.3	44.46	25050800.0
2006-12-05 11:00:00	QQQ	ETF	44.45	44.97	44.38	44.39	7939200.0
2006-12-05 12:00:00	QQQ	ETF	44.39	44.42	44.3	44.38	7646600.0
2006-12-05 13:00:00	QQQ	ETF	44.39	44.43	44.31	44.39	5375500.0
2006-12-05 14:00:00	QQQ	ETF	44.38	44.49	44.34	44.4	8788800.0
2006-12-05 15:00:00	QQQ	ETF	44.39	44.47	44.32	44.41	10115700.0
2006-12-05 07:00:00	IWM	ETF	79.25	79.25	79.25	79.25	100.0
2006-12-05 08:00:00	IWM	ETF	79.3	79.65	79.3	79.47	365000.0
2006-12-05 09:00:00	IWM	ETF	79.48	79.53	79.07	79.2306	4697300.0
2006-12-05 10:00:00	IWM	ETF	79.24	79.76	79.23	79.5	11113900.0
2006-12-05 11:00:00	IWM	ETF	79.5	79.6	79.28	79.32	5609900.0
2006-12-05 12:00:00	IWM	ETF	79.33	79.4	79.14	79.37	3072100.0
2006-12-05 13:00:00	IWM	ETF	79.37	79.44	79.2	79.31	1654700.0
2006-12-05 14:00:00	IWM	ETF	79.3	79.62	79.27	79.4	4850800.0
2006-12-05 15:00:00	IWM	ETF	79.4	79.44	79.2	79.37	6480500.0
2006-12-05 16:00:00	IWM	ETF	79.36	79.4	79.26	79.37	593100.0
2006-12-05 17:00:00	IWM	ETF	79.37	79.37	79.37	79.37	10500.0
2006-12-05 18:00:00	IWM	ETF	79.34	79.34	79.34	79.34	500.0
2006-12-05 19:00:00	IWM	ETF	79.36	79.36	79.36	79.36	200.0
2006-12-05 08:00:00	DIA	ETF	122.93	123.14	122.91	123.03	39300.0
2006-12-05 09:00:00	DIA	ETF	123.04	123.06	122.73	122.87	739700.0
2006-12-05 10:00:00	DIA	ETF	122.88	123.34	122.87	123.18	2270400.0
2006-12-05 11:00:00	DIA	ETF	123.18	123.25	123.0	123.03	868200.0
2006-12-05 12:00:00	DIA	ETF	123.03	123.18	122.88	123.17	657900.0
2006-12-05 13:00:00	DIA	ETF	123.17	123.26	123.08	123.16	418500.0
2006-12-05 14:00:00	DIA	ETF	123.14	123.37	123.11	123.28	554600.0
2006-12-05 15:00:00	DIA	ETF	123.28	123.32	123.12	123.31	644000.0
2006-12-05 16:00:00	DIA	ETF	123.32	123.36	123.27	123.29	185700.0
2006-12-05 18:00:00	DIA	ETF	123.39	123.39	123.39	123.39	100.0
2006-12-05 08:00:00	GLD	ETF	64.0	64.31	63.99	64.23	258500.0
2006-12-05 09:00:00	GLD	ETF	64.17	64.42	64.13	64.33	590200.0
2006-12-05 10:00:00	GLD	ETF	64.32	64.33	63.36	63.7	1866400.0
2006-12-05 11:00:00	GLD	ETF	63.7002	63.96	63.67	63.82	846000.0
2006-12-05 12:00:00	GLD	ETF	63.82	63.95	63.75	63.86	370100.0
2006-12-05 13:00:00	GLD	ETF	63.8699	63.9199	63.71	63.9	398000.0
2006-12-05 14:00:00	GLD	ETF	63.89	63.9	63.6	63.74	387100.0

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

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