PREVIEW / etf_30min / 2024-08-02
file: by_date/etf_30min/2024/2024-08-02.parquet size: 884 KB rows: 36,102
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-02 04:00:00 | SPY | ETF | 538.9 | 539.92 | 537.15 | 538.06 | 33084.0 |
| 2024-08-02 04:30:00 | SPY | ETF | 538.07 | 538.49 | 537.8 | 538.49 | 10408.0 |
| 2024-08-02 05:00:00 | SPY | ETF | 538.4 | 538.4 | 536.9 | 536.98 | 18218.0 |
| 2024-08-02 05:30:00 | SPY | ETF | 536.99 | 537.43 | 536.94 | 537.0 | 13618.0 |
| 2024-08-02 06:00:00 | SPY | ETF | 537.02 | 537.49 | 536.29 | 537.03 | 23863.0 |
| 2024-08-02 06:30:00 | SPY | ETF | 537.02 | 537.83 | 536.39 | 537.25 | 39598.0 |
| 2024-08-02 07:00:00 | SPY | ETF | 537.24 | 537.7 | 536.7 | 536.92 | 243087.0 |
| 2024-08-02 07:30:00 | SPY | ETF | 536.77 | 537.48 | 536.77 | 536.975 | 208664.0 |
| 2024-08-02 08:00:00 | SPY | ETF | 537.21 | 539.55 | 536.68 | 537.61 | 245868.0 |
| 2024-08-02 08:30:00 | SPY | ETF | 537.63 | 538.71 | 533.06 | 534.68 | 2253874.0 |
| 2024-08-02 09:00:00 | SPY | ETF | 534.66 | 536.8 | 534.15 | 535.71 | 787759.0 |
| 2024-08-02 09:30:00 | SPY | ETF | 535.71 | 536.99 | 533.89 | 534.13 | 6476041.0 |
| 2024-08-02 10:00:00 | SPY | ETF | 534.13 | 534.96 | 529.59 | 530.48 | 7018650.0 |
| 2024-08-02 10:30:00 | SPY | ETF | 530.495 | 531.5 | 529.02 | 529.26 | 4947060.0 |
| 2024-08-02 11:00:00 | SPY | ETF | 529.27 | 530.07 | 528.6 | 529.42 | 3966486.0 |
| 2024-08-02 11:30:00 | SPY | ETF | 529.43 | 532.82 | 529.2 | 532.18 | 4503241.0 |
| 2024-08-02 12:00:00 | SPY | ETF | 532.19 | 533.21 | 531.03 | 532.72 | 3035075.0 |
| 2024-08-02 12:30:00 | SPY | ETF | 532.7 | 533.52 | 530.57 | 531.255 | 2395855.0 |
| 2024-08-02 13:00:00 | SPY | ETF | 531.24 | 532.02 | 530.51 | 530.58 | 2022596.0 |
| 2024-08-02 13:30:00 | SPY | ETF | 530.57 | 530.73 | 529.66 | 530.2212 | 2018176.0 |
| 2024-08-02 14:00:00 | SPY | ETF | 530.22 | 531.78 | 529.54 | 531.75 | 2360631.0 |
| 2024-08-02 14:30:00 | SPY | ETF | 531.73 | 532.41 | 530.865 | 530.91 | 2378994.0 |
| 2024-08-02 15:00:00 | SPY | ETF | 530.9 | 532.618 | 530.63 | 532.32 | 2966737.0 |
| 2024-08-02 15:30:00 | SPY | ETF | 532.35 | 533.17 | 530.52 | 532.98 | 9213394.0 |
| 2024-08-02 16:00:00 | SPY | ETF | 533.03 | 533.03 | 532.24 | 532.4 | 4811948.0 |
| 2024-08-02 16:30:00 | SPY | ETF | 532.4 | 532.43 | 531.08 | 531.24 | 279848.0 |
| 2024-08-02 17:00:00 | SPY | ETF | 531.38 | 532.9 | 531.226 | 531.71 | 100798.0 |
| 2024-08-02 17:30:00 | SPY | ETF | 531.71 | 531.9 | 531.44 | 531.65 | 68154.0 |
| 2024-08-02 18:00:00 | SPY | ETF | 531.65 | 531.7708 | 531.41 | 531.6 | 9791.0 |
| 2024-08-02 18:30:00 | SPY | ETF | 531.61 | 532.26 | 531.61 | 531.91 | 56551.0 |
| 2024-08-02 19:00:00 | SPY | ETF | 531.95 | 531.95 | 531.13 | 531.13 | 34053.0 |
| 2024-08-02 19:30:00 | SPY | ETF | 531.13 | 531.29 | 531.0 | 531.25 | 13696.0 |
| 2024-08-02 04:00:00 | QQQ | ETF | 453.48 | 453.53 | 451.55 | 452.73 | 94498.0 |
| 2024-08-02 04:30:00 | QQQ | ETF | 452.66 | 453.0 | 452.2 | 452.8 | 24800.0 |
| 2024-08-02 05:00:00 | QQQ | ETF | 452.82 | 452.82 | 451.07 | 451.37 | 85775.0 |
| 2024-08-02 05:30:00 | QQQ | ETF | 451.48 | 452.09 | 451.32 | 451.83 | 36674.0 |
| 2024-08-02 06:00:00 | QQQ | ETF | 451.68 | 452.75 | 450.8 | 452.41 | 85343.0 |
| 2024-08-02 06:30:00 | QQQ | ETF | 452.33 | 453.0 | 451.4 | 452.45 | 50526.0 |
| 2024-08-02 07:00:00 | QQQ | ETF | 452.37 | 452.93 | 451.86 | 452.09 | 185108.0 |
| 2024-08-02 07:30:00 | QQQ | ETF | 452.14 | 452.75 | 451.38 | 451.5 | 115941.0 |
| 2024-08-02 08:00:00 | QQQ | ETF | 452.14 | 454.17 | 450.8904 | 452.19 | 304983.0 |
| 2024-08-02 08:30:00 | QQQ | ETF | 452.71 | 453.55 | 447.5 | 449.39 | 1976144.0 |
| 2024-08-02 09:00:00 | QQQ | ETF | 449.41 | 451.29 | 448.34 | 450.8 | 1225420.0 |
| 2024-08-02 09:30:00 | QQQ | ETF | 450.89 | 453.57 | 448.285 | 449.1 | 6787972.0 |
| 2024-08-02 10:00:00 | QQQ | ETF | 449.09 | 450.11 | 444.47 | 446.95 | 6419656.0 |
| 2024-08-02 10:30:00 | QQQ | ETF | 446.925 | 448.51 | 445.0436 | 445.45 | 5218208.0 |
| 2024-08-02 11:00:00 | QQQ | ETF | 445.45 | 447.6 | 444.96 | 446.7575 | 4094923.0 |
| 2024-08-02 11:30:00 | QQQ | ETF | 446.765 | 450.395 | 446.38 | 449.58 | 3230871.0 |
| 2024-08-02 12:00:00 | QQQ | ETF | 449.56 | 450.33 | 447.8 | 449.45 | 2183593.0 |
| 2024-08-02 12:30:00 | QQQ | ETF | 449.44 | 450.49 | 446.89 | 447.46 | 2192052.0 |
> showing 50 of 36,102 rows — these rows as CSV