PREVIEW / etf_5min / 2025-06-18
file: by_date/etf_5min/2025/2025-06-18.parquet size: 2.7 MB rows: 134,365
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-06-18 04:00:00 | SPY | ETF | 599.02 | 599.25 | 598.22 | 599.17 | 3566.0 |
| 2025-06-18 04:05:00 | SPY | ETF | 599.22 | 599.45 | 599.22 | 599.44 | 2700.0 |
| 2025-06-18 04:10:00 | SPY | ETF | 599.38 | 599.47 | 599.18 | 599.22 | 42515.0 |
| 2025-06-18 04:15:00 | SPY | ETF | 599.2 | 599.2 | 599.05 | 599.05 | 1670.0 |
| 2025-06-18 04:20:00 | SPY | ETF | 599.05 | 599.05 | 598.75 | 598.99 | 10396.0 |
| 2025-06-18 04:25:00 | SPY | ETF | 599.1 | 599.1 | 598.92 | 599.06 | 1300.0 |
| 2025-06-18 04:30:00 | SPY | ETF | 598.94 | 599.0 | 598.93 | 598.98 | 930.0 |
| 2025-06-18 04:35:00 | SPY | ETF | 599.07 | 599.07 | 598.95 | 598.95 | 700.0 |
| 2025-06-18 04:40:00 | SPY | ETF | 598.94 | 598.96 | 598.94 | 598.96 | 200.0 |
| 2025-06-18 04:45:00 | SPY | ETF | 599.14 | 599.26 | 599.14 | 599.14 | 3900.0 |
| 2025-06-18 04:50:00 | SPY | ETF | 599.12 | 599.16 | 599.11 | 599.16 | 1371.0 |
| 2025-06-18 04:55:00 | SPY | ETF | 599.29 | 599.43 | 599.27 | 599.35 | 4295.0 |
| 2025-06-18 05:00:00 | SPY | ETF | 599.35 | 600.0 | 599.35 | 599.91 | 12264.0 |
| 2025-06-18 05:05:00 | SPY | ETF | 599.85 | 600.05 | 599.69 | 599.71 | 7489.0 |
| 2025-06-18 05:10:00 | SPY | ETF | 599.64 | 599.65 | 599.6 | 599.64 | 625.0 |
| 2025-06-18 05:15:00 | SPY | ETF | 599.7 | 599.81 | 599.68 | 599.76 | 3090.0 |
| 2025-06-18 05:20:00 | SPY | ETF | 599.74 | 599.74 | 599.53 | 599.53 | 936.0 |
| 2025-06-18 05:25:00 | SPY | ETF | 599.66 | 599.66 | 599.58 | 599.6 | 739.0 |
| 2025-06-18 05:30:00 | SPY | ETF | 599.72 | 599.75 | 599.42 | 599.42 | 4190.0 |
| 2025-06-18 05:35:00 | SPY | ETF | 599.44 | 599.48 | 599.44 | 599.48 | 520.0 |
| 2025-06-18 05:40:00 | SPY | ETF | 599.44 | 599.46 | 599.35 | 599.46 | 2900.0 |
| 2025-06-18 05:45:00 | SPY | ETF | 599.47 | 599.48 | 599.31 | 599.41 | 4916.0 |
| 2025-06-18 05:50:00 | SPY | ETF | 599.42 | 599.58 | 599.4 | 599.45 | 4230.0 |
| 2025-06-18 05:55:00 | SPY | ETF | 599.47 | 599.47 | 599.38 | 599.39 | 767.0 |
| 2025-06-18 06:00:00 | SPY | ETF | 599.31 | 599.31 | 599.14 | 599.17 | 12213.0 |
| 2025-06-18 06:05:00 | SPY | ETF | 599.0 | 599.14 | 598.94 | 598.94 | 53161.0 |
| 2025-06-18 06:10:00 | SPY | ETF | 598.99 | 599.05 | 598.75 | 599.04 | 11880.0 |
| 2025-06-18 06:15:00 | SPY | ETF | 599.04 | 599.2 | 599.04 | 599.15 | 980.0 |
| 2025-06-18 06:20:00 | SPY | ETF | 599.15 | 599.15 | 598.29 | 598.74 | 12594.0 |
| 2025-06-18 06:25:00 | SPY | ETF | 598.82 | 598.88 | 598.57 | 598.61 | 2780.0 |
| 2025-06-18 06:30:00 | SPY | ETF | 598.68 | 598.71 | 598.3 | 598.3 | 8840.0 |
| 2025-06-18 06:35:00 | SPY | ETF | 598.25 | 598.29 | 598.06 | 598.27 | 3700.0 |
| 2025-06-18 06:40:00 | SPY | ETF | 598.29 | 598.66 | 598.21 | 598.43 | 4354.0 |
| 2025-06-18 06:45:00 | SPY | ETF | 598.5 | 598.66 | 598.2 | 598.25 | 2774.0 |
| 2025-06-18 06:50:00 | SPY | ETF | 598.38 | 598.38 | 597.71 | 597.78 | 2590.0 |
| 2025-06-18 06:55:00 | SPY | ETF | 597.73 | 597.75 | 597.41 | 597.5 | 12788.0 |
| 2025-06-18 07:00:00 | SPY | ETF | 597.51 | 597.65 | 597.43 | 597.51 | 40678.0 |
| 2025-06-18 07:05:00 | SPY | ETF | 597.65 | 597.76 | 597.5 | 597.59 | 3566.0 |
| 2025-06-18 07:10:00 | SPY | ETF | 597.53 | 597.88 | 597.39 | 597.75 | 3685.0 |
| 2025-06-18 07:15:00 | SPY | ETF | 597.84 | 597.85 | 597.83 | 597.85 | 300.0 |
| 2025-06-18 07:20:00 | SPY | ETF | 597.6 | 598.02 | 597.6 | 597.959 | 4493.0 |
| 2025-06-18 07:25:00 | SPY | ETF | 597.97 | 598.21 | 597.97 | 598.08 | 6366.0 |
| 2025-06-18 07:30:00 | SPY | ETF | 598.05 | 598.19 | 598.0 | 598.14 | 16701.0 |
| 2025-06-18 07:35:00 | SPY | ETF | 598.2 | 598.3 | 598.02 | 598.02 | 6167.0 |
| 2025-06-18 07:40:00 | SPY | ETF | 598.13 | 598.63 | 598.13 | 598.58 | 10725.0 |
| 2025-06-18 07:45:00 | SPY | ETF | 598.59 | 599.19 | 598.59 | 599.12 | 15876.0 |
| 2025-06-18 07:50:00 | SPY | ETF | 599.07 | 599.07 | 598.89 | 598.91 | 10799.0 |
| 2025-06-18 07:55:00 | SPY | ETF | 598.89 | 598.9 | 598.6 | 598.7 | 10950.0 |
| 2025-06-18 08:00:00 | SPY | ETF | 597.66 | 599.5 | 597.4012 | 598.42 | 62940.0 |
| 2025-06-18 08:05:00 | SPY | ETF | 598.41 | 598.65 | 598.3812 | 598.52 | 7594.0 |
> showing 50 of 134,365 rows — these rows as CSV