PREVIEW / etf_1hour / 2010-12-08

all etf 1-hour files

  file:    by_date/etf_1hour/2010/2010-12-08.parquet
  size:    174 KB
  rows:    5,290

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
2010-12-08 04:00:00	SPY	ETF	122.43	122.78	122.4	122.75	1476.0
2010-12-08 05:00:00	SPY	ETF	122.65	122.7	122.65	122.67	2850.0
2010-12-08 06:00:00	SPY	ETF	122.67	122.73	122.61	122.61	6660.0
2010-12-08 07:00:00	SPY	ETF	122.59	122.86	122.56	122.68	165635.0
2010-12-08 08:00:00	SPY	ETF	122.74	123.15	122.7	123.06	1253758.0
2010-12-08 09:00:00	SPY	ETF	123.05	123.38	122.89	123.12	15529486.0
2010-12-08 10:00:00	SPY	ETF	123.11	123.13	122.41	122.73	33690042.0
2010-12-08 11:00:00	SPY	ETF	122.73	123.11	122.655	123.06	13588255.0
2010-12-08 12:00:00	SPY	ETF	123.07	123.12	122.78	122.88	10116193.0
2010-12-08 13:00:00	SPY	ETF	122.88	123.24	122.85	123.1	12453083.0
2010-12-08 14:00:00	SPY	ETF	123.11	123.37	123.0	123.2	12448212.0
2010-12-08 15:00:00	SPY	ETF	123.2	123.38	122.98	123.25	26784204.0
2010-12-08 16:00:00	SPY	ETF	123.27	123.49	122.685	123.49	7291834.0
2010-12-08 17:00:00	SPY	ETF	123.5	123.55	123.47	123.48	190547.0
2010-12-08 18:00:00	SPY	ETF	123.48	123.74	123.29	123.7	193084.0
2010-12-08 19:00:00	SPY	ETF	123.7	123.77	123.65	123.77	75545.0
2010-12-08 06:00:00	QQQ	ETF	53.86	53.89	53.85	53.88	4639.0
2010-12-08 07:00:00	QQQ	ETF	53.86	53.94	53.86	53.9	30124.0
2010-12-08 08:00:00	QQQ	ETF	53.89	54.07	53.89	54.02	173232.0
2010-12-08 09:00:00	QQQ	ETF	54.02	54.15	53.96	54.011	6720044.0
2010-12-08 10:00:00	QQQ	ETF	54.01	54.015	53.6899	53.83	13974042.0
2010-12-08 11:00:00	QQQ	ETF	53.838	54.02	53.81	53.9877	4215345.0
2010-12-08 12:00:00	QQQ	ETF	53.99	54.01	53.85	53.88	2383432.0
2010-12-08 13:00:00	QQQ	ETF	53.889	54.03	53.87	53.9801	3879799.0
2010-12-08 14:00:00	QQQ	ETF	53.98	54.12	53.94	54.06	3564289.0
2010-12-08 15:00:00	QQQ	ETF	54.05	54.13	53.95	54.1	6727000.0
2010-12-08 16:00:00	QQQ	ETF	54.09	54.18	54.0336	54.17	2837476.0
2010-12-08 17:00:00	QQQ	ETF	54.18	54.19	54.12	54.12	6812.0
2010-12-08 18:00:00	QQQ	ETF	54.15	54.26	54.14	54.25	53794.0
2010-12-08 19:00:00	QQQ	ETF	54.23	54.32	54.22	54.26	37961.0
2010-12-08 04:00:00	IWM	ETF	76.3	76.54	76.3	76.54	300.0
2010-12-08 06:00:00	IWM	ETF	76.51	76.51	76.51	76.51	100.0
2010-12-08 07:00:00	IWM	ETF	76.51	76.67	76.51	76.63	23400.0
2010-12-08 08:00:00	IWM	ETF	76.59	76.89	76.59	76.82	198738.0
2010-12-08 09:00:00	IWM	ETF	76.81	77.01	76.58	76.73	5740199.0
2010-12-08 10:00:00	IWM	ETF	76.73	76.73	76.37	76.6	8387887.0
2010-12-08 11:00:00	IWM	ETF	76.61	76.82	76.57	76.81	3909340.0
2010-12-08 12:00:00	IWM	ETF	76.81	76.85	76.5	76.54	2478343.0
2010-12-08 13:00:00	IWM	ETF	76.55	76.78	76.52	76.73	3510572.0
2010-12-08 14:00:00	IWM	ETF	76.739	76.81	76.64	76.645	3442747.0
2010-12-08 15:00:00	IWM	ETF	76.65	76.69	76.46	76.53	5694968.0
2010-12-08 16:00:00	IWM	ETF	76.52	76.77	76.52	76.77	1816980.0
2010-12-08 17:00:00	IWM	ETF	76.74	76.78	76.7	76.77	162000.0
2010-12-08 18:00:00	IWM	ETF	76.77	76.85	76.73	76.85	9200.0
2010-12-08 19:00:00	IWM	ETF	76.86	76.9	76.82	76.9	2871.0
2010-12-08 04:00:00	DIA	ETF	113.62	113.62	113.62	113.62	100.0
2010-12-08 07:00:00	DIA	ETF	113.5	113.62	113.5	113.62	1600.0
2010-12-08 08:00:00	DIA	ETF	113.56	113.88	113.56	113.88	19000.0
2010-12-08 09:00:00	DIA	ETF	113.86	114.08	113.67	113.91	529590.0
2010-12-08 10:00:00	DIA	ETF	113.9	113.91	113.45	113.63	1462774.0

> showing 50 of 5,290 rows — these rows as CSV

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