PREVIEW / etf_1min / 2017-01-17

all etf 1-min files

  file:    by_date/etf_1min/2017/2017-01-17.parquet
  size:    2.9 MB
  rows:    155,141

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
2017-01-17 04:00:00	SPY	ETF	226.64	226.64	226.45	226.53	4693.0
2017-01-17 04:06:00	SPY	ETF	226.47	226.47	226.47	226.47	200.0
2017-01-17 04:07:00	SPY	ETF	226.43	226.43	226.43	226.43	200.0
2017-01-17 04:09:00	SPY	ETF	226.47	226.47	226.47	226.47	800.0
2017-01-17 04:10:00	SPY	ETF	226.45	226.45	226.43	226.43	600.0
2017-01-17 04:20:00	SPY	ETF	226.3	226.3	226.3	226.3	101.0
2017-01-17 04:33:00	SPY	ETF	226.47	226.47	226.47	226.47	224.0
2017-01-17 04:55:00	SPY	ETF	226.4	226.4	226.4	226.4	160.0
2017-01-17 05:17:00	SPY	ETF	226.35	226.35	226.33	226.33	200.0
2017-01-17 05:18:00	SPY	ETF	226.37	226.37	226.37	226.37	100.0
2017-01-17 05:20:00	SPY	ETF	226.31	226.31	226.31	226.31	1020.0
2017-01-17 05:21:00	SPY	ETF	226.28	226.28	226.19	226.19	990.0
2017-01-17 05:23:00	SPY	ETF	226.21	226.21	226.21	226.21	300.0
2017-01-17 05:28:00	SPY	ETF	226.31	226.31	226.31	226.31	200.0
2017-01-17 05:30:00	SPY	ETF	226.25	226.25	226.25	226.25	202.0
2017-01-17 05:33:00	SPY	ETF	226.23	226.23	226.23	226.23	300.0
2017-01-17 05:40:00	SPY	ETF	226.28	226.28	226.28	226.28	726.0
2017-01-17 05:45:00	SPY	ETF	226.18	226.18	226.18	226.18	401.0
2017-01-17 05:51:00	SPY	ETF	226.13	226.13	226.1	226.1	1001.0
2017-01-17 05:52:00	SPY	ETF	226.1	226.1	226.1	226.1	320.0
2017-01-17 05:53:00	SPY	ETF	226.1	226.1	226.1	226.1	979.0
2017-01-17 05:54:00	SPY	ETF	226.11	226.11	226.1	226.1	2300.0
2017-01-17 05:55:00	SPY	ETF	226.1	226.1	226.08	226.08	6052.0
2017-01-17 05:56:00	SPY	ETF	226.05	226.05	226.0	226.0	1525.0
2017-01-17 05:57:00	SPY	ETF	226.0	226.01	226.0	226.01	1500.0
2017-01-17 06:00:00	SPY	ETF	226.08	226.08	226.08	226.08	1010.0
2017-01-17 06:01:00	SPY	ETF	226.1	226.1	226.08	226.08	7489.0
2017-01-17 06:02:00	SPY	ETF	226.06	226.06	226.06	226.06	200.0
2017-01-17 06:03:00	SPY	ETF	226.06	226.06	226.05	226.05	900.0
2017-01-17 06:05:00	SPY	ETF	226.1	226.1	226.1	226.1	200.0
2017-01-17 06:07:00	SPY	ETF	226.1	226.1	226.08	226.08	3295.0
2017-01-17 06:11:00	SPY	ETF	226.08	226.08	226.07	226.07	2101.0
2017-01-17 06:14:00	SPY	ETF	225.99	225.99	225.98	225.98	521.0
2017-01-17 06:16:00	SPY	ETF	226.01	226.01	226.01	226.01	100.0
2017-01-17 06:18:00	SPY	ETF	225.99	225.99	225.99	225.99	221.0
2017-01-17 06:25:00	SPY	ETF	226.09	226.09	226.09	226.09	105.0
2017-01-17 06:30:00	SPY	ETF	226.1	226.11	226.1	226.11	1755.0
2017-01-17 06:31:00	SPY	ETF	226.11	226.11	226.11	226.11	300.0
2017-01-17 06:33:00	SPY	ETF	226.08	226.08	226.08	226.08	300.0
2017-01-17 06:34:00	SPY	ETF	226.08	226.08	226.04	226.04	852.0
2017-01-17 06:35:00	SPY	ETF	226.06	226.06	226.06	226.06	400.0
2017-01-17 06:39:00	SPY	ETF	226.03	226.03	226.03	226.03	2002.0
2017-01-17 06:40:00	SPY	ETF	226.03	226.03	225.96	225.96	2103.0
2017-01-17 06:42:00	SPY	ETF	225.99	225.99	225.82	225.9	9936.0
2017-01-17 06:46:00	SPY	ETF	226.1	226.1	226.1	226.1	1003.0
2017-01-17 06:47:00	SPY	ETF	226.05	226.05	226.05	226.05	1021.0
2017-01-17 06:51:00	SPY	ETF	226.1	226.16	226.1	226.16	402.0
2017-01-17 06:52:00	SPY	ETF	226.14	226.14	226.14	226.14	3500.0
2017-01-17 06:53:00	SPY	ETF	226.19	226.2	226.19	226.19	1257.0
2017-01-17 06:54:00	SPY	ETF	226.24	226.25	226.24	226.24	6745.0

> showing 50 of 155,141 rows — these rows as CSV

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