PREVIEW / etf_1hour / 2016-10-21

all etf 1-hour files

  file:    by_date/etf_1hour/2016/2016-10-21.parquet
  size:    248 KB
  rows:    7,996

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-10-21 04:00:00	SPY	ETF	213.51	213.66	213.33	213.33	13451.0
2016-10-21 05:00:00	SPY	ETF	213.32	213.68	213.3	213.66	15482.0
2016-10-21 06:00:00	SPY	ETF	213.66	213.67	213.34	213.34	30436.0
2016-10-21 07:00:00	SPY	ETF	213.35	213.49	213.28	213.49	118092.0
2016-10-21 08:00:00	SPY	ETF	213.42	213.95	213.15	213.17	2774914.0
2016-10-21 09:00:00	SPY	ETF	213.17	213.27	212.76	213.17	13602052.0
2016-10-21 10:00:00	SPY	ETF	213.17	213.57	212.98	213.38	25911295.0
2016-10-21 11:00:00	SPY	ETF	213.38	213.77	213.29	213.665	8292170.0
2016-10-21 12:00:00	SPY	ETF	213.66	213.76	213.49	213.61	5898580.0
2016-10-21 13:00:00	SPY	ETF	213.61	213.84	213.36	213.81	4751930.0
2016-10-21 14:00:00	SPY	ETF	213.805	214.01	213.68	214.0	5199517.0
2016-10-21 15:00:00	SPY	ETF	213.99	214.08	213.8	213.935	15584804.0
2016-10-21 16:00:00	SPY	ETF	213.97	214.01	213.81	213.98	4236303.0
2016-10-21 17:00:00	SPY	ETF	213.96	214.14	213.94	214.02	1396050.0
2016-10-21 18:00:00	SPY	ETF	214.02	214.06	213.92	213.96	66335.0
2016-10-21 19:00:00	SPY	ETF	213.99	214.03	213.96	214.03	30753.0
2016-10-21 04:00:00	QQQ	ETF	118.04	118.04	117.86	117.86	800.0
2016-10-21 05:00:00	QQQ	ETF	117.91	117.91	117.91	117.91	5000.0
2016-10-21 06:00:00	QQQ	ETF	118.02	118.02	117.95	117.95	1990.0
2016-10-21 07:00:00	QQQ	ETF	117.91	118.04	117.91	118.03	19299.0
2016-10-21 08:00:00	QQQ	ETF	118.02	118.06	117.71	117.9	143040.0
2016-10-21 09:00:00	QQQ	ETF	117.91	117.92	117.41	117.83	2775764.0
2016-10-21 10:00:00	QQQ	ETF	117.82	117.95	117.67	117.865	1675534.0
2016-10-21 11:00:00	QQQ	ETF	117.86	118.16	117.81	118.11	1702242.0
2016-10-21 12:00:00	QQQ	ETF	118.105	118.15	117.93	118.0192	913321.0
2016-10-21 13:00:00	QQQ	ETF	118.021	118.17	117.89	118.13	813270.0
2016-10-21 14:00:00	QQQ	ETF	118.13	118.2	118.04	118.18	636618.0
2016-10-21 15:00:00	QQQ	ETF	118.17	118.22	118.06	118.16	2214503.0
2016-10-21 16:00:00	QQQ	ETF	118.16	118.18	118.11	118.17	929979.0
2016-10-21 17:00:00	QQQ	ETF	118.18	118.19	118.17	118.19	540024.0
2016-10-21 18:00:00	QQQ	ETF	118.16	118.2	118.16	118.19	5200.0
2016-10-21 19:00:00	QQQ	ETF	118.18	118.2	118.15	118.2	3149.0
2016-10-21 07:00:00	IWM	ETF	120.84	120.89	120.8	120.87	9056.0
2016-10-21 08:00:00	IWM	ETF	120.88	120.93	120.53	120.53	193106.0
2016-10-21 09:00:00	IWM	ETF	120.53	120.65	120.1	120.6	3549179.0
2016-10-21 10:00:00	IWM	ETF	120.6	121.07	120.36	120.9625	3430107.0
2016-10-21 11:00:00	IWM	ETF	120.96	121.37	120.9	121.2	1757011.0
2016-10-21 12:00:00	IWM	ETF	121.21	121.26	120.94	121.07	1252509.0
2016-10-21 13:00:00	IWM	ETF	121.08	121.1	120.72	121.01	1478763.0
2016-10-21 14:00:00	IWM	ETF	121.01	121.15	120.87	121.11	1616142.0
2016-10-21 15:00:00	IWM	ETF	121.1	121.16	120.94	121.05	3439368.0
2016-10-21 16:00:00	IWM	ETF	121.03	121.23	120.97	121.2	1083886.0
2016-10-21 17:00:00	IWM	ETF	121.07	121.13	121.07	121.13	466600.0
2016-10-21 18:00:00	IWM	ETF	121.13	121.2	121.07	121.2	194492.0
2016-10-21 07:00:00	DIA	ETF	181.08	181.08	181.04	181.04	2600.0
2016-10-21 08:00:00	DIA	ETF	181.29	181.29	180.75	180.82	7600.0
2016-10-21 09:00:00	DIA	ETF	180.57	180.63	180.23	180.47	1253368.0
2016-10-21 10:00:00	DIA	ETF	180.47	180.6	180.24	180.48	1868155.0
2016-10-21 11:00:00	DIA	ETF	180.47	181.06	180.379	180.9801	429738.0
2016-10-21 12:00:00	DIA	ETF	180.99	181.07	180.77	180.85	255028.0

> showing 50 of 7,996 rows — these rows as CSV

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