PREVIEW / etf_5min / 2025-01-06
file: by_date/etf_5min/2025/2025-01-06.parquet size: 2.8 MB rows: 139,778
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-06 04:00:00 | SPY | ETF | 593.73 | 594.19 | 593.73 | 594.06 | 4375.0 |
| 2025-01-06 04:05:00 | SPY | ETF | 594.0 | 594.07 | 593.97 | 594.07 | 2562.0 |
| 2025-01-06 04:10:00 | SPY | ETF | 594.2 | 594.22 | 594.1 | 594.21 | 1521.0 |
| 2025-01-06 04:15:00 | SPY | ETF | 594.16 | 594.16 | 594.06 | 594.1 | 2980.0 |
| 2025-01-06 04:20:00 | SPY | ETF | 594.17 | 594.34 | 594.17 | 594.29 | 7436.0 |
| 2025-01-06 04:25:00 | SPY | ETF | 594.28 | 594.28 | 594.12 | 594.14 | 2632.0 |
| 2025-01-06 04:30:00 | SPY | ETF | 594.22 | 594.22 | 594.22 | 594.22 | 101.0 |
| 2025-01-06 04:35:00 | SPY | ETF | 594.37 | 594.37 | 594.16 | 594.16 | 1260.0 |
| 2025-01-06 04:40:00 | SPY | ETF | 594.29 | 594.34 | 594.29 | 594.34 | 753.0 |
| 2025-01-06 04:45:00 | SPY | ETF | 594.55 | 594.55 | 594.49 | 594.49 | 480.0 |
| 2025-01-06 04:50:00 | SPY | ETF | 594.59 | 594.66 | 594.59 | 594.66 | 2402.0 |
| 2025-01-06 04:55:00 | SPY | ETF | 594.65 | 594.79 | 594.65 | 594.78 | 2738.0 |
| 2025-01-06 05:00:00 | SPY | ETF | 594.77 | 594.77 | 594.53 | 594.59 | 798.0 |
| 2025-01-06 05:05:00 | SPY | ETF | 594.7 | 594.7 | 594.7 | 594.7 | 100.0 |
| 2025-01-06 05:10:00 | SPY | ETF | 594.69 | 594.82 | 594.69 | 594.82 | 680.0 |
| 2025-01-06 05:15:00 | SPY | ETF | 594.75 | 595.21 | 594.75 | 595.14 | 4700.0 |
| 2025-01-06 05:20:00 | SPY | ETF | 594.96 | 595.09 | 594.94 | 595.09 | 1331.0 |
| 2025-01-06 05:25:00 | SPY | ETF | 595.0 | 595.0 | 594.93 | 594.94 | 1123.0 |
| 2025-01-06 05:30:00 | SPY | ETF | 594.85 | 594.85 | 594.63 | 594.77 | 969.0 |
| 2025-01-06 05:35:00 | SPY | ETF | 594.78 | 594.81 | 594.59 | 594.81 | 978.0 |
| 2025-01-06 05:40:00 | SPY | ETF | 594.75 | 594.85 | 594.71 | 594.71 | 600.0 |
| 2025-01-06 05:45:00 | SPY | ETF | 594.66 | 594.66 | 594.44 | 594.46 | 2970.0 |
| 2025-01-06 05:55:00 | SPY | ETF | 594.52 | 594.52 | 594.52 | 594.52 | 100.0 |
| 2025-01-06 06:00:00 | SPY | ETF | 594.37 | 594.37 | 593.87 | 594.29 | 8100.0 |
| 2025-01-06 06:05:00 | SPY | ETF | 594.34 | 594.67 | 594.34 | 594.47 | 1776.0 |
| 2025-01-06 06:10:00 | SPY | ETF | 594.69 | 594.77 | 594.69 | 594.77 | 200.0 |
| 2025-01-06 06:15:00 | SPY | ETF | 595.05 | 595.09 | 594.87 | 595.09 | 5300.0 |
| 2025-01-06 06:20:00 | SPY | ETF | 595.12 | 595.4 | 595.11 | 595.4 | 15166.0 |
| 2025-01-06 06:25:00 | SPY | ETF | 595.64 | 595.9 | 595.57 | 595.9 | 8090.0 |
| 2025-01-06 06:30:00 | SPY | ETF | 595.9 | 596.17 | 595.76 | 595.83 | 14221.0 |
| 2025-01-06 06:35:00 | SPY | ETF | 595.79 | 596.27 | 595.79 | 596.18 | 1379.0 |
| 2025-01-06 06:40:00 | SPY | ETF | 596.08 | 596.13 | 596.0 | 596.0 | 3817.0 |
| 2025-01-06 06:45:00 | SPY | ETF | 596.0 | 596.04 | 595.81 | 595.86 | 19429.0 |
| 2025-01-06 06:50:00 | SPY | ETF | 595.8 | 596.11 | 595.7 | 596.11 | 5024.0 |
| 2025-01-06 06:55:00 | SPY | ETF | 596.2 | 596.2 | 596.14 | 596.19 | 2643.0 |
| 2025-01-06 07:00:00 | SPY | ETF | 596.24 | 596.35 | 596.02 | 596.29 | 46163.0 |
| 2025-01-06 07:05:00 | SPY | ETF | 596.29 | 596.3 | 596.01 | 596.01 | 7588.0 |
| 2025-01-06 07:10:00 | SPY | ETF | 596.0 | 596.07 | 595.86 | 595.97 | 13738.0 |
| 2025-01-06 07:15:00 | SPY | ETF | 596.04 | 596.23 | 595.9 | 596.07 | 3950.0 |
| 2025-01-06 07:20:00 | SPY | ETF | 596.115 | 596.31 | 595.96 | 596.295 | 10698.0 |
| 2025-01-06 07:25:00 | SPY | ETF | 596.3 | 596.35 | 596.11 | 596.27 | 12741.0 |
| 2025-01-06 07:30:00 | SPY | ETF | 596.23 | 596.341 | 596.07 | 596.15 | 17074.0 |
| 2025-01-06 07:35:00 | SPY | ETF | 596.05 | 596.34 | 596.05 | 596.29 | 4729.0 |
| 2025-01-06 07:40:00 | SPY | ETF | 596.36 | 596.42 | 596.29 | 596.41 | 4623.0 |
| 2025-01-06 07:45:00 | SPY | ETF | 596.48 | 596.95 | 596.43 | 596.84 | 12752.0 |
| 2025-01-06 07:50:00 | SPY | ETF | 596.87 | 596.95 | 596.55 | 596.59 | 26634.0 |
| 2025-01-06 07:55:00 | SPY | ETF | 596.611 | 596.611 | 596.43 | 596.5 | 8132.0 |
| 2025-01-06 08:00:00 | SPY | ETF | 596.23 | 596.88 | 591.89 | 596.57 | 74385.0 |
| 2025-01-06 08:05:00 | SPY | ETF | 596.55 | 596.66 | 596.46 | 596.57 | 28135.0 |
| 2025-01-06 08:10:00 | SPY | ETF | 596.57 | 596.57 | 596.32 | 596.3842 | 5032.0 |
> showing 50 of 139,778 rows — these rows as CSV