PREVIEW / etf_5min / 2019-06-21

all etf 5-min files

  file:    by_date/etf_5min/2019/2019-06-21.parquet
  size:    1.4 MB
  rows:    62,545

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
2019-06-21 04:00:00	SPY	ETF	294.37	294.37	294.04	294.13	2888.0
2019-06-21 04:05:00	SPY	ETF	294.11	294.29	294.08	294.19	6780.0
2019-06-21 04:10:00	SPY	ETF	294.23	294.29	294.23	294.29	410.0
2019-06-21 04:15:00	SPY	ETF	294.28	294.28	294.22	294.24	1173.0
2019-06-21 04:20:00	SPY	ETF	294.24	294.26	294.11	294.16	2550.0
2019-06-21 04:25:00	SPY	ETF	294.19	294.19	294.19	294.19	300.0
2019-06-21 04:30:00	SPY	ETF	294.2	294.29	294.2	294.24	900.0
2019-06-21 04:35:00	SPY	ETF	294.22	294.24	294.17	294.17	1500.0
2019-06-21 04:40:00	SPY	ETF	294.17	294.17	294.1	294.1	989.0
2019-06-21 04:45:00	SPY	ETF	294.03	294.11	294.02	294.06	2900.0
2019-06-21 04:50:00	SPY	ETF	294.05	294.05	293.95	293.95	1825.0
2019-06-21 05:00:00	SPY	ETF	293.99	294.04	293.97	294.04	14700.0
2019-06-21 05:10:00	SPY	ETF	294.02	294.02	294.02	294.02	6000.0
2019-06-21 05:20:00	SPY	ETF	294.05	294.17	294.05	294.17	3370.0
2019-06-21 05:25:00	SPY	ETF	294.25	294.25	294.25	294.25	100.0
2019-06-21 05:30:00	SPY	ETF	294.32	294.32	294.32	294.32	100.0
2019-06-21 05:35:00	SPY	ETF	294.04	294.07	294.04	294.07	400.0
2019-06-21 05:40:00	SPY	ETF	294.1	294.1	294.07	294.07	400.0
2019-06-21 05:50:00	SPY	ETF	293.96	294.0	293.85	293.97	11277.0
2019-06-21 05:55:00	SPY	ETF	293.95	294.15	293.95	294.06	300.0
2019-06-21 06:00:00	SPY	ETF	294.0	294.07	293.94	293.97	4520.0
2019-06-21 06:05:00	SPY	ETF	294.1	294.1	294.07	294.07	200.0
2019-06-21 06:10:00	SPY	ETF	294.02	294.02	294.02	294.02	200.0
2019-06-21 06:15:00	SPY	ETF	293.93	293.97	293.88	293.88	2301.0
2019-06-21 06:20:00	SPY	ETF	293.85	293.85	293.85	293.85	510.0
2019-06-21 06:25:00	SPY	ETF	293.83	293.86	293.8	293.86	9460.0
2019-06-21 06:35:00	SPY	ETF	293.9	293.98	293.9	293.91	20650.0
2019-06-21 06:40:00	SPY	ETF	293.91	294.0	293.91	294.0	450.0
2019-06-21 06:45:00	SPY	ETF	294.05	294.18	294.04	294.14	3751.0
2019-06-21 06:50:00	SPY	ETF	294.04	294.06	294.02	294.06	1650.0
2019-06-21 06:55:00	SPY	ETF	294.16	294.26	294.11	294.11	5801.0
2019-06-21 07:00:00	SPY	ETF	294.13	294.33	294.11	294.27	8801.0
2019-06-21 07:05:00	SPY	ETF	294.29	294.29	294.12	294.12	9970.0
2019-06-21 07:10:00	SPY	ETF	294.12	294.12	294.05	294.05	12571.0
2019-06-21 07:15:00	SPY	ETF	294.08	294.2	294.06	294.08	10750.0
2019-06-21 07:20:00	SPY	ETF	294.08	294.08	293.92	294.0	48336.0
2019-06-21 07:25:00	SPY	ETF	293.98	294.03	293.94	293.97	17290.0
2019-06-21 07:30:00	SPY	ETF	293.96	293.96	293.9	293.95	10508.0
2019-06-21 07:35:00	SPY	ETF	293.98	293.99	293.87	293.98	19385.0
2019-06-21 07:40:00	SPY	ETF	293.96	293.98	293.92	293.95	1875.0
2019-06-21 07:45:00	SPY	ETF	293.95	293.96	293.93	293.93	2000.0
2019-06-21 07:50:00	SPY	ETF	294.02	294.02	293.95	293.95	9985.0
2019-06-21 07:55:00	SPY	ETF	293.94	293.97	293.91	293.91	3194.0
2019-06-21 08:00:00	SPY	ETF	294.06	294.35	293.4	294.03	118279.0
2019-06-21 08:05:00	SPY	ETF	294.0	294.04	293.84	293.89	66801.0
2019-06-21 08:10:00	SPY	ETF	293.88	293.95	293.84	293.84	17092.0
2019-06-21 08:15:00	SPY	ETF	293.84	293.91	293.83	293.88	8143.0
2019-06-21 08:20:00	SPY	ETF	293.88	293.88	293.76	293.84	77993.0
2019-06-21 08:25:00	SPY	ETF	293.8	293.82	293.77	293.8	72350.0
2019-06-21 08:30:00	SPY	ETF	293.8	294.17	293.8	294.16	65942.0

> showing 50 of 62,545 rows — these rows as CSV

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