PREVIEW / etf_30min / 2024-08-09
file: by_date/etf_30min/2024/2024-08-09.parquet size: 805 KB rows: 31,886
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-08-09 04:00:00 | SPY | ETF | 531.69 | 531.96 | 531.36 | 531.9 | 17353.0 |
| 2024-08-09 04:30:00 | SPY | ETF | 531.79 | 533.14 | 531.79 | 532.94 | 33828.0 |
| 2024-08-09 05:00:00 | SPY | ETF | 533.0 | 533.07 | 532.71 | 532.74 | 6569.0 |
| 2024-08-09 05:30:00 | SPY | ETF | 532.81 | 532.81 | 532.0 | 532.54 | 9389.0 |
| 2024-08-09 06:00:00 | SPY | ETF | 532.22 | 532.22 | 531.37 | 531.98 | 8543.0 |
| 2024-08-09 06:30:00 | SPY | ETF | 531.85 | 532.0 | 531.36 | 531.49 | 57294.0 |
| 2024-08-09 07:00:00 | SPY | ETF | 531.57 | 532.39 | 530.85 | 531.15 | 160938.0 |
| 2024-08-09 07:30:00 | SPY | ETF | 531.16 | 531.24 | 530.15 | 530.84 | 174393.0 |
| 2024-08-09 08:00:00 | SPY | ETF | 531.69 | 532.9396 | 529.05 | 529.42 | 355117.0 |
| 2024-08-09 08:30:00 | SPY | ETF | 529.45 | 529.49 | 528.09 | 529.07 | 509217.0 |
| 2024-08-09 09:00:00 | SPY | ETF | 529.01 | 530.01 | 528.71 | 529.84 | 267367.0 |
| 2024-08-09 09:30:00 | SPY | ETF | 529.81 | 531.1101 | 528.56 | 529.27 | 4289215.0 |
| 2024-08-09 10:00:00 | SPY | ETF | 529.24 | 531.81 | 528.8 | 530.61 | 2910101.0 |
| 2024-08-09 10:30:00 | SPY | ETF | 530.65 | 532.1599 | 529.38 | 531.5 | 2450632.0 |
| 2024-08-09 11:00:00 | SPY | ETF | 531.51 | 532.6499 | 530.82 | 530.84 | 1754635.0 |
| 2024-08-09 11:30:00 | SPY | ETF | 530.9 | 531.84 | 530.12 | 530.302 | 1471306.0 |
| 2024-08-09 12:00:00 | SPY | ETF | 530.32 | 530.66 | 529.8 | 530.3 | 989217.0 |
| 2024-08-09 12:30:00 | SPY | ETF | 530.29 | 531.46 | 530.23 | 531.44 | 1186082.0 |
| 2024-08-09 13:00:00 | SPY | ETF | 531.44 | 534.14 | 531.31 | 534.12 | 1817537.0 |
| 2024-08-09 13:30:00 | SPY | ETF | 534.13 | 534.51 | 532.34 | 532.5999 | 2192957.0 |
| 2024-08-09 14:00:00 | SPY | ETF | 532.62 | 532.96 | 531.69 | 532.02 | 1717401.0 |
| 2024-08-09 14:30:00 | SPY | ETF | 532.01 | 532.79 | 531.47 | 532.4192 | 1551532.0 |
| 2024-08-09 15:00:00 | SPY | ETF | 532.38 | 533.16 | 531.88 | 532.73 | 2266113.0 |
| 2024-08-09 15:30:00 | SPY | ETF | 532.74 | 533.41 | 532.06 | 532.91 | 5235677.0 |
| 2024-08-09 16:00:00 | SPY | ETF | 532.91 | 533.07 | 532.54 | 532.57 | 3484448.0 |
| 2024-08-09 16:30:00 | SPY | ETF | 532.57 | 532.99 | 532.25 | 532.48 | 355934.0 |
| 2024-08-09 17:00:00 | SPY | ETF | 532.32 | 532.59 | 532.32 | 532.5 | 40613.0 |
| 2024-08-09 17:30:00 | SPY | ETF | 532.47 | 532.74 | 532.47 | 532.55 | 75268.0 |
| 2024-08-09 18:00:00 | SPY | ETF | 532.65 | 532.89 | 532.5013 | 532.8496 | 31676.0 |
| 2024-08-09 18:30:00 | SPY | ETF | 532.85 | 532.97 | 532.85 | 532.86 | 13152.0 |
| 2024-08-09 19:00:00 | SPY | ETF | 532.9016 | 532.9687 | 532.86 | 532.88 | 5023.0 |
| 2024-08-09 19:30:00 | SPY | ETF | 532.94 | 533.08 | 532.86 | 532.99 | 30807.0 |
| 2024-08-09 04:00:00 | QQQ | ETF | 449.1 | 450.21 | 449.09 | 450.18 | 34522.0 |
| 2024-08-09 04:30:00 | QQQ | ETF | 450.26 | 451.55 | 450.07 | 451.07 | 38748.0 |
| 2024-08-09 05:00:00 | QQQ | ETF | 451.37 | 451.37 | 450.71 | 450.97 | 22826.0 |
| 2024-08-09 05:30:00 | QQQ | ETF | 450.85 | 450.91 | 449.98 | 450.71 | 49965.0 |
| 2024-08-09 06:00:00 | QQQ | ETF | 450.48 | 450.48 | 449.15 | 449.99 | 44975.0 |
| 2024-08-09 06:30:00 | QQQ | ETF | 449.99 | 450.07 | 449.38 | 449.59 | 20539.0 |
| 2024-08-09 07:00:00 | QQQ | ETF | 449.68 | 450.25 | 448.41 | 448.76 | 117166.0 |
| 2024-08-09 07:30:00 | QQQ | ETF | 448.78 | 448.88 | 447.69 | 448.55 | 200116.0 |
| 2024-08-09 08:00:00 | QQQ | ETF | 449.959 | 451.1496 | 446.3 | 446.82 | 353358.0 |
| 2024-08-09 08:30:00 | QQQ | ETF | 446.79 | 446.79 | 445.09 | 446.14 | 440529.0 |
| 2024-08-09 09:00:00 | QQQ | ETF | 446.0 | 446.95 | 445.63 | 446.71 | 298634.0 |
| 2024-08-09 09:30:00 | QQQ | ETF | 446.73 | 448.62 | 446.07 | 446.29 | 3942450.0 |
| 2024-08-09 10:00:00 | QQQ | ETF | 446.26 | 449.52 | 445.61 | 447.77 | 2371659.0 |
| 2024-08-09 10:30:00 | QQQ | ETF | 447.83 | 449.3313 | 446.4 | 448.53 | 1918071.0 |
| 2024-08-09 11:00:00 | QQQ | ETF | 448.54 | 449.81 | 448.07 | 448.07 | 1287680.0 |
| 2024-08-09 11:30:00 | QQQ | ETF | 448.13 | 449.06 | 447.19 | 447.3901 | 1212985.0 |
| 2024-08-09 12:00:00 | QQQ | ETF | 447.41 | 447.84 | 446.84 | 447.47 | 926926.0 |
| 2024-08-09 12:30:00 | QQQ | ETF | 447.43 | 448.62 | 447.36 | 448.6 | 1142795.0 |
> showing 50 of 31,886 rows — these rows as CSV