PREVIEW / etf_5min / 2019-05-01

all etf 5-min files

  file:    by_date/etf_5min/2019/2019-05-01.parquet
  size:    1.5 MB
  rows:    62,890

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-05-01 04:00:00	SPY	ETF	295.27	295.27	295.27	295.27	400.0
2019-05-01 04:05:00	SPY	ETF	295.35	295.35	295.35	295.35	200.0
2019-05-01 04:10:00	SPY	ETF	295.33	295.33	295.33	295.33	200.0
2019-05-01 04:15:00	SPY	ETF	295.36	295.38	295.35	295.38	500.0
2019-05-01 04:20:00	SPY	ETF	295.36	295.36	295.34	295.34	800.0
2019-05-01 04:30:00	SPY	ETF	295.31	295.32	295.31	295.32	1210.0
2019-05-01 04:50:00	SPY	ETF	295.28	295.28	295.28	295.28	300.0
2019-05-01 04:55:00	SPY	ETF	295.22	295.22	295.22	295.22	1610.0
2019-05-01 05:10:00	SPY	ETF	295.21	295.21	295.21	295.21	200.0
2019-05-01 05:15:00	SPY	ETF	295.23	295.23	295.23	295.23	100.0
2019-05-01 05:20:00	SPY	ETF	295.19	295.19	295.19	295.19	300.0
2019-05-01 05:25:00	SPY	ETF	295.19	295.19	295.19	295.19	200.0
2019-05-01 05:40:00	SPY	ETF	295.14	295.16	295.14	295.16	600.0
2019-05-01 05:45:00	SPY	ETF	295.16	295.16	295.16	295.16	415.0
2019-05-01 05:50:00	SPY	ETF	295.18	295.18	295.18	295.18	2050.0
2019-05-01 05:55:00	SPY	ETF	295.15	295.15	295.15	295.15	200.0
2019-05-01 06:00:00	SPY	ETF	295.13	295.13	295.13	295.13	108.0
2019-05-01 06:05:00	SPY	ETF	295.13	295.13	295.12	295.13	650.0
2019-05-01 06:20:00	SPY	ETF	295.13	295.13	295.13	295.13	400.0
2019-05-01 06:25:00	SPY	ETF	295.1	295.11	295.1	295.11	1238.0
2019-05-01 06:30:00	SPY	ETF	295.12	295.12	295.12	295.12	169.0
2019-05-01 06:35:00	SPY	ETF	295.06	295.06	295.06	295.06	100.0
2019-05-01 06:40:00	SPY	ETF	295.06	295.06	294.97	294.97	1861.0
2019-05-01 06:45:00	SPY	ETF	294.97	294.97	294.95	294.95	4040.0
2019-05-01 06:55:00	SPY	ETF	294.95	294.95	294.95	294.95	1030.0
2019-05-01 07:00:00	SPY	ETF	294.93	294.97	294.85	294.88	12012.0
2019-05-01 07:05:00	SPY	ETF	294.93	295.0	294.93	295.0	2255.0
2019-05-01 07:10:00	SPY	ETF	295.01	295.09	295.01	295.09	1009.0
2019-05-01 07:15:00	SPY	ETF	295.1	295.15	295.1	295.13	6904.0
2019-05-01 07:20:00	SPY	ETF	295.13	295.13	295.1	295.1	13980.0
2019-05-01 07:25:00	SPY	ETF	295.1	295.13	295.09	295.09	27694.0
2019-05-01 07:30:00	SPY	ETF	295.09	295.12	295.06	295.06	21446.0
2019-05-01 07:35:00	SPY	ETF	295.06	295.07	295.06	295.07	29764.0
2019-05-01 07:40:00	SPY	ETF	295.07	295.08	295.05	295.05	1500.0
2019-05-01 07:45:00	SPY	ETF	295.08	295.08	295.05	295.07	2442.0
2019-05-01 07:55:00	SPY	ETF	295.05	295.05	295.05	295.05	838.0
2019-05-01 08:00:00	SPY	ETF	295.0601	295.25	294.98	295.1199	18997.0
2019-05-01 08:05:00	SPY	ETF	295.12	295.15	295.07	295.0799	5659.0
2019-05-01 08:10:00	SPY	ETF	295.06	295.06	294.9901	295.05	14542.0
2019-05-01 08:15:00	SPY	ETF	295.05	295.16	295.05	295.0801	5452.0
2019-05-01 08:20:00	SPY	ETF	295.11	295.11	295.06	295.11	6293.0
2019-05-01 08:25:00	SPY	ETF	295.11	295.15	295.11	295.15	26711.0
2019-05-01 08:30:00	SPY	ETF	295.14	295.24	295.14	295.16	34427.0
2019-05-01 08:35:00	SPY	ETF	295.08	295.18	295.08	295.12	243111.0
2019-05-01 08:40:00	SPY	ETF	295.14	295.15	295.07	295.07	12331.0
2019-05-01 08:45:00	SPY	ETF	295.07	295.13	295.07	295.11	51925.0
2019-05-01 08:50:00	SPY	ETF	295.06	295.11	294.93	294.93	132355.0
2019-05-01 08:55:00	SPY	ETF	294.93	294.96	294.85	294.95	38530.0
2019-05-01 09:00:00	SPY	ETF	294.95	294.95	294.87	294.88	25643.0
2019-05-01 09:05:00	SPY	ETF	294.88	294.88	294.86	294.87	5111.0

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

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