PREVIEW / etf_5min / 2025-04-21
file: by_date/etf_5min/2025/2025-04-21.parquet size: 2.9 MB rows: 143,998
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-04-21 04:00:00 | SPY | ETF | 522.78 | 522.78 | 520.71 | 521.53 | 10219.0 |
| 2025-04-21 04:05:00 | SPY | ETF | 521.35 | 521.54 | 521.26 | 521.33 | 3544.0 |
| 2025-04-21 04:10:00 | SPY | ETF | 521.3 | 521.33 | 521.14 | 521.14 | 997.0 |
| 2025-04-21 04:15:00 | SPY | ETF | 521.24 | 521.24 | 521.0 | 521.0 | 200.0 |
| 2025-04-21 04:20:00 | SPY | ETF | 521.04 | 521.24 | 521.04 | 521.24 | 200.0 |
| 2025-04-21 04:25:00 | SPY | ETF | 521.1 | 521.1 | 521.1 | 521.1 | 390.0 |
| 2025-04-21 04:35:00 | SPY | ETF | 521.5 | 521.5 | 521.5 | 521.5 | 129.0 |
| 2025-04-21 04:40:00 | SPY | ETF | 521.33 | 521.33 | 521.29 | 521.3 | 6037.0 |
| 2025-04-21 04:45:00 | SPY | ETF | 521.2 | 521.2 | 521.2 | 521.2 | 100.0 |
| 2025-04-21 04:50:00 | SPY | ETF | 521.27 | 521.31 | 521.0 | 521.0 | 10682.0 |
| 2025-04-21 04:55:00 | SPY | ETF | 521.0 | 521.25 | 520.92 | 521.25 | 1377.0 |
| 2025-04-21 05:00:00 | SPY | ETF | 521.36 | 521.36 | 521.11 | 521.13 | 3060.0 |
| 2025-04-21 05:05:00 | SPY | ETF | 521.14 | 521.14 | 521.02 | 521.02 | 300.0 |
| 2025-04-21 05:10:00 | SPY | ETF | 520.97 | 520.97 | 520.61 | 520.7 | 4669.0 |
| 2025-04-21 05:15:00 | SPY | ETF | 520.61 | 520.61 | 520.5 | 520.5 | 2299.0 |
| 2025-04-21 05:20:00 | SPY | ETF | 520.74 | 520.74 | 520.74 | 520.74 | 175.0 |
| 2025-04-21 05:25:00 | SPY | ETF | 520.73 | 521.15 | 520.7 | 521.05 | 5861.0 |
| 2025-04-21 05:30:00 | SPY | ETF | 520.88 | 520.89 | 520.8 | 520.8 | 500.0 |
| 2025-04-21 05:35:00 | SPY | ETF | 520.79 | 520.79 | 520.79 | 520.79 | 217.0 |
| 2025-04-21 05:40:00 | SPY | ETF | 520.8 | 520.8 | 520.62 | 520.62 | 732.0 |
| 2025-04-21 05:45:00 | SPY | ETF | 520.55 | 520.91 | 520.55 | 520.8 | 2022.0 |
| 2025-04-21 05:50:00 | SPY | ETF | 520.91 | 521.0 | 520.87 | 520.87 | 1612.0 |
| 2025-04-21 05:55:00 | SPY | ETF | 520.94 | 520.94 | 520.92 | 520.92 | 300.0 |
| 2025-04-21 06:00:00 | SPY | ETF | 521.18 | 521.2 | 521.17 | 521.2 | 15330.0 |
| 2025-04-21 06:05:00 | SPY | ETF | 521.3 | 521.3 | 521.3 | 521.3 | 700.0 |
| 2025-04-21 06:10:00 | SPY | ETF | 521.44 | 521.44 | 521.22 | 521.23 | 1400.0 |
| 2025-04-21 06:15:00 | SPY | ETF | 521.24 | 521.25 | 521.21 | 521.21 | 500.0 |
| 2025-04-21 06:20:00 | SPY | ETF | 521.18 | 521.21 | 521.17 | 521.19 | 1300.0 |
| 2025-04-21 06:25:00 | SPY | ETF | 521.0 | 521.0 | 520.82 | 520.86 | 1480.0 |
| 2025-04-21 06:30:00 | SPY | ETF | 520.75 | 520.99 | 520.75 | 520.9 | 8079.0 |
| 2025-04-21 06:35:00 | SPY | ETF | 520.99 | 520.99 | 520.82 | 520.92 | 2500.0 |
| 2025-04-21 06:40:00 | SPY | ETF | 521.02 | 521.19 | 521.0 | 521.19 | 4150.0 |
| 2025-04-21 06:45:00 | SPY | ETF | 521.23 | 521.29 | 521.2 | 521.26 | 2300.0 |
| 2025-04-21 06:55:00 | SPY | ETF | 521.5 | 521.72 | 521.5 | 521.65 | 700.0 |
| 2025-04-21 07:00:00 | SPY | ETF | 521.65 | 522.37 | 521.65 | 522.21 | 23683.0 |
| 2025-04-21 07:05:00 | SPY | ETF | 522.25 | 522.41 | 522.061 | 522.3 | 4899.0 |
| 2025-04-21 07:10:00 | SPY | ETF | 522.14 | 522.14 | 521.61 | 521.7 | 35612.0 |
| 2025-04-21 07:15:00 | SPY | ETF | 521.7 | 521.7 | 521.27 | 521.27 | 6930.0 |
| 2025-04-21 07:20:00 | SPY | ETF | 521.1 | 521.16 | 519.57 | 519.63 | 46604.0 |
| 2025-04-21 07:25:00 | SPY | ETF | 519.57 | 520.25 | 519.39 | 520.25 | 45191.0 |
| 2025-04-21 07:30:00 | SPY | ETF | 520.18 | 520.19 | 519.74 | 520.0 | 14601.0 |
| 2025-04-21 07:35:00 | SPY | ETF | 520.0 | 520.0 | 519.59 | 519.73 | 9580.0 |
| 2025-04-21 07:40:00 | SPY | ETF | 519.75 | 520.19 | 519.63 | 519.71 | 11641.0 |
| 2025-04-21 07:45:00 | SPY | ETF | 519.7 | 519.84 | 519.5 | 519.72 | 17175.0 |
| 2025-04-21 07:50:00 | SPY | ETF | 519.75 | 519.77 | 519.26 | 519.61 | 21015.0 |
| 2025-04-21 07:55:00 | SPY | ETF | 519.55 | 520.05 | 519.44 | 520.0 | 74717.0 |
| 2025-04-21 08:00:00 | SPY | ETF | 522.31 | 523.05 | 519.3789 | 520.0399 | 142058.0 |
| 2025-04-21 08:05:00 | SPY | ETF | 520.08 | 520.24 | 520.0301 | 520.09 | 11979.0 |
| 2025-04-21 08:10:00 | SPY | ETF | 520.05 | 520.55 | 520.0 | 520.46 | 59189.0 |
| 2025-04-21 08:15:00 | SPY | ETF | 520.35 | 520.56 | 520.22 | 520.22 | 5950.0 |
> showing 50 of 143,998 rows — these rows as CSV