PREVIEW / stock_30min / 2024-09-09
file: by_date/stock_30min/2024/2024-09-09.parquet size: 2.0 MB rows: 98,475 symbols: 877
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-09-09 04:00:00 | AAPL | Stock | 221.95 | 223.0 | 221.59 | 222.72 | 17284.0 |
| 2024-09-09 04:30:00 | AAPL | Stock | 222.76 | 223.0 | 222.76 | 222.95 | 7032.0 |
| 2024-09-09 05:00:00 | AAPL | Stock | 222.74 | 222.75 | 222.57 | 222.64 | 6280.0 |
| 2024-09-09 05:30:00 | AAPL | Stock | 222.7 | 222.7 | 222.42 | 222.49 | 5379.0 |
| 2024-09-09 06:00:00 | AAPL | Stock | 222.49 | 222.62 | 222.29 | 222.3 | 16466.0 |
| 2024-09-09 06:30:00 | AAPL | Stock | 222.23 | 222.27 | 221.71 | 221.79 | 21685.0 |
| 2024-09-09 07:00:00 | AAPL | Stock | 221.9 | 222.19 | 220.68 | 222.17 | 41132.0 |
| 2024-09-09 07:30:00 | AAPL | Stock | 222.11 | 222.11 | 221.2 | 221.2 | 15506.0 |
| 2024-09-09 08:00:00 | AAPL | Stock | 222.0019 | 222.82 | 220.56 | 220.6 | 117492.0 |
| 2024-09-09 08:30:00 | AAPL | Stock | 220.73 | 221.2498 | 220.6428 | 221.0 | 55477.0 |
| 2024-09-09 09:00:00 | AAPL | Stock | 220.86 | 220.98 | 220.35 | 220.85 | 114718.0 |
| 2024-09-09 09:30:00 | AAPL | Stock | 220.83 | 221.27 | 217.82 | 219.24 | 6711341.0 |
| 2024-09-09 10:00:00 | AAPL | Stock | 219.2 | 220.2 | 218.74 | 218.875 | 3198184.0 |
| 2024-09-09 10:30:00 | AAPL | Stock | 218.88 | 218.88 | 217.1 | 217.2 | 3119362.0 |
| 2024-09-09 11:00:00 | AAPL | Stock | 217.2 | 219.01 | 217.05 | 218.96 | 1841156.0 |
| 2024-09-09 11:30:00 | AAPL | Stock | 218.98 | 219.91 | 218.93 | 219.91 | 1633159.0 |
| 2024-09-09 12:00:00 | AAPL | Stock | 219.89 | 220.5 | 219.6483 | 220.22 | 1662512.0 |
| 2024-09-09 12:30:00 | AAPL | Stock | 220.2126 | 220.61 | 219.81 | 220.15 | 1342746.0 |
| 2024-09-09 13:00:00 | AAPL | Stock | 220.16 | 220.93 | 219.9 | 220.84 | 1784419.0 |
| 2024-09-09 13:30:00 | AAPL | Stock | 220.838 | 220.88 | 218.4843 | 219.1694 | 4261279.0 |
| 2024-09-09 14:00:00 | AAPL | Stock | 219.155 | 219.155 | 217.08 | 217.17 | 5090931.0 |
| 2024-09-09 14:30:00 | AAPL | Stock | 217.14 | 218.0 | 216.71 | 217.88 | 4497076.0 |
| 2024-09-09 15:00:00 | AAPL | Stock | 217.87 | 219.2725 | 217.782 | 219.26 | 3026910.0 |
| 2024-09-09 15:30:00 | AAPL | Stock | 219.27 | 221.06 | 219.27 | 220.99 | 6668510.0 |
| 2024-09-09 16:00:00 | AAPL | Stock | 220.95 | 221.7901 | 220.88 | 221.48 | 6676785.0 |
| 2024-09-09 16:30:00 | AAPL | Stock | 221.38 | 221.507 | 220.9 | 221.0449 | 153881.0 |
| 2024-09-09 17:00:00 | AAPL | Stock | 221.05 | 221.2464 | 221.0 | 221.15 | 35171.0 |
| 2024-09-09 17:30:00 | AAPL | Stock | 221.15 | 221.24 | 221.02 | 221.12 | 16791.0 |
| 2024-09-09 18:00:00 | AAPL | Stock | 221.15 | 221.15 | 220.8124 | 220.8124 | 26090.0 |
| 2024-09-09 18:30:00 | AAPL | Stock | 220.8142 | 220.9 | 220.3928 | 220.4205 | 17344.0 |
| 2024-09-09 19:00:00 | AAPL | Stock | 220.5 | 220.8 | 220.5 | 220.78 | 29857.0 |
| 2024-09-09 19:30:00 | AAPL | Stock | 220.713 | 220.8797 | 220.7 | 220.8797 | 22471.0 |
| 2024-09-09 04:00:00 | MSFT | Stock | 404.58 | 406.0 | 404.58 | 405.43 | 1885.0 |
| 2024-09-09 04:30:00 | MSFT | Stock | 405.5 | 405.92 | 405.5 | 405.7 | 2452.0 |
| 2024-09-09 05:00:00 | MSFT | Stock | 405.98 | 406.48 | 405.98 | 406.48 | 500.0 |
| 2024-09-09 05:30:00 | MSFT | Stock | 406.8 | 407.0 | 406.55 | 406.55 | 2034.0 |
| 2024-09-09 06:00:00 | MSFT | Stock | 406.79 | 406.95 | 406.69 | 406.69 | 1475.0 |
| 2024-09-09 06:30:00 | MSFT | Stock | 406.68 | 406.83 | 406.51 | 406.6 | 2625.0 |
| 2024-09-09 07:00:00 | MSFT | Stock | 406.2 | 406.8 | 406.01 | 406.45 | 5972.0 |
| 2024-09-09 07:30:00 | MSFT | Stock | 406.42 | 406.42 | 406.0 | 406.0 | 1250.0 |
| 2024-09-09 08:00:00 | MSFT | Stock | 406.5 | 406.68 | 402.704 | 405.28 | 21110.0 |
| 2024-09-09 08:30:00 | MSFT | Stock | 405.28 | 405.7 | 405.21 | 405.6 | 9376.0 |
| 2024-09-09 09:00:00 | MSFT | Stock | 405.54 | 407.5 | 405.3635 | 407.12 | 26844.0 |
| 2024-09-09 09:30:00 | MSFT | Stock | 407.12 | 408.65 | 405.7 | 406.8 | 1567786.0 |
| 2024-09-09 10:00:00 | MSFT | Stock | 406.76 | 406.8138 | 403.99 | 404.31 | 564336.0 |
| 2024-09-09 10:30:00 | MSFT | Stock | 404.2901 | 404.38 | 402.3 | 402.31 | 641535.0 |
| 2024-09-09 11:00:00 | MSFT | Stock | 402.355 | 403.59 | 402.15 | 403.3 | 469026.0 |
| 2024-09-09 11:30:00 | MSFT | Stock | 403.295 | 404.615 | 403.11 | 404.59 | 322636.0 |
| 2024-09-09 12:00:00 | MSFT | Stock | 404.615 | 405.54 | 404.4 | 405.4309 | 305761.0 |
| 2024-09-09 12:30:00 | MSFT | Stock | 405.409 | 405.945 | 404.8 | 404.9 | 387564.0 |
> showing 50 of 98,475 rows — these rows as CSV