PREVIEW / etf_1hour / 2016-11-14

all etf 1-hour files

  file:    by_date/etf_1hour/2016/2016-11-14.parquet
  size:    278 KB
  rows:    8,942

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-14 04:00:00	SPY	ETF	217.29	217.71	217.24	217.47	22605.0
2016-11-14 05:00:00	SPY	ETF	217.4	217.48	217.2	217.22	11455.0
2016-11-14 06:00:00	SPY	ETF	217.14	217.18	216.34	216.57	120009.0
2016-11-14 07:00:00	SPY	ETF	216.57	216.98	216.54	216.73	150672.0
2016-11-14 08:00:00	SPY	ETF	216.76	217.61	216.54	217.22	879823.0
2016-11-14 09:00:00	SPY	ETF	217.2	217.23	216.49	216.59	11396095.0
2016-11-14 10:00:00	SPY	ETF	216.59	217.27	216.15	216.185	16699231.0
2016-11-14 11:00:00	SPY	ETF	216.18	216.58	215.9	216.27	13379996.0
2016-11-14 12:00:00	SPY	ETF	216.29	216.36	215.72	216.12	10434380.0
2016-11-14 13:00:00	SPY	ETF	216.12	216.73	215.95	216.32	9471815.0
2016-11-14 14:00:00	SPY	ETF	216.32	216.8	216.12	216.79	7729390.0
2016-11-14 15:00:00	SPY	ETF	216.79	216.89	216.27	216.55	16509633.0
2016-11-14 16:00:00	SPY	ETF	216.53	216.7129	216.4086	216.63	6658996.0
2016-11-14 17:00:00	SPY	ETF	216.63	216.65	216.54	216.55	132266.0
2016-11-14 18:00:00	SPY	ETF	216.56	216.65	216.38	216.59	115326.0
2016-11-14 19:00:00	SPY	ETF	216.6	216.74	216.45	216.72	66779.0
2016-11-14 04:00:00	QQQ	ETF	116.09	116.39	116.09	116.39	3241.0
2016-11-14 05:00:00	QQQ	ETF	116.22	116.23	116.22	116.23	627.0
2016-11-14 06:00:00	QQQ	ETF	116.09	116.09	115.61	115.74	18288.0
2016-11-14 07:00:00	QQQ	ETF	115.75	115.91	115.7	115.75	47251.0
2016-11-14 08:00:00	QQQ	ETF	115.77	116.01	115.57	115.86	137280.0
2016-11-14 09:00:00	QQQ	ETF	115.89	115.94	114.88	114.9474	6731427.0
2016-11-14 10:00:00	QQQ	ETF	114.94	115.36	114.36	114.39	8739198.0
2016-11-14 11:00:00	QQQ	ETF	114.4	114.85	114.03	114.5999	5582811.0
2016-11-14 12:00:00	QQQ	ETF	114.62	114.7	114.13	114.56	2784816.0
2016-11-14 13:00:00	QQQ	ETF	114.58	115.14	114.5	114.69	2713127.0
2016-11-14 14:00:00	QQQ	ETF	114.675	115.091	114.49	115.09	2047910.0
2016-11-14 15:00:00	QQQ	ETF	115.08	115.1301	114.52	114.63	3451577.0
2016-11-14 16:00:00	QQQ	ETF	114.63	114.66	114.48	114.55	824651.0
2016-11-14 17:00:00	QQQ	ETF	114.57	114.66	114.53	114.66	284770.0
2016-11-14 18:00:00	QQQ	ETF	114.54	114.57	114.41	114.56	42493.0
2016-11-14 19:00:00	QQQ	ETF	114.56	114.63	114.54	114.58	13596.0
2016-11-14 04:00:00	IWM	ETF	128.11	128.32	128.11	128.19	6526.0
2016-11-14 05:00:00	IWM	ETF	128.21	128.45	128.2	128.2	7015.0
2016-11-14 06:00:00	IWM	ETF	128.24	128.24	127.65	127.84	18750.0
2016-11-14 07:00:00	IWM	ETF	127.79	128.36	127.79	128.3	112010.0
2016-11-14 08:00:00	IWM	ETF	128.28	128.91	128.26	128.85	544216.0
2016-11-14 09:00:00	IWM	ETF	128.82	129.74	128.47	129.27	10090309.0
2016-11-14 10:00:00	IWM	ETF	129.27	130.26	128.7938	129.03	14927642.0
2016-11-14 11:00:00	IWM	ETF	129.04	129.71	128.69	129.41	7974635.0
2016-11-14 12:00:00	IWM	ETF	129.42	129.49	128.39	129.06	5301719.0
2016-11-14 13:00:00	IWM	ETF	129.05	129.46	128.75	128.83	5420445.0
2016-11-14 14:00:00	IWM	ETF	128.83	129.05	128.41	128.72	3602013.0
2016-11-14 15:00:00	IWM	ETF	128.72	129.27	128.57	129.14	7044049.0
2016-11-14 16:00:00	IWM	ETF	129.15	129.38	129.072	129.26	8247393.0
2016-11-14 17:00:00	IWM	ETF	129.28	129.32	129.15	129.2	97823.0
2016-11-14 18:00:00	IWM	ETF	129.22	129.23	129.01	129.11	1530844.0
2016-11-14 19:00:00	IWM	ETF	129.11	129.28	129.02	129.28	23593.0
2016-11-14 04:00:00	DIA	ETF	188.71	189.57	188.71	189.46	3477.0
2016-11-14 05:00:00	DIA	ETF	189.47	189.48	189.37	189.37	2700.0

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

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