PREVIEW / etf_1hour / 2017-02-13

all etf 1-hour files

  file:    by_date/etf_1hour/2017/2017-02-13.parquet
  size:    279 KB
  rows:    9,135

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
2017-02-13 04:00:00	SPY	ETF	231.68	231.74	231.67	231.74	1060.0
2017-02-13 05:00:00	SPY	ETF	231.7	231.77	231.67	231.68	3143.0
2017-02-13 06:00:00	SPY	ETF	231.72	231.79	231.72	231.78	6304.0
2017-02-13 07:00:00	SPY	ETF	231.78	231.95	231.78	231.89	84537.0
2017-02-13 08:00:00	SPY	ETF	231.85	232.06	231.78	232.01	386250.0
2017-02-13 09:00:00	SPY	ETF	232.0	232.45	231.94	232.291	7394056.0
2017-02-13 10:00:00	SPY	ETF	232.2905	232.51	232.28	232.49	6931547.0
2017-02-13 11:00:00	SPY	ETF	232.49	232.64	232.33	232.4037	4953955.0
2017-02-13 12:00:00	SPY	ETF	232.4	232.75	232.39	232.73	4114859.0
2017-02-13 13:00:00	SPY	ETF	232.726	233.07	232.65	232.91	5784361.0
2017-02-13 14:00:00	SPY	ETF	232.9151	232.99	232.72	232.74	5838460.0
2017-02-13 15:00:00	SPY	ETF	232.73	232.845	232.63	232.73	11579469.0
2017-02-13 16:00:00	SPY	ETF	232.74	232.88	232.5995	232.86	6358390.0
2017-02-13 17:00:00	SPY	ETF	232.85	232.87	232.77	232.83	212676.0
2017-02-13 18:00:00	SPY	ETF	232.83	232.91	232.77	232.84	49364.0
2017-02-13 19:00:00	SPY	ETF	232.87	232.88	232.81	232.84	65695.0
2017-02-13 04:00:00	QQQ	ETF	127.51	127.51	127.51	127.51	100.0
2017-02-13 05:00:00	QQQ	ETF	127.51	127.51	127.44	127.44	200.0
2017-02-13 06:00:00	QQQ	ETF	127.49	127.55	127.47	127.47	57117.0
2017-02-13 07:00:00	QQQ	ETF	127.56	127.62	127.53	127.61	15389.0
2017-02-13 08:00:00	QQQ	ETF	127.58	127.65	127.58	127.63	38611.0
2017-02-13 09:00:00	QQQ	ETF	127.63	127.91	127.63	127.865	2924229.0
2017-02-13 10:00:00	QQQ	ETF	127.8645	128.0	127.83	127.97	2419601.0
2017-02-13 11:00:00	QQQ	ETF	127.97	128.05	127.85	127.963	2168870.0
2017-02-13 12:00:00	QQQ	ETF	127.965	128.14	127.95	128.1038	1308805.0
2017-02-13 13:00:00	QQQ	ETF	128.1	128.21	128.05	128.17	1652786.0
2017-02-13 14:00:00	QQQ	ETF	128.18	128.26	128.13	128.14	1055397.0
2017-02-13 15:00:00	QQQ	ETF	128.15	128.2265	128.05	128.09	2996193.0
2017-02-13 16:00:00	QQQ	ETF	128.11	128.25	128.08	128.25	883640.0
2017-02-13 17:00:00	QQQ	ETF	128.11	128.24	128.11	128.2	61609.0
2017-02-13 18:00:00	QQQ	ETF	128.21	128.21	128.19	128.19	5415.0
2017-02-13 19:00:00	QQQ	ETF	128.18	128.22	128.18	128.18	4323.0
2017-02-13 04:00:00	IWM	ETF	138.21	138.36	138.21	138.36	812.0
2017-02-13 05:00:00	IWM	ETF	138.36	138.39	138.3	138.3	600.0
2017-02-13 07:00:00	IWM	ETF	138.43	138.54	138.41	138.46	19476.0
2017-02-13 08:00:00	IWM	ETF	138.45	138.77	138.44	138.77	46699.0
2017-02-13 09:00:00	IWM	ETF	137.94	139.205	137.94	138.77	3209205.0
2017-02-13 10:00:00	IWM	ETF	138.78	139.01	138.46	138.86	2381547.0
2017-02-13 11:00:00	IWM	ETF	138.86	138.91	138.37	138.38	2056808.0
2017-02-13 12:00:00	IWM	ETF	138.38	138.58	138.37	138.5372	1107204.0
2017-02-13 13:00:00	IWM	ETF	138.535	138.77	138.5	138.55	1246557.0
2017-02-13 14:00:00	IWM	ETF	138.55	138.6	138.26	138.29	1536826.0
2017-02-13 15:00:00	IWM	ETF	138.2801	138.4	138.09	138.33	3749328.0
2017-02-13 16:00:00	IWM	ETF	138.3	138.51	138.27	138.31	1838326.0
2017-02-13 17:00:00	IWM	ETF	138.3	138.31	138.29	138.29	101028.0
2017-02-13 18:00:00	IWM	ETF	138.35	138.35	138.35	138.35	300.0
2017-02-13 19:00:00	IWM	ETF	138.35	138.35	138.31	138.31	2800.0
2017-02-13 04:00:00	DIA	ETF	203.01	203.01	203.01	203.01	200.0
2017-02-13 07:00:00	DIA	ETF	203.19	203.19	203.19	203.19	1300.0
2017-02-13 08:00:00	DIA	ETF	203.21	203.38	203.21	203.35	8799.0

> showing 50 of 9,135 rows — these rows as CSV

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