PREVIEW / etf_30min / 2024-07-12
file: by_date/etf_30min/2024/2024-07-12.parquet size: 825 KB rows: 32,898
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-07-12 04:00:00 | SPY | ETF | 557.09 | 557.49 | 557.09 | 557.45 | 7895.0 |
| 2024-07-12 04:30:00 | SPY | ETF | 557.41 | 557.55 | 557.4 | 557.55 | 10173.0 |
| 2024-07-12 05:00:00 | SPY | ETF | 557.55 | 557.65 | 557.24 | 557.24 | 2546.0 |
| 2024-07-12 05:30:00 | SPY | ETF | 557.25 | 557.52 | 557.24 | 557.52 | 2333.0 |
| 2024-07-12 06:00:00 | SPY | ETF | 557.49 | 557.61 | 557.3 | 557.3 | 5844.0 |
| 2024-07-12 06:30:00 | SPY | ETF | 557.58 | 557.58 | 557.0 | 557.21 | 6113.0 |
| 2024-07-12 07:00:00 | SPY | ETF | 557.2 | 557.28 | 556.8 | 557.14 | 111234.0 |
| 2024-07-12 07:30:00 | SPY | ETF | 557.15 | 557.32 | 557.03 | 557.24 | 92863.0 |
| 2024-07-12 08:00:00 | SPY | ETF | 557.27 | 557.5596 | 556.82 | 557.0 | 52604.0 |
| 2024-07-12 08:30:00 | SPY | ETF | 556.6 | 557.7 | 555.19 | 557.44 | 162850.0 |
| 2024-07-12 09:00:00 | SPY | ETF | 557.58 | 557.68 | 557.15 | 557.62 | 82820.0 |
| 2024-07-12 09:30:00 | SPY | ETF | 557.63 | 559.0698 | 557.15 | 558.8799 | 3355798.0 |
| 2024-07-12 10:00:00 | SPY | ETF | 558.85 | 559.86 | 558.625 | 559.78 | 2780645.0 |
| 2024-07-12 10:30:00 | SPY | ETF | 559.78 | 561.3599 | 559.68 | 561.1981 | 2007478.0 |
| 2024-07-12 11:00:00 | SPY | ETF | 561.18 | 561.73 | 561.0 | 561.7205 | 1848183.0 |
| 2024-07-12 11:30:00 | SPY | ETF | 561.71 | 561.76 | 560.72 | 560.7693 | 1306844.0 |
| 2024-07-12 12:00:00 | SPY | ETF | 560.79 | 561.06 | 560.13 | 560.64 | 1620643.0 |
| 2024-07-12 12:30:00 | SPY | ETF | 560.63 | 561.655 | 560.44 | 561.64 | 1608923.0 |
| 2024-07-12 13:00:00 | SPY | ETF | 561.64 | 562.43 | 561.51 | 562.43 | 1663880.0 |
| 2024-07-12 13:30:00 | SPY | ETF | 562.425 | 563.67 | 562.23 | 563.05 | 2234715.0 |
| 2024-07-12 14:00:00 | SPY | ETF | 563.03 | 563.41 | 562.6 | 562.995 | 1857002.0 |
| 2024-07-12 14:30:00 | SPY | ETF | 563.0 | 563.29 | 562.76 | 563.24 | 1395961.0 |
| 2024-07-12 15:00:00 | SPY | ETF | 563.24 | 563.295 | 562.56 | 562.82 | 1818662.0 |
| 2024-07-12 15:30:00 | SPY | ETF | 562.82 | 562.82 | 558.95 | 559.9 | 10616164.0 |
| 2024-07-12 16:00:00 | SPY | ETF | 559.91 | 560.34 | 559.25 | 559.6 | 3101427.0 |
| 2024-07-12 16:30:00 | SPY | ETF | 559.64 | 559.99 | 559.5996 | 559.73 | 109820.0 |
| 2024-07-12 17:00:00 | SPY | ETF | 559.75 | 559.75 | 559.4 | 559.45 | 110557.0 |
| 2024-07-12 17:30:00 | SPY | ETF | 559.45 | 559.62 | 559.4 | 559.53 | 54360.0 |
| 2024-07-12 18:00:00 | SPY | ETF | 559.56 | 559.75 | 559.5093 | 559.75 | 34822.0 |
| 2024-07-12 18:30:00 | SPY | ETF | 559.7 | 559.73 | 559.6 | 559.71 | 3022.0 |
| 2024-07-12 19:00:00 | SPY | ETF | 559.67 | 559.72 | 559.67 | 559.6979 | 711.0 |
| 2024-07-12 19:30:00 | SPY | ETF | 559.7 | 559.85 | 559.67 | 559.77 | 21582.0 |
| 2024-07-12 04:00:00 | QQQ | ETF | 491.49 | 492.27 | 491.49 | 492.26 | 52810.0 |
| 2024-07-12 04:30:00 | QQQ | ETF | 492.28 | 492.39 | 492.15 | 492.37 | 25823.0 |
| 2024-07-12 05:00:00 | QQQ | ETF | 492.39 | 492.61 | 491.96 | 492.19 | 28722.0 |
| 2024-07-12 05:30:00 | QQQ | ETF | 492.02 | 492.49 | 492.0 | 492.35 | 15374.0 |
| 2024-07-12 06:00:00 | QQQ | ETF | 492.5 | 492.64 | 492.09 | 492.27 | 22318.0 |
| 2024-07-12 06:30:00 | QQQ | ETF | 492.26 | 492.36 | 491.8 | 492.24 | 43473.0 |
| 2024-07-12 07:00:00 | QQQ | ETF | 492.19 | 492.32 | 491.64 | 492.2 | 44655.0 |
| 2024-07-12 07:30:00 | QQQ | ETF | 492.18 | 492.57 | 492.18 | 492.56 | 49516.0 |
| 2024-07-12 08:00:00 | QQQ | ETF | 492.52 | 492.52 | 491.01 | 491.96 | 138659.0 |
| 2024-07-12 08:30:00 | QQQ | ETF | 491.57 | 493.08 | 490.0 | 492.42 | 260439.0 |
| 2024-07-12 09:00:00 | QQQ | ETF | 492.64 | 492.7 | 492.0 | 492.5 | 245143.0 |
| 2024-07-12 09:30:00 | QQQ | ETF | 492.51 | 495.04 | 492.04 | 494.89 | 3401897.0 |
| 2024-07-12 10:00:00 | QQQ | ETF | 494.91 | 495.94 | 494.4 | 495.03 | 2524300.0 |
| 2024-07-12 10:30:00 | QQQ | ETF | 495.07 | 497.695 | 494.95 | 497.12 | 2127095.0 |
| 2024-07-12 11:00:00 | QQQ | ETF | 497.11 | 497.82 | 496.79 | 497.58 | 1246563.0 |
| 2024-07-12 11:30:00 | QQQ | ETF | 497.56 | 497.82 | 496.02 | 496.12 | 984996.0 |
| 2024-07-12 12:00:00 | QQQ | ETF | 496.06 | 496.58 | 495.1743 | 495.9 | 1305403.0 |
| 2024-07-12 12:30:00 | QQQ | ETF | 495.91 | 497.04 | 495.63 | 497.0 | 840078.0 |
> showing 50 of 32,898 rows — these rows as CSV