PREVIEW / etf_1min / 2016-07-20

all etf 1-min files

  file:    by_date/etf_1min/2016/2016-07-20.parquet
  size:    2.5 MB
  rows:    133,677

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-20 04:00:00	SPY	ETF	216.4	216.4	216.4	216.4	295.0
2016-07-20 04:03:00	SPY	ETF	216.4	216.4	216.4	216.4	300.0
2016-07-20 04:07:00	SPY	ETF	216.44	216.44	216.44	216.44	200.0
2016-07-20 04:08:00	SPY	ETF	216.49	216.5	216.49	216.5	1100.0
2016-07-20 04:09:00	SPY	ETF	216.45	216.45	216.45	216.45	600.0
2016-07-20 04:11:00	SPY	ETF	216.48	216.52	216.48	216.48	903.0
2016-07-20 04:12:00	SPY	ETF	216.48	216.48	216.48	216.48	600.0
2016-07-20 04:13:00	SPY	ETF	216.48	216.51	216.48	216.51	300.0
2016-07-20 04:14:00	SPY	ETF	216.54	216.54	216.54	216.54	203.0
2016-07-20 04:16:00	SPY	ETF	216.48	216.48	216.48	216.48	600.0
2016-07-20 04:17:00	SPY	ETF	216.53	216.53	216.53	216.53	301.0
2016-07-20 04:19:00	SPY	ETF	216.5	216.5	216.5	216.5	200.0
2016-07-20 04:20:00	SPY	ETF	216.5	216.5	216.5	216.5	300.0
2016-07-20 04:21:00	SPY	ETF	216.56	216.56	216.56	216.56	113.0
2016-07-20 04:22:00	SPY	ETF	216.53	216.53	216.53	216.53	350.0
2016-07-20 04:25:00	SPY	ETF	216.54	216.54	216.54	216.54	526.0
2016-07-20 04:26:00	SPY	ETF	216.53	216.53	216.53	216.53	200.0
2016-07-20 04:27:00	SPY	ETF	216.56	216.57	216.56	216.57	1101.0
2016-07-20 04:30:00	SPY	ETF	216.57	216.57	216.57	216.57	625.0
2016-07-20 04:34:00	SPY	ETF	216.56	216.56	216.56	216.56	400.0
2016-07-20 04:35:00	SPY	ETF	216.58	216.58	216.58	216.58	401.0
2016-07-20 04:37:00	SPY	ETF	216.64	216.64	216.61	216.61	402.0
2016-07-20 04:38:00	SPY	ETF	216.6	216.6	216.6	216.6	1000.0
2016-07-20 04:39:00	SPY	ETF	216.64	216.64	216.64	216.64	192.0
2016-07-20 04:41:00	SPY	ETF	216.65	216.68	216.65	216.68	481.0
2016-07-20 04:42:00	SPY	ETF	216.69	216.69	216.69	216.69	300.0
2016-07-20 04:43:00	SPY	ETF	216.71	216.71	216.71	216.71	526.0
2016-07-20 04:44:00	SPY	ETF	216.72	216.73	216.72	216.73	627.0
2016-07-20 04:45:00	SPY	ETF	216.73	216.83	216.73	216.8	725.0
2016-07-20 04:46:00	SPY	ETF	216.8	216.8	216.78	216.8	1216.0
2016-07-20 04:48:00	SPY	ETF	216.85	216.85	216.85	216.85	200.0
2016-07-20 04:50:00	SPY	ETF	216.83	216.83	216.83	216.83	200.0
2016-07-20 04:52:00	SPY	ETF	216.85	216.85	216.83	216.84	901.0
2016-07-20 04:53:00	SPY	ETF	216.83	216.83	216.83	216.83	201.0
2016-07-20 04:54:00	SPY	ETF	216.8	216.8	216.78	216.78	1103.0
2016-07-20 04:56:00	SPY	ETF	216.75	216.76	216.75	216.76	1405.0
2016-07-20 04:57:00	SPY	ETF	216.75	216.75	216.75	216.75	100.0
2016-07-20 04:58:00	SPY	ETF	216.75	216.75	216.75	216.75	100.0
2016-07-20 04:59:00	SPY	ETF	216.75	216.75	216.75	216.75	500.0
2016-07-20 05:01:00	SPY	ETF	216.75	216.79	216.75	216.79	2100.0
2016-07-20 05:04:00	SPY	ETF	216.78	216.78	216.78	216.78	1100.0
2016-07-20 05:06:00	SPY	ETF	216.85	216.97	216.85	216.97	5359.0
2016-07-20 05:07:00	SPY	ETF	216.93	216.93	216.93	216.93	1306.0
2016-07-20 05:11:00	SPY	ETF	216.96	216.96	216.94	216.94	1597.0
2016-07-20 05:15:00	SPY	ETF	216.88	216.88	216.88	216.88	1100.0
2016-07-20 05:18:00	SPY	ETF	216.91	216.91	216.91	216.91	900.0
2016-07-20 05:20:00	SPY	ETF	216.97	217.04	216.97	217.0	3911.0
2016-07-20 05:21:00	SPY	ETF	217.04	217.04	217.04	217.04	307.0
2016-07-20 05:22:00	SPY	ETF	217.03	217.03	217.03	217.03	1100.0
2016-07-20 05:24:00	SPY	ETF	217.03	217.03	217.03	217.03	300.0

> showing 50 of 133,677 rows — these rows as CSV

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