PREVIEW / etf_5min / 2023-03-02

all etf 5-min files

  file:    by_date/etf_5min/2023/2023-03-02.parquet
  size:    1.9 MB
  rows:    93,886

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-03-02 04:00:00	SPY	ETF	392.88	393.07	392.5	393.0	13407.0
2023-03-02 04:05:00	SPY	ETF	392.97	393.07	392.78	393.07	5555.0
2023-03-02 04:10:00	SPY	ETF	393.05	393.05	392.86	392.91	1073.0
2023-03-02 04:15:00	SPY	ETF	392.93	392.99	392.68	392.68	1757.0
2023-03-02 04:20:00	SPY	ETF	392.76	392.76	392.54	392.54	729.0
2023-03-02 04:25:00	SPY	ETF	392.51	392.8	392.51	392.8	13593.0
2023-03-02 04:30:00	SPY	ETF	392.76	392.85	392.76	392.77	1800.0
2023-03-02 04:35:00	SPY	ETF	392.83	392.83	392.73	392.73	1000.0
2023-03-02 04:40:00	SPY	ETF	392.68	392.76	392.68	392.74	400.0
2023-03-02 04:45:00	SPY	ETF	392.65	392.65	392.55	392.56	300.0
2023-03-02 04:50:00	SPY	ETF	392.55	392.58	392.55	392.58	401.0
2023-03-02 05:00:00	SPY	ETF	392.29	392.49	392.29	392.35	2227.0
2023-03-02 05:05:00	SPY	ETF	392.26	392.26	391.94	392.01	6494.0
2023-03-02 05:10:00	SPY	ETF	391.97	392.2	391.95	392.2	2385.0
2023-03-02 05:15:00	SPY	ETF	392.21	392.48	392.21	392.42	5757.0
2023-03-02 05:20:00	SPY	ETF	392.43	392.81	392.41	392.74	6925.0
2023-03-02 05:25:00	SPY	ETF	392.63	392.89	392.63	392.89	2931.0
2023-03-02 05:30:00	SPY	ETF	392.9	392.93	392.82	392.92	4316.0
2023-03-02 05:35:00	SPY	ETF	392.81	392.83	392.66	392.66	5249.0
2023-03-02 05:40:00	SPY	ETF	392.51	392.71	392.51	392.71	2700.0
2023-03-02 05:45:00	SPY	ETF	392.75	392.93	392.75	392.89	15020.0
2023-03-02 05:50:00	SPY	ETF	392.93	392.93	392.74	392.74	603.0
2023-03-02 05:55:00	SPY	ETF	392.82	392.97	392.82	392.95	1400.0
2023-03-02 06:00:00	SPY	ETF	393.09	393.42	393.09	393.4	9210.0
2023-03-02 06:05:00	SPY	ETF	393.43	393.61	393.42	393.48	8198.0
2023-03-02 06:10:00	SPY	ETF	393.47	393.58	393.33	393.35	13490.0
2023-03-02 06:15:00	SPY	ETF	393.48	393.59	393.46	393.46	8669.0
2023-03-02 06:20:00	SPY	ETF	393.48	393.48	393.33	393.35	4100.0
2023-03-02 06:25:00	SPY	ETF	393.3	393.36	393.21	393.24	2648.0
2023-03-02 06:30:00	SPY	ETF	393.22	393.38	393.15	393.38	4761.0
2023-03-02 06:35:00	SPY	ETF	393.33	393.38	393.33	393.35	3300.0
2023-03-02 06:40:00	SPY	ETF	393.34	393.6	393.34	393.58	10161.0
2023-03-02 06:45:00	SPY	ETF	393.56	393.63	393.43	393.43	1950.0
2023-03-02 06:50:00	SPY	ETF	393.39	393.39	393.3	393.3	3052.0
2023-03-02 06:55:00	SPY	ETF	393.43	393.59	393.43	393.59	4451.0
2023-03-02 07:00:00	SPY	ETF	393.59	393.96	393.58	393.91	24528.0
2023-03-02 07:05:00	SPY	ETF	393.83	393.92	393.79	393.92	8845.0
2023-03-02 07:10:00	SPY	ETF	393.85	393.85	393.72	393.75	13741.0
2023-03-02 07:15:00	SPY	ETF	393.79	393.85	393.65	393.71	37235.0
2023-03-02 07:20:00	SPY	ETF	393.75	393.76	393.431	393.431	13031.0
2023-03-02 07:25:00	SPY	ETF	393.39	393.45	393.31	393.32	13837.0
2023-03-02 07:30:00	SPY	ETF	393.32	393.46	393.16	393.32	57340.0
2023-03-02 07:35:00	SPY	ETF	393.23	393.32	393.22	393.3	13548.0
2023-03-02 07:40:00	SPY	ETF	393.32	393.5	393.11	393.11	47229.0
2023-03-02 07:45:00	SPY	ETF	393.09	393.33	393.09	393.29	41139.0
2023-03-02 07:50:00	SPY	ETF	393.27	393.27	392.95	393.1	23357.0
2023-03-02 07:55:00	SPY	ETF	393.1	393.27	393.09	393.12	16823.0
2023-03-02 08:00:00	SPY	ETF	393.759	393.96	391.96	393.42	137115.0
2023-03-02 08:05:00	SPY	ETF	393.45	393.49	393.24	393.26	75138.0
2023-03-02 08:10:00	SPY	ETF	393.2	393.2	393.01	393.13	39380.0

> showing 50 of 93,886 rows — these rows as CSV

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