PREVIEW / stock_30min / 2003-09-24
file: by_date/stock_30min/2003/2003-09-24.parquet size: 723 KB rows: 37,503 symbols: 1,615
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 |
|---|---|---|---|---|---|---|---|
| 2003-09-24 08:00:00 | AAPL | Stock | 0.4 | 0.4 | 0.4 | 0.4 | 22400.0 |
| 2003-09-24 08:30:00 | AAPL | Stock | 0.4 | 0.4 | 0.4 | 0.4 | 33600.0 |
| 2003-09-24 09:00:00 | AAPL | Stock | 0.4 | 0.4 | 0.3977 | 0.398 | 515200.0 |
| 2003-09-24 09:30:00 | AAPL | Stock | 0.3966 | 0.3984 | 0.3923 | 0.3936 | 23860200.0 |
| 2003-09-24 10:00:00 | AAPL | Stock | 0.3934 | 0.3945 | 0.3893 | 0.3904 | 17582768.0 |
| 2003-09-24 10:30:00 | AAPL | Stock | 0.3904 | 0.392 | 0.3889 | 0.3891 | 11816448.0 |
| 2003-09-24 11:00:00 | AAPL | Stock | 0.3889 | 0.3896 | 0.3886 | 0.3889 | 11127760.0 |
| 2003-09-24 11:30:00 | AAPL | Stock | 0.3889 | 0.3893 | 0.383 | 0.383 | 29970472.0 |
| 2003-09-24 12:00:00 | AAPL | Stock | 0.3829 | 0.3829 | 0.378 | 0.3815 | 27078520.0 |
| 2003-09-24 12:30:00 | AAPL | Stock | 0.3814 | 0.3829 | 0.377 | 0.3777 | 23776088.0 |
| 2003-09-24 13:00:00 | AAPL | Stock | 0.3779 | 0.3809 | 0.3775 | 0.3777 | 13582352.0 |
| 2003-09-24 13:30:00 | AAPL | Stock | 0.3778 | 0.3795 | 0.3765 | 0.3786 | 7971768.0 |
| 2003-09-24 14:00:00 | AAPL | Stock | 0.3784 | 0.3821 | 0.3779 | 0.3816 | 17311784.0 |
| 2003-09-24 14:30:00 | AAPL | Stock | 0.3813 | 0.3832 | 0.3813 | 0.382 | 14345352.0 |
| 2003-09-24 15:00:00 | AAPL | Stock | 0.3825 | 0.3841 | 0.3813 | 0.3825 | 18088784.0 |
| 2003-09-24 15:30:00 | AAPL | Stock | 0.3827 | 0.3843 | 0.3793 | 0.3795 | 41678280.0 |
| 2003-09-24 16:00:00 | AAPL | Stock | 0.3802 | 0.3814 | 0.3793 | 0.3804 | 1360800.0 |
| 2003-09-24 17:00:00 | AAPL | Stock | 0.3768 | 0.3807 | 0.3768 | 0.3807 | 106400.0 |
| 2003-09-24 17:30:00 | AAPL | Stock | 0.3795 | 0.3795 | 0.3759 | 0.3759 | 87360.0 |
| 2003-09-24 08:00:00 | MSFT | Stock | 29.72 | 29.81 | 29.72 | 29.75 | 18710.0 |
| 2003-09-24 08:30:00 | MSFT | Stock | 29.75 | 29.77 | 29.75 | 29.751 | 16662.0 |
| 2003-09-24 09:00:00 | MSFT | Stock | 29.76 | 29.76 | 29.699 | 29.7 | 65125.0 |
| 2003-09-24 09:30:00 | MSFT | Stock | 29.61 | 29.7 | 29.37 | 29.403 | 6584870.0 |
| 2003-09-24 10:00:00 | MSFT | Stock | 29.403 | 29.5 | 29.31 | 29.361 | 3281039.0 |
| 2003-09-24 10:30:00 | MSFT | Stock | 29.37 | 29.46 | 29.27 | 29.29 | 3372048.0 |
| 2003-09-24 11:00:00 | MSFT | Stock | 29.29 | 29.38 | 29.24 | 29.25 | 2098466.0 |
| 2003-09-24 11:30:00 | MSFT | Stock | 29.25 | 29.3 | 29.11 | 29.13 | 3919132.0 |
| 2003-09-24 12:00:00 | MSFT | Stock | 29.13 | 29.13 | 28.93 | 28.97 | 4729714.0 |
| 2003-09-24 12:30:00 | MSFT | Stock | 28.97 | 29.04 | 28.65 | 28.82 | 4628159.0 |
| 2003-09-24 13:00:00 | MSFT | Stock | 28.821 | 28.84 | 28.65 | 28.69 | 2529274.0 |
| 2003-09-24 13:30:00 | MSFT | Stock | 28.68 | 28.771 | 28.56 | 28.6 | 3357963.0 |
| 2003-09-24 14:00:00 | MSFT | Stock | 28.6 | 28.79 | 28.57 | 28.66 | 3355291.0 |
| 2003-09-24 14:30:00 | MSFT | Stock | 28.66 | 28.71 | 28.52 | 28.55 | 3089494.0 |
| 2003-09-24 15:00:00 | MSFT | Stock | 28.55 | 28.63 | 28.46 | 28.5 | 4037249.0 |
| 2003-09-24 15:30:00 | MSFT | Stock | 28.5 | 28.57 | 28.419 | 28.48 | 6964417.0 |
| 2003-09-24 16:00:00 | MSFT | Stock | 28.47 | 28.54 | 28.41 | 28.46 | 2027491.0 |
| 2003-09-24 16:30:00 | MSFT | Stock | 28.41 | 28.46 | 28.4 | 28.46 | 2582614.0 |
| 2003-09-24 17:00:00 | MSFT | Stock | 28.42 | 28.46 | 28.4 | 28.41 | 14349.0 |
| 2003-09-24 17:30:00 | MSFT | Stock | 28.42 | 28.46 | 28.38 | 28.4 | 159378.0 |
| 2003-09-24 18:00:00 | MSFT | Stock | 28.4 | 28.43 | 28.4 | 28.43 | 3807.0 |
| 2003-09-24 08:00:00 | NVDA | Stock | 0.1604 | 0.1604 | 0.1592 | 0.16 | 3324000.0 |
| 2003-09-24 08:30:00 | NVDA | Stock | 0.1602 | 0.1605 | 0.1579 | 0.1585 | 5568000.0 |
| 2003-09-24 09:00:00 | NVDA | Stock | 0.1587 | 0.1598 | 0.1567 | 0.1574 | 17080800.0 |
| 2003-09-24 09:30:00 | NVDA | Stock | 0.1569 | 0.1583 | 0.1545 | 0.1554 | 171078360.0 |
| 2003-09-24 10:00:00 | NVDA | Stock | 0.1555 | 0.1555 | 0.1527 | 0.1529 | 184379520.0 |
| 2003-09-24 10:30:00 | NVDA | Stock | 0.1529 | 0.1532 | 0.1518 | 0.1527 | 142948080.0 |
| 2003-09-24 11:00:00 | NVDA | Stock | 0.1527 | 0.153 | 0.1517 | 0.1522 | 81689160.0 |
| 2003-09-24 11:30:00 | NVDA | Stock | 0.1522 | 0.1522 | 0.1482 | 0.1493 | 224657520.0 |
| 2003-09-24 12:00:00 | NVDA | Stock | 0.1493 | 0.151 | 0.149 | 0.1507 | 57913440.0 |
| 2003-09-24 12:30:00 | NVDA | Stock | 0.1508 | 0.1508 | 0.1491 | 0.1503 | 41546400.0 |
> showing 50 of 37,503 rows — these rows as CSV