PREVIEW / etf_5min / 2018-08-23

all etf 5-min files

  file:    by_date/etf_5min/2018/2018-08-23.parquet
  size:    1.3 MB
  rows:    55,565

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-23 04:00:00	SPY	ETF	286.09	286.12	286.09	286.09	700.0
2018-08-23 04:15:00	SPY	ETF	285.94	285.94	285.94	285.94	300.0
2018-08-23 04:20:00	SPY	ETF	286.1	286.1	286.1	286.1	120.0
2018-08-23 04:25:00	SPY	ETF	286.09	286.09	286.09	286.09	300.0
2018-08-23 04:30:00	SPY	ETF	286.08	286.08	286.07	286.07	200.0
2018-08-23 04:35:00	SPY	ETF	286.32	286.32	286.32	286.32	102.0
2018-08-23 05:05:00	SPY	ETF	286.25	286.32	286.25	286.27	6800.0
2018-08-23 05:10:00	SPY	ETF	286.29	286.31	286.29	286.31	3050.0
2018-08-23 05:15:00	SPY	ETF	286.25	286.28	286.25	286.28	4900.0
2018-08-23 05:20:00	SPY	ETF	286.28	286.28	286.25	286.25	500.0
2018-08-23 05:30:00	SPY	ETF	286.15	286.15	286.15	286.15	400.0
2018-08-23 05:40:00	SPY	ETF	286.1	286.12	286.1	286.12	800.0
2018-08-23 05:50:00	SPY	ETF	286.13	286.13	286.13	286.13	300.0
2018-08-23 05:55:00	SPY	ETF	286.15	286.15	286.15	286.15	400.0
2018-08-23 06:00:00	SPY	ETF	286.1	286.11	286.1	286.11	1019.0
2018-08-23 06:05:00	SPY	ETF	286.11	286.11	286.1	286.1	400.0
2018-08-23 06:10:00	SPY	ETF	286.1	286.1	286.1	286.1	300.0
2018-08-23 06:25:00	SPY	ETF	286.11	286.11	286.11	286.11	100.0
2018-08-23 06:30:00	SPY	ETF	286.06	286.06	286.06	286.06	100.0
2018-08-23 06:35:00	SPY	ETF	286.03	286.03	286.03	286.03	300.0
2018-08-23 06:40:00	SPY	ETF	286.08	286.08	286.08	286.08	1400.0
2018-08-23 06:50:00	SPY	ETF	286.18	286.23	286.15	286.23	4200.0
2018-08-23 06:55:00	SPY	ETF	286.21	286.22	286.21	286.22	2200.0
2018-08-23 07:00:00	SPY	ETF	286.15	286.16	286.08	286.08	3041.0
2018-08-23 07:05:00	SPY	ETF	286.1	286.17	286.1	286.15	18603.0
2018-08-23 07:10:00	SPY	ETF	286.12	286.12	286.04	286.04	5540.0
2018-08-23 07:15:00	SPY	ETF	286.01	286.01	285.93	285.93	14125.0
2018-08-23 07:20:00	SPY	ETF	285.96	285.96	285.96	285.96	1370.0
2018-08-23 07:25:00	SPY	ETF	285.99	286.03	285.98	285.98	16170.0
2018-08-23 07:30:00	SPY	ETF	286.01	286.06	285.98	286.01	3850.0
2018-08-23 07:35:00	SPY	ETF	285.98	285.98	285.98	285.98	5210.0
2018-08-23 07:40:00	SPY	ETF	286.03	286.14	286.03	286.14	3598.0
2018-08-23 07:55:00	SPY	ETF	286.09	286.16	286.09	286.14	1130.0
2018-08-23 08:00:00	SPY	ETF	286.15	286.15	285.99	286.14	8893.0
2018-08-23 08:05:00	SPY	ETF	286.1	286.16	286.1	286.16	5900.0
2018-08-23 08:10:00	SPY	ETF	286.13	286.17	286.13	286.17	10521.0
2018-08-23 08:15:00	SPY	ETF	286.17	286.23	286.16	286.21	10507.0
2018-08-23 08:20:00	SPY	ETF	286.2	286.24	286.09	286.1	21857.0
2018-08-23 08:25:00	SPY	ETF	286.15	286.15	286.15	286.15	100.0
2018-08-23 08:30:00	SPY	ETF	286.15	286.16	286.07	286.08	6326.0
2018-08-23 08:35:00	SPY	ETF	286.08	286.08	286.03	286.06	6510.0
2018-08-23 08:45:00	SPY	ETF	286.08	286.13	286.08	286.12	3768.0
2018-08-23 08:50:00	SPY	ETF	286.14	286.17	286.12	286.15	23523.0
2018-08-23 08:55:00	SPY	ETF	286.16	286.18	286.13	286.17	3327.0
2018-08-23 09:00:00	SPY	ETF	286.17	286.17	286.11	286.11	5013.0
2018-08-23 09:05:00	SPY	ETF	286.13	286.13	286.05	286.07	10705.0
2018-08-23 09:10:00	SPY	ETF	286.03	286.05	285.9	285.95	40433.0
2018-08-23 09:15:00	SPY	ETF	285.98	285.98	285.8	285.85	41963.0
2018-08-23 09:20:00	SPY	ETF	285.85	285.86	285.82	285.83	16130.0
2018-08-23 09:25:00	SPY	ETF	285.84	285.95	285.83	285.94	172002.0

> showing 50 of 55,565 rows — these rows as CSV

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