PREVIEW / etf_1hour / 2016-07-21

all etf 1-hour files

  file:    by_date/etf_1hour/2016/2016-07-21.parquet
  size:    254 KB
  rows:    8,051

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-07-21 04:00:00	SPY	ETF	217.15	217.2	216.76	216.96	21549.0
2016-07-21 05:00:00	SPY	ETF	216.94	216.95	216.68	216.8	30026.0
2016-07-21 06:00:00	SPY	ETF	216.84	217.05	216.84	216.98	37435.0
2016-07-21 07:00:00	SPY	ETF	216.94	217.08	216.89	217.05	177887.0
2016-07-21 08:00:00	SPY	ETF	217.06	217.11	216.76	216.9	486225.0
2016-07-21 09:00:00	SPY	ETF	216.9	217.22	216.8	216.91	6627206.0
2016-07-21 10:00:00	SPY	ETF	216.9	217.18	216.82	217.16	7621731.0
2016-07-21 11:00:00	SPY	ETF	217.16	217.18	216.39	216.55	7987874.0
2016-07-21 12:00:00	SPY	ETF	216.56	216.64	216.27	216.335	8640868.0
2016-07-21 13:00:00	SPY	ETF	216.33	216.5	216.06	216.18	6770010.0
2016-07-21 14:00:00	SPY	ETF	216.18	216.22	215.9225	216.01	6761322.0
2016-07-21 15:00:00	SPY	ETF	216.01	217.0789	215.75	216.25	17534951.0
2016-07-21 16:00:00	SPY	ETF	216.24	216.34	216.0467	216.3	3684173.0
2016-07-21 17:00:00	SPY	ETF	216.29	216.3	216.2	216.25	110429.0
2016-07-21 18:00:00	SPY	ETF	216.27	216.31	216.19	216.24	116370.0
2016-07-21 19:00:00	SPY	ETF	216.24	216.27	216.16	216.24	31329.0
2016-07-21 04:00:00	QQQ	ETF	113.51	113.57	113.51	113.57	200.0
2016-07-21 05:00:00	QQQ	ETF	113.39	113.39	113.34	113.34	9597.0
2016-07-21 06:00:00	QQQ	ETF	113.39	113.43	113.38	113.43	1200.0
2016-07-21 07:00:00	QQQ	ETF	113.45	113.56	113.45	113.55	46098.0
2016-07-21 08:00:00	QQQ	ETF	113.52	113.57	113.42	113.49	48203.0
2016-07-21 09:00:00	QQQ	ETF	113.49	113.74	113.42	113.47	2615956.0
2016-07-21 10:00:00	QQQ	ETF	113.47	113.68	113.39	113.52	1779270.0
2016-07-21 11:00:00	QQQ	ETF	113.52	113.61	113.16	113.28	1283672.0
2016-07-21 12:00:00	QQQ	ETF	113.28	113.311	113.141	113.193	939920.0
2016-07-21 13:00:00	QQQ	ETF	113.19	113.31	113.08	113.16	2169282.0
2016-07-21 14:00:00	QQQ	ETF	113.16	113.179	112.96	113.015	1903514.0
2016-07-21 15:00:00	QQQ	ETF	113.01	113.22	112.87	113.18	3242681.0
2016-07-21 16:00:00	QQQ	ETF	113.19	113.23	113.1021	113.2	725037.0
2016-07-21 17:00:00	QQQ	ETF	113.12	113.13	113.04	113.05	65265.0
2016-07-21 18:00:00	QQQ	ETF	113.11	113.17	113.08	113.13	56268.0
2016-07-21 19:00:00	QQQ	ETF	113.13	113.14	113.11	113.11	7200.0
2016-07-21 04:00:00	IWM	ETF	119.98	119.98	119.9	119.96	18400.0
2016-07-21 05:00:00	IWM	ETF	119.95	119.95	119.92	119.92	5000.0
2016-07-21 06:00:00	IWM	ETF	119.92	120.0	119.92	120.0	6874.0
2016-07-21 07:00:00	IWM	ETF	120.0	120.05	119.87	120.02	39815.0
2016-07-21 08:00:00	IWM	ETF	119.94	120.05	119.9	119.96	62671.0
2016-07-21 09:00:00	IWM	ETF	119.98	120.49	119.96	120.2	2131678.0
2016-07-21 10:00:00	IWM	ETF	120.2	120.595	120.15	120.54	2424787.0
2016-07-21 11:00:00	IWM	ETF	120.54	120.545	119.72	119.815	3221777.0
2016-07-21 12:00:00	IWM	ETF	119.815	119.9	119.575	119.61	1917673.0
2016-07-21 13:00:00	IWM	ETF	119.6	119.79	119.425	119.48	1611914.0
2016-07-21 14:00:00	IWM	ETF	119.48	119.56	119.3	119.431	1996548.0
2016-07-21 15:00:00	IWM	ETF	119.43	119.68	119.25	119.51	3433931.0
2016-07-21 16:00:00	IWM	ETF	119.52	119.56	119.37	119.51	525028.0
2016-07-21 17:00:00	IWM	ETF	119.46	119.5	119.45	119.5	3163.0
2016-07-21 18:00:00	IWM	ETF	119.45	119.45	119.45	119.45	100.0
2016-07-21 19:00:00	IWM	ETF	119.51	119.53	119.51	119.52	2000.0
2016-07-21 04:00:00	DIA	ETF	185.74	185.74	185.74	185.74	600.0
2016-07-21 05:00:00	DIA	ETF	185.51	185.51	185.51	185.51	200.0

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

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