PREVIEW / etf_1hour / 2016-09-09

all etf 1-hour files

  file:    by_date/etf_1hour/2016/2016-09-09.parquet
  size:    270 KB
  rows:    8,661

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-09-09 04:00:00	SPY	ETF	218.14	218.14	217.92	218.12	14523.0
2016-09-09 05:00:00	SPY	ETF	218.1	218.14	217.98	218.02	11153.0
2016-09-09 06:00:00	SPY	ETF	218.02	218.04	217.72	217.74	95785.0
2016-09-09 07:00:00	SPY	ETF	217.75	217.75	217.35	217.53	841550.0
2016-09-09 08:00:00	SPY	ETF	217.52	218.359	217.0	217.07	1790883.0
2016-09-09 09:00:00	SPY	ETF	217.07	217.24	216.2899	216.52	20983653.0
2016-09-09 10:00:00	SPY	ETF	216.52	216.64	215.74	216.15	30428986.0
2016-09-09 11:00:00	SPY	ETF	216.15	216.2	215.51	215.605	16476182.0
2016-09-09 12:00:00	SPY	ETF	215.605	215.76	215.2038	215.42	16313587.0
2016-09-09 13:00:00	SPY	ETF	215.42	215.425	214.38	214.61	24183628.0
2016-09-09 14:00:00	SPY	ETF	214.61	214.72	214.0	214.435	33886297.0
2016-09-09 15:00:00	SPY	ETF	214.435	214.55	213.25	213.28	51907326.0
2016-09-09 16:00:00	SPY	ETF	213.28	213.6226	212.59	212.77	17560030.0
2016-09-09 17:00:00	SPY	ETF	212.72	213.32	212.71	212.83	2342735.0
2016-09-09 18:00:00	SPY	ETF	212.86	212.87	212.63	212.7	227402.0
2016-09-09 19:00:00	SPY	ETF	212.71	212.75	212.63	212.63	87941.0
2016-09-09 04:00:00	QQQ	ETF	117.03	117.03	116.87	116.92	99800.0
2016-09-09 05:00:00	QQQ	ETF	116.93	116.93	116.9	116.9	5935.0
2016-09-09 06:00:00	QQQ	ETF	116.85	116.88	116.8	116.84	21298.0
2016-09-09 07:00:00	QQQ	ETF	116.8	116.8	116.6	116.67	65218.0
2016-09-09 08:00:00	QQQ	ETF	116.67	116.68	116.29	116.32	218153.0
2016-09-09 09:00:00	QQQ	ETF	116.34	116.51	116.2	116.298	4135680.0
2016-09-09 10:00:00	QQQ	ETF	116.3	116.45	115.85	116.02	5047384.0
2016-09-09 11:00:00	QQQ	ETF	116.01	116.05	115.47	115.56	3795766.0
2016-09-09 12:00:00	QQQ	ETF	115.555	115.64	115.2	115.33	4157504.0
2016-09-09 13:00:00	QQQ	ETF	115.34	115.35	114.79	114.92	3882676.0
2016-09-09 14:00:00	QQQ	ETF	114.91	115.059	114.61	114.95	5045619.0
2016-09-09 15:00:00	QQQ	ETF	114.94	115.02	114.26	114.28	8587782.0
2016-09-09 16:00:00	QQQ	ETF	114.3	115.4005	113.95	113.98	1502538.0
2016-09-09 17:00:00	QQQ	ETF	114.13	114.28	113.97	114.08	281764.0
2016-09-09 18:00:00	QQQ	ETF	114.08	114.14	114.0	114.03	10933.0
2016-09-09 19:00:00	QQQ	ETF	114.0	114.05	113.74	113.94	42562.0
2016-09-09 04:00:00	IWM	ETF	124.78	124.78	124.78	124.78	100.0
2016-09-09 07:00:00	IWM	ETF	124.6	124.71	124.4	124.46	169724.0
2016-09-09 08:00:00	IWM	ETF	124.5	124.51	124.11	124.11	387758.0
2016-09-09 09:00:00	IWM	ETF	124.19	124.33	123.32	123.48	5578154.0
2016-09-09 10:00:00	IWM	ETF	123.48	123.57	123.05	123.28	5521982.0
2016-09-09 11:00:00	IWM	ETF	123.27	123.33	122.75	122.87	3265960.0
2016-09-09 12:00:00	IWM	ETF	122.87	123.01	122.6	122.74	3325910.0
2016-09-09 13:00:00	IWM	ETF	122.73	122.73	121.87	122.09	4953112.0
2016-09-09 14:00:00	IWM	ETF	122.08	122.28	121.62	121.99	5772176.0
2016-09-09 15:00:00	IWM	ETF	122.0	122.13	121.21	121.25	11109132.0
2016-09-09 16:00:00	IWM	ETF	121.26	121.4	120.67	120.67	3567646.0
2016-09-09 17:00:00	IWM	ETF	120.69	121.23	120.69	120.94	35534.0
2016-09-09 18:00:00	IWM	ETF	120.81	120.9	120.8	120.8	3535.0
2016-09-09 19:00:00	IWM	ETF	120.75	120.78	120.73	120.73	3070.0
2016-09-09 06:00:00	DIA	ETF	184.35	184.35	184.15	184.15	6500.0
2016-09-09 07:00:00	DIA	ETF	184.15	184.15	183.9	183.9	5500.0
2016-09-09 08:00:00	DIA	ETF	184.06	184.06	183.6	183.65	31630.0
2016-09-09 09:00:00	DIA	ETF	183.6	183.77	183.18	183.35	963752.0

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

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