PREVIEW / etf_5min / 2025-01-13
file: by_date/etf_5min/2025/2025-01-13.parquet size: 2.8 MB rows: 137,312
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-13 04:00:00 | SPY | ETF | 578.23 | 578.23 | 575.09 | 575.38 | 17652.0 |
| 2025-01-13 04:05:00 | SPY | ETF | 575.48 | 575.72 | 575.21 | 575.68 | 2481.0 |
| 2025-01-13 04:10:00 | SPY | ETF | 575.41 | 575.57 | 575.29 | 575.57 | 2570.0 |
| 2025-01-13 04:15:00 | SPY | ETF | 575.38 | 575.47 | 575.18 | 575.47 | 856.0 |
| 2025-01-13 04:20:00 | SPY | ETF | 575.45 | 575.81 | 575.34 | 575.34 | 1960.0 |
| 2025-01-13 04:25:00 | SPY | ETF | 575.14 | 575.25 | 575.14 | 575.25 | 3434.0 |
| 2025-01-13 04:30:00 | SPY | ETF | 575.07 | 575.28 | 575.07 | 575.15 | 2559.0 |
| 2025-01-13 04:35:00 | SPY | ETF | 575.23 | 575.55 | 575.23 | 575.47 | 1008.0 |
| 2025-01-13 04:40:00 | SPY | ETF | 575.73 | 575.73 | 575.12 | 575.12 | 1829.0 |
| 2025-01-13 04:45:00 | SPY | ETF | 575.25 | 575.47 | 575.22 | 575.44 | 9985.0 |
| 2025-01-13 04:50:00 | SPY | ETF | 575.1 | 575.17 | 575.08 | 575.11 | 3727.0 |
| 2025-01-13 04:55:00 | SPY | ETF | 575.05 | 575.25 | 575.04 | 575.25 | 800.0 |
| 2025-01-13 05:00:00 | SPY | ETF | 575.33 | 575.33 | 575.3 | 575.3 | 200.0 |
| 2025-01-13 05:05:00 | SPY | ETF | 575.2 | 575.23 | 575.2 | 575.23 | 1670.0 |
| 2025-01-13 05:10:00 | SPY | ETF | 575.23 | 575.52 | 575.2 | 575.5 | 3418.0 |
| 2025-01-13 05:15:00 | SPY | ETF | 575.51 | 575.52 | 575.51 | 575.52 | 2233.0 |
| 2025-01-13 05:20:00 | SPY | ETF | 575.53 | 575.56 | 575.44 | 575.44 | 1500.0 |
| 2025-01-13 05:25:00 | SPY | ETF | 575.64 | 575.64 | 575.64 | 575.64 | 100.0 |
| 2025-01-13 05:30:00 | SPY | ETF | 575.76 | 575.8 | 575.74 | 575.74 | 400.0 |
| 2025-01-13 05:35:00 | SPY | ETF | 575.97 | 576.16 | 575.97 | 576.16 | 751.0 |
| 2025-01-13 05:40:00 | SPY | ETF | 575.94 | 575.94 | 575.94 | 575.94 | 100.0 |
| 2025-01-13 05:45:00 | SPY | ETF | 576.02 | 576.02 | 576.02 | 576.02 | 160.0 |
| 2025-01-13 05:50:00 | SPY | ETF | 576.13 | 576.13 | 575.85 | 575.85 | 473.0 |
| 2025-01-13 05:55:00 | SPY | ETF | 575.67 | 575.79 | 575.53 | 575.7 | 600.0 |
| 2025-01-13 06:00:00 | SPY | ETF | 575.5 | 576.1 | 575.5 | 576.1 | 2606.0 |
| 2025-01-13 06:05:00 | SPY | ETF | 576.23 | 576.23 | 575.87 | 575.91 | 3222.0 |
| 2025-01-13 06:10:00 | SPY | ETF | 575.63 | 575.75 | 575.56 | 575.75 | 664.0 |
| 2025-01-13 06:15:00 | SPY | ETF | 575.89 | 575.98 | 575.8 | 575.8 | 1597.0 |
| 2025-01-13 06:20:00 | SPY | ETF | 575.99 | 575.99 | 575.9 | 575.9 | 4980.0 |
| 2025-01-13 06:25:00 | SPY | ETF | 575.84 | 575.93 | 575.84 | 575.92 | 3699.0 |
| 2025-01-13 06:30:00 | SPY | ETF | 575.76 | 575.93 | 575.76 | 575.93 | 1300.0 |
| 2025-01-13 06:35:00 | SPY | ETF | 576.08 | 576.2 | 576.01 | 576.13 | 5794.0 |
| 2025-01-13 06:40:00 | SPY | ETF | 576.0 | 576.0 | 576.0 | 576.0 | 100.0 |
| 2025-01-13 06:45:00 | SPY | ETF | 575.9 | 575.98 | 575.9 | 575.94 | 479.0 |
| 2025-01-13 06:50:00 | SPY | ETF | 576.07 | 576.07 | 576.0 | 576.0 | 200.0 |
| 2025-01-13 06:55:00 | SPY | ETF | 576.16 | 576.18 | 575.97 | 575.97 | 1004.0 |
| 2025-01-13 07:00:00 | SPY | ETF | 576.02 | 576.4 | 575.58 | 575.6 | 28558.0 |
| 2025-01-13 07:05:00 | SPY | ETF | 575.61 | 575.7 | 575.3 | 575.3 | 9577.0 |
| 2025-01-13 07:10:00 | SPY | ETF | 575.36 | 575.77 | 575.36 | 575.55 | 16572.0 |
| 2025-01-13 07:15:00 | SPY | ETF | 575.32 | 575.88 | 575.32 | 575.88 | 25903.0 |
| 2025-01-13 07:20:00 | SPY | ETF | 575.93 | 576.49 | 575.93 | 576.49 | 27562.0 |
| 2025-01-13 07:25:00 | SPY | ETF | 576.46 | 576.67 | 576.12 | 576.2 | 18710.0 |
| 2025-01-13 07:30:00 | SPY | ETF | 576.3 | 576.54 | 576.12 | 576.47 | 10334.0 |
| 2025-01-13 07:35:00 | SPY | ETF | 576.39 | 576.98 | 576.35 | 576.88 | 60641.0 |
| 2025-01-13 07:40:00 | SPY | ETF | 576.92 | 577.15 | 576.87 | 577.11 | 20354.0 |
| 2025-01-13 07:45:00 | SPY | ETF | 577.15 | 577.25 | 576.88 | 577.0 | 20882.0 |
| 2025-01-13 07:50:00 | SPY | ETF | 577.0 | 577.48 | 577.0 | 577.0 | 38362.0 |
| 2025-01-13 07:55:00 | SPY | ETF | 577.0 | 577.16 | 576.88 | 576.94 | 23319.0 |
| 2025-01-13 08:00:00 | SPY | ETF | 575.8 | 578.77 | 575.3196 | 576.9399 | 59145.0 |
| 2025-01-13 08:05:00 | SPY | ETF | 576.8 | 576.829 | 576.42 | 576.7099 | 7499.0 |
> showing 50 of 137,312 rows — these rows as CSV