PREVIEW / etf_5min / 2024-12-26
file: by_date/etf_5min/2024/2024-12-26.parquet size: 2.4 MB rows: 122,693
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 |
|---|---|---|---|---|---|---|---|
| 2024-12-26 04:00:00 | SPY | ETF | 600.5 | 600.5 | 599.74 | 599.74 | 13265.0 |
| 2024-12-26 04:05:00 | SPY | ETF | 599.65 | 599.93 | 599.64 | 599.91 | 3423.0 |
| 2024-12-26 04:10:00 | SPY | ETF | 599.84 | 599.84 | 599.41 | 599.47 | 11048.0 |
| 2024-12-26 04:15:00 | SPY | ETF | 599.44 | 599.74 | 599.44 | 599.5 | 1440.0 |
| 2024-12-26 04:20:00 | SPY | ETF | 599.36 | 599.53 | 599.36 | 599.53 | 264.0 |
| 2024-12-26 04:25:00 | SPY | ETF | 599.4 | 599.6 | 599.4 | 599.5 | 3551.0 |
| 2024-12-26 04:30:00 | SPY | ETF | 599.59 | 599.9 | 599.56 | 599.81 | 1937.0 |
| 2024-12-26 04:35:00 | SPY | ETF | 599.87 | 599.87 | 599.7 | 599.81 | 647.0 |
| 2024-12-26 04:40:00 | SPY | ETF | 599.84 | 599.84 | 599.75 | 599.75 | 200.0 |
| 2024-12-26 04:50:00 | SPY | ETF | 599.6 | 599.6 | 599.0 | 599.0 | 2280.0 |
| 2024-12-26 04:55:00 | SPY | ETF | 599.1 | 599.25 | 599.1 | 599.18 | 1853.0 |
| 2024-12-26 05:00:00 | SPY | ETF | 598.93 | 598.93 | 598.57 | 598.57 | 2753.0 |
| 2024-12-26 05:05:00 | SPY | ETF | 598.54 | 598.67 | 598.54 | 598.59 | 480.0 |
| 2024-12-26 05:10:00 | SPY | ETF | 598.65 | 598.67 | 598.59 | 598.6 | 599.0 |
| 2024-12-26 05:15:00 | SPY | ETF | 598.73 | 598.85 | 598.65 | 598.85 | 1296.0 |
| 2024-12-26 05:20:00 | SPY | ETF | 598.88 | 598.88 | 598.68 | 598.68 | 789.0 |
| 2024-12-26 05:30:00 | SPY | ETF | 598.77 | 598.77 | 598.77 | 598.77 | 104.0 |
| 2024-12-26 05:35:00 | SPY | ETF | 598.94 | 598.97 | 598.94 | 598.97 | 1274.0 |
| 2024-12-26 05:40:00 | SPY | ETF | 598.95 | 598.95 | 598.95 | 598.95 | 3000.0 |
| 2024-12-26 05:45:00 | SPY | ETF | 598.91 | 599.05 | 598.91 | 599.05 | 705.0 |
| 2024-12-26 05:50:00 | SPY | ETF | 598.79 | 598.8 | 598.76 | 598.79 | 3918.0 |
| 2024-12-26 05:55:00 | SPY | ETF | 598.95 | 598.95 | 598.95 | 598.95 | 472.0 |
| 2024-12-26 06:00:00 | SPY | ETF | 598.72 | 598.81 | 598.62 | 598.81 | 1382.0 |
| 2024-12-26 06:05:00 | SPY | ETF | 598.78 | 598.78 | 598.65 | 598.65 | 721.0 |
| 2024-12-26 06:10:00 | SPY | ETF | 598.74 | 598.75 | 598.6 | 598.6 | 1800.0 |
| 2024-12-26 06:15:00 | SPY | ETF | 598.35 | 598.4 | 598.35 | 598.4 | 2100.0 |
| 2024-12-26 06:20:00 | SPY | ETF | 598.38 | 598.69 | 598.38 | 598.64 | 600.0 |
| 2024-12-26 06:25:00 | SPY | ETF | 598.87 | 598.87 | 598.84 | 598.84 | 406.0 |
| 2024-12-26 06:30:00 | SPY | ETF | 598.99 | 599.1 | 598.99 | 599.1 | 3418.0 |
| 2024-12-26 06:35:00 | SPY | ETF | 599.1 | 599.14 | 599.1 | 599.14 | 349.0 |
| 2024-12-26 06:40:00 | SPY | ETF | 599.1 | 599.1 | 599.1 | 599.1 | 300.0 |
| 2024-12-26 06:45:00 | SPY | ETF | 599.04 | 599.09 | 598.96 | 598.96 | 983.0 |
| 2024-12-26 06:50:00 | SPY | ETF | 599.09 | 599.18 | 599.09 | 599.18 | 587.0 |
| 2024-12-26 06:55:00 | SPY | ETF | 599.21 | 599.21 | 599.18 | 599.21 | 300.0 |
| 2024-12-26 07:00:00 | SPY | ETF | 599.19 | 599.47 | 599.16 | 599.35 | 11770.0 |
| 2024-12-26 07:05:00 | SPY | ETF | 599.35 | 599.39 | 599.29 | 599.31 | 4764.0 |
| 2024-12-26 07:10:00 | SPY | ETF | 599.26 | 599.31 | 599.16 | 599.2 | 2717.0 |
| 2024-12-26 07:15:00 | SPY | ETF | 599.19 | 599.37 | 599.15 | 599.37 | 1594.0 |
| 2024-12-26 07:20:00 | SPY | ETF | 599.4 | 599.4 | 599.3 | 599.3 | 460.0 |
| 2024-12-26 07:25:00 | SPY | ETF | 599.12 | 599.48 | 599.12 | 599.48 | 6785.0 |
| 2024-12-26 07:30:00 | SPY | ETF | 599.35 | 599.35 | 599.25 | 599.28 | 1587.0 |
| 2024-12-26 07:35:00 | SPY | ETF | 599.3 | 599.34 | 599.27 | 599.27 | 1238.0 |
| 2024-12-26 07:40:00 | SPY | ETF | 599.15 | 599.16 | 599.0 | 599.16 | 6308.0 |
| 2024-12-26 07:45:00 | SPY | ETF | 599.11 | 599.25 | 599.03 | 599.25 | 500.0 |
| 2024-12-26 07:50:00 | SPY | ETF | 599.33 | 599.4 | 599.29 | 599.4 | 2297.0 |
| 2024-12-26 07:55:00 | SPY | ETF | 599.41 | 599.45 | 599.33 | 599.33 | 2187.0 |
| 2024-12-26 08:00:00 | SPY | ETF | 599.39 | 601.69 | 598.8096 | 599.2795 | 31740.0 |
| 2024-12-26 08:05:00 | SPY | ETF | 599.3 | 599.39 | 599.2 | 599.39 | 2676.0 |
| 2024-12-26 08:10:00 | SPY | ETF | 599.36 | 599.48 | 599.36 | 599.45 | 3621.0 |
| 2024-12-26 08:15:00 | SPY | ETF | 599.46 | 599.52 | 599.0 | 599.43 | 15685.0 |
> showing 50 of 122,693 rows — these rows as CSV