PREVIEW / stock_30min / 2024-06-20
file: by_date/stock_30min/2024/2024-06-20.parquet size: 2.1 MB rows: 100,748 symbols: 957
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-06-20 04:00:00 | AAPL | Stock | 215.31 | 215.31 | 214.19 | 214.6 | 34845.0 |
| 2024-06-20 04:30:00 | AAPL | Stock | 214.75 | 214.9 | 214.29 | 214.62 | 12977.0 |
| 2024-06-20 05:00:00 | AAPL | Stock | 214.66 | 214.75 | 214.5 | 214.7 | 10224.0 |
| 2024-06-20 05:30:00 | AAPL | Stock | 214.65 | 214.65 | 214.5 | 214.65 | 3831.0 |
| 2024-06-20 06:00:00 | AAPL | Stock | 214.69 | 214.75 | 214.69 | 214.74 | 1937.0 |
| 2024-06-20 06:30:00 | AAPL | Stock | 214.65 | 214.69 | 213.91 | 214.37 | 18643.0 |
| 2024-06-20 07:00:00 | AAPL | Stock | 214.36 | 214.5 | 213.67 | 213.93 | 36726.0 |
| 2024-06-20 07:30:00 | AAPL | Stock | 213.82 | 213.83 | 213.5 | 213.65 | 18817.0 |
| 2024-06-20 08:00:00 | AAPL | Stock | 214.3 | 214.7755 | 213.2 | 213.94 | 196138.0 |
| 2024-06-20 08:30:00 | AAPL | Stock | 213.94 | 214.1 | 213.65 | 213.7 | 58437.0 |
| 2024-06-20 09:00:00 | AAPL | Stock | 213.67 | 214.0 | 213.06 | 214.0 | 192361.0 |
| 2024-06-20 09:30:00 | AAPL | Stock | 213.96 | 214.24 | 212.27 | 212.8168 | 8586091.0 |
| 2024-06-20 10:00:00 | AAPL | Stock | 212.82 | 213.15 | 211.48 | 211.6386 | 5378463.0 |
| 2024-06-20 10:30:00 | AAPL | Stock | 211.63 | 211.97 | 210.1 | 211.21 | 5796647.0 |
| 2024-06-20 11:00:00 | AAPL | Stock | 211.22 | 211.33 | 209.53 | 209.535 | 4691029.0 |
| 2024-06-20 11:30:00 | AAPL | Stock | 209.54 | 211.18 | 209.42 | 210.8738 | 4556300.0 |
| 2024-06-20 12:00:00 | AAPL | Stock | 210.88 | 211.04 | 209.52 | 209.525 | 2955384.0 |
| 2024-06-20 12:30:00 | AAPL | Stock | 209.53 | 210.22 | 209.3205 | 209.895 | 2878886.0 |
| 2024-06-20 13:00:00 | AAPL | Stock | 209.895 | 210.2899 | 209.13 | 209.38 | 2492864.0 |
| 2024-06-20 13:30:00 | AAPL | Stock | 209.37 | 210.35 | 209.21 | 209.8 | 2544373.0 |
| 2024-06-20 14:00:00 | AAPL | Stock | 209.79 | 210.61 | 209.74 | 210.04 | 2425482.0 |
| 2024-06-20 14:30:00 | AAPL | Stock | 210.04 | 210.17 | 209.43 | 210.022 | 2968598.0 |
| 2024-06-20 15:00:00 | AAPL | Stock | 210.02 | 210.05 | 209.16 | 209.6732 | 3586917.0 |
| 2024-06-20 15:30:00 | AAPL | Stock | 209.67 | 209.75 | 208.85 | 209.56 | 7435639.0 |
| 2024-06-20 16:00:00 | AAPL | Stock | 209.56 | 210.05 | 209.56 | 209.72 | 9801050.0 |
| 2024-06-20 16:30:00 | AAPL | Stock | 209.71 | 210.0 | 209.68 | 209.95 | 108225.0 |
| 2024-06-20 17:00:00 | AAPL | Stock | 209.95 | 209.96 | 209.68 | 209.8 | 38790.0 |
| 2024-06-20 17:30:00 | AAPL | Stock | 209.8 | 209.86 | 209.5 | 209.5 | 28107.0 |
| 2024-06-20 18:00:00 | AAPL | Stock | 209.69 | 210.174 | 209.51 | 210.17 | 24015.0 |
| 2024-06-20 18:30:00 | AAPL | Stock | 210.13 | 210.18 | 210.02 | 210.02 | 8712.0 |
| 2024-06-20 19:00:00 | AAPL | Stock | 210.04 | 210.1 | 210.0 | 210.05 | 6545.0 |
| 2024-06-20 19:30:00 | AAPL | Stock | 210.03 | 210.04 | 209.75 | 210.0 | 21718.0 |
| 2024-06-20 04:00:00 | MSFT | Stock | 448.0 | 448.01 | 447.2 | 447.77 | 2663.0 |
| 2024-06-20 04:30:00 | MSFT | Stock | 447.79 | 448.58 | 447.78 | 448.2 | 2347.0 |
| 2024-06-20 05:00:00 | MSFT | Stock | 448.09 | 448.64 | 448.0 | 448.6 | 4228.0 |
| 2024-06-20 06:00:00 | MSFT | Stock | 448.54 | 448.93 | 448.54 | 448.93 | 640.0 |
| 2024-06-20 06:30:00 | MSFT | Stock | 449.16 | 449.3 | 449.05 | 449.05 | 1421.0 |
| 2024-06-20 07:00:00 | MSFT | Stock | 448.63 | 448.87 | 447.43 | 447.43 | 7768.0 |
| 2024-06-20 07:30:00 | MSFT | Stock | 447.3 | 447.3 | 446.81 | 447.22 | 7677.0 |
| 2024-06-20 08:00:00 | MSFT | Stock | 448.61 | 449.115 | 445.5 | 446.94 | 40850.0 |
| 2024-06-20 08:30:00 | MSFT | Stock | 447.0 | 447.2353 | 446.0 | 446.62 | 26382.0 |
| 2024-06-20 09:00:00 | MSFT | Stock | 446.62 | 446.62 | 446.13 | 446.2 | 9950.0 |
| 2024-06-20 09:30:00 | MSFT | Stock | 446.3 | 446.53 | 441.27 | 442.47 | 2045644.0 |
| 2024-06-20 10:00:00 | MSFT | Stock | 442.3814 | 443.14 | 441.89 | 442.61 | 1045111.0 |
| 2024-06-20 10:30:00 | MSFT | Stock | 442.61 | 444.13 | 442.46 | 443.55 | 765894.0 |
| 2024-06-20 11:00:00 | MSFT | Stock | 443.55 | 444.29 | 443.05 | 444.1829 | 638416.0 |
| 2024-06-20 11:30:00 | MSFT | Stock | 444.165 | 445.82 | 444.05 | 444.29 | 702663.0 |
| 2024-06-20 12:00:00 | MSFT | Stock | 444.31 | 445.2 | 443.52 | 443.52 | 384699.0 |
| 2024-06-20 12:30:00 | MSFT | Stock | 443.5 | 445.47 | 442.96 | 444.4577 | 484972.0 |
| 2024-06-20 13:00:00 | MSFT | Stock | 444.44 | 445.05 | 443.85 | 444.7 | 382518.0 |
> showing 50 of 100,748 rows — these rows as CSV