PREVIEW / etf_30min / 2024-10-21
file: by_date/etf_30min/2024/2024-10-21.parquet size: 860 KB rows: 35,050
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-10-21 04:00:00 | SPY | ETF | 584.28 | 584.59 | 584.22 | 584.33 | 18575.0 |
| 2024-10-21 04:30:00 | SPY | ETF | 584.29 | 584.46 | 584.29 | 584.46 | 1369.0 |
| 2024-10-21 05:00:00 | SPY | ETF | 584.46 | 584.46 | 583.63 | 583.63 | 12095.0 |
| 2024-10-21 05:30:00 | SPY | ETF | 583.68 | 583.89 | 583.27 | 583.81 | 7771.0 |
| 2024-10-21 06:00:00 | SPY | ETF | 583.8 | 583.8 | 583.67 | 583.77 | 933.0 |
| 2024-10-21 06:30:00 | SPY | ETF | 583.79 | 583.79 | 582.8 | 582.84 | 33780.0 |
| 2024-10-21 07:00:00 | SPY | ETF | 582.81 | 583.04 | 582.46 | 582.53 | 119482.0 |
| 2024-10-21 07:30:00 | SPY | ETF | 582.44 | 582.88 | 582.38 | 582.62 | 59458.0 |
| 2024-10-21 08:00:00 | SPY | ETF | 582.91 | 584.75 | 582.4 | 583.06 | 63356.0 |
| 2024-10-21 08:30:00 | SPY | ETF | 583.07 | 583.4 | 583.05 | 583.31 | 108104.0 |
| 2024-10-21 09:00:00 | SPY | ETF | 583.29 | 583.92 | 583.26 | 583.85 | 101317.0 |
| 2024-10-21 09:30:00 | SPY | ETF | 583.87 | 584.47 | 583.74 | 584.0399 | 2121508.0 |
| 2024-10-21 10:00:00 | SPY | ETF | 584.05 | 584.85 | 583.81 | 583.92 | 2011865.0 |
| 2024-10-21 10:30:00 | SPY | ETF | 583.93 | 583.97 | 582.0653 | 582.6 | 2683535.0 |
| 2024-10-21 11:00:00 | SPY | ETF | 582.595 | 582.65 | 580.67 | 580.83 | 2073118.0 |
| 2024-10-21 11:30:00 | SPY | ETF | 580.84 | 582.63 | 580.6001 | 582.3549 | 1994843.0 |
| 2024-10-21 12:00:00 | SPY | ETF | 582.33 | 582.47 | 581.8 | 582.1701 | 974972.0 |
| 2024-10-21 12:30:00 | SPY | ETF | 582.2 | 582.8813 | 581.9 | 582.82 | 630887.0 |
| 2024-10-21 13:00:00 | SPY | ETF | 582.83 | 583.2 | 582.6 | 582.91 | 956587.0 |
| 2024-10-21 13:30:00 | SPY | ETF | 582.92 | 583.38 | 582.885 | 583.25 | 586158.0 |
| 2024-10-21 14:00:00 | SPY | ETF | 583.28 | 583.29 | 582.35 | 582.6422 | 828612.0 |
| 2024-10-21 14:30:00 | SPY | ETF | 582.65 | 582.83 | 582.26 | 582.3888 | 1017333.0 |
| 2024-10-21 15:00:00 | SPY | ETF | 582.385 | 583.2 | 582.1701 | 582.93 | 1104888.0 |
| 2024-10-21 15:30:00 | SPY | ETF | 582.9 | 583.73 | 582.29 | 583.67 | 4338757.0 |
| 2024-10-21 16:00:00 | SPY | ETF | 583.68 | 583.93 | 583.24 | 583.88 | 1570326.0 |
| 2024-10-21 16:30:00 | SPY | ETF | 583.89 | 584.03 | 583.84 | 583.88 | 152180.0 |
| 2024-10-21 17:00:00 | SPY | ETF | 583.95 | 583.96 | 583.8802 | 583.96 | 58332.0 |
| 2024-10-21 17:30:00 | SPY | ETF | 583.95 | 584.019 | 583.5375 | 583.96 | 375600.0 |
| 2024-10-21 18:00:00 | SPY | ETF | 583.96 | 584.0 | 583.82 | 583.99 | 21383.0 |
| 2024-10-21 18:30:00 | SPY | ETF | 583.94 | 583.94 | 583.64 | 583.65 | 10933.0 |
| 2024-10-21 19:00:00 | SPY | ETF | 583.69 | 583.76 | 583.61 | 583.61 | 9485.0 |
| 2024-10-21 19:30:00 | SPY | ETF | 583.66 | 583.66 | 583.56 | 583.61 | 14402.0 |
| 2024-10-21 04:00:00 | QQQ | ETF | 494.02 | 494.02 | 493.56 | 493.66 | 23716.0 |
| 2024-10-21 04:30:00 | QQQ | ETF | 493.7 | 494.04 | 493.62 | 494.04 | 4039.0 |
| 2024-10-21 05:00:00 | QQQ | ETF | 493.96 | 493.96 | 492.89 | 493.05 | 14903.0 |
| 2024-10-21 05:30:00 | QQQ | ETF | 492.97 | 493.37 | 492.55 | 493.16 | 8760.0 |
| 2024-10-21 06:00:00 | QQQ | ETF | 493.13 | 493.33 | 492.97 | 493.06 | 3361.0 |
| 2024-10-21 06:30:00 | QQQ | ETF | 493.11 | 493.27 | 491.9 | 491.9 | 56388.0 |
| 2024-10-21 07:00:00 | QQQ | ETF | 491.95 | 492.19 | 491.34 | 491.37 | 165020.0 |
| 2024-10-21 07:30:00 | QQQ | ETF | 491.29 | 491.75 | 491.29 | 491.62 | 24944.0 |
| 2024-10-21 08:00:00 | QQQ | ETF | 492.0 | 494.47 | 491.37 | 492.4 | 135553.0 |
| 2024-10-21 08:30:00 | QQQ | ETF | 492.36 | 492.7702 | 492.22 | 492.61 | 64676.0 |
| 2024-10-21 09:00:00 | QQQ | ETF | 492.58 | 493.26 | 492.5 | 493.25 | 100820.0 |
| 2024-10-21 09:30:00 | QQQ | ETF | 493.22 | 495.0 | 493.12 | 494.77 | 2165510.0 |
| 2024-10-21 10:00:00 | QQQ | ETF | 494.83 | 496.23 | 494.66 | 495.15 | 1931180.0 |
| 2024-10-21 10:30:00 | QQQ | ETF | 495.14 | 495.26 | 492.17 | 493.33 | 2221320.0 |
| 2024-10-21 11:00:00 | QQQ | ETF | 493.26 | 493.46 | 491.31 | 491.6514 | 1862628.0 |
| 2024-10-21 11:30:00 | QQQ | ETF | 491.57 | 494.1112 | 491.49 | 493.904 | 1556030.0 |
| 2024-10-21 12:00:00 | QQQ | ETF | 493.87 | 494.126 | 493.3727 | 493.57 | 998521.0 |
| 2024-10-21 12:30:00 | QQQ | ETF | 493.58 | 494.39 | 493.19 | 494.25 | 720298.0 |
> showing 50 of 35,050 rows — these rows as CSV