PREVIEW / etf_5min / 2025-07-18
file: by_date/etf_5min/2025/2025-07-18.parquet size: 2.7 MB rows: 136,745
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-07-18 04:00:00 | SPY | ETF | 628.74 | 629.1 | 628.68 | 628.85 | 13751.0 |
| 2025-07-18 04:05:00 | SPY | ETF | 628.84 | 628.84 | 628.72 | 628.81 | 717.0 |
| 2025-07-18 04:10:00 | SPY | ETF | 628.72 | 628.95 | 628.7 | 628.94 | 1255.0 |
| 2025-07-18 04:15:00 | SPY | ETF | 628.91 | 628.98 | 628.89 | 628.98 | 3385.0 |
| 2025-07-18 04:20:00 | SPY | ETF | 629.05 | 629.15 | 629.02 | 629.05 | 3633.0 |
| 2025-07-18 04:25:00 | SPY | ETF | 629.06 | 629.06 | 629.04 | 629.04 | 580.0 |
| 2025-07-18 04:30:00 | SPY | ETF | 628.96 | 628.97 | 628.9 | 628.9 | 2416.0 |
| 2025-07-18 04:35:00 | SPY | ETF | 628.88 | 628.94 | 628.86 | 628.94 | 707.0 |
| 2025-07-18 04:40:00 | SPY | ETF | 628.93 | 628.93 | 628.82 | 628.9 | 1620.0 |
| 2025-07-18 04:45:00 | SPY | ETF | 628.92 | 628.93 | 628.91 | 628.93 | 300.0 |
| 2025-07-18 04:50:00 | SPY | ETF | 629.02 | 629.15 | 629.0 | 629.15 | 2892.0 |
| 2025-07-18 04:55:00 | SPY | ETF | 629.06 | 629.09 | 628.95 | 628.98 | 17154.0 |
| 2025-07-18 05:00:00 | SPY | ETF | 629.01 | 629.1 | 628.97 | 629.1 | 888.0 |
| 2025-07-18 05:05:00 | SPY | ETF | 629.1 | 629.1 | 629.05 | 629.06 | 700.0 |
| 2025-07-18 05:10:00 | SPY | ETF | 629.1 | 629.1 | 629.06 | 629.07 | 400.0 |
| 2025-07-18 05:15:00 | SPY | ETF | 629.1 | 629.1 | 629.06 | 629.06 | 329.0 |
| 2025-07-18 05:20:00 | SPY | ETF | 629.03 | 629.07 | 629.03 | 629.06 | 15860.0 |
| 2025-07-18 05:25:00 | SPY | ETF | 629.05 | 629.05 | 628.94 | 629.05 | 400.0 |
| 2025-07-18 05:30:00 | SPY | ETF | 629.08 | 629.12 | 629.08 | 629.12 | 900.0 |
| 2025-07-18 05:35:00 | SPY | ETF | 629.1 | 629.16 | 629.1 | 629.12 | 6620.0 |
| 2025-07-18 05:45:00 | SPY | ETF | 629.02 | 629.02 | 628.97 | 628.97 | 600.0 |
| 2025-07-18 05:50:00 | SPY | ETF | 629.05 | 629.05 | 629.01 | 629.02 | 786.0 |
| 2025-07-18 05:55:00 | SPY | ETF | 628.99 | 628.99 | 628.99 | 628.99 | 100.0 |
| 2025-07-18 06:00:00 | SPY | ETF | 628.95 | 629.02 | 628.95 | 629.01 | 400.0 |
| 2025-07-18 06:05:00 | SPY | ETF | 628.98 | 629.01 | 628.92 | 628.96 | 1000.0 |
| 2025-07-18 06:10:00 | SPY | ETF | 628.96 | 628.96 | 628.89 | 628.89 | 1000.0 |
| 2025-07-18 06:15:00 | SPY | ETF | 628.85 | 628.85 | 628.68 | 628.69 | 600.0 |
| 2025-07-18 06:20:00 | SPY | ETF | 628.62 | 628.62 | 628.33 | 628.36 | 7878.0 |
| 2025-07-18 06:25:00 | SPY | ETF | 628.38 | 628.46 | 628.37 | 628.44 | 4369.0 |
| 2025-07-18 06:30:00 | SPY | ETF | 628.42 | 628.52 | 628.33 | 628.41 | 7081.0 |
| 2025-07-18 06:35:00 | SPY | ETF | 628.4 | 628.5 | 628.36 | 628.5 | 2040.0 |
| 2025-07-18 06:40:00 | SPY | ETF | 628.54 | 628.54 | 628.45 | 628.5 | 2830.0 |
| 2025-07-18 06:50:00 | SPY | ETF | 628.48 | 628.49 | 628.45 | 628.45 | 1000.0 |
| 2025-07-18 06:55:00 | SPY | ETF | 628.41 | 628.52 | 628.41 | 628.51 | 1340.0 |
| 2025-07-18 07:00:00 | SPY | ETF | 628.45 | 628.67 | 628.4 | 628.4 | 12207.0 |
| 2025-07-18 07:05:00 | SPY | ETF | 628.42 | 628.429 | 628.32 | 628.429 | 5078.0 |
| 2025-07-18 07:10:00 | SPY | ETF | 628.46 | 628.47 | 628.33 | 628.33 | 10194.0 |
| 2025-07-18 07:15:00 | SPY | ETF | 628.33 | 628.42 | 628.18 | 628.19 | 7523.0 |
| 2025-07-18 07:20:00 | SPY | ETF | 628.21 | 628.45 | 628.21 | 628.43 | 5833.0 |
| 2025-07-18 07:25:00 | SPY | ETF | 628.38 | 628.42 | 628.36 | 628.42 | 3869.0 |
| 2025-07-18 07:30:00 | SPY | ETF | 628.42 | 628.48 | 628.42 | 628.46 | 2540.0 |
| 2025-07-18 07:35:00 | SPY | ETF | 628.46 | 628.48 | 628.36 | 628.42 | 8352.0 |
| 2025-07-18 07:40:00 | SPY | ETF | 628.4 | 628.449 | 628.35 | 628.42 | 3492.0 |
| 2025-07-18 07:45:00 | SPY | ETF | 628.47 | 628.56 | 628.41 | 628.49 | 11314.0 |
| 2025-07-18 07:50:00 | SPY | ETF | 628.48 | 628.67 | 628.48 | 628.67 | 30535.0 |
| 2025-07-18 07:55:00 | SPY | ETF | 628.67 | 628.67 | 628.48 | 628.48 | 7663.0 |
| 2025-07-18 08:00:00 | SPY | ETF | 629.2 | 629.65 | 628.21 | 628.61 | 54898.0 |
| 2025-07-18 08:05:00 | SPY | ETF | 628.59 | 628.62 | 628.44 | 628.56 | 22762.0 |
| 2025-07-18 08:10:00 | SPY | ETF | 628.5999 | 628.68 | 628.57 | 628.67 | 5969.0 |
| 2025-07-18 08:15:00 | SPY | ETF | 628.58 | 628.8188 | 628.56 | 628.71 | 42105.0 |
> showing 50 of 136,745 rows — these rows as CSV