PREVIEW / etf_5min / 2025-03-31
file: by_date/etf_5min/2025/2025-03-31.parquet size: 2.9 MB rows: 145,591
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 |
|---|---|---|---|---|---|---|---|
| 2025-03-31 04:00:00 | SPY | ETF | 552.6 | 552.6 | 551.66 | 551.72 | 19396.0 |
| 2025-03-31 04:05:00 | SPY | ETF | 551.65 | 552.03 | 551.53 | 551.98 | 21839.0 |
| 2025-03-31 04:10:00 | SPY | ETF | 551.86 | 552.48 | 551.86 | 552.48 | 2812.0 |
| 2025-03-31 04:15:00 | SPY | ETF | 552.34 | 552.52 | 552.17 | 552.17 | 2967.0 |
| 2025-03-31 04:20:00 | SPY | ETF | 551.77 | 551.78 | 551.46 | 551.5 | 5068.0 |
| 2025-03-31 04:25:00 | SPY | ETF | 551.48 | 551.8 | 551.48 | 551.55 | 3661.0 |
| 2025-03-31 04:30:00 | SPY | ETF | 551.69 | 551.7 | 551.39 | 551.7 | 3587.0 |
| 2025-03-31 04:35:00 | SPY | ETF | 551.64 | 551.64 | 551.29 | 551.55 | 2106.0 |
| 2025-03-31 04:40:00 | SPY | ETF | 551.55 | 551.7 | 551.21 | 551.22 | 3853.0 |
| 2025-03-31 04:45:00 | SPY | ETF | 551.03 | 551.17 | 550.98 | 551.1 | 27183.0 |
| 2025-03-31 04:50:00 | SPY | ETF | 551.14 | 551.14 | 550.96 | 550.96 | 550.0 |
| 2025-03-31 04:55:00 | SPY | ETF | 550.83 | 550.85 | 550.76 | 550.81 | 4549.0 |
| 2025-03-31 05:00:00 | SPY | ETF | 550.73 | 550.73 | 550.15 | 550.2 | 7790.0 |
| 2025-03-31 05:05:00 | SPY | ETF | 550.1 | 550.28 | 550.0 | 550.06 | 9111.0 |
| 2025-03-31 05:10:00 | SPY | ETF | 550.08 | 550.32 | 549.81 | 549.81 | 7378.0 |
| 2025-03-31 05:15:00 | SPY | ETF | 549.98 | 550.64 | 549.98 | 550.39 | 7226.0 |
| 2025-03-31 05:20:00 | SPY | ETF | 550.46 | 550.6 | 550.33 | 550.6 | 11812.0 |
| 2025-03-31 05:25:00 | SPY | ETF | 550.64 | 551.05 | 550.64 | 550.97 | 10943.0 |
| 2025-03-31 05:30:00 | SPY | ETF | 551.01 | 551.08 | 550.93 | 550.93 | 1575.0 |
| 2025-03-31 05:35:00 | SPY | ETF | 551.07 | 551.07 | 550.76 | 550.83 | 2483.0 |
| 2025-03-31 05:40:00 | SPY | ETF | 550.8 | 550.8 | 550.35 | 550.35 | 532.0 |
| 2025-03-31 05:45:00 | SPY | ETF | 550.36 | 550.36 | 550.15 | 550.3 | 860.0 |
| 2025-03-31 05:50:00 | SPY | ETF | 550.55 | 550.55 | 550.2 | 550.2 | 1166.0 |
| 2025-03-31 05:55:00 | SPY | ETF | 550.17 | 550.42 | 550.17 | 550.42 | 17920.0 |
| 2025-03-31 06:00:00 | SPY | ETF | 550.47 | 550.58 | 550.39 | 550.4 | 34914.0 |
| 2025-03-31 06:05:00 | SPY | ETF | 550.5 | 550.51 | 550.44 | 550.44 | 2016.0 |
| 2025-03-31 06:10:00 | SPY | ETF | 550.19 | 550.52 | 550.13 | 550.52 | 4839.0 |
| 2025-03-31 06:15:00 | SPY | ETF | 550.48 | 550.48 | 550.22 | 550.23 | 2058.0 |
| 2025-03-31 06:20:00 | SPY | ETF | 550.6 | 550.6 | 550.25 | 550.25 | 60556.0 |
| 2025-03-31 06:25:00 | SPY | ETF | 550.25 | 550.64 | 550.25 | 550.61 | 13616.0 |
| 2025-03-31 06:30:00 | SPY | ETF | 550.56 | 550.78 | 550.56 | 550.72 | 6782.0 |
| 2025-03-31 06:35:00 | SPY | ETF | 550.75 | 550.87 | 550.7 | 550.71 | 6150.0 |
| 2025-03-31 06:40:00 | SPY | ETF | 550.7 | 550.7 | 550.65 | 550.7 | 13213.0 |
| 2025-03-31 06:45:00 | SPY | ETF | 550.68 | 551.06 | 550.68 | 550.87 | 55103.0 |
| 2025-03-31 06:50:00 | SPY | ETF | 550.96 | 550.96 | 550.67 | 550.69 | 2287.0 |
| 2025-03-31 06:55:00 | SPY | ETF | 550.83 | 550.83 | 550.69 | 550.69 | 1664.0 |
| 2025-03-31 07:00:00 | SPY | ETF | 550.75 | 551.0 | 550.46 | 550.68 | 10921.0 |
| 2025-03-31 07:05:00 | SPY | ETF | 550.66 | 550.73 | 549.9 | 549.92 | 15295.0 |
| 2025-03-31 07:10:00 | SPY | ETF | 549.93 | 550.1 | 549.93 | 550.1 | 30336.0 |
| 2025-03-31 07:15:00 | SPY | ETF | 550.06 | 550.49 | 550.06 | 550.07 | 35093.0 |
| 2025-03-31 07:20:00 | SPY | ETF | 550.01 | 550.05 | 549.8 | 549.8 | 6984.0 |
| 2025-03-31 07:25:00 | SPY | ETF | 549.81 | 549.86 | 549.17 | 549.25 | 23962.0 |
| 2025-03-31 07:30:00 | SPY | ETF | 549.28 | 549.4 | 548.701 | 548.85 | 73462.0 |
| 2025-03-31 07:35:00 | SPY | ETF | 548.845 | 549.43 | 548.845 | 549.3 | 30845.0 |
| 2025-03-31 07:40:00 | SPY | ETF | 549.335 | 549.65 | 549.23 | 549.31 | 25890.0 |
| 2025-03-31 07:45:00 | SPY | ETF | 549.29 | 549.71 | 549.26 | 549.71 | 62505.0 |
| 2025-03-31 07:50:00 | SPY | ETF | 549.68 | 549.92 | 549.65 | 549.71 | 23343.0 |
| 2025-03-31 07:55:00 | SPY | ETF | 549.82 | 549.88 | 549.7 | 549.79 | 34418.0 |
| 2025-03-31 08:00:00 | SPY | ETF | 550.81 | 552.45 | 548.7204 | 549.48 | 108074.0 |
| 2025-03-31 08:05:00 | SPY | ETF | 549.58 | 549.97 | 549.58 | 549.9 | 24398.0 |
> showing 50 of 145,591 rows — these rows as CSV