PREVIEW / etf_30min / 2024-07-11
file: by_date/etf_30min/2024/2024-07-11.parquet size: 845 KB rows: 34,049
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-11 04:00:00 | SPY | ETF | 561.1 | 561.36 | 561.1 | 561.24 | 5733.0 |
| 2024-07-11 04:30:00 | SPY | ETF | 561.36 | 561.36 | 561.13 | 561.13 | 3252.0 |
| 2024-07-11 05:00:00 | SPY | ETF | 561.03 | 561.08 | 561.0 | 561.03 | 5267.0 |
| 2024-07-11 05:30:00 | SPY | ETF | 561.03 | 561.09 | 561.03 | 561.08 | 1300.0 |
| 2024-07-11 06:00:00 | SPY | ETF | 561.06 | 561.06 | 560.95 | 560.98 | 3993.0 |
| 2024-07-11 06:30:00 | SPY | ETF | 560.95 | 560.95 | 560.77 | 560.94 | 6962.0 |
| 2024-07-11 07:00:00 | SPY | ETF | 560.93 | 561.02 | 560.86 | 560.91 | 167425.0 |
| 2024-07-11 07:30:00 | SPY | ETF | 560.95 | 560.95 | 560.78 | 560.79 | 31685.0 |
| 2024-07-11 08:00:00 | SPY | ETF | 560.9298 | 561.48 | 560.52 | 561.02 | 264436.0 |
| 2024-07-11 08:30:00 | SPY | ETF | 561.97 | 563.52 | 561.0 | 561.24 | 1455472.0 |
| 2024-07-11 09:00:00 | SPY | ETF | 561.24 | 561.9 | 560.89 | 561.44 | 449045.0 |
| 2024-07-11 09:30:00 | SPY | ETF | 561.44 | 561.97 | 561.22 | 561.95 | 3038780.0 |
| 2024-07-11 10:00:00 | SPY | ETF | 561.95 | 562.33 | 559.29 | 559.77 | 3448733.0 |
| 2024-07-11 10:30:00 | SPY | ETF | 559.76 | 560.37 | 558.4 | 558.47 | 2240686.0 |
| 2024-07-11 11:00:00 | SPY | ETF | 558.47 | 559.24 | 557.11 | 557.32 | 2247961.0 |
| 2024-07-11 11:30:00 | SPY | ETF | 557.32 | 557.59 | 556.43 | 556.74 | 1752416.0 |
| 2024-07-11 12:00:00 | SPY | ETF | 556.73 | 557.43 | 556.18 | 557.205 | 1839282.0 |
| 2024-07-11 12:30:00 | SPY | ETF | 557.21 | 557.77 | 556.0 | 556.3355 | 1870575.0 |
| 2024-07-11 13:00:00 | SPY | ETF | 556.33 | 557.115 | 555.88 | 557.08 | 1490012.0 |
| 2024-07-11 13:30:00 | SPY | ETF | 557.09 | 557.09 | 555.83 | 555.93 | 1189216.0 |
| 2024-07-11 14:00:00 | SPY | ETF | 555.94 | 556.89 | 555.83 | 556.25 | 1720681.0 |
| 2024-07-11 14:30:00 | SPY | ETF | 556.23 | 557.31 | 556.19 | 557.16 | 1483650.0 |
| 2024-07-11 15:00:00 | SPY | ETF | 557.16 | 557.49 | 556.48 | 556.558 | 2199023.0 |
| 2024-07-11 15:30:00 | SPY | ETF | 556.56 | 557.57 | 556.4 | 556.42 | 8363758.0 |
| 2024-07-11 16:00:00 | SPY | ETF | 556.42 | 558.0349 | 556.07 | 556.86 | 3691908.0 |
| 2024-07-11 16:30:00 | SPY | ETF | 556.87 | 556.98 | 556.73 | 556.75 | 87635.0 |
| 2024-07-11 17:00:00 | SPY | ETF | 556.75 | 556.81 | 556.33 | 556.35 | 46505.0 |
| 2024-07-11 17:30:00 | SPY | ETF | 556.45 | 556.46 | 556.25 | 556.3999 | 26957.0 |
| 2024-07-11 18:00:00 | SPY | ETF | 556.4 | 556.89 | 556.3211 | 556.47 | 56590.0 |
| 2024-07-11 18:30:00 | SPY | ETF | 556.6 | 556.95 | 556.6 | 556.85 | 26273.0 |
| 2024-07-11 19:00:00 | SPY | ETF | 556.91 | 557.17 | 556.91 | 557.12 | 8309.0 |
| 2024-07-11 19:30:00 | SPY | ETF | 557.06 | 557.1 | 556.4 | 556.43 | 11029.0 |
| 2024-07-11 04:00:00 | QQQ | ETF | 502.93 | 502.96 | 502.74 | 502.86 | 23683.0 |
| 2024-07-11 04:30:00 | QQQ | ETF | 502.89 | 503.05 | 502.71 | 502.79 | 17254.0 |
| 2024-07-11 05:00:00 | QQQ | ETF | 502.74 | 502.78 | 502.65 | 502.74 | 17204.0 |
| 2024-07-11 05:30:00 | QQQ | ETF | 502.71 | 502.89 | 502.62 | 502.85 | 6128.0 |
| 2024-07-11 06:00:00 | QQQ | ETF | 502.8 | 502.83 | 502.71 | 502.8 | 3170.0 |
| 2024-07-11 06:30:00 | QQQ | ETF | 502.81 | 502.82 | 502.68 | 502.78 | 7354.0 |
| 2024-07-11 07:00:00 | QQQ | ETF | 502.81 | 502.94 | 502.73 | 502.8 | 164058.0 |
| 2024-07-11 07:30:00 | QQQ | ETF | 502.85 | 502.91 | 502.8 | 502.8 | 21861.0 |
| 2024-07-11 08:00:00 | QQQ | ETF | 502.8 | 503.337 | 502.4254 | 503.0 | 180023.0 |
| 2024-07-11 08:30:00 | QQQ | ETF | 503.74 | 505.21 | 502.64 | 503.05 | 1317637.0 |
| 2024-07-11 09:00:00 | QQQ | ETF | 503.02 | 503.64 | 502.59 | 503.18 | 498278.0 |
| 2024-07-11 09:30:00 | QQQ | ETF | 503.07 | 503.28 | 501.32 | 502.475 | 3814745.0 |
| 2024-07-11 10:00:00 | QQQ | ETF | 502.49 | 502.5101 | 497.3501 | 498.2037 | 3877224.0 |
| 2024-07-11 10:30:00 | QQQ | ETF | 498.175 | 499.03 | 496.02 | 496.101 | 2592345.0 |
| 2024-07-11 11:00:00 | QQQ | ETF | 496.1 | 497.14 | 494.27 | 494.455 | 3636470.0 |
| 2024-07-11 11:30:00 | QQQ | ETF | 494.45 | 494.73 | 493.02 | 493.1032 | 3074550.0 |
| 2024-07-11 12:00:00 | QQQ | ETF | 493.12 | 494.29 | 492.5 | 493.925 | 2066527.0 |
| 2024-07-11 12:30:00 | QQQ | ETF | 493.9 | 494.57 | 492.12 | 492.31 | 2089516.0 |
> showing 50 of 34,049 rows — these rows as CSV