PREVIEW / etf_1hour / 2016-12-02

all etf 1-hour files

  file:    by_date/etf_1hour/2016/2016-12-02.parquet
  size:    272 KB
  rows:    8,731

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
2016-12-02 04:00:00	SPY	ETF	219.25	219.25	218.99	219.15	57133.0
2016-12-02 05:00:00	SPY	ETF	219.09	219.14	219.01	219.11	9007.0
2016-12-02 06:00:00	SPY	ETF	219.07	219.19	219.06	219.06	12116.0
2016-12-02 07:00:00	SPY	ETF	219.1	219.4	219.1	219.36	137317.0
2016-12-02 08:00:00	SPY	ETF	219.2	219.69	219.12	219.53	745629.0
2016-12-02 09:00:00	SPY	ETF	219.53	220.0	219.46	219.92	7879471.0
2016-12-02 10:00:00	SPY	ETF	219.93	220.16	219.61	219.95	9484426.0
2016-12-02 11:00:00	SPY	ETF	219.96	220.25	219.87	219.92	12283820.0
2016-12-02 12:00:00	SPY	ETF	219.915	219.95	219.51	219.87	5840921.0
2016-12-02 13:00:00	SPY	ETF	219.865	219.8859	219.32	219.415	7237965.0
2016-12-02 14:00:00	SPY	ETF	219.41	219.54	219.26	219.42	5676350.0
2016-12-02 15:00:00	SPY	ETF	219.42	219.87	219.38	219.66	15738235.0
2016-12-02 16:00:00	SPY	ETF	219.69	219.86	219.545	219.6	8533396.0
2016-12-02 17:00:00	SPY	ETF	219.65	219.75	219.52	219.68	90582.0
2016-12-02 18:00:00	SPY	ETF	219.66	219.68	219.29	219.37	178926.0
2016-12-02 19:00:00	SPY	ETF	219.39	219.44	219.36	219.44	29147.0
2016-12-02 04:00:00	QQQ	ETF	115.16	115.16	114.98	114.99	5142.0
2016-12-02 05:00:00	QQQ	ETF	115.0	115.02	115.0	115.02	11206.0
2016-12-02 06:00:00	QQQ	ETF	114.98	115.04	114.97	115.0	11756.0
2016-12-02 07:00:00	QQQ	ETF	115.02	115.22	115.02	115.19	13087.0
2016-12-02 08:00:00	QQQ	ETF	115.14	115.53	115.05	115.45	270256.0
2016-12-02 09:00:00	QQQ	ETF	115.45	116.16	115.34	115.72	4747333.0
2016-12-02 10:00:00	QQQ	ETF	115.73	115.93	115.22	115.79	4023903.0
2016-12-02 11:00:00	QQQ	ETF	115.79	116.13	115.71	115.755	2455782.0
2016-12-02 12:00:00	QQQ	ETF	115.76	115.935	115.631	115.895	1276877.0
2016-12-02 13:00:00	QQQ	ETF	115.88	115.89	115.51	115.6199	1396986.0
2016-12-02 14:00:00	QQQ	ETF	115.61	115.67	115.45	115.585	1685067.0
2016-12-02 15:00:00	QQQ	ETF	115.59	115.765	115.47	115.69	3673703.0
2016-12-02 16:00:00	QQQ	ETF	115.69	115.73	115.52	115.52	577501.0
2016-12-02 17:00:00	QQQ	ETF	115.55	115.6	115.51	115.51	2546.0
2016-12-02 18:00:00	QQQ	ETF	115.5	115.68	115.5	115.68	2816.0
2016-12-02 19:00:00	QQQ	ETF	115.66	115.67	115.65	115.65	1150.0
2016-12-02 04:00:00	IWM	ETF	130.6	130.74	130.6	130.65	963.0
2016-12-02 06:00:00	IWM	ETF	130.67	130.67	130.67	130.67	700.0
2016-12-02 07:00:00	IWM	ETF	130.72	130.75	130.71	130.73	36067.0
2016-12-02 08:00:00	IWM	ETF	130.74	131.04	130.71	130.99	178576.0
2016-12-02 09:00:00	IWM	ETF	130.96	131.287	130.8	131.205	2552392.0
2016-12-02 10:00:00	IWM	ETF	131.21	131.36	130.52	131.3	3318382.0
2016-12-02 11:00:00	IWM	ETF	131.3	131.47	131.09	131.13	2020026.0
2016-12-02 12:00:00	IWM	ETF	131.12	131.19	130.84	131.06	2776844.0
2016-12-02 13:00:00	IWM	ETF	131.05	131.054	130.67	130.77	1650218.0
2016-12-02 14:00:00	IWM	ETF	130.7662	130.92	130.65	130.83	1245585.0
2016-12-02 15:00:00	IWM	ETF	130.83	131.12	130.74	130.86	4352552.0
2016-12-02 16:00:00	IWM	ETF	130.85	130.98	130.8	130.97	1542907.0
2016-12-02 17:00:00	IWM	ETF	130.99	131.0	130.8511	130.94	394240.0
2016-12-02 18:00:00	IWM	ETF	130.94	130.94	130.82	130.85	4680.0
2016-12-02 04:00:00	DIA	ETF	191.64	191.64	191.64	191.64	100.0
2016-12-02 05:00:00	DIA	ETF	191.68	191.68	191.68	191.68	100.0
2016-12-02 06:00:00	DIA	ETF	191.69	191.7	191.69	191.7	200.0
2016-12-02 07:00:00	DIA	ETF	191.82	191.83	191.82	191.83	200.0

> showing 50 of 8,731 rows — these rows as CSV

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