PREVIEW / etf_5min / 2018-08-21

all etf 5-min files

  file:    by_date/etf_5min/2018/2018-08-21.parquet
  size:    1.4 MB
  rows:    59,128

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
2018-08-21 04:00:00	SPY	ETF	285.98	285.98	285.98	285.98	100.0
2018-08-21 04:05:00	SPY	ETF	285.96	285.96	285.93	285.93	1525.0
2018-08-21 04:10:00	SPY	ETF	285.92	285.92	285.9	285.9	1319.0
2018-08-21 04:15:00	SPY	ETF	285.95	285.95	285.94	285.94	400.0
2018-08-21 04:25:00	SPY	ETF	285.94	285.94	285.94	285.94	900.0
2018-08-21 04:30:00	SPY	ETF	285.98	286.0	285.98	286.0	500.0
2018-08-21 04:35:00	SPY	ETF	285.99	286.0	285.97	286.0	1500.0
2018-08-21 04:40:00	SPY	ETF	285.99	285.99	285.99	285.99	300.0
2018-08-21 04:45:00	SPY	ETF	286.0	286.0	285.99	285.99	709.0
2018-08-21 04:55:00	SPY	ETF	285.99	286.05	285.99	286.05	1032.0
2018-08-21 05:00:00	SPY	ETF	286.1	286.13	286.1	286.13	633.0
2018-08-21 05:05:00	SPY	ETF	286.07	286.07	286.06	286.06	2928.0
2018-08-21 05:10:00	SPY	ETF	286.07	286.09	286.06	286.06	3100.0
2018-08-21 05:15:00	SPY	ETF	286.16	286.16	286.16	286.16	100.0
2018-08-21 05:20:00	SPY	ETF	286.16	286.22	286.16	286.22	500.0
2018-08-21 05:30:00	SPY	ETF	286.25	286.25	286.25	286.25	1000.0
2018-08-21 05:35:00	SPY	ETF	286.19	286.19	286.14	286.14	910.0
2018-08-21 05:40:00	SPY	ETF	286.15	286.15	286.15	286.15	100.0
2018-08-21 05:45:00	SPY	ETF	286.18	286.18	286.18	286.18	100.0
2018-08-21 05:50:00	SPY	ETF	286.13	286.13	286.13	286.13	1800.0
2018-08-21 05:55:00	SPY	ETF	286.16	286.33	286.16	286.33	2627.0
2018-08-21 06:00:00	SPY	ETF	286.28	286.33	286.28	286.33	1730.0
2018-08-21 06:10:00	SPY	ETF	286.28	286.28	286.25	286.25	2000.0
2018-08-21 06:15:00	SPY	ETF	286.21	286.25	286.21	286.23	1400.0
2018-08-21 06:20:00	SPY	ETF	286.28	286.28	286.28	286.28	100.0
2018-08-21 06:25:00	SPY	ETF	286.33	286.33	286.33	286.33	100.0
2018-08-21 06:30:00	SPY	ETF	286.3	286.3	286.3	286.3	250.0
2018-08-21 06:40:00	SPY	ETF	286.3	286.3	286.27	286.27	350.0
2018-08-21 06:45:00	SPY	ETF	286.27	286.29	286.27	286.29	200.0
2018-08-21 06:55:00	SPY	ETF	286.23	286.28	286.23	286.28	1350.0
2018-08-21 07:00:00	SPY	ETF	286.28	286.3	286.24	286.24	2739.0
2018-08-21 07:05:00	SPY	ETF	286.22	286.24	286.22	286.24	2130.0
2018-08-21 07:10:00	SPY	ETF	286.19	286.25	286.17	286.24	3100.0
2018-08-21 07:15:00	SPY	ETF	286.25	286.32	286.25	286.27	6607.0
2018-08-21 07:20:00	SPY	ETF	286.26	286.26	286.23	286.25	5100.0
2018-08-21 07:25:00	SPY	ETF	286.23	286.23	286.22	286.22	4300.0
2018-08-21 07:30:00	SPY	ETF	286.24	286.24	286.24	286.24	3000.0
2018-08-21 07:35:00	SPY	ETF	286.26	286.28	286.23	286.24	32610.0
2018-08-21 07:40:00	SPY	ETF	286.23	286.26	286.23	286.25	11000.0
2018-08-21 07:45:00	SPY	ETF	286.27	286.28	286.27	286.27	13524.0
2018-08-21 07:50:00	SPY	ETF	286.28	286.29	286.27	286.29	13953.0
2018-08-21 08:00:00	SPY	ETF	286.2899	286.2899	286.2	286.24	632822.0
2018-08-21 08:05:00	SPY	ETF	286.21	286.26	286.21	286.24	2621.0
2018-08-21 08:10:00	SPY	ETF	286.21	286.21	286.17	286.2099	8115.0
2018-08-21 08:15:00	SPY	ETF	286.17	286.2	286.12	286.2	12727.0
2018-08-21 08:20:00	SPY	ETF	286.15	286.18	286.15	286.15	1717.0
2018-08-21 08:25:00	SPY	ETF	286.17	286.22	286.17	286.22	8063.0
2018-08-21 08:30:00	SPY	ETF	286.2	286.23	286.18	286.18	36580.0
2018-08-21 08:35:00	SPY	ETF	286.17	286.17	286.12	286.12	14229.0
2018-08-21 08:40:00	SPY	ETF	286.11	286.14	286.1	286.14	15515.0

> showing 50 of 59,128 rows — these rows as CSV

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