PREVIEW / etf_5min / 2021-02-24

all etf 5-min files

  file:    by_date/etf_5min/2021/2021-02-24.parquet
  size:    1.9 MB
  rows:    90,842

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-02-24 04:00:00	SPY	ETF	387.46	387.68	387.45	387.5	8414.0
2021-02-24 04:05:00	SPY	ETF	387.46	387.46	387.24	387.24	2500.0
2021-02-24 04:10:00	SPY	ETF	387.2	387.29	387.14	387.14	2201.0
2021-02-24 04:15:00	SPY	ETF	387.43	387.71	387.43	387.71	4232.0
2021-02-24 04:20:00	SPY	ETF	387.76	388.1	387.75	387.96	9975.0
2021-02-24 04:25:00	SPY	ETF	388.06	388.11	388.0	388.11	3000.0
2021-02-24 04:30:00	SPY	ETF	388.14	388.16	388.01	388.01	1100.0
2021-02-24 04:35:00	SPY	ETF	387.99	387.99	387.84	387.86	930.0
2021-02-24 04:40:00	SPY	ETF	387.94	388.01	387.94	387.94	760.0
2021-02-24 04:45:00	SPY	ETF	387.96	387.99	387.91	387.99	310.0
2021-02-24 04:50:00	SPY	ETF	388.14	388.22	388.14	388.22	1225.0
2021-02-24 04:55:00	SPY	ETF	388.04	388.12	388.04	388.12	850.0
2021-02-24 05:00:00	SPY	ETF	388.31	388.46	388.29	388.41	4649.0
2021-02-24 05:05:00	SPY	ETF	388.11	388.2	388.11	388.19	2450.0
2021-02-24 05:10:00	SPY	ETF	388.21	388.29	388.12	388.12	1180.0
2021-02-24 05:15:00	SPY	ETF	388.11	388.24	388.11	388.24	1800.0
2021-02-24 05:20:00	SPY	ETF	388.01	388.01	387.87	387.87	1000.0
2021-02-24 05:25:00	SPY	ETF	387.99	388.1	387.99	388.1	2100.0
2021-02-24 05:30:00	SPY	ETF	388.12	388.29	388.12	388.29	300.0
2021-02-24 05:35:00	SPY	ETF	388.31	388.39	388.19	388.24	10100.0
2021-02-24 05:40:00	SPY	ETF	388.26	388.26	388.17	388.19	1300.0
2021-02-24 05:45:00	SPY	ETF	388.22	388.22	388.06	388.06	10200.0
2021-02-24 05:50:00	SPY	ETF	388.22	388.22	388.19	388.19	1304.0
2021-02-24 05:55:00	SPY	ETF	388.14	388.14	387.99	387.99	10048.0
2021-02-24 06:00:00	SPY	ETF	388.0	388.17	388.0	388.07	5275.0
2021-02-24 06:10:00	SPY	ETF	387.92	387.96	387.92	387.92	5000.0
2021-02-24 06:15:00	SPY	ETF	388.0	388.21	387.8	387.8	8034.0
2021-02-24 06:20:00	SPY	ETF	387.87	388.35	387.87	388.05	16934.0
2021-02-24 06:25:00	SPY	ETF	388.17	388.17	387.95	388.1	3300.0
2021-02-24 06:30:00	SPY	ETF	388.05	388.05	387.95	387.95	1200.0
2021-02-24 06:35:00	SPY	ETF	387.6	387.66	387.56	387.57	27536.0
2021-02-24 06:40:00	SPY	ETF	387.57	387.62	387.57	387.62	1103.0
2021-02-24 06:45:00	SPY	ETF	387.64	387.8	387.61	387.78	2900.0
2021-02-24 06:50:00	SPY	ETF	387.73	387.85	387.72	387.83	7499.0
2021-02-24 06:55:00	SPY	ETF	387.8	387.8	387.55	387.65	7999.0
2021-02-24 07:00:00	SPY	ETF	387.6	387.93	387.6	387.88	14312.0
2021-02-24 07:05:00	SPY	ETF	387.84	388.26	387.84	388.25	36418.0
2021-02-24 07:10:00	SPY	ETF	388.23	388.4	388.18	388.36	61893.0
2021-02-24 07:15:00	SPY	ETF	388.3	388.54	388.24	388.46	18970.0
2021-02-24 07:20:00	SPY	ETF	388.55	388.76	388.51	388.76	29970.0
2021-02-24 07:25:00	SPY	ETF	388.72	389.17	388.72	388.99	37661.0
2021-02-24 07:30:00	SPY	ETF	388.99	388.99	388.61	388.68	24126.0
2021-02-24 07:35:00	SPY	ETF	388.67	388.8	388.59	388.8	27645.0
2021-02-24 07:40:00	SPY	ETF	388.74	388.83	388.58	388.81	22810.0
2021-02-24 07:45:00	SPY	ETF	388.87	389.23	388.87	389.23	39412.0
2021-02-24 07:50:00	SPY	ETF	389.21	389.37	389.08	389.09	22855.0
2021-02-24 07:55:00	SPY	ETF	389.07	389.29	389.01	389.05	28864.0
2021-02-24 08:00:00	SPY	ETF	389.05	389.31	385.4	388.95	63290.0
2021-02-24 08:05:00	SPY	ETF	388.95	389.13	388.93	388.98	9484.0
2021-02-24 08:10:00	SPY	ETF	388.92	389.06	388.82	388.83	19079.0

> showing 50 of 90,842 rows — these rows as CSV

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