PREVIEW / etf_5min / 2019-09-09

all etf 5-min files

  file:    by_date/etf_5min/2019/2019-09-09.parquet
  size:    1.4 MB
  rows:    61,605

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-09-09 04:00:00	SPY	ETF	298.92	298.92	298.82	298.85	3789.0
2019-09-09 04:05:00	SPY	ETF	298.83	298.83	298.83	298.83	170.0
2019-09-09 04:20:00	SPY	ETF	298.77	298.81	298.77	298.81	1300.0
2019-09-09 04:25:00	SPY	ETF	298.76	298.76	298.73	298.73	475.0
2019-09-09 04:35:00	SPY	ETF	298.8	298.8	298.8	298.8	450.0
2019-09-09 04:45:00	SPY	ETF	298.78	298.8	298.78	298.8	1200.0
2019-09-09 05:30:00	SPY	ETF	298.92	298.92	298.92	298.92	500.0
2019-09-09 05:35:00	SPY	ETF	298.9	298.9	298.9	298.9	300.0
2019-09-09 05:40:00	SPY	ETF	298.87	298.87	298.85	298.85	450.0
2019-09-09 05:45:00	SPY	ETF	298.99	299.0	298.99	299.0	700.0
2019-09-09 05:50:00	SPY	ETF	299.05	299.1	299.03	299.1	8300.0
2019-09-09 06:00:00	SPY	ETF	299.15	299.18	299.15	299.18	500.0
2019-09-09 06:05:00	SPY	ETF	299.18	299.18	299.18	299.18	110.0
2019-09-09 06:10:00	SPY	ETF	299.18	299.21	299.17	299.17	1527.0
2019-09-09 06:15:00	SPY	ETF	299.13	299.16	299.1	299.16	600.0
2019-09-09 06:20:00	SPY	ETF	299.16	299.16	299.16	299.16	300.0
2019-09-09 06:25:00	SPY	ETF	299.13	299.13	299.13	299.13	100.0
2019-09-09 06:30:00	SPY	ETF	299.11	299.11	299.09	299.09	400.0
2019-09-09 06:35:00	SPY	ETF	299.05	299.08	299.05	299.08	1400.0
2019-09-09 06:40:00	SPY	ETF	299.03	299.03	299.0	299.0	2657.0
2019-09-09 06:45:00	SPY	ETF	298.98	298.98	298.98	298.98	157.0
2019-09-09 06:50:00	SPY	ETF	299.1	299.1	299.04	299.1	2407.0
2019-09-09 07:00:00	SPY	ETF	299.04	299.06	298.99	299.0	59132.0
2019-09-09 07:05:00	SPY	ETF	298.99	299.0	298.95	298.97	3154.0
2019-09-09 07:10:00	SPY	ETF	298.95	299.0	298.92	299.0	3014.0
2019-09-09 07:15:00	SPY	ETF	299.0	299.02	299.0	299.02	10622.0
2019-09-09 07:20:00	SPY	ETF	299.03	299.07	299.02	299.02	4044.0
2019-09-09 07:25:00	SPY	ETF	299.01	299.06	299.01	299.05	3150.0
2019-09-09 07:30:00	SPY	ETF	299.05	299.08	299.0	299.02	11136.0
2019-09-09 07:35:00	SPY	ETF	299.05	299.1	299.04	299.04	22553.0
2019-09-09 07:40:00	SPY	ETF	299.04	299.17	299.04	299.13	15476.0
2019-09-09 07:45:00	SPY	ETF	299.13	299.13	299.09	299.09	1670.0
2019-09-09 07:50:00	SPY	ETF	299.11	299.16	299.09	299.12	12350.0
2019-09-09 07:55:00	SPY	ETF	299.14	299.19	299.14	299.19	4055.0
2019-09-09 08:00:00	SPY	ETF	298.9999	299.2	298.85	299.2	10546.0
2019-09-09 08:05:00	SPY	ETF	299.2	299.25	299.14	299.1501	4650.0
2019-09-09 08:10:00	SPY	ETF	299.16	299.21	299.16	299.2	4211.0
2019-09-09 08:15:00	SPY	ETF	299.22	299.24	299.19	299.23	9180.0
2019-09-09 08:20:00	SPY	ETF	299.22	299.31	299.22	299.28	47718.0
2019-09-09 08:25:00	SPY	ETF	299.2799	299.32	299.25	299.3	5740.0
2019-09-09 08:30:00	SPY	ETF	299.28	299.3	299.21	299.22	18062.0
2019-09-09 08:35:00	SPY	ETF	299.22	299.28	299.21	299.23	2671.0
2019-09-09 08:40:00	SPY	ETF	299.26	299.3	299.22	299.27	6264.0
2019-09-09 08:45:00	SPY	ETF	299.29	299.29	299.25	299.28	12102.0
2019-09-09 08:50:00	SPY	ETF	299.26	299.3	299.25	299.28	20559.0
2019-09-09 08:55:00	SPY	ETF	299.29	299.29	299.25	299.25	8100.0
2019-09-09 09:00:00	SPY	ETF	299.22	299.26	299.22	299.26	7822.0
2019-09-09 09:05:00	SPY	ETF	299.25	299.34	299.19	299.34	30588.0
2019-09-09 09:10:00	SPY	ETF	299.34	299.34	299.27	299.3	33098.0
2019-09-09 09:15:00	SPY	ETF	299.31	299.35	299.25	299.26	36045.0

> showing 50 of 61,605 rows — these rows as CSV

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