PREVIEW / etf_5min / 2019-08-23

all etf 5-min files

  file:    by_date/etf_5min/2019/2019-08-23.parquet
  size:    1.6 MB
  rows:    65,950

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-08-23 04:00:00	SPY	ETF	293.14	293.14	293.1	293.1	1035.0
2019-08-23 04:05:00	SPY	ETF	293.2	293.27	293.2	293.27	2711.0
2019-08-23 04:10:00	SPY	ETF	293.17	293.22	293.17	293.22	1000.0
2019-08-23 04:15:00	SPY	ETF	293.25	293.25	293.25	293.25	500.0
2019-08-23 04:20:00	SPY	ETF	293.32	293.32	293.32	293.32	500.0
2019-08-23 04:25:00	SPY	ETF	293.42	293.42	293.42	293.42	529.0
2019-08-23 04:30:00	SPY	ETF	293.42	293.5	293.42	293.5	1475.0
2019-08-23 04:45:00	SPY	ETF	293.46	293.46	293.44	293.44	1400.0
2019-08-23 04:50:00	SPY	ETF	293.34	293.34	293.34	293.34	1000.0
2019-08-23 04:55:00	SPY	ETF	293.39	293.39	293.39	293.39	300.0
2019-08-23 05:00:00	SPY	ETF	293.35	293.38	293.35	293.38	1000.0
2019-08-23 05:10:00	SPY	ETF	293.48	293.48	293.48	293.48	600.0
2019-08-23 05:40:00	SPY	ETF	293.28	293.28	293.28	293.28	500.0
2019-08-23 05:50:00	SPY	ETF	293.14	293.19	293.14	293.18	3200.0
2019-08-23 05:55:00	SPY	ETF	293.3	293.31	293.29	293.29	2104.0
2019-08-23 06:00:00	SPY	ETF	293.28	293.28	293.28	293.28	100.0
2019-08-23 06:05:00	SPY	ETF	293.29	293.29	293.29	293.29	352.0
2019-08-23 06:15:00	SPY	ETF	293.14	293.14	293.14	293.14	5000.0
2019-08-23 06:20:00	SPY	ETF	293.18	293.18	293.13	293.13	1200.0
2019-08-23 06:25:00	SPY	ETF	293.1	293.1	293.1	293.1	444.0
2019-08-23 06:35:00	SPY	ETF	292.9	292.9	292.7	292.7	2768.0
2019-08-23 06:40:00	SPY	ETF	292.8	292.8	292.8	292.8	410.0
2019-08-23 06:45:00	SPY	ETF	292.83	292.85	292.83	292.85	1500.0
2019-08-23 06:50:00	SPY	ETF	292.75	292.8	292.75	292.8	3420.0
2019-08-23 06:55:00	SPY	ETF	292.7	292.85	292.7	292.85	1391.0
2019-08-23 07:00:00	SPY	ETF	292.89	293.0	292.86	292.94	2624.0
2019-08-23 07:05:00	SPY	ETF	292.89	293.0	292.89	293.0	9512.0
2019-08-23 07:10:00	SPY	ETF	293.06	293.07	293.01	293.01	4555.0
2019-08-23 07:15:00	SPY	ETF	292.91	293.05	292.91	293.0	50083.0
2019-08-23 07:20:00	SPY	ETF	292.99	293.05	292.99	293.05	13432.0
2019-08-23 07:25:00	SPY	ETF	293.05	293.05	293.05	293.05	135.0
2019-08-23 07:30:00	SPY	ETF	293.05	293.05	292.98	292.98	12553.0
2019-08-23 07:35:00	SPY	ETF	292.94	293.05	292.94	292.95	100230.0
2019-08-23 07:40:00	SPY	ETF	292.92	293.45	292.92	293.36	74841.0
2019-08-23 07:45:00	SPY	ETF	293.36	293.36	293.2	293.2	27796.0
2019-08-23 07:50:00	SPY	ETF	293.21	293.24	293.2	293.2	4475.0
2019-08-23 07:55:00	SPY	ETF	293.2	293.24	293.17	293.19	2988.0
2019-08-23 08:00:00	SPY	ETF	292.98	293.57	290.71	290.98	651318.0
2019-08-23 08:05:00	SPY	ETF	290.91	292.01	290.61	291.3	336179.0
2019-08-23 08:10:00	SPY	ETF	291.27	291.6	290.89	291.09	430082.0
2019-08-23 08:15:00	SPY	ETF	290.99	291.23	290.85	291.06	298644.0
2019-08-23 08:20:00	SPY	ETF	291.0	291.1	290.79	290.95	166300.0
2019-08-23 08:25:00	SPY	ETF	290.83	290.83	290.25	290.58	290091.0
2019-08-23 08:30:00	SPY	ETF	290.69	290.81	290.47	290.56	150674.0
2019-08-23 08:35:00	SPY	ETF	290.54	290.86	290.38	290.8	191191.0
2019-08-23 08:40:00	SPY	ETF	290.82	290.98	290.65	290.71	110118.0
2019-08-23 08:45:00	SPY	ETF	290.7	291.01	290.48	290.92	116235.0
2019-08-23 08:50:00	SPY	ETF	290.96	291.13	290.8	290.91	158034.0
2019-08-23 08:55:00	SPY	ETF	290.89	291.4	290.89	291.17	142374.0
2019-08-23 09:00:00	SPY	ETF	291.13	291.19	290.77	290.99	712110.0

> showing 50 of 65,950 rows — these rows as CSV

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