PREVIEW / etf_1min / 2017-11-22

all etf 1-min files

  file:    by_date/etf_1min/2017/2017-11-22.parquet
  size:    2.6 MB
  rows:    134,914

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-11-22 04:03:00	SPY	ETF	259.86	259.88	259.86	259.88	900.0
2017-11-22 04:04:00	SPY	ETF	259.88	259.88	259.88	259.88	200.0
2017-11-22 04:47:00	SPY	ETF	259.9	259.9	259.9	259.9	200.0
2017-11-22 04:51:00	SPY	ETF	259.9	259.9	259.9	259.9	100.0
2017-11-22 04:59:00	SPY	ETF	259.92	259.92	259.92	259.92	300.0
2017-11-22 05:01:00	SPY	ETF	259.92	259.92	259.92	259.92	300.0
2017-11-22 05:02:00	SPY	ETF	259.92	259.95	259.92	259.95	5000.0
2017-11-22 05:26:00	SPY	ETF	259.95	259.95	259.95	259.95	100.0
2017-11-22 06:19:00	SPY	ETF	259.92	259.92	259.92	259.92	100.0
2017-11-22 06:22:00	SPY	ETF	259.9	259.9	259.9	259.9	100.0
2017-11-22 06:23:00	SPY	ETF	259.92	259.92	259.92	259.92	200.0
2017-11-22 06:24:00	SPY	ETF	259.93	259.93	259.93	259.93	400.0
2017-11-22 06:45:00	SPY	ETF	259.88	259.88	259.88	259.88	157.0
2017-11-22 06:48:00	SPY	ETF	259.94	259.94	259.94	259.94	250.0
2017-11-22 06:52:00	SPY	ETF	259.95	259.95	259.94	259.94	850.0
2017-11-22 06:53:00	SPY	ETF	259.92	259.92	259.92	259.92	100.0
2017-11-22 06:54:00	SPY	ETF	259.92	259.92	259.92	259.92	900.0
2017-11-22 06:56:00	SPY	ETF	259.9	259.9	259.9	259.9	100.0
2017-11-22 06:58:00	SPY	ETF	259.93	259.93	259.93	259.93	300.0
2017-11-22 06:59:00	SPY	ETF	259.93	259.93	259.93	259.93	100.0
2017-11-22 07:00:00	SPY	ETF	259.97	259.99	259.97	259.99	1900.0
2017-11-22 07:01:00	SPY	ETF	260.0	260.0	260.0	260.0	10400.0
2017-11-22 07:02:00	SPY	ETF	259.99	260.01	259.99	260.01	1029.0
2017-11-22 07:03:00	SPY	ETF	260.01	260.03	260.01	260.01	6300.0
2017-11-22 07:04:00	SPY	ETF	260.01	260.01	260.01	260.01	100.0
2017-11-22 07:05:00	SPY	ETF	260.0	260.0	260.0	260.0	3856.0
2017-11-22 07:07:00	SPY	ETF	260.01	260.01	260.01	260.01	100.0
2017-11-22 07:08:00	SPY	ETF	260.03	260.03	260.03	260.03	300.0
2017-11-22 07:09:00	SPY	ETF	260.03	260.03	260.01	260.01	7000.0
2017-11-22 07:10:00	SPY	ETF	260.07	260.07	260.07	260.07	1000.0
2017-11-22 07:11:00	SPY	ETF	260.08	260.1	260.08	260.1	1700.0
2017-11-22 07:12:00	SPY	ETF	260.06	260.06	260.06	260.06	4110.0
2017-11-22 07:13:00	SPY	ETF	260.05	260.05	260.05	260.05	300.0
2017-11-22 07:14:00	SPY	ETF	260.04	260.04	260.04	260.04	300.0
2017-11-22 07:16:00	SPY	ETF	260.07	260.07	260.07	260.07	100.0
2017-11-22 07:19:00	SPY	ETF	260.06	260.06	260.06	260.06	117.0
2017-11-22 07:21:00	SPY	ETF	260.07	260.09	260.07	260.09	4700.0
2017-11-22 07:22:00	SPY	ETF	260.1	260.1	260.1	260.1	5000.0
2017-11-22 07:23:00	SPY	ETF	260.12	260.12	260.07	260.08	40000.0
2017-11-22 07:24:00	SPY	ETF	260.09	260.09	260.09	260.09	100.0
2017-11-22 07:25:00	SPY	ETF	260.09	260.09	260.09	260.09	150.0
2017-11-22 07:28:00	SPY	ETF	260.09	260.13	260.08	260.13	13631.0
2017-11-22 07:30:00	SPY	ETF	260.08	260.11	260.07	260.11	2550.0
2017-11-22 07:37:00	SPY	ETF	260.09	260.09	260.09	260.09	1069.0
2017-11-22 07:38:00	SPY	ETF	260.09	260.09	260.09	260.09	10000.0
2017-11-22 07:39:00	SPY	ETF	260.1	260.11	260.1	260.11	5030.0
2017-11-22 07:41:00	SPY	ETF	260.11	260.11	260.11	260.11	2032.0
2017-11-22 07:42:00	SPY	ETF	260.12	260.12	260.11	260.11	305.0
2017-11-22 07:43:00	SPY	ETF	260.12	260.12	260.12	260.12	750.0
2017-11-22 07:44:00	SPY	ETF	260.12	260.12	260.12	260.12	3650.0

> showing 50 of 134,914 rows — these rows as CSV

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