PREVIEW / etf_1hour / 2016-11-15

all etf 1-hour files

  file:    by_date/etf_1hour/2016/2016-11-15.parquet
  size:    274 KB
  rows:    8,791

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-15 04:00:00	SPY	ETF	217.29	217.42	216.89	216.89	27297.0
2016-11-15 05:00:00	SPY	ETF	217.01	217.12	216.95	216.95	11220.0
2016-11-15 06:00:00	SPY	ETF	216.94	216.99	216.71	216.91	36309.0
2016-11-15 07:00:00	SPY	ETF	216.89	216.91	216.66	216.76	127211.0
2016-11-15 08:00:00	SPY	ETF	216.76	217.22	216.7	217.05	727389.0
2016-11-15 09:00:00	SPY	ETF	217.02	217.24	216.8	216.96	9835872.0
2016-11-15 10:00:00	SPY	ETF	216.96	217.43	216.94	217.28	10889587.0
2016-11-15 11:00:00	SPY	ETF	217.27	217.46	217.09	217.2499	8056744.0
2016-11-15 12:00:00	SPY	ETF	217.24	217.42	217.0	217.0489	8342090.0
2016-11-15 13:00:00	SPY	ETF	217.04	217.43	217.04	217.405	5280041.0
2016-11-15 14:00:00	SPY	ETF	217.4	218.14	217.33	218.0601	11327186.0
2016-11-15 15:00:00	SPY	ETF	218.06	218.28	217.93	218.25	24978644.0
2016-11-15 16:00:00	SPY	ETF	218.24	218.47	217.23	218.39	10085585.0
2016-11-15 17:00:00	SPY	ETF	218.37	218.4	218.33	218.38	102163.0
2016-11-15 18:00:00	SPY	ETF	218.38	218.48	218.34	218.44	73048.0
2016-11-15 19:00:00	SPY	ETF	218.41	218.97	218.35	218.67	197071.0
2016-11-15 04:00:00	QQQ	ETF	114.76	115.04	114.76	114.89	4101.0
2016-11-15 05:00:00	QQQ	ETF	114.87	114.89	114.87	114.89	2700.0
2016-11-15 06:00:00	QQQ	ETF	114.85	114.85	114.69	114.7	7650.0
2016-11-15 07:00:00	QQQ	ETF	114.71	114.74	114.58	114.64	22632.0
2016-11-15 08:00:00	QQQ	ETF	114.69	115.46	114.63	115.39	313585.0
2016-11-15 09:00:00	QQQ	ETF	115.38	115.9899	115.25	115.9799	4407925.0
2016-11-15 10:00:00	QQQ	ETF	115.97	116.55	115.87	116.13	6345080.0
2016-11-15 11:00:00	QQQ	ETF	116.125	116.28	115.95	116.05	2744123.0
2016-11-15 12:00:00	QQQ	ETF	116.0452	116.15	115.67	115.73	1678595.0
2016-11-15 13:00:00	QQQ	ETF	115.725	116.07	115.705	116.06	1662004.0
2016-11-15 14:00:00	QQQ	ETF	116.07	116.52	116.01	116.5165	3346879.0
2016-11-15 15:00:00	QQQ	ETF	116.51	116.62	116.23	116.24	6545652.0
2016-11-15 16:00:00	QQQ	ETF	116.23	116.35	116.0874	116.27	1439078.0
2016-11-15 17:00:00	QQQ	ETF	116.28	116.28	116.28	116.28	500.0
2016-11-15 18:00:00	QQQ	ETF	116.3	116.4	116.3	116.35	16889.0
2016-11-15 19:00:00	QQQ	ETF	116.35	116.65	116.35	116.6	25948.0
2016-11-15 04:00:00	IWM	ETF	129.38	129.38	128.95	129.12	2443.0
2016-11-15 05:00:00	IWM	ETF	129.03	129.16	129.03	129.16	2240.0
2016-11-15 06:00:00	IWM	ETF	129.08	129.08	128.98	129.0	3884.0
2016-11-15 07:00:00	IWM	ETF	128.97	128.98	128.63	128.65	73672.0
2016-11-15 08:00:00	IWM	ETF	128.75	129.22	128.72	128.87	236202.0
2016-11-15 09:00:00	IWM	ETF	128.82	129.2	128.3	128.3999	5286978.0
2016-11-15 10:00:00	IWM	ETF	128.4	129.14	128.355	128.75	6218806.0
2016-11-15 11:00:00	IWM	ETF	128.76	128.98	128.57	128.66	3940217.0
2016-11-15 12:00:00	IWM	ETF	128.66	128.95	128.59	128.63	2282481.0
2016-11-15 13:00:00	IWM	ETF	128.63	129.13	128.63	129.08	2160436.0
2016-11-15 14:00:00	IWM	ETF	129.09	129.71	129.09	129.66	4006020.0
2016-11-15 15:00:00	IWM	ETF	129.66	129.89	129.45	129.52	5019012.0
2016-11-15 16:00:00	IWM	ETF	129.55	129.62	129.46	129.48	795414.0
2016-11-15 17:00:00	IWM	ETF	129.45	129.5	129.45	129.49	14448.0
2016-11-15 18:00:00	IWM	ETF	129.45	129.5	129.4	129.5	5200.0
2016-11-15 19:00:00	IWM	ETF	129.5	129.54	129.4	129.54	26879.0
2016-11-15 04:00:00	DIA	ETF	189.02	189.13	189.02	189.13	570.0
2016-11-15 05:00:00	DIA	ETF	189.0	189.0	189.0	189.0	3000.0

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

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