PREVIEW / etf_5min / 2019-10-21

all etf 5-min files

  file:    by_date/etf_5min/2019/2019-10-21.parquet
  size:    1.4 MB
  rows:    58,841

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-10-21 04:00:00	SPY	ETF	298.82	298.94	298.82	298.9	2543.0
2019-10-21 04:05:00	SPY	ETF	298.9	299.0	298.89	298.9	4025.0
2019-10-21 04:10:00	SPY	ETF	298.93	298.97	298.92	298.96	2003.0
2019-10-21 04:15:00	SPY	ETF	299.01	299.04	299.0	299.0	3100.0
2019-10-21 04:20:00	SPY	ETF	299.03	299.03	298.97	298.97	900.0
2019-10-21 04:25:00	SPY	ETF	298.95	298.95	298.95	298.95	600.0
2019-10-21 04:30:00	SPY	ETF	299.0	299.04	298.99	299.04	4500.0
2019-10-21 04:35:00	SPY	ETF	299.0	299.0	299.0	299.0	400.0
2019-10-21 04:40:00	SPY	ETF	298.9	298.97	298.9	298.97	1500.0
2019-10-21 04:45:00	SPY	ETF	299.07	299.07	299.07	299.07	100.0
2019-10-21 04:50:00	SPY	ETF	298.95	298.95	298.88	298.88	2600.0
2019-10-21 05:00:00	SPY	ETF	298.8	298.81	298.8	298.8	3250.0
2019-10-21 05:05:00	SPY	ETF	298.8	298.92	298.8	298.92	4600.0
2019-10-21 05:10:00	SPY	ETF	298.95	298.95	298.95	298.95	1000.0
2019-10-21 05:15:00	SPY	ETF	298.93	298.93	298.79	298.83	12300.0
2019-10-21 05:20:00	SPY	ETF	298.82	298.82	298.73	298.73	12199.0
2019-10-21 05:25:00	SPY	ETF	298.8	298.8	298.8	298.8	500.0
2019-10-21 05:30:00	SPY	ETF	298.82	298.94	298.79	298.9	9936.0
2019-10-21 05:35:00	SPY	ETF	298.9	298.91	298.83	298.91	2250.0
2019-10-21 05:40:00	SPY	ETF	298.93	298.93	298.93	298.93	1000.0
2019-10-21 05:45:00	SPY	ETF	299.04	299.06	299.04	299.06	1290.0
2019-10-21 05:55:00	SPY	ETF	298.96	298.99	298.96	298.99	300.0
2019-10-21 06:00:00	SPY	ETF	298.97	299.01	298.97	299.01	400.0
2019-10-21 06:10:00	SPY	ETF	298.89	298.95	298.89	298.93	2015.0
2019-10-21 06:15:00	SPY	ETF	298.93	298.98	298.93	298.98	1100.0
2019-10-21 06:20:00	SPY	ETF	298.98	299.04	298.98	299.04	1399.0
2019-10-21 06:25:00	SPY	ETF	299.11	299.18	299.11	299.11	4175.0
2019-10-21 06:30:00	SPY	ETF	299.06	299.06	298.94	298.94	200.0
2019-10-21 06:35:00	SPY	ETF	298.94	298.94	298.89	298.9	500.0
2019-10-21 06:40:00	SPY	ETF	298.88	298.88	298.88	298.88	408.0
2019-10-21 06:45:00	SPY	ETF	298.93	298.96	298.93	298.96	600.0
2019-10-21 06:50:00	SPY	ETF	298.96	299.05	298.96	298.98	5400.0
2019-10-21 06:55:00	SPY	ETF	298.99	298.99	298.95	298.95	250.0
2019-10-21 07:00:00	SPY	ETF	298.93	299.0	298.9	299.0	32998.0
2019-10-21 07:05:00	SPY	ETF	298.95	299.0	298.95	298.95	7467.0
2019-10-21 07:10:00	SPY	ETF	298.89	299.0	298.88	298.91	16660.0
2019-10-21 07:15:00	SPY	ETF	298.92	298.97	298.9	298.91	1690.0
2019-10-21 07:20:00	SPY	ETF	298.92	298.95	298.87	298.95	4492.0
2019-10-21 07:25:00	SPY	ETF	298.96	299.0	298.95	298.99	3290.0
2019-10-21 07:30:00	SPY	ETF	299.0	299.01	298.98	299.01	5800.0
2019-10-21 07:35:00	SPY	ETF	299.01	299.09	298.97	299.09	4200.0
2019-10-21 07:40:00	SPY	ETF	299.07	299.07	299.0	299.02	6268.0
2019-10-21 07:45:00	SPY	ETF	299.05	299.05	299.04	299.04	1120.0
2019-10-21 07:50:00	SPY	ETF	299.04	299.09	299.04	299.09	511.0
2019-10-21 07:55:00	SPY	ETF	299.06	299.12	299.06	299.1	3515.0
2019-10-21 08:00:00	SPY	ETF	299.08	299.28	298.51	299.25	51843.0
2019-10-21 08:05:00	SPY	ETF	299.25	299.26	299.21	299.25	8266.0
2019-10-21 08:10:00	SPY	ETF	299.22	299.28	299.21	299.28	1926.0
2019-10-21 08:15:00	SPY	ETF	299.27	299.27	299.23	299.23	8027.0
2019-10-21 08:20:00	SPY	ETF	299.26	299.32	299.21	299.28	15989.0

> showing 50 of 58,841 rows — these rows as CSV

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