PREVIEW / etf_5min / 2025-07-30
file: by_date/etf_5min/2025/2025-07-30.parquet size: 2.9 MB rows: 143,768
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-30 04:00:00 | SPY | ETF | 636.04 | 636.3 | 636.04 | 636.3 | 2680.0 |
| 2025-07-30 04:05:00 | SPY | ETF | 636.17 | 636.17 | 636.04 | 636.04 | 2801.0 |
| 2025-07-30 04:10:00 | SPY | ETF | 635.94 | 636.03 | 635.92 | 636.0 | 1600.0 |
| 2025-07-30 04:15:00 | SPY | ETF | 635.96 | 635.97 | 635.93 | 635.94 | 1797.0 |
| 2025-07-30 04:20:00 | SPY | ETF | 635.9 | 635.9 | 635.74 | 635.77 | 1197.0 |
| 2025-07-30 04:25:00 | SPY | ETF | 635.8 | 635.8 | 635.7 | 635.7 | 200.0 |
| 2025-07-30 04:30:00 | SPY | ETF | 635.59 | 635.6 | 635.29 | 635.29 | 1100.0 |
| 2025-07-30 04:35:00 | SPY | ETF | 635.54 | 635.69 | 635.54 | 635.69 | 2215.0 |
| 2025-07-30 04:40:00 | SPY | ETF | 635.74 | 635.74 | 635.71 | 635.71 | 300.0 |
| 2025-07-30 04:45:00 | SPY | ETF | 635.79 | 635.79 | 635.79 | 635.79 | 600.0 |
| 2025-07-30 04:55:00 | SPY | ETF | 635.78 | 635.78 | 635.77 | 635.77 | 400.0 |
| 2025-07-30 05:00:00 | SPY | ETF | 635.78 | 635.82 | 635.65 | 635.77 | 3352.0 |
| 2025-07-30 05:05:00 | SPY | ETF | 635.74 | 635.87 | 635.73 | 635.87 | 1991.0 |
| 2025-07-30 05:10:00 | SPY | ETF | 635.81 | 635.86 | 635.8 | 635.85 | 1100.0 |
| 2025-07-30 05:15:00 | SPY | ETF | 635.86 | 636.04 | 635.86 | 636.04 | 800.0 |
| 2025-07-30 05:20:00 | SPY | ETF | 635.81 | 635.86 | 635.81 | 635.81 | 900.0 |
| 2025-07-30 05:25:00 | SPY | ETF | 635.84 | 635.84 | 635.84 | 635.84 | 100.0 |
| 2025-07-30 05:30:00 | SPY | ETF | 635.76 | 635.76 | 635.61 | 635.61 | 395.0 |
| 2025-07-30 05:40:00 | SPY | ETF | 635.6 | 635.6 | 635.6 | 635.6 | 100.0 |
| 2025-07-30 05:45:00 | SPY | ETF | 635.64 | 635.66 | 635.64 | 635.66 | 401.0 |
| 2025-07-30 05:50:00 | SPY | ETF | 635.61 | 635.63 | 635.61 | 635.63 | 200.0 |
| 2025-07-30 05:55:00 | SPY | ETF | 635.65 | 635.98 | 635.65 | 635.98 | 1098.0 |
| 2025-07-30 06:00:00 | SPY | ETF | 636.05 | 636.09 | 635.97 | 635.97 | 5570.0 |
| 2025-07-30 06:05:00 | SPY | ETF | 635.94 | 636.01 | 635.94 | 635.94 | 2500.0 |
| 2025-07-30 06:10:00 | SPY | ETF | 635.98 | 636.1 | 635.98 | 636.04 | 1100.0 |
| 2025-07-30 06:15:00 | SPY | ETF | 636.06 | 636.06 | 636.01 | 636.01 | 230.0 |
| 2025-07-30 06:20:00 | SPY | ETF | 636.08 | 636.08 | 636.08 | 636.08 | 300.0 |
| 2025-07-30 06:25:00 | SPY | ETF | 635.9 | 635.96 | 635.9 | 635.96 | 600.0 |
| 2025-07-30 06:30:00 | SPY | ETF | 635.98 | 636.02 | 635.97 | 635.97 | 500.0 |
| 2025-07-30 06:35:00 | SPY | ETF | 635.94 | 636.09 | 635.94 | 636.09 | 1215.0 |
| 2025-07-30 06:40:00 | SPY | ETF | 636.07 | 636.08 | 636.04 | 636.08 | 1200.0 |
| 2025-07-30 06:45:00 | SPY | ETF | 636.05 | 636.1 | 636.05 | 636.1 | 780.0 |
| 2025-07-30 06:50:00 | SPY | ETF | 636.0 | 636.01 | 635.96 | 635.99 | 1395.0 |
| 2025-07-30 06:55:00 | SPY | ETF | 636.01 | 636.11 | 636.01 | 636.11 | 400.0 |
| 2025-07-30 07:00:00 | SPY | ETF | 636.16 | 636.18 | 636.04 | 636.16 | 16915.0 |
| 2025-07-30 07:05:00 | SPY | ETF | 636.18 | 636.18 | 636.07 | 636.14 | 37538.0 |
| 2025-07-30 07:10:00 | SPY | ETF | 636.19 | 636.25 | 636.15 | 636.15 | 1650.0 |
| 2025-07-30 07:15:00 | SPY | ETF | 636.09 | 636.16 | 636.0 | 636.0 | 14099.0 |
| 2025-07-30 07:20:00 | SPY | ETF | 636.11 | 636.14 | 636.08 | 636.1 | 6214.0 |
| 2025-07-30 07:25:00 | SPY | ETF | 636.1 | 636.29 | 636.1 | 636.2 | 2486.0 |
| 2025-07-30 07:30:00 | SPY | ETF | 636.22 | 636.29 | 636.18 | 636.29 | 5804.0 |
| 2025-07-30 07:35:00 | SPY | ETF | 636.29 | 636.34 | 636.29 | 636.29 | 680.0 |
| 2025-07-30 07:40:00 | SPY | ETF | 636.29 | 636.32 | 636.01 | 636.13 | 31795.0 |
| 2025-07-30 07:45:00 | SPY | ETF | 636.12 | 636.4 | 636.12 | 636.39 | 17533.0 |
| 2025-07-30 07:50:00 | SPY | ETF | 636.39 | 636.5 | 636.18 | 636.25 | 38508.0 |
| 2025-07-30 07:55:00 | SPY | ETF | 636.19 | 636.29 | 636.18 | 636.21 | 20650.0 |
| 2025-07-30 08:00:00 | SPY | ETF | 636.12 | 636.39 | 635.58 | 636.0699 | 45741.0 |
| 2025-07-30 08:05:00 | SPY | ETF | 636.05 | 636.08 | 635.51 | 635.57 | 25864.0 |
| 2025-07-30 08:10:00 | SPY | ETF | 635.55 | 636.01 | 635.37 | 635.94 | 32656.0 |
| 2025-07-30 08:15:00 | SPY | ETF | 635.94 | 636.23 | 635.67 | 635.87 | 23869.0 |
> showing 50 of 143,768 rows — these rows as CSV