PREVIEW / etf_1hour / 2016-11-09

all etf 1-hour files

  file:    by_date/etf_1hour/2016/2016-11-09.parquet
  size:    292 KB
  rows:    9,342

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-11-09 04:00:00	SPY	ETF	210.14	211.38	209.57	210.22	692769.0
2016-11-09 05:00:00	SPY	ETF	210.19	210.8	209.31	210.0	717685.0
2016-11-09 06:00:00	SPY	ETF	210.0	210.0	208.31	209.49	1966642.0
2016-11-09 07:00:00	SPY	ETF	209.48	211.55	209.4	211.44	5442466.0
2016-11-09 08:00:00	SPY	ETF	211.44	215.6	203.35	211.5	11019279.0
2016-11-09 09:00:00	SPY	ETF	211.53	214.63	205.4	214.43	59222747.0
2016-11-09 10:00:00	SPY	ETF	214.43	214.45	213.04	213.82	36194071.0
2016-11-09 11:00:00	SPY	ETF	213.8	216.45	213.79	215.99	33881523.0
2016-11-09 12:00:00	SPY	ETF	215.995	216.1	214.87	215.96	18151209.0
2016-11-09 13:00:00	SPY	ETF	215.961	216.25	215.21	215.8372	17908717.0
2016-11-09 14:00:00	SPY	ETF	215.835	216.915	215.73	216.45	19277820.0
2016-11-09 15:00:00	SPY	ETF	216.445	217.1	216.04	216.41	38155477.0
2016-11-09 16:00:00	SPY	ETF	216.43	216.7	214.46	216.53	13823612.0
2016-11-09 17:00:00	SPY	ETF	216.53	216.54	216.44	216.45	279028.0
2016-11-09 18:00:00	SPY	ETF	216.44	216.44	216.02	216.17	185785.0
2016-11-09 19:00:00	SPY	ETF	216.2	216.69	216.05	216.5	205327.0
2016-11-09 04:00:00	QQQ	ETF	114.5	115.0	113.83	114.71	109872.0
2016-11-09 05:00:00	QQQ	ETF	114.47	114.91	114.25	114.51	16452.0
2016-11-09 06:00:00	QQQ	ETF	114.58	114.58	113.58	114.1	98861.0
2016-11-09 07:00:00	QQQ	ETF	114.29	115.25	114.23	115.23	852676.0
2016-11-09 08:00:00	QQQ	ETF	115.26	115.48	111.7	115.12	1289062.0
2016-11-09 09:00:00	QQQ	ETF	115.11	117.16	115.09	116.88	14781330.0
2016-11-09 10:00:00	QQQ	ETF	116.88	116.89	115.82	116.42	9171370.0
2016-11-09 11:00:00	QQQ	ETF	116.41	117.82	116.41	117.42	6871766.0
2016-11-09 12:00:00	QQQ	ETF	117.43	117.625	116.88	117.59	4003969.0
2016-11-09 13:00:00	QQQ	ETF	117.59	117.639	116.63	116.91	5473565.0
2016-11-09 14:00:00	QQQ	ETF	116.91	117.69	116.8	117.29	4254074.0
2016-11-09 15:00:00	QQQ	ETF	117.29	117.84	117.29	117.62	8168126.0
2016-11-09 16:00:00	QQQ	ETF	117.6	117.83	117.1371	117.66	1423548.0
2016-11-09 17:00:00	QQQ	ETF	117.6	117.63	117.55	117.59	220897.0
2016-11-09 18:00:00	QQQ	ETF	117.57	117.57	117.38	117.39	42435.0
2016-11-09 19:00:00	QQQ	ETF	117.54	117.8	117.45	117.7	44786.0
2016-11-09 04:00:00	IWM	ETF	116.7	117.4	116.6	117.05	84701.0
2016-11-09 05:00:00	IWM	ETF	116.7	117.05	116.49	116.8	65630.0
2016-11-09 06:00:00	IWM	ETF	116.78	117.07	116.24	116.89	38144.0
2016-11-09 07:00:00	IWM	ETF	116.94	117.96	116.88	117.96	431437.0
2016-11-09 08:00:00	IWM	ETF	117.94	118.09	112.9	117.85	1645611.0
2016-11-09 09:00:00	IWM	ETF	117.87	119.93	117.71	119.73	12336527.0
2016-11-09 10:00:00	IWM	ETF	119.73	119.7864	118.9	119.7	8271218.0
2016-11-09 11:00:00	IWM	ETF	119.68	121.81	119.68	121.49	8951290.0
2016-11-09 12:00:00	IWM	ETF	121.49	121.78	120.68	121.75	6592522.0
2016-11-09 13:00:00	IWM	ETF	121.75	121.99	121.05	121.73	5971294.0
2016-11-09 14:00:00	IWM	ETF	121.74	122.44	121.68	122.27	6566748.0
2016-11-09 15:00:00	IWM	ETF	122.28	122.83	122.12	122.55	11489160.0
2016-11-09 16:00:00	IWM	ETF	122.54	122.76	119.4062	122.43	3923280.0
2016-11-09 17:00:00	IWM	ETF	122.46	122.54	122.37	122.45	128157.0
2016-11-09 18:00:00	IWM	ETF	122.43	122.54	122.43	122.54	5669.0
2016-11-09 19:00:00	IWM	ETF	122.26	122.5	122.26	122.44	6445.0
2016-11-09 04:00:00	DIA	ETF	181.45	182.4	180.2	180.54	13150.0
2016-11-09 06:00:00	DIA	ETF	180.08	180.08	179.28	179.64	2450.0

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

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