PREVIEW / etf_5min / 2025-01-07
file: by_date/etf_5min/2025/2025-01-07.parquet size: 2.7 MB rows: 134,164
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-01-07 04:00:00 | SPY | ETF | 595.67 | 595.83 | 595.56 | 595.83 | 3824.0 |
| 2025-01-07 04:05:00 | SPY | ETF | 595.8 | 595.94 | 595.77 | 595.94 | 1275.0 |
| 2025-01-07 04:10:00 | SPY | ETF | 595.96 | 595.96 | 595.8 | 595.8 | 1070.0 |
| 2025-01-07 04:15:00 | SPY | ETF | 595.71 | 595.71 | 595.59 | 595.68 | 506.0 |
| 2025-01-07 04:20:00 | SPY | ETF | 595.69 | 595.69 | 595.65 | 595.65 | 670.0 |
| 2025-01-07 04:25:00 | SPY | ETF | 595.65 | 595.65 | 595.65 | 595.65 | 184.0 |
| 2025-01-07 04:30:00 | SPY | ETF | 595.69 | 595.69 | 595.61 | 595.65 | 581.0 |
| 2025-01-07 04:35:00 | SPY | ETF | 595.68 | 595.84 | 595.68 | 595.84 | 447.0 |
| 2025-01-07 04:40:00 | SPY | ETF | 595.81 | 595.81 | 595.62 | 595.62 | 1550.0 |
| 2025-01-07 04:45:00 | SPY | ETF | 595.58 | 595.58 | 595.21 | 595.21 | 3368.0 |
| 2025-01-07 04:50:00 | SPY | ETF | 595.27 | 595.38 | 595.11 | 595.38 | 9440.0 |
| 2025-01-07 04:55:00 | SPY | ETF | 595.36 | 595.38 | 595.35 | 595.35 | 1442.0 |
| 2025-01-07 05:00:00 | SPY | ETF | 595.23 | 595.3 | 595.08 | 595.28 | 2907.0 |
| 2025-01-07 05:05:00 | SPY | ETF | 595.41 | 595.47 | 595.41 | 595.47 | 700.0 |
| 2025-01-07 05:10:00 | SPY | ETF | 595.7 | 595.8 | 595.7 | 595.8 | 700.0 |
| 2025-01-07 05:15:00 | SPY | ETF | 595.81 | 595.85 | 595.81 | 595.85 | 3050.0 |
| 2025-01-07 05:20:00 | SPY | ETF | 596.0 | 596.02 | 596.0 | 596.02 | 660.0 |
| 2025-01-07 05:30:00 | SPY | ETF | 595.88 | 596.03 | 595.86 | 596.01 | 3509.0 |
| 2025-01-07 05:35:00 | SPY | ETF | 596.04 | 596.04 | 596.03 | 596.03 | 700.0 |
| 2025-01-07 05:40:00 | SPY | ETF | 596.0 | 596.0 | 595.88 | 595.88 | 295.0 |
| 2025-01-07 05:45:00 | SPY | ETF | 595.79 | 595.79 | 595.78 | 595.79 | 1000.0 |
| 2025-01-07 05:50:00 | SPY | ETF | 595.98 | 596.05 | 595.98 | 596.05 | 1800.0 |
| 2025-01-07 05:55:00 | SPY | ETF | 596.03 | 596.03 | 596.03 | 596.03 | 400.0 |
| 2025-01-07 06:00:00 | SPY | ETF | 596.01 | 596.01 | 595.91 | 595.91 | 200.0 |
| 2025-01-07 06:10:00 | SPY | ETF | 595.84 | 595.84 | 595.84 | 595.84 | 200.0 |
| 2025-01-07 06:15:00 | SPY | ETF | 595.84 | 595.87 | 595.7 | 595.87 | 300.0 |
| 2025-01-07 06:20:00 | SPY | ETF | 595.92 | 595.92 | 595.92 | 595.92 | 199.0 |
| 2025-01-07 06:25:00 | SPY | ETF | 596.09 | 596.15 | 596.09 | 596.15 | 832.0 |
| 2025-01-07 06:30:00 | SPY | ETF | 596.15 | 596.15 | 595.53 | 595.53 | 10391.0 |
| 2025-01-07 06:35:00 | SPY | ETF | 595.57 | 595.6 | 595.45 | 595.6 | 37045.0 |
| 2025-01-07 06:40:00 | SPY | ETF | 595.6 | 595.6 | 595.56 | 595.6 | 17030.0 |
| 2025-01-07 06:45:00 | SPY | ETF | 595.58 | 595.58 | 595.58 | 595.58 | 12833.0 |
| 2025-01-07 06:50:00 | SPY | ETF | 595.59 | 595.7 | 595.59 | 595.61 | 9298.0 |
| 2025-01-07 06:55:00 | SPY | ETF | 595.45 | 595.69 | 595.4 | 595.69 | 2394.0 |
| 2025-01-07 07:00:00 | SPY | ETF | 595.8 | 595.8 | 595.36 | 595.57 | 1470.0 |
| 2025-01-07 07:05:00 | SPY | ETF | 595.71 | 595.79 | 595.64 | 595.67 | 4929.0 |
| 2025-01-07 07:10:00 | SPY | ETF | 595.75 | 595.96 | 595.75 | 595.8 | 6330.0 |
| 2025-01-07 07:15:00 | SPY | ETF | 595.73 | 595.78 | 595.641 | 595.641 | 6335.0 |
| 2025-01-07 07:20:00 | SPY | ETF | 595.83 | 595.83 | 595.75 | 595.77 | 500.0 |
| 2025-01-07 07:25:00 | SPY | ETF | 595.63 | 595.64 | 595.6 | 595.6 | 900.0 |
| 2025-01-07 07:30:00 | SPY | ETF | 595.74 | 596.0 | 595.71 | 596.0 | 12678.0 |
| 2025-01-07 07:35:00 | SPY | ETF | 596.04 | 596.12 | 596.0 | 596.0 | 18482.0 |
| 2025-01-07 07:40:00 | SPY | ETF | 596.05 | 596.34 | 596.05 | 596.29 | 8783.0 |
| 2025-01-07 07:45:00 | SPY | ETF | 596.25 | 596.25 | 596.12 | 596.16 | 16840.0 |
| 2025-01-07 07:50:00 | SPY | ETF | 596.2 | 596.4 | 596.2 | 596.22 | 30959.0 |
| 2025-01-07 07:55:00 | SPY | ETF | 596.22 | 596.22 | 595.77 | 595.81 | 11556.0 |
| 2025-01-07 08:00:00 | SPY | ETF | 595.36 | 596.37 | 594.23 | 595.97 | 27858.0 |
| 2025-01-07 08:05:00 | SPY | ETF | 595.99 | 596.0193 | 595.86 | 595.91 | 2214.0 |
| 2025-01-07 08:10:00 | SPY | ETF | 595.8301 | 596.19 | 595.8301 | 596.13 | 1358.0 |
| 2025-01-07 08:15:00 | SPY | ETF | 596.2 | 596.421 | 596.2 | 596.36 | 16090.0 |
> showing 50 of 134,164 rows — these rows as CSV