PREVIEW / etf_1min / 2016-10-13

all etf 1-min files

  file:    by_date/etf_1min/2016/2016-10-13.parquet
  size:    2.7 MB
  rows:    140,226

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-13 04:00:00	SPY	ETF	211.94	211.94	211.75	211.79	3314.0
2016-10-13 04:01:00	SPY	ETF	211.9	211.9	211.9	211.9	467.0
2016-10-13 04:02:00	SPY	ETF	211.89	211.9	211.89	211.9	5102.0
2016-10-13 04:03:00	SPY	ETF	211.9	211.93	211.87	211.92	1101.0
2016-10-13 04:04:00	SPY	ETF	211.96	211.96	211.96	211.96	615.0
2016-10-13 04:06:00	SPY	ETF	211.96	211.96	211.96	211.96	100.0
2016-10-13 04:07:00	SPY	ETF	212.01	212.01	211.98	211.98	600.0
2016-10-13 04:08:00	SPY	ETF	211.96	211.96	211.96	211.96	302.0
2016-10-13 04:11:00	SPY	ETF	212.03	212.03	212.03	212.03	2508.0
2016-10-13 04:12:00	SPY	ETF	212.01	212.08	212.01	212.08	800.0
2016-10-13 04:13:00	SPY	ETF	212.08	212.08	212.08	212.08	101.0
2016-10-13 04:14:00	SPY	ETF	212.13	212.13	212.13	212.13	13451.0
2016-10-13 04:16:00	SPY	ETF	212.06	212.06	212.06	212.06	13401.0
2016-10-13 04:19:00	SPY	ETF	212.01	212.01	211.99	212.01	19601.0
2016-10-13 04:20:00	SPY	ETF	212.04	212.04	212.02	212.02	13401.0
2016-10-13 04:21:00	SPY	ETF	212.01	212.02	212.01	212.02	8801.0
2016-10-13 04:22:00	SPY	ETF	212.02	212.04	212.01	212.01	19924.0
2016-10-13 04:23:00	SPY	ETF	211.98	212.0	211.98	212.0	13621.0
2016-10-13 04:24:00	SPY	ETF	212.0	212.0	211.98	211.98	5200.0
2016-10-13 04:25:00	SPY	ETF	212.01	212.03	211.99	212.01	18201.0
2016-10-13 04:26:00	SPY	ETF	211.99	211.99	211.96	211.96	2300.0
2016-10-13 04:27:00	SPY	ETF	212.01	212.03	211.99	212.03	630.0
2016-10-13 04:28:00	SPY	ETF	211.98	211.98	211.96	211.96	1103.0
2016-10-13 04:29:00	SPY	ETF	211.96	211.98	211.96	211.98	13425.0
2016-10-13 04:30:00	SPY	ETF	211.96	211.96	211.96	211.96	100.0
2016-10-13 04:31:00	SPY	ETF	211.96	211.96	211.94	211.94	2694.0
2016-10-13 04:32:00	SPY	ETF	211.96	211.96	211.96	211.96	1000.0
2016-10-13 04:33:00	SPY	ETF	211.96	211.97	211.96	211.96	14400.0
2016-10-13 04:34:00	SPY	ETF	211.96	211.99	211.96	211.99	1600.0
2016-10-13 04:35:00	SPY	ETF	212.01	212.01	212.01	212.01	134.0
2016-10-13 04:36:00	SPY	ETF	212.01	212.04	212.01	212.04	801.0
2016-10-13 04:37:00	SPY	ETF	212.01	212.03	212.01	212.03	414.0
2016-10-13 04:39:00	SPY	ETF	212.06	212.06	212.06	212.06	101.0
2016-10-13 04:41:00	SPY	ETF	212.08	212.08	212.08	212.08	103.0
2016-10-13 04:42:00	SPY	ETF	212.16	212.16	212.16	212.16	203.0
2016-10-13 04:43:00	SPY	ETF	212.16	212.16	212.16	212.16	203.0
2016-10-13 04:44:00	SPY	ETF	212.16	212.16	212.16	212.16	402.0
2016-10-13 04:45:00	SPY	ETF	212.16	212.16	212.16	212.16	385.0
2016-10-13 04:48:00	SPY	ETF	212.23	212.23	212.23	212.23	301.0
2016-10-13 04:51:00	SPY	ETF	212.16	212.16	212.16	212.16	1002.0
2016-10-13 04:53:00	SPY	ETF	212.26	212.26	212.26	212.26	602.0
2016-10-13 04:54:00	SPY	ETF	212.27	212.3	212.27	212.3	2107.0
2016-10-13 04:55:00	SPY	ETF	212.3	212.3	212.3	212.3	102.0
2016-10-13 04:56:00	SPY	ETF	212.28	212.28	212.28	212.28	300.0
2016-10-13 05:02:00	SPY	ETF	212.29	212.3	212.29	212.3	402.0
2016-10-13 05:03:00	SPY	ETF	212.28	212.28	212.28	212.28	100.0
2016-10-13 05:04:00	SPY	ETF	212.28	212.34	212.28	212.34	2114.0
2016-10-13 05:05:00	SPY	ETF	212.39	212.39	212.39	212.39	402.0
2016-10-13 05:08:00	SPY	ETF	212.31	212.31	212.31	212.31	802.0
2016-10-13 05:16:00	SPY	ETF	212.31	212.31	212.31	212.31	100.0

> showing 50 of 140,226 rows — these rows as CSV

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