PREVIEW / etf_5min / 2020-02-20

all etf 5-min files

  file:    by_date/etf_5min/2020/2020-02-20.parquet
  size:    1.6 MB
  rows:    68,463

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
2020-02-20 04:00:00	SPY	ETF	337.59	338.11	337.59	338.1	3973.0
2020-02-20 04:05:00	SPY	ETF	338.11	338.16	338.11	338.16	1020.0
2020-02-20 04:10:00	SPY	ETF	338.13	338.27	338.13	338.27	604.0
2020-02-20 04:15:00	SPY	ETF	338.16	338.17	338.16	338.17	740.0
2020-02-20 04:20:00	SPY	ETF	338.06	338.06	337.92	337.92	1727.0
2020-02-20 04:25:00	SPY	ETF	337.95	337.96	337.95	337.96	407.0
2020-02-20 04:30:00	SPY	ETF	338.0	338.05	338.0	338.05	2187.0
2020-02-20 04:40:00	SPY	ETF	338.18	338.3	338.18	338.23	1405.0
2020-02-20 04:45:00	SPY	ETF	338.18	338.18	338.18	338.18	420.0
2020-02-20 04:55:00	SPY	ETF	338.22	338.3	338.22	338.25	1150.0
2020-02-20 05:05:00	SPY	ETF	338.28	338.28	338.24	338.24	220.0
2020-02-20 05:10:00	SPY	ETF	338.21	338.21	338.21	338.21	227.0
2020-02-20 05:15:00	SPY	ETF	338.2	338.23	338.18	338.18	600.0
2020-02-20 05:20:00	SPY	ETF	338.01	338.01	337.99	338.01	883.0
2020-02-20 05:30:00	SPY	ETF	338.08	338.08	338.08	338.08	431.0
2020-02-20 05:35:00	SPY	ETF	338.04	338.04	338.04	338.04	100.0
2020-02-20 05:40:00	SPY	ETF	337.98	337.98	337.98	337.98	708.0
2020-02-20 05:45:00	SPY	ETF	337.91	337.92	337.85	337.86	4100.0
2020-02-20 05:50:00	SPY	ETF	337.9	337.95	337.83	337.91	5639.0
2020-02-20 05:55:00	SPY	ETF	337.95	337.98	337.95	337.98	662.0
2020-02-20 06:00:00	SPY	ETF	337.95	337.96	337.86	337.86	4569.0
2020-02-20 06:05:00	SPY	ETF	337.89	337.93	337.89	337.91	750.0
2020-02-20 06:15:00	SPY	ETF	338.01	338.01	338.0	338.0	2520.0
2020-02-20 06:20:00	SPY	ETF	338.05	338.11	338.03	338.08	2270.0
2020-02-20 06:25:00	SPY	ETF	338.04	338.05	338.02	338.02	1300.0
2020-02-20 06:30:00	SPY	ETF	338.0	338.11	338.0	338.04	3957.0
2020-02-20 06:35:00	SPY	ETF	338.05	338.08	338.01	338.04	2000.0
2020-02-20 06:40:00	SPY	ETF	338.04	338.06	338.01	338.01	2190.0
2020-02-20 06:45:00	SPY	ETF	337.93	337.93	337.79	337.84	10974.0
2020-02-20 06:50:00	SPY	ETF	337.84	337.84	337.68	337.68	23258.0
2020-02-20 06:55:00	SPY	ETF	337.69	337.7	337.61	337.61	4001.0
2020-02-20 07:00:00	SPY	ETF	337.66	337.82	337.61	337.82	22141.0
2020-02-20 07:05:00	SPY	ETF	337.82	337.95	337.8	337.95	11341.0
2020-02-20 07:10:00	SPY	ETF	337.92	337.92	337.88	337.9	2297.0
2020-02-20 07:15:00	SPY	ETF	337.9	337.9	337.85	337.9	2647.0
2020-02-20 07:20:00	SPY	ETF	337.82	337.87	337.75	337.75	2115.0
2020-02-20 07:25:00	SPY	ETF	337.84	337.84	337.78	337.81	9287.0
2020-02-20 07:30:00	SPY	ETF	337.78	337.8	337.72	337.8	4766.0
2020-02-20 07:35:00	SPY	ETF	337.76	337.79	337.76	337.79	1600.0
2020-02-20 07:40:00	SPY	ETF	337.81	337.81	337.7	337.7	2299.0
2020-02-20 07:45:00	SPY	ETF	337.7	337.82	337.7	337.82	51991.0
2020-02-20 07:50:00	SPY	ETF	337.78	337.8	337.7	337.7	11801.0
2020-02-20 07:55:00	SPY	ETF	337.71	337.86	337.71	337.85	20292.0
2020-02-20 08:00:00	SPY	ETF	337.94	338.8	337.61	337.87	60198.0
2020-02-20 08:05:00	SPY	ETF	337.9	337.94	337.9	337.93	12875.0
2020-02-20 08:10:00	SPY	ETF	337.9	337.99	337.9	337.93	9529.0
2020-02-20 08:15:00	SPY	ETF	337.9399	337.99	337.9399	337.97	3415.0
2020-02-20 08:20:00	SPY	ETF	337.99	337.99	337.85	337.87	20288.0
2020-02-20 08:25:00	SPY	ETF	337.89	337.9	337.74	337.74	21034.0
2020-02-20 08:30:00	SPY	ETF	337.75	338.03	337.75	337.83	41846.0

> showing 50 of 68,463 rows — these rows as CSV

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