PREVIEW / etf_30min / 2024-01-02
file: by_date/etf_30min/2024/2024-01-02.parquet size: 827 KB rows: 33,165
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-01-02 04:00:00 | SPY | ETF | 476.25 | 476.36 | 475.66 | 475.73 | 47157.0 |
| 2024-01-02 04:30:00 | SPY | ETF | 475.75 | 475.75 | 475.27 | 475.4 | 21340.0 |
| 2024-01-02 05:00:00 | SPY | ETF | 475.39 | 475.43 | 475.1 | 475.1 | 10056.0 |
| 2024-01-02 05:30:00 | SPY | ETF | 475.24 | 475.51 | 475.1 | 475.1 | 31779.0 |
| 2024-01-02 06:00:00 | SPY | ETF | 475.01 | 475.08 | 473.19 | 473.2 | 60789.0 |
| 2024-01-02 06:30:00 | SPY | ETF | 473.2 | 473.25 | 472.5 | 473.17 | 88166.0 |
| 2024-01-02 07:00:00 | SPY | ETF | 473.05 | 473.06 | 472.5 | 472.66 | 223740.0 |
| 2024-01-02 07:30:00 | SPY | ETF | 472.64 | 472.66 | 471.7 | 471.79 | 178816.0 |
| 2024-01-02 08:00:00 | SPY | ETF | 473.0699 | 476.35 | 471.65 | 471.76 | 353496.0 |
| 2024-01-02 08:30:00 | SPY | ETF | 471.75 | 472.33 | 471.64 | 472.03 | 176091.0 |
| 2024-01-02 09:00:00 | SPY | ETF | 472.09 | 472.49 | 471.54 | 472.16 | 563666.0 |
| 2024-01-02 09:30:00 | SPY | ETF | 472.16 | 472.8 | 471.36 | 472.27 | 9879430.0 |
| 2024-01-02 10:00:00 | SPY | ETF | 472.275 | 472.71 | 471.59 | 471.76 | 5054062.0 |
| 2024-01-02 10:30:00 | SPY | ETF | 471.77 | 472.07 | 471.3 | 471.68 | 3855803.0 |
| 2024-01-02 11:00:00 | SPY | ETF | 471.67 | 472.45 | 471.63 | 472.33 | 3303172.0 |
| 2024-01-02 11:30:00 | SPY | ETF | 472.32 | 473.29 | 472.27 | 473.185 | 3268732.0 |
| 2024-01-02 12:00:00 | SPY | ETF | 473.19 | 473.36 | 472.77 | 472.975 | 2788371.0 |
| 2024-01-02 12:30:00 | SPY | ETF | 472.975 | 473.67 | 472.59 | 472.65 | 2845249.0 |
| 2024-01-02 13:00:00 | SPY | ETF | 472.65 | 472.97 | 472.28 | 472.6605 | 2528182.0 |
| 2024-01-02 13:30:00 | SPY | ETF | 472.66 | 472.9597 | 472.0 | 472.1499 | 3024055.0 |
| 2024-01-02 14:00:00 | SPY | ETF | 472.13 | 472.25 | 471.545 | 471.8801 | 3734494.0 |
| 2024-01-02 14:30:00 | SPY | ETF | 471.86 | 472.06 | 470.92 | 470.925 | 3631028.0 |
| 2024-01-02 15:00:00 | SPY | ETF | 470.9275 | 471.07 | 470.49 | 470.91 | 5567082.0 |
| 2024-01-02 15:30:00 | SPY | ETF | 470.905 | 472.67 | 470.67 | 472.6 | 19977212.0 |
| 2024-01-02 16:00:00 | SPY | ETF | 472.6 | 473.0 | 471.9163 | 472.55 | 7632824.0 |
| 2024-01-02 16:30:00 | SPY | ETF | 472.54 | 472.8 | 472.2 | 472.69 | 251787.0 |
| 2024-01-02 17:00:00 | SPY | ETF | 472.69 | 472.74 | 472.62 | 472.73 | 15582.0 |
| 2024-01-02 17:30:00 | SPY | ETF | 472.6701 | 472.79 | 472.65 | 472.79 | 648926.0 |
| 2024-01-02 18:00:00 | SPY | ETF | 472.84 | 472.87 | 472.52 | 472.5997 | 24389.0 |
| 2024-01-02 18:30:00 | SPY | ETF | 472.61 | 472.67 | 472.6 | 472.67 | 5508.0 |
| 2024-01-02 19:00:00 | SPY | ETF | 472.68 | 472.71 | 472.61 | 472.7 | 9478.0 |
| 2024-01-02 19:30:00 | SPY | ETF | 472.66 | 472.7 | 472.44 | 472.5 | 15636.0 |
| 2024-01-02 04:00:00 | QQQ | ETF | 409.84 | 409.84 | 409.15 | 409.29 | 17547.0 |
| 2024-01-02 04:30:00 | QQQ | ETF | 409.25 | 409.27 | 408.94 | 409.03 | 10919.0 |
| 2024-01-02 05:00:00 | QQQ | ETF | 409.05 | 409.05 | 408.78 | 408.78 | 6399.0 |
| 2024-01-02 05:30:00 | QQQ | ETF | 408.86 | 409.1 | 408.45 | 408.49 | 20286.0 |
| 2024-01-02 06:00:00 | QQQ | ETF | 408.42 | 408.59 | 406.27 | 406.27 | 71780.0 |
| 2024-01-02 06:30:00 | QQQ | ETF | 406.18 | 406.34 | 405.5 | 406.17 | 195808.0 |
| 2024-01-02 07:00:00 | QQQ | ETF | 406.19 | 406.25 | 405.56 | 405.82 | 82756.0 |
| 2024-01-02 07:30:00 | QQQ | ETF | 405.75 | 405.91 | 404.83 | 404.99 | 207245.0 |
| 2024-01-02 08:00:00 | QQQ | ETF | 408.41 | 410.0 | 404.81 | 405.05 | 181040.0 |
| 2024-01-02 08:30:00 | QQQ | ETF | 405.04 | 405.7 | 404.95 | 405.61 | 243743.0 |
| 2024-01-02 09:00:00 | QQQ | ETF | 405.63 | 406.2 | 405.2 | 405.85 | 324830.0 |
| 2024-01-02 09:30:00 | QQQ | ETF | 405.84 | 406.09 | 402.5 | 403.58 | 7526312.0 |
| 2024-01-02 10:00:00 | QQQ | ETF | 403.575 | 404.165 | 402.48 | 402.6401 | 3645960.0 |
| 2024-01-02 10:30:00 | QQQ | ETF | 402.64 | 402.65 | 401.7408 | 402.355 | 3208949.0 |
| 2024-01-02 11:00:00 | QQQ | ETF | 402.355 | 403.58 | 402.32 | 403.56 | 2815640.0 |
| 2024-01-02 11:30:00 | QQQ | ETF | 403.55 | 404.15 | 403.5 | 403.97 | 1983513.0 |
| 2024-01-02 12:00:00 | QQQ | ETF | 403.97 | 404.18 | 403.3715 | 403.52 | 1605683.0 |
| 2024-01-02 12:30:00 | QQQ | ETF | 403.52 | 404.1601 | 402.5212 | 402.575 | 1752367.0 |
> showing 50 of 33,165 rows — these rows as CSV