PREVIEW / etf_1hour / 2011-02-02

all etf 1-hour files

  file:    by_date/etf_1hour/2011/2011-02-02.parquet
  size:    171 KB
  rows:    5,270

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
2011-02-02 04:00:00	SPY	ETF	130.76	130.76	130.66	130.68	6822.0
2011-02-02 05:00:00	SPY	ETF	130.75	130.9	130.72	130.86	6700.0
2011-02-02 06:00:00	SPY	ETF	130.82	130.91	130.7	130.71	33600.0
2011-02-02 07:00:00	SPY	ETF	130.63	130.74	130.61	130.64	264589.0
2011-02-02 08:00:00	SPY	ETF	130.64	130.7	130.37	130.46	1606328.0
2011-02-02 09:00:00	SPY	ETF	130.46	130.74	130.19	130.6901	16535454.0
2011-02-02 10:00:00	SPY	ETF	130.7	130.84	130.38	130.65	19801506.0
2011-02-02 11:00:00	SPY	ETF	130.66	130.68	130.39	130.64	13035136.0
2011-02-02 12:00:00	SPY	ETF	130.65	130.67	130.39	130.5499	10799501.0
2011-02-02 13:00:00	SPY	ETF	130.55	130.66	130.48	130.54	8338562.0
2011-02-02 14:00:00	SPY	ETF	130.535	130.8381	130.48	130.67	10014498.0
2011-02-02 15:00:00	SPY	ETF	130.67	130.838	130.33	130.47	25720364.0
2011-02-02 16:00:00	SPY	ETF	130.47	130.838	130.38	130.46	8420749.0
2011-02-02 17:00:00	SPY	ETF	130.46	130.47	130.41	130.43	111559.0
2011-02-02 18:00:00	SPY	ETF	130.45	130.838	130.42	130.47	645533.0
2011-02-02 19:00:00	SPY	ETF	130.43	130.52	130.42	130.46	34241.0
2011-02-02 05:00:00	QQQ	ETF	57.02	57.05	57.02	57.05	10200.0
2011-02-02 07:00:00	QQQ	ETF	56.99	57.02	56.97	57.01	29120.0
2011-02-02 08:00:00	QQQ	ETF	57.01	57.02	56.88	56.93	1585719.0
2011-02-02 09:00:00	QQQ	ETF	56.94	57.05	56.8	57.03	9415042.0
2011-02-02 10:00:00	QQQ	ETF	57.0284	57.17	56.84	57.06	8329055.0
2011-02-02 11:00:00	QQQ	ETF	57.06	57.1	56.92	57.09	5690692.0
2011-02-02 12:00:00	QQQ	ETF	57.09	57.1	56.9404	57.0	3694122.0
2011-02-02 13:00:00	QQQ	ETF	57.01	57.022	56.951	56.98	4026711.0
2011-02-02 14:00:00	QQQ	ETF	56.98	57.08	56.96	57.07	3120535.0
2011-02-02 15:00:00	QQQ	ETF	57.06	57.12	56.88	56.95	7431506.0
2011-02-02 16:00:00	QQQ	ETF	56.95	56.98	56.91	56.97	1959519.0
2011-02-02 17:00:00	QQQ	ETF	56.98	56.98	56.94	56.94	18200.0
2011-02-02 18:00:00	QQQ	ETF	56.97	56.97	56.95	56.95	7988.0
2011-02-02 19:00:00	QQQ	ETF	56.96	56.97	56.94	56.94	9512.0
2011-02-02 06:00:00	IWM	ETF	79.9	79.9	79.9	79.9	210.0
2011-02-02 07:00:00	IWM	ETF	79.74	79.85	79.7	79.75	43600.0
2011-02-02 08:00:00	IWM	ETF	79.75	79.78	79.55	79.59	338678.0
2011-02-02 09:00:00	IWM	ETF	79.59	80.13	79.38	80.11	5899880.0
2011-02-02 10:00:00	IWM	ETF	80.11	80.11	79.64	79.73	6612075.0
2011-02-02 11:00:00	IWM	ETF	79.73	79.8201	79.47	79.76	5473886.0
2011-02-02 12:00:00	IWM	ETF	79.7605	79.77	79.42	79.5	4607973.0
2011-02-02 13:00:00	IWM	ETF	79.5	79.59	79.42	79.51	2938416.0
2011-02-02 14:00:00	IWM	ETF	79.51	79.68	79.45	79.6	3629553.0
2011-02-02 15:00:00	IWM	ETF	79.6	79.715	79.43	79.47	6018891.0
2011-02-02 16:00:00	IWM	ETF	79.47	79.58	79.42	79.54	1446153.0
2011-02-02 17:00:00	IWM	ETF	79.55	79.55	79.54	79.55	8800.0
2011-02-02 18:00:00	IWM	ETF	79.48	79.48	79.48	79.48	1100.0
2011-02-02 19:00:00	IWM	ETF	79.47	79.47	79.47	79.47	100.0
2011-02-02 07:00:00	DIA	ETF	120.0	120.03	119.92	119.99	25400.0
2011-02-02 08:00:00	DIA	ETF	119.98	120.03	119.82	119.82	31783.0
2011-02-02 09:00:00	DIA	ETF	119.81	120.21	119.71	120.16	624899.0
2011-02-02 10:00:00	DIA	ETF	120.15	120.28	119.95	120.16	1010814.0
2011-02-02 11:00:00	DIA	ETF	120.15	120.2106	119.9901	120.2106	540034.0
2011-02-02 12:00:00	DIA	ETF	120.22	120.22	120.03	120.18	266238.0

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

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