PREVIEW / etf_1hour / 2016-12-29

all etf 1-hour files

  file:    by_date/etf_1hour/2016/2016-12-29.parquet
  size:    269 KB
  rows:    8,736

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-12-29 04:00:00	SPY	ETF	224.3	224.49	224.3	224.41	5752.0
2016-12-29 05:00:00	SPY	ETF	224.42	224.6	224.4	224.54	6982.0
2016-12-29 06:00:00	SPY	ETF	224.52	224.52	224.47	224.5	1106.0
2016-12-29 07:00:00	SPY	ETF	224.48	224.63	224.48	224.63	112759.0
2016-12-29 08:00:00	SPY	ETF	224.55	224.69	224.46	224.52	203149.0
2016-12-29 09:00:00	SPY	ETF	224.53	224.89	224.39	224.57	4725944.0
2016-12-29 10:00:00	SPY	ETF	224.565	224.75	224.24	224.295	7278323.0
2016-12-29 11:00:00	SPY	ETF	224.3	224.385	224.04	224.13	6030026.0
2016-12-29 12:00:00	SPY	ETF	224.13	224.31	223.84	224.15	7190955.0
2016-12-29 13:00:00	SPY	ETF	224.16	224.2	223.96	224.17	3333001.0
2016-12-29 14:00:00	SPY	ETF	224.17	224.48	224.15	224.29	6992870.0
2016-12-29 15:00:00	SPY	ETF	224.3	224.37	224.18	224.37	8339353.0
2016-12-29 16:00:00	SPY	ETF	224.37	224.52	224.2533	224.5	3250195.0
2016-12-29 17:00:00	SPY	ETF	224.5	224.5	224.44	224.49	27248.0
2016-12-29 18:00:00	SPY	ETF	224.5	224.57	224.46	224.51	25929.0
2016-12-29 19:00:00	SPY	ETF	224.48	224.5	224.4	224.45	48805.0
2016-12-29 04:00:00	QQQ	ETF	119.81	119.84	119.81	119.84	600.0
2016-12-29 06:00:00	QQQ	ETF	119.84	119.84	119.84	119.84	688.0
2016-12-29 07:00:00	QQQ	ETF	119.86	119.96	119.86	119.94	4739.0
2016-12-29 08:00:00	QQQ	ETF	119.94	119.97	119.87	119.96	81146.0
2016-12-29 09:00:00	QQQ	ETF	119.91	120.13	119.68	119.771	1503559.0
2016-12-29 10:00:00	QQQ	ETF	119.78	119.975	119.59	119.67	1208133.0
2016-12-29 11:00:00	QQQ	ETF	119.66	119.6669	119.37	119.425	1796165.0
2016-12-29 12:00:00	QQQ	ETF	119.43	119.7188	119.33	119.621	1535452.0
2016-12-29 13:00:00	QQQ	ETF	119.62	119.66	119.39	119.485	736084.0
2016-12-29 14:00:00	QQQ	ETF	119.49	119.66	119.48	119.605	1412889.0
2016-12-29 15:00:00	QQQ	ETF	119.6	119.74	119.559	119.7	2337681.0
2016-12-29 16:00:00	QQQ	ETF	119.72	119.82	119.5818	119.7125	384787.0
2016-12-29 17:00:00	QQQ	ETF	119.82	119.82	119.79	119.82	521.0
2016-12-29 18:00:00	QQQ	ETF	119.82	119.82	119.78	119.79	4962.0
2016-12-29 19:00:00	QQQ	ETF	119.76	119.79	119.76	119.79	549.0
2016-12-29 05:00:00	IWM	ETF	135.25	135.25	135.25	135.25	331.0
2016-12-29 07:00:00	IWM	ETF	135.18	135.39	135.18	135.37	16530.0
2016-12-29 08:00:00	IWM	ETF	135.37	135.42	135.16	135.34	79235.0
2016-12-29 09:00:00	IWM	ETF	135.37	136.26	135.27	135.5899	2248892.0
2016-12-29 10:00:00	IWM	ETF	135.58	135.9573	135.19	135.26	1960522.0
2016-12-29 11:00:00	IWM	ETF	135.26	135.44	134.835	134.9	1903266.0
2016-12-29 12:00:00	IWM	ETF	134.91	135.2	134.685	135.0	1947088.0
2016-12-29 13:00:00	IWM	ETF	135.0	135.05	134.69	134.9	1496414.0
2016-12-29 14:00:00	IWM	ETF	134.9	135.09	134.78	134.97	1752004.0
2016-12-29 15:00:00	IWM	ETF	134.97	135.44	134.84	135.38	3656409.0
2016-12-29 16:00:00	IWM	ETF	135.39	135.52	135.29	135.4	1795251.0
2016-12-29 17:00:00	IWM	ETF	135.4	135.4	135.4	135.4	100.0
2016-12-29 08:00:00	DIA	ETF	198.13	198.2	198.1	198.2	27550.0
2016-12-29 09:00:00	DIA	ETF	197.99	198.52	197.99	198.22	278646.0
2016-12-29 10:00:00	DIA	ETF	198.24	198.46	197.9201	198.0146	413090.0
2016-12-29 11:00:00	DIA	ETF	198.01	198.09	197.835	197.91	552818.0
2016-12-29 12:00:00	DIA	ETF	197.91	198.02	197.63	197.8844	523079.0
2016-12-29 13:00:00	DIA	ETF	197.87	197.94	197.77	197.94	178712.0
2016-12-29 14:00:00	DIA	ETF	197.94	198.15	197.87	197.998	206483.0

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

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