PREVIEW / etf_5min / 2025-11-18
file: by_date/etf_5min/2025/2025-11-18.parquet size: 3.2 MB rows: 158,310
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-11-18 04:00:00 | SPY | ETF | 663.96 | 664.06 | 663.39 | 663.57 | 5555.0 |
| 2025-11-18 04:05:00 | SPY | ETF | 663.71 | 663.86 | 663.33 | 663.67 | 7784.0 |
| 2025-11-18 04:10:00 | SPY | ETF | 663.67 | 664.33 | 663.46 | 664.33 | 8259.0 |
| 2025-11-18 04:15:00 | SPY | ETF | 664.58 | 664.85 | 664.58 | 664.58 | 1120.0 |
| 2025-11-18 04:20:00 | SPY | ETF | 664.5 | 664.5 | 663.8 | 663.9 | 2664.0 |
| 2025-11-18 04:25:00 | SPY | ETF | 663.73 | 663.91 | 663.64 | 663.8 | 2213.0 |
| 2025-11-18 04:30:00 | SPY | ETF | 663.74 | 664.21 | 663.58 | 663.8 | 4169.0 |
| 2025-11-18 04:35:00 | SPY | ETF | 663.68 | 663.78 | 663.2 | 663.45 | 5321.0 |
| 2025-11-18 04:40:00 | SPY | ETF | 663.39 | 663.75 | 663.2 | 663.75 | 3146.0 |
| 2025-11-18 04:45:00 | SPY | ETF | 663.75 | 663.91 | 663.61 | 663.7 | 1595.0 |
| 2025-11-18 04:50:00 | SPY | ETF | 663.9 | 664.42 | 663.9 | 664.26 | 4834.0 |
| 2025-11-18 04:55:00 | SPY | ETF | 664.33 | 664.68 | 664.32 | 664.61 | 3035.0 |
| 2025-11-18 05:00:00 | SPY | ETF | 664.45 | 664.62 | 664.27 | 664.37 | 2056.0 |
| 2025-11-18 05:05:00 | SPY | ETF | 664.42 | 664.54 | 664.0 | 664.0 | 719.0 |
| 2025-11-18 05:10:00 | SPY | ETF | 663.76 | 663.82 | 663.59 | 663.59 | 2402.0 |
| 2025-11-18 05:15:00 | SPY | ETF | 663.54 | 663.98 | 663.54 | 663.98 | 475.0 |
| 2025-11-18 05:20:00 | SPY | ETF | 663.93 | 663.97 | 663.6 | 663.64 | 3197.0 |
| 2025-11-18 05:25:00 | SPY | ETF | 663.63 | 663.76 | 663.63 | 663.67 | 564.0 |
| 2025-11-18 05:30:00 | SPY | ETF | 663.7 | 664.2 | 663.65 | 664.05 | 4455.0 |
| 2025-11-18 05:35:00 | SPY | ETF | 663.7 | 663.89 | 663.62 | 663.62 | 1931.0 |
| 2025-11-18 05:40:00 | SPY | ETF | 663.61 | 663.69 | 663.48 | 663.59 | 999.0 |
| 2025-11-18 05:45:00 | SPY | ETF | 663.89 | 663.89 | 663.7 | 663.7 | 283.0 |
| 2025-11-18 05:50:00 | SPY | ETF | 663.88 | 664.17 | 663.85 | 664.17 | 778.0 |
| 2025-11-18 05:55:00 | SPY | ETF | 664.22 | 664.63 | 664.22 | 664.37 | 1667.0 |
| 2025-11-18 06:00:00 | SPY | ETF | 664.4 | 664.43 | 664.2 | 664.43 | 4592.0 |
| 2025-11-18 06:05:00 | SPY | ETF | 664.35 | 664.59 | 663.87 | 663.87 | 3416.0 |
| 2025-11-18 06:10:00 | SPY | ETF | 663.86 | 663.89 | 663.6 | 663.7 | 1844.0 |
| 2025-11-18 06:15:00 | SPY | ETF | 663.44 | 663.61 | 663.44 | 663.55 | 2114.0 |
| 2025-11-18 06:20:00 | SPY | ETF | 663.5 | 664.18 | 663.5 | 664.18 | 1435.0 |
| 2025-11-18 06:25:00 | SPY | ETF | 664.06 | 664.06 | 663.69 | 663.89 | 2012.0 |
| 2025-11-18 06:30:00 | SPY | ETF | 663.76 | 663.76 | 663.17 | 663.3 | 3157.0 |
| 2025-11-18 06:35:00 | SPY | ETF | 663.25 | 663.4 | 662.99 | 663.17 | 4744.0 |
| 2025-11-18 06:40:00 | SPY | ETF | 663.09 | 663.61 | 663.01 | 663.23 | 7233.0 |
| 2025-11-18 06:45:00 | SPY | ETF | 663.25 | 663.6 | 663.12 | 663.37 | 2452.0 |
| 2025-11-18 06:50:00 | SPY | ETF | 663.25 | 663.5 | 663.06 | 663.5 | 7661.0 |
| 2025-11-18 06:55:00 | SPY | ETF | 663.51 | 663.85 | 663.51 | 663.85 | 3453.0 |
| 2025-11-18 07:00:00 | SPY | ETF | 663.88 | 663.92 | 662.39 | 662.45 | 34701.0 |
| 2025-11-18 07:05:00 | SPY | ETF | 662.45 | 662.72 | 662.18 | 662.32 | 39438.0 |
| 2025-11-18 07:10:00 | SPY | ETF | 662.43 | 662.51 | 661.84 | 661.96 | 56308.0 |
| 2025-11-18 07:15:00 | SPY | ETF | 661.92 | 662.96 | 661.89 | 662.95 | 22239.0 |
| 2025-11-18 07:20:00 | SPY | ETF | 662.99 | 663.07 | 662.65 | 662.65 | 15595.0 |
| 2025-11-18 07:25:00 | SPY | ETF | 662.54 | 662.56 | 662.06 | 662.13 | 31780.0 |
| 2025-11-18 07:30:00 | SPY | ETF | 662.19 | 662.6 | 662.07 | 662.4 | 11193.0 |
| 2025-11-18 07:35:00 | SPY | ETF | 662.41 | 662.91 | 662.1 | 662.63 | 23678.0 |
| 2025-11-18 07:40:00 | SPY | ETF | 662.7 | 662.7 | 662.13 | 662.25 | 22239.0 |
| 2025-11-18 07:45:00 | SPY | ETF | 662.19 | 662.32 | 661.49 | 661.931 | 49161.0 |
| 2025-11-18 07:50:00 | SPY | ETF | 661.96 | 662.0 | 661.55 | 661.6 | 133149.0 |
| 2025-11-18 07:55:00 | SPY | ETF | 661.67 | 661.68 | 660.5 | 661.4 | 133036.0 |
| 2025-11-18 08:00:00 | SPY | ETF | 665.5674 | 665.5674 | 660.05 | 662.64 | 161921.0 |
| 2025-11-18 08:05:00 | SPY | ETF | 662.65 | 662.85 | 662.24 | 662.71 | 135010.0 |
> showing 50 of 158,310 rows — these rows as CSV