PREVIEW / stock_30min / 2023-05-26
file: by_date/stock_30min/2023/2023-05-26.parquet size: 2.0 MB rows: 99,852 symbols: 1,652
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-05-26 04:00:00 | AAPL | Stock | 172.7 | 173.09 | 172.7 | 173.0 | 1560.0 |
| 2023-05-26 04:30:00 | AAPL | Stock | 172.98 | 173.12 | 172.98 | 173.12 | 5829.0 |
| 2023-05-26 05:00:00 | AAPL | Stock | 173.31 | 173.31 | 173.09 | 173.1 | 541.0 |
| 2023-05-26 05:30:00 | AAPL | Stock | 173.08 | 173.08 | 173.0 | 173.0 | 1862.0 |
| 2023-05-26 06:00:00 | AAPL | Stock | 173.02 | 173.14 | 172.92 | 173.01 | 2897.0 |
| 2023-05-26 06:30:00 | AAPL | Stock | 173.3 | 173.38 | 173.3 | 173.38 | 1204.0 |
| 2023-05-26 07:00:00 | AAPL | Stock | 173.3 | 173.45 | 173.3 | 173.43 | 10510.0 |
| 2023-05-26 07:30:00 | AAPL | Stock | 173.45 | 173.5 | 173.32 | 173.44 | 13338.0 |
| 2023-05-26 08:00:00 | AAPL | Stock | 173.35 | 173.49 | 172.57 | 173.3 | 68983.0 |
| 2023-05-26 08:30:00 | AAPL | Stock | 173.4 | 173.4 | 172.9 | 173.2842 | 65597.0 |
| 2023-05-26 09:00:00 | AAPL | Stock | 173.39 | 173.68 | 173.2 | 173.31 | 96835.0 |
| 2023-05-26 09:30:00 | AAPL | Stock | 173.31 | 174.748 | 173.11 | 174.6 | 5151362.0 |
| 2023-05-26 10:00:00 | AAPL | Stock | 174.6 | 175.39 | 174.51 | 175.345 | 3818606.0 |
| 2023-05-26 10:30:00 | AAPL | Stock | 175.36 | 175.58 | 175.21 | 175.43 | 3165191.0 |
| 2023-05-26 11:00:00 | AAPL | Stock | 175.43 | 175.77 | 174.88 | 175.03 | 3146548.0 |
| 2023-05-26 11:30:00 | AAPL | Stock | 175.03 | 175.54 | 175.0 | 175.12 | 2223236.0 |
| 2023-05-26 12:00:00 | AAPL | Stock | 175.12 | 175.32 | 175.02 | 175.3087 | 2065158.0 |
| 2023-05-26 12:30:00 | AAPL | Stock | 175.305 | 175.35 | 175.06 | 175.235 | 1694132.0 |
| 2023-05-26 13:00:00 | AAPL | Stock | 175.235 | 175.53 | 175.22 | 175.385 | 1662057.0 |
| 2023-05-26 13:30:00 | AAPL | Stock | 175.39 | 175.485 | 175.115 | 175.215 | 1666618.0 |
| 2023-05-26 14:00:00 | AAPL | Stock | 175.215 | 175.24 | 174.84 | 175.015 | 1854452.0 |
| 2023-05-26 14:30:00 | AAPL | Stock | 175.015 | 175.26 | 174.98 | 175.125 | 1627983.0 |
| 2023-05-26 15:00:00 | AAPL | Stock | 175.125 | 175.45 | 174.9601 | 175.38 | 2394174.0 |
| 2023-05-26 15:30:00 | AAPL | Stock | 175.375 | 175.665 | 175.21 | 175.38 | 5970965.0 |
| 2023-05-26 16:00:00 | AAPL | Stock | 175.38 | 175.6 | 175.31 | 175.52 | 7715684.0 |
| 2023-05-26 16:30:00 | AAPL | Stock | 175.52 | 175.68 | 175.43 | 175.64 | 25744.0 |
| 2023-05-26 17:00:00 | AAPL | Stock | 175.64 | 175.65 | 175.5294 | 175.53 | 9388.0 |
| 2023-05-26 17:30:00 | AAPL | Stock | 175.53 | 175.55 | 175.5 | 175.5 | 3283.0 |
| 2023-05-26 18:00:00 | AAPL | Stock | 175.51 | 175.59 | 175.3 | 175.5 | 22372.0 |
| 2023-05-26 18:30:00 | AAPL | Stock | 175.46 | 175.5388 | 175.45 | 175.5 | 5764.0 |
| 2023-05-26 19:00:00 | AAPL | Stock | 175.46 | 175.5 | 175.45 | 175.4999 | 3022.0 |
| 2023-05-26 19:30:00 | AAPL | Stock | 175.45 | 175.5 | 175.43 | 175.5 | 13701.0 |
| 2023-05-26 04:00:00 | MSFT | Stock | 324.5 | 325.24 | 324.5 | 325.02 | 2440.0 |
| 2023-05-26 04:30:00 | MSFT | Stock | 325.25 | 325.57 | 325.21 | 325.57 | 1694.0 |
| 2023-05-26 05:00:00 | MSFT | Stock | 324.81 | 324.81 | 324.8 | 324.8 | 781.0 |
| 2023-05-26 05:30:00 | MSFT | Stock | 324.82 | 324.9 | 324.82 | 324.9 | 678.0 |
| 2023-05-26 06:00:00 | MSFT | Stock | 324.66 | 324.75 | 324.53 | 324.53 | 1603.0 |
| 2023-05-26 06:30:00 | MSFT | Stock | 324.78 | 325.35 | 324.75 | 325.35 | 3791.0 |
| 2023-05-26 07:00:00 | MSFT | Stock | 325.22 | 325.4 | 324.33 | 324.77 | 10088.0 |
| 2023-05-26 07:30:00 | MSFT | Stock | 324.7 | 324.92 | 324.22 | 324.92 | 14023.0 |
| 2023-05-26 08:00:00 | MSFT | Stock | 325.34 | 325.4536 | 323.0 | 324.42 | 42155.0 |
| 2023-05-26 08:30:00 | MSFT | Stock | 324.5 | 324.62 | 323.8 | 324.49 | 46127.0 |
| 2023-05-26 09:00:00 | MSFT | Stock | 324.55 | 324.87 | 323.49 | 323.98 | 29236.0 |
| 2023-05-26 09:30:00 | MSFT | Stock | 323.98 | 328.0 | 323.88 | 327.645 | 3620808.0 |
| 2023-05-26 10:00:00 | MSFT | Stock | 327.68 | 329.3 | 327.01 | 329.27 | 1754831.0 |
| 2023-05-26 10:30:00 | MSFT | Stock | 329.29 | 330.97 | 328.84 | 330.72 | 1898596.0 |
| 2023-05-26 11:00:00 | MSFT | Stock | 330.685 | 331.82 | 329.84 | 331.3699 | 2306813.0 |
| 2023-05-26 11:30:00 | MSFT | Stock | 331.36 | 332.9641 | 331.1 | 332.8 | 1978302.0 |
| 2023-05-26 12:00:00 | MSFT | Stock | 332.78 | 332.84 | 331.45 | 331.7 | 1360420.0 |
| 2023-05-26 12:30:00 | MSFT | Stock | 331.7 | 332.07 | 331.2648 | 331.49 | 1016631.0 |
> showing 50 of 99,852 rows — these rows as CSV