PREVIEW / etf_5min / 2020-08-07

all etf 5-min files

  file:    by_date/etf_5min/2020/2020-08-07.parquet
  size:    1.6 MB
  rows:    74,180

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-08-07 04:00:00	SPY	ETF	334.02	334.02	333.9	333.9	1903.0
2020-08-07 04:05:00	SPY	ETF	333.82	333.82	333.61	333.61	4221.0
2020-08-07 04:10:00	SPY	ETF	333.55	333.6	333.55	333.6	3305.0
2020-08-07 04:15:00	SPY	ETF	333.63	333.63	333.63	333.63	1055.0
2020-08-07 04:20:00	SPY	ETF	333.5	333.5	333.42	333.42	300.0
2020-08-07 04:25:00	SPY	ETF	333.3	333.33	333.3	333.3	2325.0
2020-08-07 04:30:00	SPY	ETF	333.25	333.4	333.2	333.22	2604.0
2020-08-07 04:35:00	SPY	ETF	333.25	333.25	333.12	333.15	2550.0
2020-08-07 04:40:00	SPY	ETF	333.1	333.1	333.05	333.05	4610.0
2020-08-07 04:45:00	SPY	ETF	333.15	333.15	333.1	333.1	762.0
2020-08-07 04:50:00	SPY	ETF	333.25	333.25	333.25	333.25	315.0
2020-08-07 04:55:00	SPY	ETF	333.26	333.28	333.26	333.26	309.0
2020-08-07 05:00:00	SPY	ETF	333.22	333.22	332.93	332.93	2605.0
2020-08-07 05:05:00	SPY	ETF	332.88	332.91	332.73	332.91	5743.0
2020-08-07 05:10:00	SPY	ETF	332.81	332.85	332.63	332.65	1328.0
2020-08-07 05:15:00	SPY	ETF	332.46	332.75	332.46	332.75	2256.0
2020-08-07 05:20:00	SPY	ETF	332.82	332.82	332.75	332.75	408.0
2020-08-07 05:25:00	SPY	ETF	332.55	332.65	332.55	332.65	1078.0
2020-08-07 05:30:00	SPY	ETF	332.51	332.72	332.51	332.65	610.0
2020-08-07 05:35:00	SPY	ETF	332.55	332.75	332.54	332.75	1620.0
2020-08-07 05:40:00	SPY	ETF	332.73	332.78	332.66	332.75	1406.0
2020-08-07 05:45:00	SPY	ETF	332.74	332.85	332.74	332.85	2054.0
2020-08-07 05:50:00	SPY	ETF	332.8	332.8	332.8	332.8	100.0
2020-08-07 05:55:00	SPY	ETF	332.87	332.87	332.87	332.87	500.0
2020-08-07 06:00:00	SPY	ETF	332.73	332.83	332.72	332.83	4617.0
2020-08-07 06:05:00	SPY	ETF	332.8	332.86	332.63	332.65	1731.0
2020-08-07 06:10:00	SPY	ETF	332.58	332.6	332.58	332.6	650.0
2020-08-07 06:15:00	SPY	ETF	332.75	332.75	332.75	332.75	100.0
2020-08-07 06:20:00	SPY	ETF	332.7	332.9	332.7	332.9	937.0
2020-08-07 06:25:00	SPY	ETF	332.9	332.9	332.85	332.85	10646.0
2020-08-07 06:30:00	SPY	ETF	332.85	332.85	332.76	332.8	25757.0
2020-08-07 06:35:00	SPY	ETF	332.8	332.89	332.8	332.85	17677.0
2020-08-07 06:40:00	SPY	ETF	332.85	332.96	332.85	332.93	49080.0
2020-08-07 06:45:00	SPY	ETF	332.95	333.12	332.95	333.12	1220.0
2020-08-07 06:50:00	SPY	ETF	333.05	333.12	333.01	333.12	3691.0
2020-08-07 06:55:00	SPY	ETF	333.12	333.19	333.07	333.15	19095.0
2020-08-07 07:00:00	SPY	ETF	333.26	333.36	333.21	333.21	22737.0
2020-08-07 07:05:00	SPY	ETF	333.24	333.24	333.18	333.18	9071.0
2020-08-07 07:10:00	SPY	ETF	333.19	333.36	333.19	333.35	31179.0
2020-08-07 07:15:00	SPY	ETF	333.35	333.35	333.22	333.22	9181.0
2020-08-07 07:20:00	SPY	ETF	333.25	333.3	333.07	333.2	32000.0
2020-08-07 07:25:00	SPY	ETF	333.29	333.34	333.23	333.34	4331.0
2020-08-07 07:30:00	SPY	ETF	333.3	333.36	333.22	333.22	7452.0
2020-08-07 07:35:00	SPY	ETF	333.23	333.28	333.1	333.1	11811.0
2020-08-07 07:40:00	SPY	ETF	333.11	333.17	333.1	333.15	20809.0
2020-08-07 07:45:00	SPY	ETF	333.14	333.2	333.08	333.2	37218.0
2020-08-07 07:50:00	SPY	ETF	333.18	333.18	333.06	333.07	4306.0
2020-08-07 07:55:00	SPY	ETF	333.08	333.1	333.07	333.1	1855.0
2020-08-07 08:00:00	SPY	ETF	333.3501	333.6	332.7	332.92	90149.0
2020-08-07 08:05:00	SPY	ETF	332.9	332.95	332.85	332.85	15836.0

> showing 50 of 74,180 rows — these rows as CSV

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