PREVIEW / etf_5min / 2021-07-20

all etf 5-min files

  file:    by_date/etf_5min/2021/2021-07-20.parquet
  size:    1.8 MB
  rows:    83,687

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-07-20 04:00:00	SPY	ETF	426.74	427.0	426.73	426.97	23280.0
2021-07-20 04:05:00	SPY	ETF	426.99	427.04	426.72	426.73	16249.0
2021-07-20 04:10:00	SPY	ETF	426.73	427.12	426.54	427.12	17400.0
2021-07-20 04:15:00	SPY	ETF	427.17	427.18	427.08	427.17	6214.0
2021-07-20 04:20:00	SPY	ETF	427.06	427.1	427.06	427.07	3550.0
2021-07-20 04:25:00	SPY	ETF	427.01	427.22	427.01	427.22	3100.0
2021-07-20 04:30:00	SPY	ETF	427.37	427.37	427.32	427.34	2780.0
2021-07-20 04:35:00	SPY	ETF	427.19	427.25	427.15	427.25	1449.0
2021-07-20 04:40:00	SPY	ETF	427.22	427.22	427.18	427.18	254.0
2021-07-20 04:45:00	SPY	ETF	427.0	427.0	426.71	426.71	805.0
2021-07-20 04:50:00	SPY	ETF	426.7	426.8	426.68	426.78	3621.0
2021-07-20 04:55:00	SPY	ETF	426.81	426.86	426.81	426.86	1300.0
2021-07-20 05:00:00	SPY	ETF	426.92	427.06	426.65	426.65	3600.0
2021-07-20 05:05:00	SPY	ETF	426.57	426.84	426.54	426.84	1300.0
2021-07-20 05:10:00	SPY	ETF	426.84	426.98	426.84	426.98	800.0
2021-07-20 05:15:00	SPY	ETF	426.95	427.05	426.95	427.05	400.0
2021-07-20 05:20:00	SPY	ETF	426.85	426.85	426.85	426.85	500.0
2021-07-20 05:25:00	SPY	ETF	426.79	426.79	426.79	426.79	300.0
2021-07-20 05:30:00	SPY	ETF	426.78	426.78	426.78	426.78	600.0
2021-07-20 05:35:00	SPY	ETF	426.85	426.88	426.5	426.5	1800.0
2021-07-20 05:40:00	SPY	ETF	426.57	426.57	426.5	426.51	900.0
2021-07-20 05:45:00	SPY	ETF	426.5	426.5	426.24	426.24	1560.0
2021-07-20 05:50:00	SPY	ETF	426.06	426.07	425.91	425.91	2187.0
2021-07-20 05:55:00	SPY	ETF	425.98	426.15	425.98	426.14	3000.0
2021-07-20 06:00:00	SPY	ETF	425.96	426.0	425.96	426.0	3000.0
2021-07-20 06:05:00	SPY	ETF	425.97	426.5	425.96	426.5	3334.0
2021-07-20 06:10:00	SPY	ETF	426.51	427.03	426.47	426.87	10643.0
2021-07-20 06:15:00	SPY	ETF	426.99	426.99	426.85	426.85	600.0
2021-07-20 06:20:00	SPY	ETF	427.01	427.01	426.7	426.7	2509.0
2021-07-20 06:25:00	SPY	ETF	426.67	426.84	426.5	426.81	6600.0
2021-07-20 06:30:00	SPY	ETF	426.9	426.95	426.73	426.9	3800.0
2021-07-20 06:35:00	SPY	ETF	426.9	426.9	426.79	426.86	1674.0
2021-07-20 06:40:00	SPY	ETF	426.78	426.78	426.67	426.7	800.0
2021-07-20 06:45:00	SPY	ETF	426.6	426.6	426.22	426.25	4680.0
2021-07-20 06:50:00	SPY	ETF	426.31	426.5	426.25	426.48	4100.0
2021-07-20 06:55:00	SPY	ETF	426.49	426.77	426.42	426.77	5100.0
2021-07-20 07:00:00	SPY	ETF	426.7	426.7	426.33	426.66	4290.0
2021-07-20 07:05:00	SPY	ETF	426.7	426.83	426.55	426.69	31140.0
2021-07-20 07:10:00	SPY	ETF	426.69	426.69	426.25	426.38	15322.0
2021-07-20 07:15:00	SPY	ETF	426.45	426.82	426.45	426.65	18259.0
2021-07-20 07:20:00	SPY	ETF	426.6	426.9	426.59	426.78	12992.0
2021-07-20 07:25:00	SPY	ETF	426.7	426.84	426.59	426.83	55171.0
2021-07-20 07:30:00	SPY	ETF	426.83	427.04	426.82	426.95	57716.0
2021-07-20 07:35:00	SPY	ETF	426.99	427.15	426.94	427.14	16078.0
2021-07-20 07:40:00	SPY	ETF	427.11	427.11	426.94	426.97	21203.0
2021-07-20 07:45:00	SPY	ETF	426.95	426.95	426.67	426.68	62447.0
2021-07-20 07:50:00	SPY	ETF	426.74	426.95	426.69	426.9	19715.0
2021-07-20 07:55:00	SPY	ETF	426.93	427.04	426.89	426.95	25142.0
2021-07-20 08:00:00	SPY	ETF	426.3801	427.2	425.4	427.18	59159.0
2021-07-20 08:05:00	SPY	ETF	427.1	427.1	426.95	426.95	18074.0

> showing 50 of 83,687 rows — these rows as CSV

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