PREVIEW / etf_5min / 2020-06-24

all etf 5-min files

  file:    by_date/etf_5min/2020/2020-06-24.parquet
  size:    1.7 MB
  rows:    79,078

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-06-24 04:00:00	SPY	ETF	310.71	310.81	310.44	310.7	16375.0
2020-06-24 04:05:00	SPY	ETF	310.6	310.72	309.6	309.6	17119.0
2020-06-24 04:10:00	SPY	ETF	309.73	309.76	309.27	309.27	21761.0
2020-06-24 04:15:00	SPY	ETF	309.2	309.39	308.74	309.19	32846.0
2020-06-24 04:20:00	SPY	ETF	309.07	309.39	308.82	309.36	9448.0
2020-06-24 04:25:00	SPY	ETF	309.42	309.47	309.31	309.38	4599.0
2020-06-24 04:30:00	SPY	ETF	309.43	309.5	309.29	309.5	2362.0
2020-06-24 04:35:00	SPY	ETF	309.48	309.58	309.48	309.57	706.0
2020-06-24 04:40:00	SPY	ETF	309.46	309.53	309.42	309.42	8821.0
2020-06-24 04:45:00	SPY	ETF	309.57	309.73	309.57	309.68	4310.0
2020-06-24 04:50:00	SPY	ETF	309.73	309.94	309.73	309.78	8022.0
2020-06-24 04:55:00	SPY	ETF	309.75	309.83	309.75	309.81	1910.0
2020-06-24 05:00:00	SPY	ETF	309.84	310.13	309.84	309.95	2488.0
2020-06-24 05:05:00	SPY	ETF	309.83	309.85	309.55	309.55	37920.0
2020-06-24 05:10:00	SPY	ETF	309.54	309.54	308.41	308.71	30218.0
2020-06-24 05:15:00	SPY	ETF	308.6	308.85	308.18	308.23	28708.0
2020-06-24 05:20:00	SPY	ETF	308.2	308.74	308.2	308.68	21181.0
2020-06-24 05:25:00	SPY	ETF	308.79	308.79	308.7	308.75	2432.0
2020-06-24 05:30:00	SPY	ETF	308.73	309.06	308.59	309.06	4114.0
2020-06-24 05:35:00	SPY	ETF	309.12	309.15	308.8	308.87	4168.0
2020-06-24 05:40:00	SPY	ETF	308.86	308.91	308.78	308.9	9163.0
2020-06-24 05:45:00	SPY	ETF	308.88	309.03	308.8	309.0	4581.0
2020-06-24 05:50:00	SPY	ETF	308.95	309.08	308.95	308.95	2685.0
2020-06-24 05:55:00	SPY	ETF	308.93	309.1	308.87	308.98	3829.0
2020-06-24 06:00:00	SPY	ETF	309.05	309.23	308.97	309.12	3015.0
2020-06-24 06:05:00	SPY	ETF	309.02	309.34	309.02	309.34	13713.0
2020-06-24 06:10:00	SPY	ETF	309.35	309.35	308.83	308.91	16734.0
2020-06-24 06:15:00	SPY	ETF	309.05	309.33	308.76	309.33	6141.0
2020-06-24 06:20:00	SPY	ETF	309.36	309.42	309.16	309.16	15864.0
2020-06-24 06:25:00	SPY	ETF	309.08	309.16	309.02	309.02	1645.0
2020-06-24 06:30:00	SPY	ETF	309.15	309.28	309.1	309.28	875.0
2020-06-24 06:35:00	SPY	ETF	309.21	309.35	309.21	309.35	3974.0
2020-06-24 06:40:00	SPY	ETF	309.29	309.44	309.29	309.43	2990.0
2020-06-24 06:45:00	SPY	ETF	309.42	309.56	309.41	309.53	18053.0
2020-06-24 06:50:00	SPY	ETF	309.48	309.61	309.38	309.48	5826.0
2020-06-24 06:55:00	SPY	ETF	309.58	309.58	309.48	309.5	1865.0
2020-06-24 07:00:00	SPY	ETF	309.6	309.73	309.55	309.661	19184.0
2020-06-24 07:05:00	SPY	ETF	309.71	309.86	309.6	309.83	8442.0
2020-06-24 07:10:00	SPY	ETF	309.83	309.95	309.78	309.78	18336.0
2020-06-24 07:15:00	SPY	ETF	309.79	309.91	309.79	309.9	17045.0
2020-06-24 07:20:00	SPY	ETF	310.0	310.01	309.83	309.83	15961.0
2020-06-24 07:25:00	SPY	ETF	309.78	309.78	309.59	309.65	7468.0
2020-06-24 07:30:00	SPY	ETF	309.71	309.71	309.38	309.38	44618.0
2020-06-24 07:35:00	SPY	ETF	309.45	309.55	309.4	309.48	20191.0
2020-06-24 07:40:00	SPY	ETF	309.49	309.57	309.46	309.52	5292.0
2020-06-24 07:45:00	SPY	ETF	309.55	309.69	309.5	309.69	6391.0
2020-06-24 07:50:00	SPY	ETF	309.71	309.91	309.71	309.81	8740.0
2020-06-24 07:55:00	SPY	ETF	309.81	309.85	309.65	309.7	10479.0
2020-06-24 08:00:00	SPY	ETF	309.65	312.5	309.0204	309.38	70214.0
2020-06-24 08:05:00	SPY	ETF	309.73	309.73	309.54	309.6	13273.0

> showing 50 of 79,078 rows — these rows as CSV

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