PREVIEW / etf_5min / 2019-07-24

all etf 5-min files

  file:    by_date/etf_5min/2019/2019-07-24.parquet
  size:    1.4 MB
  rows:    60,297

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-07-24 04:00:00	SPY	ETF	299.35	299.47	299.3	299.3	2875.0
2019-07-24 04:05:00	SPY	ETF	299.3	299.3	299.15	299.15	2877.0
2019-07-24 04:10:00	SPY	ETF	299.17	299.17	299.17	299.17	270.0
2019-07-24 04:15:00	SPY	ETF	299.2	299.2	299.15	299.15	2800.0
2019-07-24 04:20:00	SPY	ETF	299.17	299.19	299.15	299.15	950.0
2019-07-24 04:25:00	SPY	ETF	299.2	299.2	299.2	299.2	500.0
2019-07-24 04:30:00	SPY	ETF	299.17	299.17	299.02	299.02	2900.0
2019-07-24 04:35:00	SPY	ETF	299.0	299.0	298.95	298.95	1310.0
2019-07-24 04:40:00	SPY	ETF	298.92	299.02	298.9	298.9	600.0
2019-07-24 04:45:00	SPY	ETF	298.97	298.97	298.97	298.97	100.0
2019-07-24 04:50:00	SPY	ETF	299.02	299.02	298.96	298.96	300.0
2019-07-24 04:55:00	SPY	ETF	298.95	298.95	298.95	298.95	400.0
2019-07-24 05:00:00	SPY	ETF	298.95	299.03	298.95	299.02	2033.0
2019-07-24 05:05:00	SPY	ETF	299.0	299.15	299.0	299.12	3150.0
2019-07-24 05:10:00	SPY	ETF	299.1	299.1	299.1	299.1	150.0
2019-07-24 05:15:00	SPY	ETF	299.1	299.1	299.1	299.1	500.0
2019-07-24 05:20:00	SPY	ETF	299.12	299.12	299.12	299.12	100.0
2019-07-24 05:30:00	SPY	ETF	299.02	299.07	299.02	299.04	5240.0
2019-07-24 05:35:00	SPY	ETF	299.02	299.04	299.02	299.02	1238.0
2019-07-24 05:40:00	SPY	ETF	299.02	299.02	298.95	298.95	2713.0
2019-07-24 05:45:00	SPY	ETF	298.9	298.9	298.9	298.9	200.0
2019-07-24 05:50:00	SPY	ETF	298.87	298.87	298.87	298.87	400.0
2019-07-24 05:55:00	SPY	ETF	298.92	298.95	298.92	298.95	1105.0
2019-07-24 06:05:00	SPY	ETF	299.05	299.05	299.05	299.05	300.0
2019-07-24 06:10:00	SPY	ETF	299.07	299.12	299.07	299.1	2000.0
2019-07-24 06:15:00	SPY	ETF	299.15	299.15	299.15	299.15	1100.0
2019-07-24 06:20:00	SPY	ETF	299.15	299.17	299.12	299.15	2870.0
2019-07-24 06:25:00	SPY	ETF	299.12	299.16	299.12	299.16	530.0
2019-07-24 06:30:00	SPY	ETF	299.15	299.19	299.15	299.19	15909.0
2019-07-24 06:35:00	SPY	ETF	299.2	299.2	299.16	299.17	1090.0
2019-07-24 06:40:00	SPY	ETF	299.2	299.25	299.2	299.25	1400.0
2019-07-24 06:45:00	SPY	ETF	299.24	299.34	299.24	299.26	7905.0
2019-07-24 06:50:00	SPY	ETF	299.35	299.35	299.28	299.3	900.0
2019-07-24 06:55:00	SPY	ETF	299.33	299.39	299.33	299.39	10260.0
2019-07-24 07:00:00	SPY	ETF	299.38	299.43	299.28	299.28	7730.0
2019-07-24 07:05:00	SPY	ETF	299.25	299.29	299.23	299.26	4715.0
2019-07-24 07:10:00	SPY	ETF	299.3	299.33	299.29	299.3	1775.0
2019-07-24 07:15:00	SPY	ETF	299.34	299.34	299.33	299.33	1252.0
2019-07-24 07:20:00	SPY	ETF	299.37	299.41	299.35	299.35	950.0
2019-07-24 07:25:00	SPY	ETF	299.4	299.43	299.35	299.35	17510.0
2019-07-24 07:30:00	SPY	ETF	299.35	299.35	299.2	299.33	31390.0
2019-07-24 07:35:00	SPY	ETF	299.33	299.34	299.24	299.25	15633.0
2019-07-24 07:40:00	SPY	ETF	299.33	299.35	299.25	299.26	33720.0
2019-07-24 07:45:00	SPY	ETF	299.26	299.27	299.21	299.21	17575.0
2019-07-24 07:50:00	SPY	ETF	299.26	299.29	299.24	299.27	2250.0
2019-07-24 07:55:00	SPY	ETF	299.29	299.29	299.26	299.26	2842.0
2019-07-24 08:00:00	SPY	ETF	299.2999	299.74	299.15	299.37	35596.0
2019-07-24 08:05:00	SPY	ETF	299.36	300.03	299.31	299.31	6575.0
2019-07-24 08:10:00	SPY	ETF	299.35	299.35	299.32	299.33	1797.0
2019-07-24 08:15:00	SPY	ETF	299.33	299.37	299.31	299.34	35522.0

> showing 50 of 60,297 rows — these rows as CSV

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