PREVIEW / etf_5min / 2017-09-20

all etf 5-min files

  file:    by_date/etf_5min/2017/2017-09-20.parquet
  size:    1.2 MB
  rows:    53,010

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-09-20 04:00:00	SPY	ETF	249.97	249.97	249.85	249.85	800.0
2017-09-20 04:05:00	SPY	ETF	249.97	249.97	249.95	249.95	900.0
2017-09-20 04:10:00	SPY	ETF	249.99	250.01	249.99	250.01	5241.0
2017-09-20 04:15:00	SPY	ETF	249.95	249.97	249.95	249.97	800.0
2017-09-20 04:20:00	SPY	ETF	250.0	250.0	250.0	250.0	300.0
2017-09-20 04:25:00	SPY	ETF	250.0	250.0	249.97	249.97	2400.0
2017-09-20 04:30:00	SPY	ETF	249.97	249.97	249.97	249.97	500.0
2017-09-20 04:35:00	SPY	ETF	250.0	250.0	250.0	250.0	1100.0
2017-09-20 04:50:00	SPY	ETF	250.05	250.05	250.05	250.05	300.0
2017-09-20 05:15:00	SPY	ETF	250.0	250.0	250.0	250.0	1000.0
2017-09-20 05:20:00	SPY	ETF	250.0	250.0	250.0	250.0	700.0
2017-09-20 05:30:00	SPY	ETF	250.0	250.02	250.0	250.02	5400.0
2017-09-20 06:10:00	SPY	ETF	250.0	250.03	250.0	250.03	500.0
2017-09-20 06:15:00	SPY	ETF	250.03	250.03	250.03	250.03	2000.0
2017-09-20 06:20:00	SPY	ETF	250.03	250.03	250.03	250.03	200.0
2017-09-20 06:40:00	SPY	ETF	249.97	249.97	249.97	249.97	100.0
2017-09-20 06:45:00	SPY	ETF	249.97	249.97	249.97	249.97	1800.0
2017-09-20 06:55:00	SPY	ETF	249.97	250.01	249.97	250.01	16100.0
2017-09-20 07:00:00	SPY	ETF	250.02	250.02	250.02	250.02	3005.0
2017-09-20 07:05:00	SPY	ETF	250.02	250.02	250.01	250.01	6100.0
2017-09-20 07:10:00	SPY	ETF	250.0	250.02	250.0	250.02	6320.0
2017-09-20 07:15:00	SPY	ETF	250.04	250.05	250.04	250.05	4285.0
2017-09-20 07:20:00	SPY	ETF	250.05	250.07	250.04	250.06	35715.0
2017-09-20 07:25:00	SPY	ETF	250.04	250.05	250.03	250.05	700.0
2017-09-20 07:30:00	SPY	ETF	250.05	250.08	250.05	250.07	1525.0
2017-09-20 07:35:00	SPY	ETF	250.06	250.06	250.06	250.06	1400.0
2017-09-20 07:40:00	SPY	ETF	250.05	250.05	250.01	250.01	4537.0
2017-09-20 07:45:00	SPY	ETF	250.01	250.01	249.98	249.99	5900.0
2017-09-20 07:50:00	SPY	ETF	249.99	250.05	249.99	250.03	7000.0
2017-09-20 07:55:00	SPY	ETF	250.01	250.02	249.97	249.97	3740.0
2017-09-20 08:00:00	SPY	ETF	249.96	249.98	249.95	249.98	7164.0
2017-09-20 08:05:00	SPY	ETF	250.01	250.01	250.0	250.0	200.0
2017-09-20 08:10:00	SPY	ETF	249.99	250.02	249.99	250.01	3196.0
2017-09-20 08:15:00	SPY	ETF	250.0	250.01	250.0	250.0	1507.0
2017-09-20 08:20:00	SPY	ETF	250.01	250.03	250.01	250.02	8675.0
2017-09-20 08:25:00	SPY	ETF	250.03	250.03	250.02	250.02	20200.0
2017-09-20 08:30:00	SPY	ETF	250.02	250.02	250.01	250.02	1650.0
2017-09-20 08:35:00	SPY	ETF	250.0	250.03	250.0	250.02	3800.0
2017-09-20 08:40:00	SPY	ETF	250.03	250.05	250.02	250.02	12700.0
2017-09-20 08:45:00	SPY	ETF	250.02	250.03	250.01	250.03	6410.0
2017-09-20 08:50:00	SPY	ETF	250.02	250.04	250.02	250.04	4500.0
2017-09-20 08:55:00	SPY	ETF	250.03	250.04	250.03	250.04	520.0
2017-09-20 09:00:00	SPY	ETF	250.03	250.07	250.03	250.07	3582.0
2017-09-20 09:05:00	SPY	ETF	250.05	250.07	250.04	250.04	9552.0
2017-09-20 09:10:00	SPY	ETF	250.02	250.02	250.02	250.02	1100.0
2017-09-20 09:15:00	SPY	ETF	250.03	250.03	250.01	250.01	7364.0
2017-09-20 09:20:00	SPY	ETF	250.01	250.05	250.01	250.03	22592.0
2017-09-20 09:25:00	SPY	ETF	250.04	250.07	250.04	250.06	30305.0
2017-09-20 09:30:00	SPY	ETF	250.07	250.19	250.0	250.04	1393170.0
2017-09-20 09:35:00	SPY	ETF	250.04	250.12	249.97	250.11	456254.0

> showing 50 of 53,010 rows — these rows as CSV

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