PREVIEW / etf_5min / 2025-10-20
file: by_date/etf_5min/2025/2025-10-20.parquet size: 3.0 MB rows: 151,668
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-10-20 04:00:00 | SPY | ETF | 666.0 | 667.21 | 666.0 | 667.21 | 7021.0 |
| 2025-10-20 04:05:00 | SPY | ETF | 667.0 | 667.0 | 667.0 | 667.0 | 100.0 |
| 2025-10-20 04:10:00 | SPY | ETF | 666.81 | 666.84 | 666.64 | 666.84 | 1000.0 |
| 2025-10-20 04:15:00 | SPY | ETF | 666.94 | 666.95 | 666.5 | 666.5 | 1430.0 |
| 2025-10-20 04:20:00 | SPY | ETF | 666.5 | 666.59 | 666.42 | 666.55 | 2727.0 |
| 2025-10-20 04:25:00 | SPY | ETF | 666.51 | 666.64 | 666.47 | 666.64 | 1970.0 |
| 2025-10-20 04:30:00 | SPY | ETF | 666.64 | 666.76 | 666.62 | 666.64 | 1425.0 |
| 2025-10-20 04:35:00 | SPY | ETF | 666.64 | 666.68 | 666.4 | 666.42 | 24501.0 |
| 2025-10-20 04:40:00 | SPY | ETF | 666.37 | 666.58 | 666.29 | 666.29 | 2071.0 |
| 2025-10-20 04:45:00 | SPY | ETF | 666.46 | 666.54 | 666.06 | 666.06 | 2920.0 |
| 2025-10-20 04:50:00 | SPY | ETF | 666.1 | 666.19 | 666.0 | 666.05 | 2549.0 |
| 2025-10-20 04:55:00 | SPY | ETF | 666.14 | 666.15 | 666.14 | 666.15 | 845.0 |
| 2025-10-20 05:00:00 | SPY | ETF | 666.05 | 666.13 | 665.81 | 666.13 | 2406.0 |
| 2025-10-20 05:05:00 | SPY | ETF | 666.06 | 666.14 | 665.93 | 666.14 | 1335.0 |
| 2025-10-20 05:10:00 | SPY | ETF | 666.33 | 666.33 | 666.2 | 666.2 | 542.0 |
| 2025-10-20 05:15:00 | SPY | ETF | 666.36 | 666.43 | 666.27 | 666.35 | 2743.0 |
| 2025-10-20 05:20:00 | SPY | ETF | 666.56 | 666.58 | 666.36 | 666.58 | 3051.0 |
| 2025-10-20 05:25:00 | SPY | ETF | 666.58 | 666.6 | 666.47 | 666.47 | 1700.0 |
| 2025-10-20 05:30:00 | SPY | ETF | 666.53 | 666.53 | 666.38 | 666.38 | 600.0 |
| 2025-10-20 05:35:00 | SPY | ETF | 666.32 | 666.32 | 666.16 | 666.16 | 305.0 |
| 2025-10-20 05:40:00 | SPY | ETF | 666.23 | 666.23 | 666.03 | 666.12 | 600.0 |
| 2025-10-20 05:45:00 | SPY | ETF | 666.13 | 666.13 | 665.89 | 665.98 | 400.0 |
| 2025-10-20 05:50:00 | SPY | ETF | 665.91 | 666.02 | 665.91 | 666.01 | 834.0 |
| 2025-10-20 05:55:00 | SPY | ETF | 666.29 | 666.29 | 666.29 | 666.29 | 200.0 |
| 2025-10-20 06:00:00 | SPY | ETF | 666.32 | 666.49 | 666.31 | 666.39 | 1023.0 |
| 2025-10-20 06:05:00 | SPY | ETF | 666.01 | 666.02 | 665.94 | 665.95 | 1542.0 |
| 2025-10-20 06:10:00 | SPY | ETF | 666.08 | 666.08 | 666.08 | 666.08 | 100.0 |
| 2025-10-20 06:15:00 | SPY | ETF | 666.11 | 666.12 | 666.11 | 666.12 | 682.0 |
| 2025-10-20 06:20:00 | SPY | ETF | 666.09 | 666.11 | 666.07 | 666.07 | 310.0 |
| 2025-10-20 06:25:00 | SPY | ETF | 666.03 | 666.03 | 665.95 | 665.98 | 380.0 |
| 2025-10-20 06:30:00 | SPY | ETF | 666.1 | 666.48 | 666.1 | 666.48 | 1105.0 |
| 2025-10-20 06:35:00 | SPY | ETF | 666.54 | 666.59 | 666.51 | 666.51 | 1646.0 |
| 2025-10-20 06:40:00 | SPY | ETF | 666.69 | 666.72 | 666.0 | 666.0 | 1880.0 |
| 2025-10-20 06:45:00 | SPY | ETF | 666.0 | 666.0 | 665.35 | 665.62 | 14879.0 |
| 2025-10-20 06:50:00 | SPY | ETF | 665.63 | 665.63 | 665.22 | 665.5 | 4789.0 |
| 2025-10-20 06:55:00 | SPY | ETF | 665.54 | 665.61 | 665.52 | 665.52 | 1626.0 |
| 2025-10-20 07:00:00 | SPY | ETF | 665.29 | 665.66 | 665.27 | 665.5 | 9221.0 |
| 2025-10-20 07:05:00 | SPY | ETF | 665.47 | 665.76 | 665.43 | 665.76 | 1732.0 |
| 2025-10-20 07:10:00 | SPY | ETF | 665.75 | 666.0 | 665.74 | 665.94 | 12375.0 |
| 2025-10-20 07:15:00 | SPY | ETF | 665.95 | 666.19 | 665.89 | 666.08 | 6847.0 |
| 2025-10-20 07:20:00 | SPY | ETF | 666.04 | 666.06 | 665.98 | 666.02 | 2090.0 |
| 2025-10-20 07:25:00 | SPY | ETF | 666.07 | 666.24 | 666.07 | 666.17 | 29408.0 |
| 2025-10-20 07:30:00 | SPY | ETF | 666.05 | 666.07 | 665.89 | 666.01 | 28185.0 |
| 2025-10-20 07:35:00 | SPY | ETF | 666.03 | 666.08 | 665.99 | 665.99 | 1550.0 |
| 2025-10-20 07:40:00 | SPY | ETF | 666.09 | 666.09 | 665.851 | 665.871 | 8103.0 |
| 2025-10-20 07:45:00 | SPY | ETF | 665.92 | 666.01 | 665.91 | 665.96 | 5507.0 |
| 2025-10-20 07:50:00 | SPY | ETF | 665.96 | 666.44 | 665.96 | 666.43 | 29307.0 |
| 2025-10-20 07:55:00 | SPY | ETF | 666.42 | 666.47 | 666.35 | 666.36 | 8353.0 |
| 2025-10-20 08:00:00 | SPY | ETF | 666.35 | 667.58 | 665.2791 | 666.23 | 55029.0 |
| 2025-10-20 08:05:00 | SPY | ETF | 666.2874 | 666.29 | 666.12 | 666.29 | 5266.0 |
> showing 50 of 151,668 rows — these rows as CSV