PREVIEW / etf_5min / 2021-04-09

all etf 5-min files

  file:    by_date/etf_5min/2021/2021-04-09.parquet
  size:    1.7 MB
  rows:    80,959

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
2021-04-09 04:00:00	SPY	ETF	409.12	409.13	408.99	408.99	6458.0
2021-04-09 04:05:00	SPY	ETF	408.94	408.95	408.82	408.82	4847.0
2021-04-09 04:10:00	SPY	ETF	408.8	408.8	408.57	408.65	500.0
2021-04-09 04:15:00	SPY	ETF	408.6	408.7	408.6	408.65	1499.0
2021-04-09 04:20:00	SPY	ETF	408.71	408.71	408.67	408.67	400.0
2021-04-09 04:25:00	SPY	ETF	408.62	408.62	408.56	408.59	700.0
2021-04-09 04:30:00	SPY	ETF	408.62	408.62	408.62	408.62	900.0
2021-04-09 04:35:00	SPY	ETF	408.63	408.76	408.63	408.76	300.0
2021-04-09 04:40:00	SPY	ETF	408.69	408.83	408.69	408.83	700.0
2021-04-09 04:45:00	SPY	ETF	408.83	408.83	408.83	408.83	300.0
2021-04-09 04:50:00	SPY	ETF	408.85	408.85	408.78	408.79	900.0
2021-04-09 04:55:00	SPY	ETF	409.03	409.03	409.03	409.03	385.0
2021-04-09 05:00:00	SPY	ETF	408.95	408.95	408.83	408.83	300.0
2021-04-09 05:05:00	SPY	ETF	408.8	408.8	408.74	408.74	400.0
2021-04-09 05:10:00	SPY	ETF	408.71	408.88	408.71	408.88	500.0
2021-04-09 05:15:00	SPY	ETF	408.8	408.8	408.78	408.78	1600.0
2021-04-09 05:25:00	SPY	ETF	408.9	408.9	408.85	408.85	557.0
2021-04-09 05:30:00	SPY	ETF	408.9	408.91	408.9	408.91	823.0
2021-04-09 05:35:00	SPY	ETF	408.91	408.91	408.8	408.83	1600.0
2021-04-09 05:40:00	SPY	ETF	408.79	408.86	408.78	408.86	1794.0
2021-04-09 05:45:00	SPY	ETF	408.86	408.88	408.86	408.88	800.0
2021-04-09 05:50:00	SPY	ETF	408.77	408.77	408.7	408.7	540.0
2021-04-09 05:55:00	SPY	ETF	408.92	408.96	408.92	408.96	600.0
2021-04-09 06:00:00	SPY	ETF	408.89	408.89	408.88	408.88	200.0
2021-04-09 06:05:00	SPY	ETF	408.92	409.0	408.92	408.96	1200.0
2021-04-09 06:10:00	SPY	ETF	408.96	408.96	408.79	408.79	1981.0
2021-04-09 06:15:00	SPY	ETF	408.69	408.8	408.69	408.8	2100.0
2021-04-09 06:20:00	SPY	ETF	408.79	408.79	408.63	408.63	2776.0
2021-04-09 06:25:00	SPY	ETF	408.61	408.64	408.59	408.64	620.0
2021-04-09 06:30:00	SPY	ETF	408.68	408.68	408.64	408.64	1100.0
2021-04-09 06:35:00	SPY	ETF	408.75	408.86	408.75	408.86	300.0
2021-04-09 06:40:00	SPY	ETF	408.96	408.96	408.92	408.92	300.0
2021-04-09 06:45:00	SPY	ETF	408.94	408.94	408.82	408.82	6200.0
2021-04-09 06:50:00	SPY	ETF	408.87	408.93	408.87	408.93	1000.0
2021-04-09 06:55:00	SPY	ETF	408.9	408.9	408.78	408.78	1000.0
2021-04-09 07:00:00	SPY	ETF	408.75	409.0	408.75	409.0	8161.0
2021-04-09 07:05:00	SPY	ETF	409.0	409.06	408.98	409.05	3697.0
2021-04-09 07:10:00	SPY	ETF	409.07	409.07	409.01	409.03	5826.0
2021-04-09 07:15:00	SPY	ETF	409.07	409.07	409.04	409.07	1692.0
2021-04-09 07:20:00	SPY	ETF	409.09	409.41	409.09	409.4	27125.0
2021-04-09 07:25:00	SPY	ETF	409.37	409.42	409.3	409.34	58450.0
2021-04-09 07:30:00	SPY	ETF	409.26	409.29	409.22	409.29	3750.0
2021-04-09 07:35:00	SPY	ETF	409.29	409.32	409.24	409.28	5143.0
2021-04-09 07:40:00	SPY	ETF	409.26	409.27	409.13	409.13	4160.0
2021-04-09 07:45:00	SPY	ETF	409.15	409.15	409.03	409.05	6962.0
2021-04-09 07:50:00	SPY	ETF	409.07	409.26	409.06	409.25	5970.0
2021-04-09 07:55:00	SPY	ETF	409.24	409.24	409.09	409.09	2674.0
2021-04-09 08:00:00	SPY	ETF	408.9701	409.4299	408.5	409.09	43282.0
2021-04-09 08:05:00	SPY	ETF	409.09	409.09	408.84	408.84	7364.0
2021-04-09 08:10:00	SPY	ETF	408.8	408.85	408.7	408.7	17364.0

> showing 50 of 80,959 rows — these rows as CSV

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