PREVIEW / stock_30min / 2024-06-18
file: by_date/stock_30min/2024/2024-06-18.parquet size: 2.1 MB rows: 99,076 symbols: 939
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-18 04:00:00 | AAPL | Stock | 216.81 | 217.5 | 215.0 | 217.0 | 26092.0 |
| 2024-06-18 04:30:00 | AAPL | Stock | 216.92 | 217.03 | 216.83 | 216.9 | 6014.0 |
| 2024-06-18 05:00:00 | AAPL | Stock | 216.96 | 218.36 | 216.93 | 217.81 | 67525.0 |
| 2024-06-18 05:30:00 | AAPL | Stock | 217.94 | 218.3 | 217.91 | 218.2 | 17645.0 |
| 2024-06-18 06:00:00 | AAPL | Stock | 218.17 | 218.27 | 217.91 | 218.09 | 5716.0 |
| 2024-06-18 06:30:00 | AAPL | Stock | 218.06 | 218.13 | 217.62 | 217.71 | 7719.0 |
| 2024-06-18 07:00:00 | AAPL | Stock | 217.77 | 217.99 | 217.38 | 217.88 | 44866.0 |
| 2024-06-18 07:30:00 | AAPL | Stock | 217.9 | 218.07 | 217.65 | 217.83 | 31220.0 |
| 2024-06-18 08:00:00 | AAPL | Stock | 217.8 | 218.1237 | 216.61 | 217.9 | 114494.0 |
| 2024-06-18 08:30:00 | AAPL | Stock | 217.95 | 218.2189 | 217.15 | 217.3 | 169379.0 |
| 2024-06-18 09:00:00 | AAPL | Stock | 217.2 | 217.77 | 217.09 | 217.55 | 111738.0 |
| 2024-06-18 09:30:00 | AAPL | Stock | 217.61 | 218.63 | 214.52 | 214.6666 | 11794422.0 |
| 2024-06-18 10:00:00 | AAPL | Stock | 214.68 | 215.96 | 214.44 | 215.325 | 5657103.0 |
| 2024-06-18 10:30:00 | AAPL | Stock | 215.31 | 215.62 | 215.02 | 215.495 | 3397696.0 |
| 2024-06-18 11:00:00 | AAPL | Stock | 215.4998 | 215.82 | 213.44 | 214.35 | 5715227.0 |
| 2024-06-18 11:30:00 | AAPL | Stock | 214.355 | 214.44 | 213.41 | 213.59 | 3050392.0 |
| 2024-06-18 12:00:00 | AAPL | Stock | 213.58 | 214.03 | 213.0 | 213.22 | 3262287.0 |
| 2024-06-18 12:30:00 | AAPL | Stock | 213.22 | 214.23 | 213.21 | 214.2 | 2455804.0 |
| 2024-06-18 13:00:00 | AAPL | Stock | 214.18 | 214.2 | 213.54 | 213.65 | 2622198.0 |
| 2024-06-18 13:30:00 | AAPL | Stock | 213.66 | 214.0557 | 213.41 | 213.575 | 2132273.0 |
| 2024-06-18 14:00:00 | AAPL | Stock | 213.575 | 213.98 | 213.065 | 213.723 | 2343187.0 |
| 2024-06-18 14:30:00 | AAPL | Stock | 213.725 | 214.04 | 213.4001 | 213.865 | 2256148.0 |
| 2024-06-18 15:00:00 | AAPL | Stock | 213.865 | 214.91 | 213.81 | 214.65 | 3625873.0 |
| 2024-06-18 15:30:00 | AAPL | Stock | 214.645 | 215.1 | 213.91 | 214.38 | 6493995.0 |
| 2024-06-18 16:00:00 | AAPL | Stock | 214.3301 | 214.58 | 213.9 | 214.5 | 9798090.0 |
| 2024-06-18 16:30:00 | AAPL | Stock | 214.5 | 214.5 | 214.06 | 214.17 | 113741.0 |
| 2024-06-18 17:00:00 | AAPL | Stock | 214.21 | 214.29 | 214.08 | 214.08 | 67478.0 |
| 2024-06-18 17:30:00 | AAPL | Stock | 214.07 | 214.15 | 214.06 | 214.06 | 23442.0 |
| 2024-06-18 18:00:00 | AAPL | Stock | 214.05 | 214.21 | 214.0011 | 214.17 | 26071.0 |
| 2024-06-18 18:30:00 | AAPL | Stock | 214.17 | 214.18 | 214.03 | 214.15 | 19063.0 |
| 2024-06-18 19:00:00 | AAPL | Stock | 214.11 | 214.159 | 214.04 | 214.05 | 9165.0 |
| 2024-06-18 19:30:00 | AAPL | Stock | 214.05 | 214.13 | 214.0 | 214.02 | 25568.0 |
| 2024-06-18 04:00:00 | MSFT | Stock | 449.44 | 449.44 | 449.1 | 449.37 | 2363.0 |
| 2024-06-18 04:30:00 | MSFT | Stock | 449.25 | 449.92 | 449.25 | 449.92 | 1895.0 |
| 2024-06-18 05:00:00 | MSFT | Stock | 450.01 | 450.05 | 449.91 | 449.91 | 2710.0 |
| 2024-06-18 05:30:00 | MSFT | Stock | 449.91 | 449.95 | 449.76 | 449.76 | 673.0 |
| 2024-06-18 06:00:00 | MSFT | Stock | 450.05 | 450.4 | 449.76 | 450.4 | 1632.0 |
| 2024-06-18 06:30:00 | MSFT | Stock | 450.25 | 450.25 | 449.81 | 449.81 | 1165.0 |
| 2024-06-18 07:00:00 | MSFT | Stock | 449.8 | 449.95 | 449.33 | 449.33 | 4552.0 |
| 2024-06-18 07:30:00 | MSFT | Stock | 449.38 | 449.48 | 449.2 | 449.48 | 2323.0 |
| 2024-06-18 08:00:00 | MSFT | Stock | 449.66 | 450.04 | 447.25 | 449.9776 | 22811.0 |
| 2024-06-18 08:30:00 | MSFT | Stock | 449.95 | 450.5 | 448.4009 | 449.3 | 16791.0 |
| 2024-06-18 09:00:00 | MSFT | Stock | 449.3 | 450.15 | 448.5583 | 449.84 | 14335.0 |
| 2024-06-18 09:30:00 | MSFT | Stock | 449.72 | 450.14 | 446.9 | 447.77 | 1372987.0 |
| 2024-06-18 10:00:00 | MSFT | Stock | 447.785 | 448.33 | 446.4289 | 446.91 | 822990.0 |
| 2024-06-18 10:30:00 | MSFT | Stock | 446.94 | 447.07 | 445.32 | 446.45 | 677371.0 |
| 2024-06-18 11:00:00 | MSFT | Stock | 446.4401 | 446.53 | 444.89 | 445.9 | 611555.0 |
| 2024-06-18 11:30:00 | MSFT | Stock | 445.88 | 446.54 | 445.7 | 446.49 | 348995.0 |
| 2024-06-18 12:00:00 | MSFT | Stock | 446.51 | 447.69 | 446.33 | 446.95 | 390584.0 |
| 2024-06-18 12:30:00 | MSFT | Stock | 446.97 | 447.68 | 446.6 | 447.56 | 286082.0 |
> showing 50 of 99,076 rows — these rows as CSV