PREVIEW / etf_5min / 2024-05-02

all etf 5-min files

  file:    by_date/etf_5min/2024/2024-05-02.parquet
  size:    2.2 MB
  rows:    109,756

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
2024-05-02 04:00:00	SPY	ETF	503.42	503.62	503.42	503.58	1348.0
2024-05-02 04:05:00	SPY	ETF	503.57	504.01	503.57	503.8	7346.0
2024-05-02 04:10:00	SPY	ETF	503.85	503.88	503.81	503.85	2034.0
2024-05-02 04:15:00	SPY	ETF	503.86	503.93	503.68	503.76	3834.0
2024-05-02 04:20:00	SPY	ETF	503.89	503.89	503.68	503.89	1686.0
2024-05-02 04:25:00	SPY	ETF	503.8	503.81	503.62	503.66	821.0
2024-05-02 04:30:00	SPY	ETF	503.76	503.79	503.61	503.61	6825.0
2024-05-02 04:35:00	SPY	ETF	503.49	503.58	503.49	503.58	300.0
2024-05-02 04:40:00	SPY	ETF	503.59	503.59	503.59	503.59	125.0
2024-05-02 04:45:00	SPY	ETF	503.5	503.5	503.4	503.46	1737.0
2024-05-02 04:50:00	SPY	ETF	503.46	503.46	503.46	503.46	296.0
2024-05-02 04:55:00	SPY	ETF	503.26	503.26	503.2	503.2	271.0
2024-05-02 05:00:00	SPY	ETF	503.15	503.18	503.15	503.18	300.0
2024-05-02 05:05:00	SPY	ETF	503.26	503.26	503.26	503.26	100.0
2024-05-02 05:15:00	SPY	ETF	503.43	503.43	503.43	503.43	100.0
2024-05-02 05:25:00	SPY	ETF	503.34	503.34	503.34	503.34	100.0
2024-05-02 05:30:00	SPY	ETF	503.58	503.58	503.58	503.58	100.0
2024-05-02 05:35:00	SPY	ETF	503.49	503.49	503.4	503.4	400.0
2024-05-02 05:40:00	SPY	ETF	503.37	503.37	503.37	503.37	2000.0
2024-05-02 05:45:00	SPY	ETF	503.4	503.4	503.29	503.29	500.0
2024-05-02 05:50:00	SPY	ETF	503.48	503.62	503.48	503.62	4200.0
2024-05-02 05:55:00	SPY	ETF	503.62	503.65	503.58	503.58	2024.0
2024-05-02 06:00:00	SPY	ETF	503.75	503.75	503.56	503.57	1100.0
2024-05-02 06:05:00	SPY	ETF	503.54	503.86	503.51	503.85	5609.0
2024-05-02 06:10:00	SPY	ETF	503.86	503.89	503.64	503.69	14376.0
2024-05-02 06:15:00	SPY	ETF	503.5	503.51	503.5	503.51	14888.0
2024-05-02 06:20:00	SPY	ETF	503.61	503.61	503.44	503.44	1869.0
2024-05-02 06:25:00	SPY	ETF	503.49	503.57	503.47	503.57	4108.0
2024-05-02 06:30:00	SPY	ETF	503.58	503.69	503.5	503.69	6419.0
2024-05-02 06:35:00	SPY	ETF	503.72	503.82	503.59	503.62	5235.0
2024-05-02 06:40:00	SPY	ETF	503.62	503.83	503.62	503.83	2566.0
2024-05-02 06:45:00	SPY	ETF	503.85	504.03	503.85	504.02	18494.0
2024-05-02 06:50:00	SPY	ETF	504.03	504.09	504.03	504.04	1500.0
2024-05-02 06:55:00	SPY	ETF	503.95	503.96	503.92	503.92	6900.0
2024-05-02 07:00:00	SPY	ETF	503.92	504.11	503.33	503.9	93415.0
2024-05-02 07:05:00	SPY	ETF	503.95	504.18	503.95	504.13	9687.0
2024-05-02 07:10:00	SPY	ETF	504.161	504.32	504.161	504.27	9912.0
2024-05-02 07:15:00	SPY	ETF	504.18	504.18	504.09	504.09	5216.0
2024-05-02 07:20:00	SPY	ETF	504.12	504.17	504.0	504.0	12987.0
2024-05-02 07:25:00	SPY	ETF	503.98	504.06	503.9	504.06	9238.0
2024-05-02 07:30:00	SPY	ETF	503.9	503.9	503.64	503.73	22834.0
2024-05-02 07:35:00	SPY	ETF	503.78	503.79	503.55	503.6	8500.0
2024-05-02 07:40:00	SPY	ETF	503.58	503.781	503.58	503.76	6327.0
2024-05-02 07:45:00	SPY	ETF	503.74	503.74	503.62	503.62	11100.0
2024-05-02 07:50:00	SPY	ETF	503.61	503.73	503.61	503.73	5297.0
2024-05-02 07:55:00	SPY	ETF	503.52	503.61	503.44	503.59	12785.0
2024-05-02 08:00:00	SPY	ETF	503.58	504.32	502.84	503.58	40811.0
2024-05-02 08:05:00	SPY	ETF	503.55	503.9	503.55	503.9	11600.0
2024-05-02 08:10:00	SPY	ETF	503.91	504.19	503.91	504.07	38478.0
2024-05-02 08:15:00	SPY	ETF	504.04	504.08	503.8	503.8	9850.0

> showing 50 of 109,756 rows — these rows as CSV

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