PREVIEW / etf_1hour / 2016-09-20

all etf 1-hour files

  file:    by_date/etf_1hour/2016/2016-09-20.parquet
  size:    249 KB
  rows:    8,125

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-20 04:00:00	SPY	ETF	214.04	214.2	213.87	213.99	22996.0
2016-09-20 05:00:00	SPY	ETF	214.04	214.3	214.02	214.3	15077.0
2016-09-20 06:00:00	SPY	ETF	214.3	214.4	214.15	214.27	164400.0
2016-09-20 07:00:00	SPY	ETF	214.27	214.41	214.17	214.21	477783.0
2016-09-20 08:00:00	SPY	ETF	214.19	214.44	214.19	214.29	537554.0
2016-09-20 09:00:00	SPY	ETF	214.27	214.55	214.03	214.36	7736190.0
2016-09-20 10:00:00	SPY	ETF	214.365	214.59	213.75	213.94	10762421.0
2016-09-20 11:00:00	SPY	ETF	213.93	214.25	213.77	213.8	8016627.0
2016-09-20 12:00:00	SPY	ETF	213.805	214.035	213.43	213.48	7496655.0
2016-09-20 13:00:00	SPY	ETF	213.47	214.3405	213.38	213.88	9694970.0
2016-09-20 14:00:00	SPY	ETF	213.88	214.1	213.72	214.008	4324501.0
2016-09-20 15:00:00	SPY	ETF	214.0	214.14	213.4	213.43	14932159.0
2016-09-20 16:00:00	SPY	ETF	213.43	213.9093	213.18	213.26	4604299.0
2016-09-20 17:00:00	SPY	ETF	213.27	213.32	213.19	213.31	170932.0
2016-09-20 18:00:00	SPY	ETF	213.28	213.53	213.28	213.45	300397.0
2016-09-20 19:00:00	SPY	ETF	213.45	213.52	213.42	213.44	37667.0
2016-09-20 04:00:00	QQQ	ETF	117.03	117.03	117.03	117.03	6100.0
2016-09-20 05:00:00	QQQ	ETF	117.13	117.19	117.13	117.19	300.0
2016-09-20 06:00:00	QQQ	ETF	117.18	117.27	117.18	117.21	23998.0
2016-09-20 07:00:00	QQQ	ETF	117.22	117.27	117.16	117.17	102448.0
2016-09-20 08:00:00	QQQ	ETF	117.23	117.32	117.13	117.15	99993.0
2016-09-20 09:00:00	QQQ	ETF	117.14	117.45	117.061	117.36	1848983.0
2016-09-20 10:00:00	QQQ	ETF	117.37	117.48	116.9	117.1	1710407.0
2016-09-20 11:00:00	QQQ	ETF	117.1	117.2993	116.96	116.97	1093249.0
2016-09-20 12:00:00	QQQ	ETF	116.98	117.15	116.84	116.855	951197.0
2016-09-20 13:00:00	QQQ	ETF	116.85	117.15	116.8	117.12	1310941.0
2016-09-20 14:00:00	QQQ	ETF	117.11	117.3	117.07	117.25	769055.0
2016-09-20 15:00:00	QQQ	ETF	117.25	117.3	117.0	117.0	1893701.0
2016-09-20 16:00:00	QQQ	ETF	117.0	117.1849	116.88	116.94	651040.0
2016-09-20 17:00:00	QQQ	ETF	116.93	117.04	116.91	116.95	13906.0
2016-09-20 18:00:00	QQQ	ETF	116.98	117.06	116.98	117.06	22337.0
2016-09-20 19:00:00	QQQ	ETF	117.05	117.06	117.02	117.06	2450.0
2016-09-20 06:00:00	IWM	ETF	123.16	123.24	123.16	123.18	7780.0
2016-09-20 07:00:00	IWM	ETF	123.21	123.21	123.12	123.15	7914.0
2016-09-20 08:00:00	IWM	ETF	123.12	123.3	123.12	123.15	93798.0
2016-09-20 09:00:00	IWM	ETF	123.13	123.23	122.7	123.01	2347198.0
2016-09-20 10:00:00	IWM	ETF	123.01	123.19	122.58	122.81	1805419.0
2016-09-20 11:00:00	IWM	ETF	122.8	123.05	122.73	122.82	1795841.0
2016-09-20 12:00:00	IWM	ETF	122.83	122.85	122.29	122.3183	1819645.0
2016-09-20 13:00:00	IWM	ETF	122.31	122.56	122.25	122.53	1246873.0
2016-09-20 14:00:00	IWM	ETF	122.52	122.69	122.37	122.615	1219573.0
2016-09-20 15:00:00	IWM	ETF	122.61	122.69	122.17	122.18	2737081.0
2016-09-20 16:00:00	IWM	ETF	122.18	122.27	121.96	122.02	1544463.0
2016-09-20 17:00:00	IWM	ETF	122.04	122.13	122.04	122.13	12385.0
2016-09-20 18:00:00	IWM	ETF	122.15	122.15	122.15	122.15	500.0
2016-09-20 05:00:00	DIA	ETF	181.55	181.55	181.55	181.55	100.0
2016-09-20 06:00:00	DIA	ETF	181.38	181.38	181.38	181.38	100.0
2016-09-20 07:00:00	DIA	ETF	181.65	181.65	181.65	181.65	900.0
2016-09-20 08:00:00	DIA	ETF	181.6	181.67	181.6	181.67	2870.0
2016-09-20 09:00:00	DIA	ETF	181.75	182.04	181.6	181.88	233333.0

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

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