PREVIEW / etf_5min / 2025-09-08
file: by_date/etf_5min/2025/2025-09-08.parquet size: 2.9 MB rows: 146,138
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-08 04:00:00 | SPY | ETF | 648.25 | 648.37 | 647.9 | 648.37 | 4385.0 |
| 2025-09-08 04:05:00 | SPY | ETF | 648.35 | 648.4 | 648.32 | 648.39 | 3746.0 |
| 2025-09-08 04:10:00 | SPY | ETF | 648.34 | 648.51 | 648.34 | 648.49 | 3227.0 |
| 2025-09-08 04:15:00 | SPY | ETF | 648.45 | 648.63 | 648.45 | 648.57 | 471.0 |
| 2025-09-08 04:20:00 | SPY | ETF | 648.5 | 648.5 | 648.43 | 648.48 | 600.0 |
| 2025-09-08 04:25:00 | SPY | ETF | 648.5 | 648.52 | 648.49 | 648.49 | 541.0 |
| 2025-09-08 04:30:00 | SPY | ETF | 648.5 | 648.56 | 648.5 | 648.56 | 300.0 |
| 2025-09-08 04:35:00 | SPY | ETF | 648.56 | 648.63 | 648.56 | 648.63 | 1067.0 |
| 2025-09-08 04:40:00 | SPY | ETF | 648.65 | 648.66 | 648.57 | 648.6 | 2260.0 |
| 2025-09-08 04:45:00 | SPY | ETF | 648.53 | 648.63 | 648.53 | 648.63 | 295.0 |
| 2025-09-08 04:50:00 | SPY | ETF | 648.5 | 648.5 | 648.4 | 648.4 | 1346.0 |
| 2025-09-08 04:55:00 | SPY | ETF | 648.49 | 648.49 | 648.49 | 648.49 | 100.0 |
| 2025-09-08 05:00:00 | SPY | ETF | 648.47 | 648.47 | 648.38 | 648.42 | 881.0 |
| 2025-09-08 05:05:00 | SPY | ETF | 648.39 | 648.4 | 648.3 | 648.3 | 1006.0 |
| 2025-09-08 05:10:00 | SPY | ETF | 648.3 | 648.4 | 648.3 | 648.38 | 1360.0 |
| 2025-09-08 05:15:00 | SPY | ETF | 648.39 | 648.4 | 648.39 | 648.4 | 364.0 |
| 2025-09-08 05:20:00 | SPY | ETF | 648.38 | 648.47 | 648.38 | 648.47 | 400.0 |
| 2025-09-08 05:25:00 | SPY | ETF | 648.48 | 648.51 | 648.48 | 648.51 | 934.0 |
| 2025-09-08 05:30:00 | SPY | ETF | 648.43 | 648.45 | 648.43 | 648.45 | 1012.0 |
| 2025-09-08 05:40:00 | SPY | ETF | 648.38 | 648.41 | 648.38 | 648.41 | 550.0 |
| 2025-09-08 05:45:00 | SPY | ETF | 648.44 | 648.44 | 648.44 | 648.44 | 100.0 |
| 2025-09-08 05:50:00 | SPY | ETF | 648.59 | 648.67 | 648.59 | 648.67 | 300.0 |
| 2025-09-08 05:55:00 | SPY | ETF | 648.74 | 648.77 | 648.74 | 648.77 | 739.0 |
| 2025-09-08 06:00:00 | SPY | ETF | 648.71 | 648.76 | 648.71 | 648.75 | 6140.0 |
| 2025-09-08 06:05:00 | SPY | ETF | 648.75 | 648.75 | 648.75 | 648.75 | 2757.0 |
| 2025-09-08 06:10:00 | SPY | ETF | 648.75 | 648.86 | 648.74 | 648.86 | 929.0 |
| 2025-09-08 06:15:00 | SPY | ETF | 648.8 | 648.81 | 648.8 | 648.81 | 400.0 |
| 2025-09-08 06:20:00 | SPY | ETF | 648.8 | 648.9 | 648.78 | 648.9 | 1107.0 |
| 2025-09-08 06:25:00 | SPY | ETF | 648.8 | 648.8 | 648.77 | 648.79 | 1758.0 |
| 2025-09-08 06:30:00 | SPY | ETF | 648.75 | 648.79 | 648.75 | 648.77 | 385.0 |
| 2025-09-08 06:35:00 | SPY | ETF | 648.88 | 648.96 | 648.73 | 648.77 | 2650.0 |
| 2025-09-08 06:40:00 | SPY | ETF | 648.78 | 648.86 | 648.78 | 648.83 | 1731.0 |
| 2025-09-08 06:50:00 | SPY | ETF | 648.77 | 648.77 | 648.75 | 648.75 | 300.0 |
| 2025-09-08 06:55:00 | SPY | ETF | 648.73 | 648.73 | 648.7 | 648.7 | 404.0 |
| 2025-09-08 07:00:00 | SPY | ETF | 648.67 | 648.71 | 648.56 | 648.68 | 1751.0 |
| 2025-09-08 07:05:00 | SPY | ETF | 648.7 | 648.77 | 648.65 | 648.71 | 21378.0 |
| 2025-09-08 07:10:00 | SPY | ETF | 648.68 | 648.81 | 648.68 | 648.81 | 2098.0 |
| 2025-09-08 07:15:00 | SPY | ETF | 648.641 | 648.641 | 648.641 | 648.641 | 300.0 |
| 2025-09-08 07:20:00 | SPY | ETF | 648.64 | 648.64 | 648.53 | 648.54 | 2176.0 |
| 2025-09-08 07:25:00 | SPY | ETF | 648.56 | 648.71 | 648.53 | 648.71 | 6297.0 |
| 2025-09-08 07:30:00 | SPY | ETF | 648.72 | 648.83 | 648.63 | 648.63 | 6751.0 |
| 2025-09-08 07:35:00 | SPY | ETF | 648.65 | 648.7 | 648.64 | 648.64 | 400.0 |
| 2025-09-08 07:40:00 | SPY | ETF | 648.57 | 648.62 | 648.56 | 648.62 | 6730.0 |
| 2025-09-08 07:45:00 | SPY | ETF | 648.49 | 648.64 | 648.39 | 648.58 | 10178.0 |
| 2025-09-08 07:50:00 | SPY | ETF | 648.52 | 648.6 | 648.49 | 648.56 | 7197.0 |
| 2025-09-08 07:55:00 | SPY | ETF | 648.65 | 648.65 | 648.25 | 648.25 | 17861.0 |
| 2025-09-08 08:00:00 | SPY | ETF | 648.72 | 648.84 | 647.61 | 648.3 | 39813.0 |
| 2025-09-08 08:05:00 | SPY | ETF | 648.21 | 648.21 | 648.0 | 648.17 | 7371.0 |
| 2025-09-08 08:10:00 | SPY | ETF | 648.07 | 648.08 | 647.86 | 647.96 | 10338.0 |
| 2025-09-08 08:15:00 | SPY | ETF | 647.9291 | 648.099 | 647.9291 | 648.01 | 7591.0 |
> showing 50 of 146,138 rows — these rows as CSV