PREVIEW / etf_5min / 2021-08-20

all etf 5-min files

  file:    by_date/etf_5min/2021/2021-08-20.parquet
  size:    1.7 MB
  rows:    77,827

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-08-20 04:00:00	SPY	ETF	437.57	438.02	437.5	438.02	6934.0
2021-08-20 04:05:00	SPY	ETF	437.98	438.07	437.9	437.9	1250.0
2021-08-20 04:10:00	SPY	ETF	437.78	437.81	437.65	437.65	4190.0
2021-08-20 04:15:00	SPY	ETF	437.71	437.82	437.71	437.78	4900.0
2021-08-20 04:20:00	SPY	ETF	437.71	437.71	437.15	437.16	4248.0
2021-08-20 04:25:00	SPY	ETF	437.16	437.52	437.15	437.52	1528.0
2021-08-20 04:30:00	SPY	ETF	437.4	437.4	437.36	437.36	696.0
2021-08-20 04:35:00	SPY	ETF	437.49	437.6	437.45	437.55	1010.0
2021-08-20 04:40:00	SPY	ETF	437.55	437.9	437.55	437.76	2550.0
2021-08-20 04:45:00	SPY	ETF	437.83	437.84	437.8	437.84	500.0
2021-08-20 04:50:00	SPY	ETF	437.92	437.98	437.92	437.95	1220.0
2021-08-20 04:55:00	SPY	ETF	437.91	437.96	437.91	437.96	400.0
2021-08-20 05:00:00	SPY	ETF	437.73	437.81	437.73	437.81	1000.0
2021-08-20 05:05:00	SPY	ETF	437.93	437.93	437.93	437.93	200.0
2021-08-20 05:15:00	SPY	ETF	437.63	437.63	437.63	437.63	100.0
2021-08-20 05:20:00	SPY	ETF	437.81	437.81	437.81	437.81	700.0
2021-08-20 05:25:00	SPY	ETF	438.19	438.2	438.16	438.19	14400.0
2021-08-20 05:35:00	SPY	ETF	438.3	438.51	438.3	438.51	2030.0
2021-08-20 05:40:00	SPY	ETF	438.56	438.65	438.56	438.65	13350.0
2021-08-20 05:45:00	SPY	ETF	438.56	438.61	438.56	438.6	700.0
2021-08-20 05:50:00	SPY	ETF	438.52	438.52	438.18	438.18	800.0
2021-08-20 05:55:00	SPY	ETF	438.07	438.08	437.99	438.08	1479.0
2021-08-20 06:00:00	SPY	ETF	438.08	438.09	437.99	438.06	2700.0
2021-08-20 06:05:00	SPY	ETF	437.99	438.05	437.98	438.05	1900.0
2021-08-20 06:10:00	SPY	ETF	438.05	438.05	437.84	437.84	400.0
2021-08-20 06:15:00	SPY	ETF	438.11	438.21	438.11	438.21	1500.0
2021-08-20 06:20:00	SPY	ETF	438.35	438.35	438.11	438.11	600.0
2021-08-20 06:25:00	SPY	ETF	438.19	438.24	438.18	438.2	5700.0
2021-08-20 06:30:00	SPY	ETF	438.23	438.26	438.19	438.22	6700.0
2021-08-20 06:35:00	SPY	ETF	438.07	438.07	438.04	438.04	500.0
2021-08-20 06:40:00	SPY	ETF	438.09	438.14	438.07	438.13	36400.0
2021-08-20 06:45:00	SPY	ETF	438.27	438.28	438.26	438.28	850.0
2021-08-20 06:50:00	SPY	ETF	438.26	438.3	438.25	438.3	42792.0
2021-08-20 06:55:00	SPY	ETF	438.11	438.17	438.08	438.08	1700.0
2021-08-20 07:00:00	SPY	ETF	438.08	438.12	437.85	437.86	30356.0
2021-08-20 07:05:00	SPY	ETF	437.9	437.96	437.58	437.64	10937.0
2021-08-20 07:10:00	SPY	ETF	437.63	437.89	437.63	437.67	9056.0
2021-08-20 07:15:00	SPY	ETF	437.66	437.75	437.6	437.71	14530.0
2021-08-20 07:20:00	SPY	ETF	437.7	438.0	437.68	437.99	14550.0
2021-08-20 07:25:00	SPY	ETF	437.97	438.33	437.97	438.26	36650.0
2021-08-20 07:30:00	SPY	ETF	438.29	438.35	438.25	438.25	77710.0
2021-08-20 07:35:00	SPY	ETF	438.23	438.31	438.21	438.22	5105.0
2021-08-20 07:40:00	SPY	ETF	438.35	438.57	438.35	438.37	71365.0
2021-08-20 07:45:00	SPY	ETF	438.4	438.4	438.25	438.33	3410.0
2021-08-20 07:50:00	SPY	ETF	438.31	438.33	438.09	438.09	25927.0
2021-08-20 07:55:00	SPY	ETF	438.08	438.15	437.96	437.96	17697.0
2021-08-20 08:00:00	SPY	ETF	438.0101	440.239	437.0	438.25	60399.0
2021-08-20 08:05:00	SPY	ETF	438.24	438.27	437.88	438.12	13535.0
2021-08-20 08:10:00	SPY	ETF	438.1	438.22	438.06	438.1	14812.0
2021-08-20 08:15:00	SPY	ETF	438.1	438.22	438.1	438.18	10850.0

> showing 50 of 77,827 rows — these rows as CSV

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