PREVIEW / stock_30min / 2023-08-29
file: by_date/stock_30min/2023/2023-08-29.parquet size: 2.0 MB rows: 97,145 symbols: 1,458
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-08-29 04:00:00 | AAPL | Stock | 180.25 | 180.38 | 180.01 | 180.26 | 9634.0 |
| 2023-08-29 04:30:00 | AAPL | Stock | 180.1 | 180.32 | 180.1 | 180.1 | 4235.0 |
| 2023-08-29 05:00:00 | AAPL | Stock | 180.08 | 180.25 | 180.05 | 180.2 | 4664.0 |
| 2023-08-29 05:30:00 | AAPL | Stock | 180.22 | 180.38 | 180.22 | 180.38 | 3216.0 |
| 2023-08-29 06:00:00 | AAPL | Stock | 180.43 | 180.55 | 180.29 | 180.43 | 7660.0 |
| 2023-08-29 06:30:00 | AAPL | Stock | 180.46 | 180.51 | 180.26 | 180.29 | 6311.0 |
| 2023-08-29 07:00:00 | AAPL | Stock | 180.3 | 180.4 | 180.21 | 180.21 | 13871.0 |
| 2023-08-29 07:30:00 | AAPL | Stock | 180.25 | 180.3 | 180.1 | 180.23 | 6020.0 |
| 2023-08-29 08:00:00 | AAPL | Stock | 180.39 | 180.4 | 179.91 | 179.99 | 56446.0 |
| 2023-08-29 08:30:00 | AAPL | Stock | 179.93 | 180.12 | 179.93 | 180.07 | 26132.0 |
| 2023-08-29 09:00:00 | AAPL | Stock | 180.08 | 180.24 | 179.35 | 179.72 | 138263.0 |
| 2023-08-29 09:30:00 | AAPL | Stock | 179.695 | 181.15 | 179.5 | 180.91 | 4014451.0 |
| 2023-08-29 10:00:00 | AAPL | Stock | 180.91 | 182.57 | 180.86 | 182.4 | 4493753.0 |
| 2023-08-29 10:30:00 | AAPL | Stock | 182.41 | 182.67 | 182.21 | 182.295 | 3077191.0 |
| 2023-08-29 11:00:00 | AAPL | Stock | 182.2999 | 183.12 | 182.28 | 183.03 | 2409716.0 |
| 2023-08-29 11:30:00 | AAPL | Stock | 183.03 | 183.53 | 183.01 | 183.185 | 2200393.0 |
| 2023-08-29 12:00:00 | AAPL | Stock | 183.185 | 183.59 | 183.125 | 183.585 | 2368347.0 |
| 2023-08-29 12:30:00 | AAPL | Stock | 183.585 | 183.75 | 183.3901 | 183.59 | 1848525.0 |
| 2023-08-29 13:00:00 | AAPL | Stock | 183.6 | 183.8101 | 183.4562 | 183.74 | 1591300.0 |
| 2023-08-29 13:30:00 | AAPL | Stock | 183.74 | 184.0 | 183.49 | 183.705 | 1968535.0 |
| 2023-08-29 14:00:00 | AAPL | Stock | 183.7 | 184.37 | 183.661 | 184.3301 | 2280852.0 |
| 2023-08-29 14:30:00 | AAPL | Stock | 184.33 | 184.54 | 184.1801 | 184.51 | 2186696.0 |
| 2023-08-29 15:00:00 | AAPL | Stock | 184.509 | 184.8475 | 184.28 | 184.815 | 2703934.0 |
| 2023-08-29 15:30:00 | AAPL | Stock | 184.815 | 184.9 | 183.86 | 184.12 | 6016265.0 |
| 2023-08-29 16:00:00 | AAPL | Stock | 184.12 | 184.3 | 184.1 | 184.22 | 7550102.0 |
| 2023-08-29 16:30:00 | AAPL | Stock | 184.22 | 184.49 | 184.12 | 184.38 | 142289.0 |
| 2023-08-29 17:00:00 | AAPL | Stock | 184.37 | 184.48 | 184.37 | 184.4787 | 19694.0 |
| 2023-08-29 17:30:00 | AAPL | Stock | 184.47 | 184.48 | 184.33 | 184.38 | 19164.0 |
| 2023-08-29 18:00:00 | AAPL | Stock | 184.38 | 184.7 | 184.38 | 184.58 | 25774.0 |
| 2023-08-29 18:30:00 | AAPL | Stock | 184.58 | 184.62 | 184.51 | 184.57 | 13412.0 |
| 2023-08-29 19:00:00 | AAPL | Stock | 184.52 | 184.59 | 184.4 | 184.58 | 13788.0 |
| 2023-08-29 19:30:00 | AAPL | Stock | 184.55 | 184.6 | 184.43 | 184.57 | 17606.0 |
| 2023-08-29 04:00:00 | MSFT | Stock | 323.77 | 324.1 | 323.77 | 323.9 | 891.0 |
| 2023-08-29 05:00:00 | MSFT | Stock | 324.0 | 324.0 | 323.6 | 323.6 | 937.0 |
| 2023-08-29 05:30:00 | MSFT | Stock | 323.8 | 324.1 | 323.8 | 324.1 | 736.0 |
| 2023-08-29 06:30:00 | MSFT | Stock | 324.2 | 324.2 | 323.7 | 323.7 | 400.0 |
| 2023-08-29 07:00:00 | MSFT | Stock | 323.67 | 324.1 | 323.67 | 324.0 | 905.0 |
| 2023-08-29 07:30:00 | MSFT | Stock | 323.55 | 323.55 | 322.57 | 322.97 | 4834.0 |
| 2023-08-29 08:00:00 | MSFT | Stock | 323.6101 | 324.1 | 322.1 | 322.11 | 9718.0 |
| 2023-08-29 08:30:00 | MSFT | Stock | 322.1 | 322.66 | 322.1 | 322.55 | 3082.0 |
| 2023-08-29 09:00:00 | MSFT | Stock | 322.5 | 322.88 | 321.55 | 322.0 | 16752.0 |
| 2023-08-29 09:30:00 | MSFT | Stock | 321.88 | 323.6979 | 321.88 | 323.05 | 1420060.0 |
| 2023-08-29 10:00:00 | MSFT | Stock | 323.035 | 326.94 | 323.035 | 326.75 | 1526105.0 |
| 2023-08-29 10:30:00 | MSFT | Stock | 326.78 | 328.0 | 326.78 | 327.22 | 954168.0 |
| 2023-08-29 11:00:00 | MSFT | Stock | 327.26 | 328.23 | 327.16 | 327.819 | 574816.0 |
| 2023-08-29 11:30:00 | MSFT | Stock | 327.8091 | 328.9835 | 327.77 | 328.015 | 572950.0 |
| 2023-08-29 12:00:00 | MSFT | Stock | 328.03 | 328.135 | 327.25 | 327.96 | 572055.0 |
| 2023-08-29 12:30:00 | MSFT | Stock | 327.9605 | 328.35 | 327.42 | 327.84 | 435906.0 |
| 2023-08-29 13:00:00 | MSFT | Stock | 327.87 | 328.19 | 327.6 | 327.8232 | 291147.0 |
| 2023-08-29 13:30:00 | MSFT | Stock | 327.83 | 328.43 | 326.98 | 327.3899 | 403537.0 |
> showing 50 of 97,145 rows — these rows as CSV