PREVIEW / etf_5min / 2023-08-02

all etf 5-min files

  file:    by_date/etf_5min/2023/2023-08-02.parquet
  size:    2.1 MB
  rows:    104,358

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
2023-08-02 04:00:00	SPY	ETF	452.78	454.7	452.24	452.31	36016.0
2023-08-02 04:05:00	SPY	ETF	452.32	452.5	452.3	452.3	21195.0
2023-08-02 04:10:00	SPY	ETF	452.25	452.34	452.18	452.3	4788.0
2023-08-02 04:15:00	SPY	ETF	452.23	452.28	451.74	451.74	8696.0
2023-08-02 04:20:00	SPY	ETF	451.8	452.02	451.77	452.01	3046.0
2023-08-02 04:25:00	SPY	ETF	452.08	452.12	452.02	452.12	1747.0
2023-08-02 04:30:00	SPY	ETF	452.15	452.15	451.91	451.92	1841.0
2023-08-02 04:35:00	SPY	ETF	451.96	451.97	451.88	451.88	3962.0
2023-08-02 04:40:00	SPY	ETF	451.88	452.01	451.88	452.01	1040.0
2023-08-02 04:45:00	SPY	ETF	452.1	452.1	451.88	451.88	4979.0
2023-08-02 04:50:00	SPY	ETF	451.99	452.23	451.99	452.23	1989.0
2023-08-02 04:55:00	SPY	ETF	452.38	452.74	452.38	452.73	2714.0
2023-08-02 05:00:00	SPY	ETF	452.7	452.7	452.3	452.45	7090.0
2023-08-02 05:05:00	SPY	ETF	452.44	452.84	452.44	452.8	104706.0
2023-08-02 05:10:00	SPY	ETF	452.89	452.95	452.77	452.78	5202.0
2023-08-02 05:15:00	SPY	ETF	452.95	453.22	452.92	453.22	4980.0
2023-08-02 05:20:00	SPY	ETF	453.18	453.28	453.1	453.12	12600.0
2023-08-02 05:25:00	SPY	ETF	453.13	453.14	452.87	452.87	5700.0
2023-08-02 05:30:00	SPY	ETF	452.86	452.87	452.65	452.75	5256.0
2023-08-02 05:35:00	SPY	ETF	452.83	452.89	452.75	452.75	5300.0
2023-08-02 05:40:00	SPY	ETF	452.92	452.92	452.83	452.83	500.0
2023-08-02 05:45:00	SPY	ETF	452.86	453.09	452.86	453.09	4737.0
2023-08-02 05:50:00	SPY	ETF	453.0	453.05	452.95	453.02	21243.0
2023-08-02 05:55:00	SPY	ETF	453.03	453.23	453.01	453.09	25984.0
2023-08-02 06:00:00	SPY	ETF	453.13	453.29	453.11	453.28	3767.0
2023-08-02 06:05:00	SPY	ETF	453.3	453.42	453.26	453.4	3549.0
2023-08-02 06:10:00	SPY	ETF	453.4	453.46	453.36	453.45	5508.0
2023-08-02 06:15:00	SPY	ETF	453.43	453.43	453.28	453.4	5560.0
2023-08-02 06:20:00	SPY	ETF	453.36	453.36	453.18	453.18	5303.0
2023-08-02 06:25:00	SPY	ETF	453.2	453.2	453.17	453.2	1600.0
2023-08-02 06:30:00	SPY	ETF	453.39	453.67	453.31	453.67	9049.0
2023-08-02 06:35:00	SPY	ETF	453.62	454.01	453.6	453.98	34755.0
2023-08-02 06:40:00	SPY	ETF	453.96	454.23	453.91	454.17	21154.0
2023-08-02 06:45:00	SPY	ETF	454.06	454.25	454.05	454.22	9745.0
2023-08-02 06:50:00	SPY	ETF	454.24	454.26	454.21	454.22	15012.0
2023-08-02 06:55:00	SPY	ETF	454.15	454.37	454.13	454.37	6300.0
2023-08-02 07:00:00	SPY	ETF	454.37	454.8	454.36	454.64	20631.0
2023-08-02 07:05:00	SPY	ETF	454.6	454.77	454.46	454.48	25993.0
2023-08-02 07:10:00	SPY	ETF	454.54	454.54	454.37	454.4	5340.0
2023-08-02 07:15:00	SPY	ETF	454.44	454.44	454.25	454.34	116029.0
2023-08-02 07:20:00	SPY	ETF	454.31	454.56	454.31	454.43	26658.0
2023-08-02 07:25:00	SPY	ETF	454.42	454.53	454.32	454.42	26365.0
2023-08-02 07:30:00	SPY	ETF	454.46	454.54	454.29	454.29	7350.0
2023-08-02 07:35:00	SPY	ETF	454.34	454.45	454.34	454.45	7218.0
2023-08-02 07:40:00	SPY	ETF	454.39	454.43	454.34	454.4	21663.0
2023-08-02 07:45:00	SPY	ETF	454.41	454.41	454.18	454.22	12709.0
2023-08-02 07:50:00	SPY	ETF	454.241	454.31	454.13	454.18	13351.0
2023-08-02 07:55:00	SPY	ETF	454.19	454.37	454.19	454.251	5338.0
2023-08-02 08:00:00	SPY	ETF	454.55	454.8	451.8604	454.43	59030.0
2023-08-02 08:05:00	SPY	ETF	454.42	454.5	454.28	454.28	17944.0

> showing 50 of 104,358 rows — these rows as CSV

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