PREVIEW / etf_30min / 2024-01-11
file: by_date/etf_30min/2024/2024-01-11.parquet size: 794 KB rows: 31,498
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-01-11 04:00:00 | SPY | ETF | 478.46 | 478.47 | 477.5 | 477.96 | 19227.0 |
| 2024-01-11 04:30:00 | SPY | ETF | 477.94 | 477.94 | 477.55 | 477.72 | 8525.0 |
| 2024-01-11 05:00:00 | SPY | ETF | 477.61 | 477.7 | 477.51 | 477.63 | 12451.0 |
| 2024-01-11 05:30:00 | SPY | ETF | 477.58 | 477.58 | 477.24 | 477.25 | 5924.0 |
| 2024-01-11 06:00:00 | SPY | ETF | 477.53 | 477.71 | 477.49 | 477.49 | 57117.0 |
| 2024-01-11 06:30:00 | SPY | ETF | 477.53 | 477.58 | 477.3 | 477.45 | 4590.0 |
| 2024-01-11 07:00:00 | SPY | ETF | 477.47 | 477.71 | 477.04 | 477.62 | 156661.0 |
| 2024-01-11 07:30:00 | SPY | ETF | 477.66 | 477.77 | 477.47 | 477.47 | 29858.0 |
| 2024-01-11 08:00:00 | SPY | ETF | 477.5199 | 478.38 | 477.27 | 477.8 | 183884.0 |
| 2024-01-11 08:30:00 | SPY | ETF | 478.08 | 478.5 | 475.2 | 475.61 | 2013595.0 |
| 2024-01-11 09:00:00 | SPY | ETF | 475.68 | 477.64 | 475.57 | 477.58 | 1621430.0 |
| 2024-01-11 09:30:00 | SPY | ETF | 477.58 | 478.12 | 475.72 | 476.32 | 6136083.0 |
| 2024-01-11 10:00:00 | SPY | ETF | 476.32 | 476.38 | 473.57 | 475.0 | 5979569.0 |
| 2024-01-11 10:30:00 | SPY | ETF | 474.99 | 475.57 | 473.87 | 473.99 | 4071990.0 |
| 2024-01-11 11:00:00 | SPY | ETF | 474.0 | 474.28 | 472.52 | 473.05 | 4157241.0 |
| 2024-01-11 11:30:00 | SPY | ETF | 473.05 | 473.52 | 472.26 | 472.6133 | 4084240.0 |
| 2024-01-11 12:00:00 | SPY | ETF | 472.63 | 473.619 | 472.55 | 472.94 | 2923993.0 |
| 2024-01-11 12:30:00 | SPY | ETF | 472.96 | 474.355 | 472.96 | 473.96 | 2622370.0 |
| 2024-01-11 13:00:00 | SPY | ETF | 473.95 | 475.04 | 473.88 | 474.75 | 3524888.0 |
| 2024-01-11 13:30:00 | SPY | ETF | 474.76 | 475.82 | 474.6101 | 475.7588 | 3125478.0 |
| 2024-01-11 14:00:00 | SPY | ETF | 475.76 | 476.23 | 475.32 | 476.1 | 3646075.0 |
| 2024-01-11 14:30:00 | SPY | ETF | 476.11 | 476.979 | 475.92 | 476.81 | 3169263.0 |
| 2024-01-11 15:00:00 | SPY | ETF | 476.83 | 476.92 | 475.465 | 475.91 | 3713610.0 |
| 2024-01-11 15:30:00 | SPY | ETF | 475.9 | 476.7 | 475.54 | 476.32 | 8098756.0 |
| 2024-01-11 16:00:00 | SPY | ETF | 476.32 | 476.4 | 476.18 | 476.2 | 3487018.0 |
| 2024-01-11 16:30:00 | SPY | ETF | 476.19 | 476.22 | 475.98 | 476.07 | 155561.0 |
| 2024-01-11 17:00:00 | SPY | ETF | 476.1 | 476.3 | 475.98 | 475.98 | 68635.0 |
| 2024-01-11 17:30:00 | SPY | ETF | 475.98 | 476.05 | 475.92 | 476.04 | 12211.0 |
| 2024-01-11 18:00:00 | SPY | ETF | 475.97 | 476.25 | 475.79 | 476.19 | 41492.0 |
| 2024-01-11 18:30:00 | SPY | ETF | 476.19 | 476.22 | 475.8 | 476.03 | 17751.0 |
| 2024-01-11 19:00:00 | SPY | ETF | 476.07 | 476.19 | 475.96 | 475.98 | 15770.0 |
| 2024-01-11 19:30:00 | SPY | ETF | 475.96 | 475.97 | 475.39 | 475.46 | 42270.0 |
| 2024-01-11 04:00:00 | QQQ | ETF | 410.64 | 411.19 | 410.5 | 410.53 | 73761.0 |
| 2024-01-11 04:30:00 | QQQ | ETF | 410.53 | 410.53 | 410.1 | 410.3 | 24184.0 |
| 2024-01-11 05:00:00 | QQQ | ETF | 410.25 | 410.37 | 410.02 | 410.25 | 15031.0 |
| 2024-01-11 05:30:00 | QQQ | ETF | 410.28 | 410.3 | 410.09 | 410.3 | 14216.0 |
| 2024-01-11 06:00:00 | QQQ | ETF | 410.31 | 410.72 | 410.31 | 410.51 | 30160.0 |
| 2024-01-11 06:30:00 | QQQ | ETF | 410.51 | 410.53 | 410.15 | 410.4 | 14881.0 |
| 2024-01-11 07:00:00 | QQQ | ETF | 410.37 | 410.6 | 410.22 | 410.44 | 49623.0 |
| 2024-01-11 07:30:00 | QQQ | ETF | 410.4 | 410.57 | 410.26 | 410.29 | 54569.0 |
| 2024-01-11 08:00:00 | QQQ | ETF | 410.3701 | 411.25 | 408.194 | 410.97 | 178837.0 |
| 2024-01-11 08:30:00 | QQQ | ETF | 410.96 | 411.36 | 407.6 | 407.87 | 1473910.0 |
| 2024-01-11 09:00:00 | QQQ | ETF | 407.94 | 409.85 | 407.84 | 409.78 | 433892.0 |
| 2024-01-11 09:30:00 | QQQ | ETF | 409.79 | 411.2004 | 408.4295 | 409.15 | 5694373.0 |
| 2024-01-11 10:00:00 | QQQ | ETF | 409.19 | 409.255 | 405.96 | 407.57 | 5505668.0 |
| 2024-01-11 10:30:00 | QQQ | ETF | 407.569 | 408.41 | 406.36 | 406.697 | 2730211.0 |
| 2024-01-11 11:00:00 | QQQ | ETF | 406.7 | 406.96 | 404.8 | 405.27 | 3371570.0 |
| 2024-01-11 11:30:00 | QQQ | ETF | 405.27 | 405.685 | 404.242 | 404.73 | 3363513.0 |
| 2024-01-11 12:00:00 | QQQ | ETF | 404.73 | 405.835 | 404.69 | 405.01 | 2048097.0 |
| 2024-01-11 12:30:00 | QQQ | ETF | 405.015 | 406.765 | 405.015 | 406.31 | 1814818.0 |
> showing 50 of 31,498 rows — these rows as CSV