PREVIEW / etf_30min / 2024-07-24
file: by_date/etf_30min/2024/2024-07-24.parquet size: 851 KB rows: 34,010
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-24 04:00:00 | SPY | ETF | 549.9 | 550.06 | 549.21 | 549.21 | 18234.0 |
| 2024-07-24 04:30:00 | SPY | ETF | 549.22 | 550.31 | 549.22 | 550.26 | 21594.0 |
| 2024-07-24 05:00:00 | SPY | ETF | 550.28 | 550.3 | 549.37 | 549.37 | 11424.0 |
| 2024-07-24 05:30:00 | SPY | ETF | 549.56 | 549.94 | 549.47 | 549.94 | 3516.0 |
| 2024-07-24 06:00:00 | SPY | ETF | 549.87 | 550.46 | 549.83 | 550.24 | 41898.0 |
| 2024-07-24 06:30:00 | SPY | ETF | 550.11 | 550.22 | 549.78 | 549.82 | 21790.0 |
| 2024-07-24 07:00:00 | SPY | ETF | 549.87 | 550.34 | 549.37 | 550.3 | 67138.0 |
| 2024-07-24 07:30:00 | SPY | ETF | 550.3 | 550.35 | 549.69 | 549.89 | 91647.0 |
| 2024-07-24 08:00:00 | SPY | ETF | 549.44 | 550.9 | 548.83 | 548.88 | 192109.0 |
| 2024-07-24 08:30:00 | SPY | ETF | 548.92 | 549.06 | 548.37 | 548.59 | 223402.0 |
| 2024-07-24 09:00:00 | SPY | ETF | 548.6 | 548.98 | 548.53 | 548.87 | 203375.0 |
| 2024-07-24 09:30:00 | SPY | ETF | 548.86 | 549.17 | 546.33 | 546.76 | 4843005.0 |
| 2024-07-24 10:00:00 | SPY | ETF | 546.74 | 546.9 | 545.435 | 546.04 | 3647643.0 |
| 2024-07-24 10:30:00 | SPY | ETF | 546.03 | 546.19 | 545.271 | 545.61 | 2793973.0 |
| 2024-07-24 11:00:00 | SPY | ETF | 545.61 | 545.685 | 544.19 | 544.74 | 2390603.0 |
| 2024-07-24 11:30:00 | SPY | ETF | 544.76 | 545.28 | 544.32 | 544.39 | 1634357.0 |
| 2024-07-24 12:00:00 | SPY | ETF | 544.38 | 544.92 | 543.89 | 544.1995 | 1712664.0 |
| 2024-07-24 12:30:00 | SPY | ETF | 544.18 | 544.51 | 543.63 | 543.9 | 2146791.0 |
| 2024-07-24 13:00:00 | SPY | ETF | 543.89 | 545.03 | 543.74 | 544.304 | 1597372.0 |
| 2024-07-24 13:30:00 | SPY | ETF | 544.285 | 544.95 | 543.8 | 543.88 | 1287093.0 |
| 2024-07-24 14:00:00 | SPY | ETF | 543.9 | 544.19 | 543.18 | 543.36 | 2130616.0 |
| 2024-07-24 14:30:00 | SPY | ETF | 543.355 | 543.5896 | 541.81 | 542.48 | 3057050.0 |
| 2024-07-24 15:00:00 | SPY | ETF | 542.47 | 542.598 | 541.49 | 541.65 | 3214391.0 |
| 2024-07-24 15:30:00 | SPY | ETF | 541.655 | 542.9 | 540.29 | 541.21 | 11157850.0 |
| 2024-07-24 16:00:00 | SPY | ETF | 541.2 | 542.41 | 540.9912 | 542.2904 | 6613670.0 |
| 2024-07-24 16:30:00 | SPY | ETF | 542.31 | 542.43 | 541.23 | 542.27 | 219881.0 |
| 2024-07-24 17:00:00 | SPY | ETF | 542.34 | 542.46 | 542.11 | 542.16 | 49702.0 |
| 2024-07-24 17:30:00 | SPY | ETF | 542.1595 | 542.22 | 542.09 | 542.22 | 51278.0 |
| 2024-07-24 18:00:00 | SPY | ETF | 542.23 | 542.87 | 542.23 | 542.54 | 227001.0 |
| 2024-07-24 18:30:00 | SPY | ETF | 542.53 | 542.83 | 542.53 | 542.69 | 42247.0 |
| 2024-07-24 19:00:00 | SPY | ETF | 542.62 | 542.74 | 542.42 | 542.64 | 9719.0 |
| 2024-07-24 19:30:00 | SPY | ETF | 542.51 | 542.71 | 542.43 | 542.46 | 13933.0 |
| 2024-07-24 04:00:00 | QQQ | ETF | 475.68 | 476.16 | 475.0 | 475.18 | 47512.0 |
| 2024-07-24 04:30:00 | QQQ | ETF | 475.01 | 476.47 | 474.95 | 476.24 | 23653.0 |
| 2024-07-24 05:00:00 | QQQ | ETF | 476.37 | 476.48 | 475.46 | 475.49 | 15702.0 |
| 2024-07-24 05:30:00 | QQQ | ETF | 475.6 | 475.83 | 475.48 | 475.79 | 72206.0 |
| 2024-07-24 06:00:00 | QQQ | ETF | 475.79 | 476.45 | 475.78 | 476.18 | 47151.0 |
| 2024-07-24 06:30:00 | QQQ | ETF | 476.04 | 476.05 | 475.48 | 475.63 | 57958.0 |
| 2024-07-24 07:00:00 | QQQ | ETF | 475.74 | 476.01 | 475.04 | 475.87 | 93030.0 |
| 2024-07-24 07:30:00 | QQQ | ETF | 475.97 | 475.97 | 475.22 | 475.46 | 53286.0 |
| 2024-07-24 08:00:00 | QQQ | ETF | 475.7 | 477.5 | 473.89 | 473.9 | 254670.0 |
| 2024-07-24 08:30:00 | QQQ | ETF | 473.92 | 474.08 | 473.08 | 473.7 | 493362.0 |
| 2024-07-24 09:00:00 | QQQ | ETF | 473.6602 | 474.15 | 473.44 | 473.82 | 369185.0 |
| 2024-07-24 09:30:00 | QQQ | ETF | 473.82 | 474.19 | 470.56 | 470.82 | 5109105.0 |
| 2024-07-24 10:00:00 | QQQ | ETF | 470.81 | 471.07 | 469.73 | 470.2 | 2804189.0 |
| 2024-07-24 10:30:00 | QQQ | ETF | 470.21 | 470.49 | 468.424 | 469.02 | 2393208.0 |
| 2024-07-24 11:00:00 | QQQ | ETF | 469.01 | 469.19 | 467.41 | 468.02 | 1862770.0 |
| 2024-07-24 11:30:00 | QQQ | ETF | 468.03 | 468.5 | 467.11 | 467.145 | 1727722.0 |
| 2024-07-24 12:00:00 | QQQ | ETF | 467.1762 | 467.33 | 466.24 | 466.48 | 1845532.0 |
| 2024-07-24 12:30:00 | QQQ | ETF | 466.46 | 467.0094 | 465.9001 | 466.23 | 1808386.0 |
> showing 50 of 34,010 rows — these rows as CSV