PREVIEW / stock_30min / 2024-05-13
file: by_date/stock_30min/2024/2024-05-13.parquet size: 2.0 MB rows: 98,311 symbols: 969
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-05-13 04:00:00 | AAPL | Stock | 184.3 | 184.75 | 183.7 | 184.62 | 32098.0 |
| 2024-05-13 04:30:00 | AAPL | Stock | 184.59 | 184.61 | 184.5 | 184.6 | 20137.0 |
| 2024-05-13 05:00:00 | AAPL | Stock | 184.59 | 184.8 | 184.54 | 184.77 | 13231.0 |
| 2024-05-13 05:30:00 | AAPL | Stock | 184.8 | 185.1 | 184.8 | 184.94 | 16003.0 |
| 2024-05-13 06:00:00 | AAPL | Stock | 184.91 | 184.92 | 184.7 | 184.77 | 8050.0 |
| 2024-05-13 06:30:00 | AAPL | Stock | 184.79 | 185.3 | 184.79 | 185.22 | 21775.0 |
| 2024-05-13 07:00:00 | AAPL | Stock | 185.21 | 185.74 | 185.0 | 185.36 | 60311.0 |
| 2024-05-13 07:30:00 | AAPL | Stock | 185.34 | 185.49 | 185.28 | 185.37 | 30671.0 |
| 2024-05-13 08:00:00 | AAPL | Stock | 185.28 | 185.75 | 183.91 | 185.33 | 148364.0 |
| 2024-05-13 08:30:00 | AAPL | Stock | 185.3598 | 185.5 | 185.27 | 185.49 | 83612.0 |
| 2024-05-13 09:00:00 | AAPL | Stock | 185.5 | 185.54 | 185.03 | 185.49 | 152257.0 |
| 2024-05-13 09:30:00 | AAPL | Stock | 185.5 | 185.65 | 184.62 | 185.185 | 6901065.0 |
| 2024-05-13 10:00:00 | AAPL | Stock | 185.19 | 185.865 | 184.94 | 185.689 | 4061536.0 |
| 2024-05-13 10:30:00 | AAPL | Stock | 185.68 | 186.43 | 185.63 | 186.0798 | 4854964.0 |
| 2024-05-13 11:00:00 | AAPL | Stock | 186.0701 | 186.27 | 185.805 | 185.92 | 2782303.0 |
| 2024-05-13 11:30:00 | AAPL | Stock | 185.915 | 186.25 | 185.77 | 186.05 | 2237784.0 |
| 2024-05-13 12:00:00 | AAPL | Stock | 186.05 | 186.5 | 185.97 | 186.29 | 3082519.0 |
| 2024-05-13 12:30:00 | AAPL | Stock | 186.29 | 186.88 | 186.27 | 186.815 | 3133451.0 |
| 2024-05-13 13:00:00 | AAPL | Stock | 186.81 | 186.93 | 186.25 | 186.6586 | 3919617.0 |
| 2024-05-13 13:30:00 | AAPL | Stock | 186.66 | 186.84 | 186.37 | 186.7801 | 2437973.0 |
| 2024-05-13 14:00:00 | AAPL | Stock | 186.78 | 186.95 | 186.61 | 186.6501 | 2217217.0 |
| 2024-05-13 14:30:00 | AAPL | Stock | 186.6599 | 186.83 | 186.56 | 186.815 | 1950288.0 |
| 2024-05-13 15:00:00 | AAPL | Stock | 186.8199 | 187.1 | 186.71 | 186.9899 | 3732736.0 |
| 2024-05-13 15:30:00 | AAPL | Stock | 186.985 | 187.03 | 186.07 | 186.285 | 6936824.0 |
| 2024-05-13 16:00:00 | AAPL | Stock | 186.28 | 186.48 | 186.06 | 186.23 | 6514435.0 |
| 2024-05-13 16:30:00 | AAPL | Stock | 186.26 | 186.33 | 186.17 | 186.26 | 128612.0 |
| 2024-05-13 17:00:00 | AAPL | Stock | 186.26 | 186.28 | 186.13 | 186.2 | 16423.0 |
| 2024-05-13 17:30:00 | AAPL | Stock | 186.25 | 186.27 | 186.15 | 186.16 | 8131.0 |
| 2024-05-13 18:00:00 | AAPL | Stock | 186.16 | 186.2801 | 186.16 | 186.23 | 13643.0 |
| 2024-05-13 18:30:00 | AAPL | Stock | 186.27 | 186.29 | 186.212 | 186.25 | 10034.0 |
| 2024-05-13 19:00:00 | AAPL | Stock | 186.25 | 186.3 | 186.23 | 186.23 | 2386.0 |
| 2024-05-13 19:30:00 | AAPL | Stock | 186.21 | 186.26 | 186.11 | 186.14 | 18167.0 |
| 2024-05-13 04:00:00 | MSFT | Stock | 418.6 | 418.62 | 418.24 | 418.59 | 3540.0 |
| 2024-05-13 04:30:00 | MSFT | Stock | 418.6 | 418.68 | 418.15 | 418.15 | 1047.0 |
| 2024-05-13 05:00:00 | MSFT | Stock | 418.23 | 419.0 | 418.23 | 419.0 | 7958.0 |
| 2024-05-13 05:30:00 | MSFT | Stock | 419.12 | 419.35 | 418.95 | 418.95 | 1965.0 |
| 2024-05-13 06:00:00 | MSFT | Stock | 418.65 | 419.24 | 418.65 | 418.9 | 2053.0 |
| 2024-05-13 06:30:00 | MSFT | Stock | 418.81 | 418.81 | 418.64 | 418.64 | 434.0 |
| 2024-05-13 07:00:00 | MSFT | Stock | 418.63 | 418.63 | 415.65 | 417.1 | 13699.0 |
| 2024-05-13 07:30:00 | MSFT | Stock | 417.1 | 417.8 | 417.1 | 417.8 | 7349.0 |
| 2024-05-13 08:00:00 | MSFT | Stock | 418.25 | 419.3 | 415.65 | 417.4 | 30434.0 |
| 2024-05-13 08:30:00 | MSFT | Stock | 417.4795 | 418.55 | 417.4 | 418.5 | 9558.0 |
| 2024-05-13 09:00:00 | MSFT | Stock | 418.39 | 418.5 | 418.08 | 418.25 | 10823.0 |
| 2024-05-13 09:30:00 | MSFT | Stock | 418.01 | 418.348 | 410.82 | 412.11 | 1849256.0 |
| 2024-05-13 10:00:00 | MSFT | Stock | 412.03 | 413.39 | 411.8501 | 413.12 | 598284.0 |
| 2024-05-13 10:30:00 | MSFT | Stock | 413.12 | 413.41 | 412.4295 | 413.355 | 363855.0 |
| 2024-05-13 11:00:00 | MSFT | Stock | 413.37 | 414.04 | 412.9 | 413.855 | 328356.0 |
| 2024-05-13 11:30:00 | MSFT | Stock | 413.85 | 414.71 | 413.39 | 414.32 | 315659.0 |
| 2024-05-13 12:00:00 | MSFT | Stock | 414.3 | 415.37 | 414.3 | 415.28 | 278703.0 |
| 2024-05-13 12:30:00 | MSFT | Stock | 415.29 | 415.7 | 415.08 | 415.08 | 326928.0 |
> showing 50 of 98,311 rows — these rows as CSV