PREVIEW / etf_5min / 2021-03-24

all etf 5-min files

  file:    by_date/etf_5min/2021/2021-03-24.parquet
  size:    1.8 MB
  rows:    86,799

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-03-24 04:00:00	SPY	ETF	389.5	389.5	389.25	389.3	3300.0
2021-03-24 04:05:00	SPY	ETF	389.59	389.59	389.59	389.59	120.0
2021-03-24 04:10:00	SPY	ETF	389.58	389.61	389.58	389.59	3400.0
2021-03-24 04:15:00	SPY	ETF	390.17	390.3	390.14	390.26	5300.0
2021-03-24 04:20:00	SPY	ETF	390.25	390.25	390.14	390.21	1647.0
2021-03-24 04:25:00	SPY	ETF	390.4	390.4	390.4	390.4	100.0
2021-03-24 04:30:00	SPY	ETF	390.41	390.71	390.41	390.64	14052.0
2021-03-24 04:35:00	SPY	ETF	390.62	390.62	390.34	390.34	2600.0
2021-03-24 04:40:00	SPY	ETF	390.31	390.31	390.29	390.31	400.0
2021-03-24 04:45:00	SPY	ETF	390.48	390.73	390.48	390.7	2800.0
2021-03-24 04:50:00	SPY	ETF	390.87	390.87	390.65	390.65	200.0
2021-03-24 04:55:00	SPY	ETF	390.87	391.08	390.86	390.88	1340.0
2021-03-24 05:00:00	SPY	ETF	390.88	390.97	390.88	390.97	2300.0
2021-03-24 05:05:00	SPY	ETF	390.85	391.01	390.85	391.01	9080.0
2021-03-24 05:10:00	SPY	ETF	391.08	391.24	391.08	391.16	2450.0
2021-03-24 05:15:00	SPY	ETF	391.06	391.06	390.94	390.96	2300.0
2021-03-24 05:20:00	SPY	ETF	391.08	391.08	390.92	390.94	3500.0
2021-03-24 05:25:00	SPY	ETF	391.04	391.04	390.98	390.98	1050.0
2021-03-24 05:30:00	SPY	ETF	390.9	390.94	390.9	390.91	1200.0
2021-03-24 05:35:00	SPY	ETF	390.78	390.78	390.78	390.78	100.0
2021-03-24 05:40:00	SPY	ETF	390.85	390.86	390.82	390.82	800.0
2021-03-24 05:55:00	SPY	ETF	390.94	390.97	390.94	390.97	600.0
2021-03-24 06:00:00	SPY	ETF	391.02	391.02	391.02	391.02	100.0
2021-03-24 06:05:00	SPY	ETF	391.01	391.01	390.8	390.8	699.0
2021-03-24 06:10:00	SPY	ETF	390.92	390.92	390.88	390.89	1700.0
2021-03-24 06:15:00	SPY	ETF	390.86	390.9	390.85	390.86	86300.0
2021-03-24 06:20:00	SPY	ETF	391.0	391.05	391.0	391.05	594.0
2021-03-24 06:25:00	SPY	ETF	390.95	390.95	390.8	390.95	5894.0
2021-03-24 06:30:00	SPY	ETF	390.97	391.07	390.9	391.07	16100.0
2021-03-24 06:35:00	SPY	ETF	390.98	390.98	390.85	390.9	3789.0
2021-03-24 06:40:00	SPY	ETF	390.88	390.88	390.75	390.75	500.0
2021-03-24 06:45:00	SPY	ETF	390.7	390.7	390.55	390.55	16090.0
2021-03-24 06:50:00	SPY	ETF	390.57	390.65	390.55	390.65	53931.0
2021-03-24 06:55:00	SPY	ETF	390.71	390.8	390.66	390.79	81290.0
2021-03-24 07:00:00	SPY	ETF	390.82	390.9	390.8	390.87	10460.0
2021-03-24 07:05:00	SPY	ETF	390.95	391.26	390.93	391.19	43665.0
2021-03-24 07:10:00	SPY	ETF	391.22	391.31	391.14	391.31	38893.0
2021-03-24 07:15:00	SPY	ETF	391.34	391.46	391.29	391.33	45620.0
2021-03-24 07:20:00	SPY	ETF	391.32	391.37	391.21	391.37	7846.0
2021-03-24 07:25:00	SPY	ETF	391.38	391.4	391.0	391.2	29168.0
2021-03-24 07:30:00	SPY	ETF	391.22	391.25	391.13	391.13	8049.0
2021-03-24 07:35:00	SPY	ETF	391.11	391.11	390.97	390.97	29041.0
2021-03-24 07:40:00	SPY	ETF	390.97	391.0	390.8	390.81	7375.0
2021-03-24 07:45:00	SPY	ETF	390.79	390.81	390.68	390.72	8188.0
2021-03-24 07:50:00	SPY	ETF	390.68	390.8	390.67	390.7	27656.0
2021-03-24 07:55:00	SPY	ETF	390.69	390.75	390.66	390.75	4521.0
2021-03-24 08:00:00	SPY	ETF	390.77	391.44	390.62	391.07	40209.0
2021-03-24 08:05:00	SPY	ETF	391.08	391.39	391.08	391.39	22893.0
2021-03-24 08:10:00	SPY	ETF	391.39	391.45	391.31	391.31	33044.0
2021-03-24 08:15:00	SPY	ETF	391.31	391.35	391.21	391.3	99708.0

> showing 50 of 86,799 rows — these rows as CSV

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