PREVIEW / etf_1hour / 2016-06-16

all etf 1-hour files

  file:    by_date/etf_1hour/2016/2016-06-16.parquet
  size:    255 KB
  rows:    8,180

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-06-16 04:00:00	SPY	ETF	207.12	207.12	206.81	207.01	10534.0
2016-06-16 05:00:00	SPY	ETF	207.02	207.2	207.0	207.2	18549.0
2016-06-16 06:00:00	SPY	ETF	207.18	207.2	207.01	207.06	76673.0
2016-06-16 07:00:00	SPY	ETF	207.1	207.1	206.71	206.85	552187.0
2016-06-16 08:00:00	SPY	ETF	206.88	207.75	206.61	206.79	1317220.0
2016-06-16 09:00:00	SPY	ETF	206.79	206.84	205.9	205.901	12528740.0
2016-06-16 10:00:00	SPY	ETF	205.9	206.375	205.59	206.11	22123459.0
2016-06-16 11:00:00	SPY	ETF	206.1	206.95	206.05	206.26	16931517.0
2016-06-16 12:00:00	SPY	ETF	206.255	207.7	206.13	207.34	20545452.0
2016-06-16 13:00:00	SPY	ETF	207.35	207.72	206.99	207.085	16184861.0
2016-06-16 14:00:00	SPY	ETF	207.09	208.1628	207.03	207.845	17271340.0
2016-06-16 15:00:00	SPY	ETF	207.85	208.57	207.776	208.42	27940357.0
2016-06-16 16:00:00	SPY	ETF	208.42	208.54	207.6581	208.36	9044826.0
2016-06-16 17:00:00	SPY	ETF	208.35	208.41	207.61	208.27	395166.0
2016-06-16 18:00:00	SPY	ETF	208.27	208.54	208.26	208.48	240193.0
2016-06-16 19:00:00	SPY	ETF	208.5	208.73	208.45	208.73	65853.0
2016-06-16 04:00:00	QQQ	ETF	107.2	107.29	107.15	107.27	21413.0
2016-06-16 05:00:00	QQQ	ETF	107.27	107.36	107.25	107.36	16525.0
2016-06-16 06:00:00	QQQ	ETF	107.35	107.4	107.35	107.4	2400.0
2016-06-16 07:00:00	QQQ	ETF	107.35	107.36	107.17	107.26	50200.0
2016-06-16 08:00:00	QQQ	ETF	107.25	107.31	107.15	107.29	155761.0
2016-06-16 09:00:00	QQQ	ETF	107.26	107.28	106.77	106.8	2844875.0
2016-06-16 10:00:00	QQQ	ETF	106.79	106.89	106.5	106.6785	4184228.0
2016-06-16 11:00:00	QQQ	ETF	106.67	107.07	106.64	106.72	3691498.0
2016-06-16 12:00:00	QQQ	ETF	106.73	107.58	106.66	107.46	3937264.0
2016-06-16 13:00:00	QQQ	ETF	107.46	107.67	107.27	107.32	2573425.0
2016-06-16 14:00:00	QQQ	ETF	107.33	107.83	107.29	107.66	2991627.0
2016-06-16 15:00:00	QQQ	ETF	107.67	108.14	107.65	108.03	4357553.0
2016-06-16 16:00:00	QQQ	ETF	108.05	108.08	107.98	108.02	1371603.0
2016-06-16 17:00:00	QQQ	ETF	107.99	108.02	107.97	107.97	2571.0
2016-06-16 18:00:00	QQQ	ETF	108.01	108.07	108.01	108.07	3549.0
2016-06-16 19:00:00	QQQ	ETF	108.05	108.25	108.05	108.24	10204.0
2016-06-16 04:00:00	IWM	ETF	114.0	114.0	113.96	113.98	1500.0
2016-06-16 05:00:00	IWM	ETF	114.0	114.0	114.0	114.0	100.0
2016-06-16 06:00:00	IWM	ETF	114.1	114.12	114.07	114.07	1300.0
2016-06-16 07:00:00	IWM	ETF	113.95	113.95	113.83	113.93	11607.0
2016-06-16 08:00:00	IWM	ETF	113.84	113.96	113.76	113.9	201332.0
2016-06-16 09:00:00	IWM	ETF	113.86	113.92	113.2	113.22	3952066.0
2016-06-16 10:00:00	IWM	ETF	113.22	113.5	112.89	113.15	4582449.0
2016-06-16 11:00:00	IWM	ETF	113.13	113.92	113.12	113.28	3860461.0
2016-06-16 12:00:00	IWM	ETF	113.29	114.02	113.21	113.79	4407436.0
2016-06-16 13:00:00	IWM	ETF	113.8	114.08	113.45	113.49	4219691.0
2016-06-16 14:00:00	IWM	ETF	113.48	114.34	113.46	114.21	3583823.0
2016-06-16 15:00:00	IWM	ETF	114.215	114.59	114.04	114.56	6710589.0
2016-06-16 16:00:00	IWM	ETF	114.56	114.7	114.44	114.62	660198.0
2016-06-16 17:00:00	IWM	ETF	114.59	114.64	114.56	114.57	5020.0
2016-06-16 18:00:00	IWM	ETF	114.58	114.59	114.58	114.59	3386.0
2016-06-16 19:00:00	IWM	ETF	114.57	114.75	114.57	114.75	3035.0
2016-06-16 04:00:00	DIA	ETF	175.9	175.9	175.82	175.88	314.0
2016-06-16 07:00:00	DIA	ETF	175.78	175.8	175.78	175.8	200.0

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

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