PREVIEW / etf_5min / 2025-09-09
file: by_date/etf_5min/2025/2025-09-09.parquet size: 2.9 MB rows: 144,466
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-09-09 04:00:00 | SPY | ETF | 649.75 | 649.79 | 649.71 | 649.79 | 1436.0 |
| 2025-09-09 04:05:00 | SPY | ETF | 649.71 | 649.71 | 649.57 | 649.57 | 1130.0 |
| 2025-09-09 04:10:00 | SPY | ETF | 649.53 | 649.72 | 649.53 | 649.72 | 1211.0 |
| 2025-09-09 04:15:00 | SPY | ETF | 649.67 | 649.67 | 649.43 | 649.56 | 4295.0 |
| 2025-09-09 04:20:00 | SPY | ETF | 649.64 | 649.8 | 649.64 | 649.79 | 600.0 |
| 2025-09-09 04:25:00 | SPY | ETF | 649.86 | 649.86 | 649.72 | 649.72 | 400.0 |
| 2025-09-09 04:30:00 | SPY | ETF | 649.71 | 649.71 | 649.71 | 649.71 | 134.0 |
| 2025-09-09 04:35:00 | SPY | ETF | 649.6 | 649.6 | 649.42 | 649.42 | 600.0 |
| 2025-09-09 04:40:00 | SPY | ETF | 649.6 | 649.63 | 649.59 | 649.63 | 600.0 |
| 2025-09-09 04:45:00 | SPY | ETF | 649.37 | 649.37 | 649.37 | 649.37 | 200.0 |
| 2025-09-09 04:50:00 | SPY | ETF | 649.49 | 649.49 | 649.49 | 649.49 | 100.0 |
| 2025-09-09 04:55:00 | SPY | ETF | 649.4 | 649.46 | 649.4 | 649.46 | 600.0 |
| 2025-09-09 05:00:00 | SPY | ETF | 649.62 | 649.62 | 649.62 | 649.62 | 181.0 |
| 2025-09-09 05:05:00 | SPY | ETF | 649.58 | 649.58 | 649.41 | 649.41 | 300.0 |
| 2025-09-09 05:10:00 | SPY | ETF | 649.67 | 649.7 | 649.67 | 649.7 | 400.0 |
| 2025-09-09 05:15:00 | SPY | ETF | 649.72 | 650.1 | 649.66 | 649.72 | 5293.0 |
| 2025-09-09 05:20:00 | SPY | ETF | 649.66 | 649.66 | 649.66 | 649.66 | 317.0 |
| 2025-09-09 05:30:00 | SPY | ETF | 649.62 | 649.65 | 649.62 | 649.65 | 913.0 |
| 2025-09-09 05:35:00 | SPY | ETF | 649.61 | 649.66 | 649.61 | 649.63 | 687.0 |
| 2025-09-09 05:40:00 | SPY | ETF | 649.64 | 649.64 | 649.53 | 649.54 | 45657.0 |
| 2025-09-09 05:45:00 | SPY | ETF | 649.49 | 649.59 | 649.49 | 649.59 | 450.0 |
| 2025-09-09 05:50:00 | SPY | ETF | 649.5 | 649.5 | 649.44 | 649.44 | 632.0 |
| 2025-09-09 05:55:00 | SPY | ETF | 649.4 | 649.47 | 649.37 | 649.47 | 656.0 |
| 2025-09-09 06:05:00 | SPY | ETF | 649.56 | 649.62 | 649.56 | 649.62 | 200.0 |
| 2025-09-09 06:20:00 | SPY | ETF | 649.57 | 649.57 | 649.55 | 649.56 | 300.0 |
| 2025-09-09 06:30:00 | SPY | ETF | 649.4 | 649.43 | 649.38 | 649.43 | 300.0 |
| 2025-09-09 06:35:00 | SPY | ETF | 649.51 | 649.58 | 649.51 | 649.58 | 400.0 |
| 2025-09-09 06:45:00 | SPY | ETF | 649.61 | 649.61 | 649.41 | 649.44 | 8726.0 |
| 2025-09-09 06:50:00 | SPY | ETF | 649.38 | 649.38 | 649.26 | 649.28 | 500.0 |
| 2025-09-09 06:55:00 | SPY | ETF | 649.26 | 649.43 | 649.26 | 649.43 | 605.0 |
| 2025-09-09 07:00:00 | SPY | ETF | 649.45 | 649.46 | 649.26 | 649.31 | 624.0 |
| 2025-09-09 07:05:00 | SPY | ETF | 649.35 | 649.45 | 649.35 | 649.45 | 1214.0 |
| 2025-09-09 07:10:00 | SPY | ETF | 649.39 | 649.41 | 649.26 | 649.31 | 900.0 |
| 2025-09-09 07:15:00 | SPY | ETF | 649.2 | 649.2 | 649.0 | 649.0 | 400.0 |
| 2025-09-09 07:20:00 | SPY | ETF | 649.02 | 649.1 | 648.97 | 649.1 | 3556.0 |
| 2025-09-09 07:25:00 | SPY | ETF | 649.12 | 649.19 | 649.12 | 649.13 | 400.0 |
| 2025-09-09 07:30:00 | SPY | ETF | 649.34 | 649.34 | 649.34 | 649.34 | 300.0 |
| 2025-09-09 07:35:00 | SPY | ETF | 649.3 | 649.35 | 649.27 | 649.3 | 800.0 |
| 2025-09-09 07:40:00 | SPY | ETF | 649.35 | 649.35 | 649.35 | 649.35 | 1743.0 |
| 2025-09-09 07:45:00 | SPY | ETF | 649.35 | 649.61 | 649.35 | 649.61 | 15956.0 |
| 2025-09-09 07:50:00 | SPY | ETF | 649.57 | 649.6 | 649.55 | 649.6 | 46141.0 |
| 2025-09-09 07:55:00 | SPY | ETF | 649.65 | 649.66 | 649.56 | 649.61 | 24178.0 |
| 2025-09-09 08:00:00 | SPY | ETF | 649.33 | 650.53 | 649.12 | 649.61 | 43759.0 |
| 2025-09-09 08:05:00 | SPY | ETF | 649.61 | 649.61 | 649.55 | 649.55 | 500.0 |
| 2025-09-09 08:10:00 | SPY | ETF | 649.54 | 649.6708 | 649.54 | 649.6708 | 3950.0 |
| 2025-09-09 08:15:00 | SPY | ETF | 649.63 | 649.72 | 649.59 | 649.59 | 968.0 |
| 2025-09-09 08:20:00 | SPY | ETF | 649.69 | 649.7 | 649.51 | 649.51 | 3991.0 |
| 2025-09-09 08:25:00 | SPY | ETF | 649.5 | 649.6 | 649.42 | 649.6 | 5400.0 |
| 2025-09-09 08:30:00 | SPY | ETF | 649.58 | 649.6 | 649.33 | 649.39 | 6183.0 |
| 2025-09-09 08:35:00 | SPY | ETF | 649.55 | 649.58 | 649.42 | 649.42 | 1494.0 |
> showing 50 of 144,466 rows — these rows as CSV