PREVIEW / stock_30min / 2023-10-16
file: by_date/stock_30min/2023/2023-10-16.parquet size: 2.0 MB rows: 98,715 symbols: 1,341
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 |
|---|---|---|---|---|---|---|---|
| 2023-10-16 04:00:00 | AAPL | Stock | 178.54 | 178.76 | 178.2 | 178.69 | 8734.0 |
| 2023-10-16 04:30:00 | AAPL | Stock | 178.66 | 178.84 | 178.62 | 178.78 | 10928.0 |
| 2023-10-16 05:00:00 | AAPL | Stock | 178.65 | 178.67 | 178.52 | 178.52 | 4978.0 |
| 2023-10-16 05:30:00 | AAPL | Stock | 178.44 | 178.6 | 178.44 | 178.46 | 5563.0 |
| 2023-10-16 06:00:00 | AAPL | Stock | 178.43 | 178.43 | 175.84 | 176.77 | 71246.0 |
| 2023-10-16 06:30:00 | AAPL | Stock | 176.83 | 177.1 | 176.6 | 177.1 | 34908.0 |
| 2023-10-16 07:00:00 | AAPL | Stock | 177.14 | 177.5 | 176.85 | 177.5 | 50756.0 |
| 2023-10-16 07:30:00 | AAPL | Stock | 177.55 | 177.85 | 177.25 | 177.45 | 48103.0 |
| 2023-10-16 08:00:00 | AAPL | Stock | 177.29 | 179.02 | 176.8504 | 177.4 | 90005.0 |
| 2023-10-16 08:30:00 | AAPL | Stock | 177.5 | 178.2 | 177.43 | 178.15 | 81378.0 |
| 2023-10-16 09:00:00 | AAPL | Stock | 178.14 | 178.18 | 176.33 | 176.75 | 347688.0 |
| 2023-10-16 09:30:00 | AAPL | Stock | 176.76 | 178.36 | 176.51 | 177.8 | 7307584.0 |
| 2023-10-16 10:00:00 | AAPL | Stock | 177.81 | 178.5475 | 177.34 | 178.444 | 3481318.0 |
| 2023-10-16 10:30:00 | AAPL | Stock | 178.45 | 178.85 | 178.4 | 178.82 | 2734911.0 |
| 2023-10-16 11:00:00 | AAPL | Stock | 178.82 | 179.075 | 178.295 | 178.509 | 2430795.0 |
| 2023-10-16 11:30:00 | AAPL | Stock | 178.52 | 178.69 | 178.03 | 178.0301 | 1846449.0 |
| 2023-10-16 12:00:00 | AAPL | Stock | 178.035 | 178.06 | 177.625 | 177.82 | 2163878.0 |
| 2023-10-16 12:30:00 | AAPL | Stock | 177.83 | 177.94 | 177.28 | 177.55 | 2210379.0 |
| 2023-10-16 13:00:00 | AAPL | Stock | 177.5494 | 177.84 | 176.85 | 177.465 | 2575636.0 |
| 2023-10-16 13:30:00 | AAPL | Stock | 177.47 | 178.22 | 177.4301 | 178.15 | 2163550.0 |
| 2023-10-16 14:00:00 | AAPL | Stock | 178.15 | 178.3546 | 177.82 | 178.13 | 1901024.0 |
| 2023-10-16 14:30:00 | AAPL | Stock | 178.125 | 178.55 | 177.9 | 178.5273 | 1804310.0 |
| 2023-10-16 15:00:00 | AAPL | Stock | 178.53 | 178.82 | 178.24 | 178.79 | 2184361.0 |
| 2023-10-16 15:30:00 | AAPL | Stock | 178.79 | 179.0 | 178.4 | 178.675 | 5814343.0 |
| 2023-10-16 16:00:00 | AAPL | Stock | 178.67 | 178.82 | 178.54 | 178.81 | 4908640.0 |
| 2023-10-16 16:30:00 | AAPL | Stock | 178.8 | 178.81 | 178.51 | 178.73 | 42217.0 |
| 2023-10-16 17:00:00 | AAPL | Stock | 178.7 | 178.79 | 178.66 | 178.66 | 9046.0 |
| 2023-10-16 17:30:00 | AAPL | Stock | 178.7 | 178.75 | 178.6735 | 178.6756 | 5085.0 |
| 2023-10-16 18:00:00 | AAPL | Stock | 178.72 | 178.72 | 178.68 | 178.72 | 2366.0 |
| 2023-10-16 18:30:00 | AAPL | Stock | 178.7 | 178.71 | 178.6 | 178.6 | 6707.0 |
| 2023-10-16 19:00:00 | AAPL | Stock | 178.6 | 178.68 | 178.51 | 178.53 | 4728.0 |
| 2023-10-16 19:30:00 | AAPL | Stock | 178.6 | 178.7 | 178.54 | 178.7 | 22698.0 |
| 2023-10-16 04:00:00 | MSFT | Stock | 327.0 | 327.5 | 326.97 | 327.5 | 11758.0 |
| 2023-10-16 04:30:00 | MSFT | Stock | 328.3 | 329.25 | 328.2 | 328.98 | 1484.0 |
| 2023-10-16 05:00:00 | MSFT | Stock | 328.89 | 328.89 | 328.4 | 328.43 | 1457.0 |
| 2023-10-16 05:30:00 | MSFT | Stock | 328.57 | 328.62 | 328.24 | 328.24 | 1388.0 |
| 2023-10-16 06:00:00 | MSFT | Stock | 328.02 | 328.5 | 327.56 | 328.5 | 2729.0 |
| 2023-10-16 06:30:00 | MSFT | Stock | 328.79 | 329.98 | 328.79 | 329.84 | 5968.0 |
| 2023-10-16 07:00:00 | MSFT | Stock | 329.85 | 330.24 | 329.5 | 330.0 | 5104.0 |
| 2023-10-16 07:30:00 | MSFT | Stock | 330.0 | 330.49 | 329.8 | 330.22 | 16122.0 |
| 2023-10-16 08:00:00 | MSFT | Stock | 329.75 | 330.49 | 327.71 | 329.85 | 16358.0 |
| 2023-10-16 08:30:00 | MSFT | Stock | 330.1 | 330.5 | 330.0 | 330.32 | 10169.0 |
| 2023-10-16 09:00:00 | MSFT | Stock | 330.45 | 331.3 | 330.12 | 331.13 | 31124.0 |
| 2023-10-16 09:30:00 | MSFT | Stock | 331.05 | 333.39 | 330.6 | 332.5 | 2642626.0 |
| 2023-10-16 10:00:00 | MSFT | Stock | 332.48 | 335.33 | 331.96 | 335.11 | 1912511.0 |
| 2023-10-16 10:30:00 | MSFT | Stock | 335.13 | 336.14 | 334.54 | 334.82 | 1189133.0 |
| 2023-10-16 11:00:00 | MSFT | Stock | 334.86 | 335.35 | 333.86 | 334.47 | 860485.0 |
| 2023-10-16 11:30:00 | MSFT | Stock | 334.49 | 334.62 | 333.61 | 333.6467 | 586786.0 |
| 2023-10-16 12:00:00 | MSFT | Stock | 333.67 | 333.98 | 333.15 | 333.915 | 497325.0 |
| 2023-10-16 12:30:00 | MSFT | Stock | 333.91 | 334.1 | 333.38 | 333.76 | 343660.0 |
> showing 50 of 98,715 rows — these rows as CSV