PREVIEW / etf_30min / 2024-10-29
file: by_date/etf_30min/2024/2024-10-29.parquet size: 875 KB rows: 34,850
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-29 04:00:00 | SPY | ETF | 581.19 | 581.19 | 580.21 | 581.04 | 26650.0 |
| 2024-10-29 04:30:00 | SPY | ETF | 581.13 | 581.56 | 580.97 | 581.2 | 5337.0 |
| 2024-10-29 05:00:00 | SPY | ETF | 581.11 | 581.11 | 580.61 | 581.02 | 7966.0 |
| 2024-10-29 05:30:00 | SPY | ETF | 580.93 | 580.95 | 580.81 | 580.93 | 11913.0 |
| 2024-10-29 06:00:00 | SPY | ETF | 580.99 | 580.99 | 580.46 | 580.5 | 8947.0 |
| 2024-10-29 06:30:00 | SPY | ETF | 580.64 | 580.82 | 580.55 | 580.76 | 5638.0 |
| 2024-10-29 07:00:00 | SPY | ETF | 580.65 | 580.7 | 580.1 | 580.14 | 50823.0 |
| 2024-10-29 07:30:00 | SPY | ETF | 580.14 | 580.66 | 580.01 | 580.08 | 18289.0 |
| 2024-10-29 08:00:00 | SPY | ETF | 580.24 | 581.52 | 579.49 | 579.9794 | 236053.0 |
| 2024-10-29 08:30:00 | SPY | ETF | 579.97 | 580.02 | 579.63 | 579.66 | 86215.0 |
| 2024-10-29 09:00:00 | SPY | ETF | 579.67 | 580.01 | 579.52 | 579.88 | 160184.0 |
| 2024-10-29 09:30:00 | SPY | ETF | 579.87 | 580.06 | 578.43 | 579.97 | 3068636.0 |
| 2024-10-29 10:00:00 | SPY | ETF | 579.98 | 581.85 | 579.52 | 580.465 | 2640177.0 |
| 2024-10-29 10:30:00 | SPY | ETF | 580.47 | 581.52 | 580.4201 | 581.42 | 1018813.0 |
| 2024-10-29 11:00:00 | SPY | ETF | 581.42 | 581.61 | 580.55 | 581.0 | 1080757.0 |
| 2024-10-29 11:30:00 | SPY | ETF | 581.04 | 581.55 | 580.74 | 581.39 | 867441.0 |
| 2024-10-29 12:00:00 | SPY | ETF | 581.4 | 582.0 | 581.31 | 581.39 | 810199.0 |
| 2024-10-29 12:30:00 | SPY | ETF | 581.38 | 582.0699 | 580.83 | 581.99 | 1196723.0 |
| 2024-10-29 13:00:00 | SPY | ETF | 581.9962 | 582.77 | 581.885 | 582.0099 | 1225784.0 |
| 2024-10-29 13:30:00 | SPY | ETF | 582.01 | 582.17 | 581.51 | 581.97 | 784637.0 |
| 2024-10-29 14:00:00 | SPY | ETF | 581.97 | 582.36 | 581.6801 | 582.36 | 916791.0 |
| 2024-10-29 14:30:00 | SPY | ETF | 582.35 | 582.88 | 582.3 | 582.41 | 1188185.0 |
| 2024-10-29 15:00:00 | SPY | ETF | 582.41 | 582.907 | 582.33 | 582.84 | 1040782.0 |
| 2024-10-29 15:30:00 | SPY | ETF | 582.815 | 582.895 | 581.34 | 581.7 | 5403889.0 |
| 2024-10-29 16:00:00 | SPY | ETF | 581.705 | 582.91 | 581.67 | 582.5 | 2163225.0 |
| 2024-10-29 16:30:00 | SPY | ETF | 582.45 | 582.62 | 581.45 | 582.33 | 516753.0 |
| 2024-10-29 17:00:00 | SPY | ETF | 581.77 | 582.79 | 581.77 | 582.6 | 47939.0 |
| 2024-10-29 17:30:00 | SPY | ETF | 582.52 | 582.9 | 582.52 | 582.82 | 10241.0 |
| 2024-10-29 18:00:00 | SPY | ETF | 582.85 | 583.0 | 582.6 | 582.86 | 73508.0 |
| 2024-10-29 18:30:00 | SPY | ETF | 582.9 | 583.26 | 582.9 | 583.26 | 13131.0 |
| 2024-10-29 19:00:00 | SPY | ETF | 583.24 | 583.24 | 582.75 | 583.04 | 10342.0 |
| 2024-10-29 19:30:00 | SPY | ETF | 583.02 | 583.13 | 582.9 | 583.05 | 7020.0 |
| 2024-10-29 04:00:00 | QQQ | ETF | 496.18 | 496.18 | 495.21 | 496.12 | 42010.0 |
| 2024-10-29 04:30:00 | QQQ | ETF | 496.18 | 496.58 | 495.82 | 496.21 | 33187.0 |
| 2024-10-29 05:00:00 | QQQ | ETF | 496.03 | 496.03 | 495.36 | 495.79 | 9595.0 |
| 2024-10-29 05:30:00 | QQQ | ETF | 495.76 | 496.02 | 495.66 | 495.91 | 11450.0 |
| 2024-10-29 06:00:00 | QQQ | ETF | 495.86 | 495.86 | 495.35 | 495.61 | 19061.0 |
| 2024-10-29 06:30:00 | QQQ | ETF | 495.67 | 495.99 | 495.67 | 495.9 | 27933.0 |
| 2024-10-29 07:00:00 | QQQ | ETF | 495.82 | 495.85 | 495.2 | 495.3 | 41960.0 |
| 2024-10-29 07:30:00 | QQQ | ETF | 495.45 | 495.84 | 495.23 | 495.39 | 40679.0 |
| 2024-10-29 08:00:00 | QQQ | ETF | 495.39 | 496.65 | 494.5 | 495.33 | 89043.0 |
| 2024-10-29 08:30:00 | QQQ | ETF | 495.32 | 495.58 | 495.17 | 495.22 | 47448.0 |
| 2024-10-29 09:00:00 | QQQ | ETF | 495.16 | 495.75 | 495.16 | 495.7 | 75623.0 |
| 2024-10-29 09:30:00 | QQQ | ETF | 495.72 | 496.08 | 493.85 | 495.855 | 1996964.0 |
| 2024-10-29 10:00:00 | QQQ | ETF | 495.855 | 497.9199 | 495.45 | 496.51 | 1829749.0 |
| 2024-10-29 10:30:00 | QQQ | ETF | 496.49 | 497.93 | 496.49 | 497.79 | 931673.0 |
| 2024-10-29 11:00:00 | QQQ | ETF | 497.85 | 498.05 | 497.17 | 497.79 | 1421917.0 |
| 2024-10-29 11:30:00 | QQQ | ETF | 497.79 | 498.42 | 497.4 | 498.39 | 1136075.0 |
| 2024-10-29 12:00:00 | QQQ | ETF | 498.38 | 498.9 | 498.12 | 498.23 | 1357130.0 |
| 2024-10-29 12:30:00 | QQQ | ETF | 498.23 | 499.26 | 497.53 | 499.0 | 1097410.0 |
> showing 50 of 34,850 rows — these rows as CSV