PREVIEW / etf_1hour / 2016-07-18

all etf 1-hour files

  file:    by_date/etf_1hour/2016/2016-07-18.parquet
  size:    253 KB
  rows:    8,091

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-07-18 04:00:00	SPY	ETF	216.2	216.47	216.02	216.47	60648.0
2016-07-18 05:00:00	SPY	ETF	216.43	216.47	215.96	215.96	101944.0
2016-07-18 06:00:00	SPY	ETF	216.06	216.2	215.87	216.12	35711.0
2016-07-18 07:00:00	SPY	ETF	216.06	216.37	216.02	216.37	310285.0
2016-07-18 08:00:00	SPY	ETF	216.37	216.38	215.92	215.95	1438759.0
2016-07-18 09:00:00	SPY	ETF	215.95	216.1	215.67	215.97	6817859.0
2016-07-18 10:00:00	SPY	ETF	215.97	216.525	215.94	216.4699	7810726.0
2016-07-18 11:00:00	SPY	ETF	216.47	216.55	216.28	216.43	9374504.0
2016-07-18 12:00:00	SPY	ETF	216.43	216.46	216.15	216.295	4824027.0
2016-07-18 13:00:00	SPY	ETF	216.295	216.495	216.12	216.435	5444638.0
2016-07-18 14:00:00	SPY	ETF	216.44	216.56	216.3	216.555	4147127.0
2016-07-18 15:00:00	SPY	ETF	216.555	216.6	216.4	216.4	9231799.0
2016-07-18 16:00:00	SPY	ETF	216.4	216.45	216.21	216.38	6138772.0
2016-07-18 17:00:00	SPY	ETF	216.35	216.57	216.34	216.36	971739.0
2016-07-18 18:00:00	SPY	ETF	216.4	216.46	216.33	216.42	147576.0
2016-07-18 19:00:00	SPY	ETF	216.43	216.44	216.36	216.41	64537.0
2016-07-18 04:00:00	QQQ	ETF	111.7	112.0	111.7	111.97	12966.0
2016-07-18 05:00:00	QQQ	ETF	112.04	112.04	111.8	111.84	8243.0
2016-07-18 06:00:00	QQQ	ETF	111.84	111.87	111.76	111.86	3528.0
2016-07-18 07:00:00	QQQ	ETF	111.82	112.01	111.82	112.0	45895.0
2016-07-18 08:00:00	QQQ	ETF	111.99	112.01	111.85	111.86	68149.0
2016-07-18 09:00:00	QQQ	ETF	111.87	112.055	111.85	112.05	2170765.0
2016-07-18 10:00:00	QQQ	ETF	112.04	112.58	112.04	112.52	2557214.0
2016-07-18 11:00:00	QQQ	ETF	112.53	112.74	112.525	112.65	2523453.0
2016-07-18 12:00:00	QQQ	ETF	112.65	112.66	112.45	112.53	1182508.0
2016-07-18 13:00:00	QQQ	ETF	112.53	112.68	112.42	112.6501	1082838.0
2016-07-18 14:00:00	QQQ	ETF	112.66	112.69	112.57	112.67	667541.0
2016-07-18 15:00:00	QQQ	ETF	112.67	112.7	112.53	112.53	2016190.0
2016-07-18 16:00:00	QQQ	ETF	112.54	112.6521	112.28	112.42	1817342.0
2016-07-18 17:00:00	QQQ	ETF	112.44	112.44	112.38	112.44	39800.0
2016-07-18 18:00:00	QQQ	ETF	112.42	112.48	112.42	112.48	6919.0
2016-07-18 19:00:00	QQQ	ETF	112.44	112.51	112.44	112.47	11014.0
2016-07-18 04:00:00	IWM	ETF	119.7	119.99	119.7	119.92	4060.0
2016-07-18 05:00:00	IWM	ETF	119.98	119.98	119.59	119.59	3795.0
2016-07-18 06:00:00	IWM	ETF	119.75	119.75	119.54	119.6	3600.0
2016-07-18 07:00:00	IWM	ETF	119.71	119.85	119.66	119.85	31735.0
2016-07-18 08:00:00	IWM	ETF	119.84	119.87	119.59	119.59	17360.0
2016-07-18 09:00:00	IWM	ETF	119.56	119.6763	119.33	119.62	1641807.0
2016-07-18 10:00:00	IWM	ETF	119.62	120.35	119.58	120.17	3248562.0
2016-07-18 11:00:00	IWM	ETF	120.18	120.25	119.74	119.87	1766131.0
2016-07-18 12:00:00	IWM	ETF	119.87	119.94	119.6	119.76	1124251.0
2016-07-18 13:00:00	IWM	ETF	119.76	120.04	119.66	120.03	1436177.0
2016-07-18 14:00:00	IWM	ETF	120.04	120.11	119.895	120.06	1195728.0
2016-07-18 15:00:00	IWM	ETF	120.06	120.13	119.86	119.9	2995961.0
2016-07-18 16:00:00	IWM	ETF	119.9	119.97	119.8	119.92	632201.0
2016-07-18 17:00:00	IWM	ETF	119.94	119.99	119.93	119.99	72360.0
2016-07-18 19:00:00	IWM	ETF	119.99	120.05	119.99	120.05	5500.0
2016-07-18 04:00:00	DIA	ETF	184.8	185.13	184.8	185.07	748.0
2016-07-18 05:00:00	DIA	ETF	185.13	185.13	185.1	185.1	200.0
2016-07-18 06:00:00	DIA	ETF	185.0	185.0	185.0	185.0	159.0

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

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