PREVIEW / etf_5min / 2021-05-20

all etf 5-min files

  file:    by_date/etf_5min/2021/2021-05-20.parquet
  size:    1.7 MB
  rows:    79,680

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-05-20 04:00:00	SPY	ETF	410.48	410.59	410.4	410.4	2037.0
2021-05-20 04:10:00	SPY	ETF	410.35	410.4	410.35	410.4	1200.0
2021-05-20 04:15:00	SPY	ETF	410.37	410.49	410.37	410.49	2099.0
2021-05-20 04:20:00	SPY	ETF	410.4	410.4	410.12	410.12	3500.0
2021-05-20 04:25:00	SPY	ETF	410.12	410.12	409.82	409.82	1100.0
2021-05-20 04:30:00	SPY	ETF	409.82	409.92	409.7	409.7	10895.0
2021-05-20 04:35:00	SPY	ETF	409.8	409.8	409.18	409.22	1200.0
2021-05-20 04:40:00	SPY	ETF	409.35	410.0	409.13	409.23	14646.0
2021-05-20 04:45:00	SPY	ETF	409.25	409.28	409.25	409.28	300.0
2021-05-20 04:50:00	SPY	ETF	409.13	409.13	408.9	409.03	1000.0
2021-05-20 05:00:00	SPY	ETF	408.93	408.93	408.93	408.93	646.0
2021-05-20 05:05:00	SPY	ETF	409.1	409.15	409.07	409.13	1350.0
2021-05-20 05:10:00	SPY	ETF	409.18	409.2	409.18	409.2	850.0
2021-05-20 05:15:00	SPY	ETF	409.01	409.01	409.01	409.01	200.0
2021-05-20 05:20:00	SPY	ETF	409.15	409.15	408.4	408.4	7600.0
2021-05-20 05:25:00	SPY	ETF	408.3	408.5	408.28	408.5	5100.0
2021-05-20 05:30:00	SPY	ETF	408.53	408.53	408.29	408.39	3500.0
2021-05-20 05:35:00	SPY	ETF	408.46	408.52	408.35	408.36	20700.0
2021-05-20 05:40:00	SPY	ETF	408.35	408.5	408.35	408.46	2900.0
2021-05-20 05:45:00	SPY	ETF	408.51	408.8	408.51	408.8	26574.0
2021-05-20 05:50:00	SPY	ETF	408.78	408.85	408.75	408.85	25700.0
2021-05-20 05:55:00	SPY	ETF	408.8	408.82	408.65	408.82	2458.0
2021-05-20 06:00:00	SPY	ETF	408.8	408.8	408.55	408.8	2000.0
2021-05-20 06:05:00	SPY	ETF	408.87	408.95	408.87	408.94	3110.0
2021-05-20 06:10:00	SPY	ETF	408.95	408.97	408.92	408.93	1400.0
2021-05-20 06:15:00	SPY	ETF	408.78	408.82	408.69	408.82	2300.0
2021-05-20 06:20:00	SPY	ETF	408.95	409.01	408.95	409.01	3117.0
2021-05-20 06:25:00	SPY	ETF	409.03	409.1	409.01	409.02	2249.0
2021-05-20 06:30:00	SPY	ETF	409.15	409.2	409.13	409.2	5575.0
2021-05-20 06:35:00	SPY	ETF	409.18	409.18	409.1	409.15	4203.0
2021-05-20 06:40:00	SPY	ETF	409.2	409.41	409.2	409.3	8545.0
2021-05-20 06:45:00	SPY	ETF	409.25	409.34	409.22	409.34	4200.0
2021-05-20 06:50:00	SPY	ETF	409.22	409.44	409.19	409.44	977.0
2021-05-20 06:55:00	SPY	ETF	409.4	409.47	409.4	409.47	9350.0
2021-05-20 07:00:00	SPY	ETF	409.48	409.82	409.44	409.76	21246.0
2021-05-20 07:05:00	SPY	ETF	409.7	409.7	409.5	409.55	6147.0
2021-05-20 07:10:00	SPY	ETF	409.53	409.6	409.46	409.53	5201.0
2021-05-20 07:15:00	SPY	ETF	409.63	410.28	409.63	410.28	37742.0
2021-05-20 07:20:00	SPY	ETF	410.23	410.23	410.09	410.12	32077.0
2021-05-20 07:25:00	SPY	ETF	410.11	410.28	410.09	410.14	18318.0
2021-05-20 07:30:00	SPY	ETF	410.05	410.18	410.03	410.15	8567.0
2021-05-20 07:35:00	SPY	ETF	410.2	410.31	410.13	410.15	10345.0
2021-05-20 07:40:00	SPY	ETF	410.1	410.31	410.1	410.24	13812.0
2021-05-20 07:45:00	SPY	ETF	410.29	410.29	410.16	410.16	3821.0
2021-05-20 07:50:00	SPY	ETF	410.2	410.2	410.13	410.19	8770.0
2021-05-20 07:55:00	SPY	ETF	410.17	410.23	410.17	410.18	2097.0
2021-05-20 08:00:00	SPY	ETF	409.61	411.1	408.7996	410.37	57778.0
2021-05-20 08:05:00	SPY	ETF	410.35	410.35	410.19	410.34	6100.0
2021-05-20 08:10:00	SPY	ETF	410.3	410.36	410.18	410.19	15801.0
2021-05-20 08:15:00	SPY	ETF	410.2	410.28	410.17	410.22	13716.0

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

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