PREVIEW / etf_1hour / 2014-12-23

all etf 1-hour files

  file:    by_date/etf_1hour/2014/2014-12-23.parquet
  size:    237 KB
  rows:    7,579

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
2014-12-23 04:00:00	SPY	ETF	207.18	207.25	207.1	207.25	25241.0
2014-12-23 05:00:00	SPY	ETF	207.2	207.27	207.15	207.27	5099.0
2014-12-23 06:00:00	SPY	ETF	207.34	207.4	207.34	207.34	1200.0
2014-12-23 07:00:00	SPY	ETF	207.42	207.62	207.38	207.56	50019.0
2014-12-23 08:00:00	SPY	ETF	207.57	208.18	207.5	208.18	1006189.0
2014-12-23 09:00:00	SPY	ETF	208.17	208.38	207.785	207.9	11693403.0
2014-12-23 10:00:00	SPY	ETF	207.91	208.15	207.51	207.86	23226710.0
2014-12-23 11:00:00	SPY	ETF	207.86	208.0	207.77	207.83	13429636.0
2014-12-23 12:00:00	SPY	ETF	207.82	208.02	207.76	207.98	8601128.0
2014-12-23 13:00:00	SPY	ETF	207.985	208.115	207.91	208.01	8716607.0
2014-12-23 14:00:00	SPY	ETF	208.02	208.23	207.92	208.08	11067849.0
2014-12-23 15:00:00	SPY	ETF	208.08	208.17	207.71	207.75	24412763.0
2014-12-23 16:00:00	SPY	ETF	207.75	208.0	207.67	207.96	12065670.0
2014-12-23 17:00:00	SPY	ETF	207.96	207.96	207.7623	207.92	1462146.0
2014-12-23 18:00:00	SPY	ETF	207.92	207.94	207.75	207.94	1453432.0
2014-12-23 19:00:00	SPY	ETF	207.93	207.99	207.91	207.92	130386.0
2014-12-23 07:00:00	QQQ	ETF	104.62	104.71	104.62	104.71	6200.0
2014-12-23 08:00:00	QQQ	ETF	104.64	104.86	104.62	104.83	250440.0
2014-12-23 09:00:00	QQQ	ETF	104.84	105.01	104.33	104.48	3962175.0
2014-12-23 10:00:00	QQQ	ETF	104.48	104.58	104.09	104.31	4383304.0
2014-12-23 11:00:00	QQQ	ETF	104.3	104.51	104.26	104.41	3794039.0
2014-12-23 12:00:00	QQQ	ETF	104.415	104.44	104.2	104.28	2075735.0
2014-12-23 13:00:00	QQQ	ETF	104.28	104.51	104.23	104.45	2039846.0
2014-12-23 14:00:00	QQQ	ETF	104.45	104.51	104.38	104.3961	2430443.0
2014-12-23 15:00:00	QQQ	ETF	104.395	104.48	104.2	104.22	3673131.0
2014-12-23 16:00:00	QQQ	ETF	104.21	104.569	104.15	104.24	1424022.0
2014-12-23 17:00:00	QQQ	ETF	104.22	104.22	104.18	104.18	4629.0
2014-12-23 18:00:00	QQQ	ETF	104.18	104.21	104.16	104.21	3416092.0
2014-12-23 19:00:00	QQQ	ETF	104.24	104.28	104.24	104.26	4040.0
2014-12-23 05:00:00	IWM	ETF	119.97	119.97	119.97	119.97	380.0
2014-12-23 06:00:00	IWM	ETF	120.0	120.0	120.0	120.0	100.0
2014-12-23 07:00:00	IWM	ETF	119.96	120.01	119.96	120.01	350.0
2014-12-23 08:00:00	IWM	ETF	120.1	120.47	120.0	120.47	246682.0
2014-12-23 09:00:00	IWM	ETF	120.45	120.56	120.0001	120.19	3463985.0
2014-12-23 10:00:00	IWM	ETF	120.2	120.36	119.62	119.91	5107862.0
2014-12-23 11:00:00	IWM	ETF	119.91	120.19	119.84	120.1	2783194.0
2014-12-23 12:00:00	IWM	ETF	120.1	120.17	119.94	120.0	3120196.0
2014-12-23 13:00:00	IWM	ETF	120.005	120.08	119.86	119.9	2727687.0
2014-12-23 14:00:00	IWM	ETF	119.905	119.95	119.69	119.74	2465977.0
2014-12-23 15:00:00	IWM	ETF	119.74	119.86	119.45	119.83	4784447.0
2014-12-23 16:00:00	IWM	ETF	119.83	120.01	119.77	119.9	746723.0
2014-12-23 17:00:00	IWM	ETF	119.89	119.89	119.79	119.79	13105.0
2014-12-23 18:00:00	IWM	ETF	119.77	119.86	119.77	119.86	286354.0
2014-12-23 19:00:00	IWM	ETF	119.85	119.85	119.82	119.85	1275.0
2014-12-23 08:00:00	DIA	ETF	179.5	180.0	179.5	179.85	48915.0
2014-12-23 09:00:00	DIA	ETF	179.91	180.0	179.68	179.91	524636.0
2014-12-23 10:00:00	DIA	ETF	179.93	180.2	179.8	180.11	1028282.0
2014-12-23 11:00:00	DIA	ETF	180.11	180.19	180.01	180.06	647751.0
2014-12-23 12:00:00	DIA	ETF	180.07	180.27	180.0	180.24	651073.0
2014-12-23 13:00:00	DIA	ETF	180.24	180.4	180.19	180.24	607028.0

> showing 50 of 7,579 rows — these rows as CSV

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