PREVIEW / stock_30min / 2006-01-13
file: by_date/stock_30min/2006/2006-01-13.parquet size: 871 KB rows: 47,240 symbols: 2,164
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 |
|---|---|---|---|---|---|---|---|
| 2006-01-13 07:00:00 | AAPL | Stock | 3.0036 | 3.0111 | 3.0036 | 3.0089 | 114800.0 |
| 2006-01-13 07:30:00 | AAPL | Stock | 3.0107 | 3.0264 | 3.0107 | 3.0107 | 267904.0 |
| 2006-01-13 08:00:00 | AAPL | Stock | 3.0204 | 3.0393 | 3.0129 | 3.0268 | 4038328.0 |
| 2006-01-13 08:30:00 | AAPL | Stock | 3.0257 | 3.0286 | 3.0179 | 3.0246 | 820260.0 |
| 2006-01-13 09:00:00 | AAPL | Stock | 3.0236 | 3.0425 | 3.0232 | 3.0389 | 7379988.0 |
| 2006-01-13 09:30:00 | AAPL | Stock | 3.0354 | 3.0679 | 3.0286 | 3.0329 | 150253124.0 |
| 2006-01-13 10:00:00 | AAPL | Stock | 3.0325 | 3.0464 | 3.0214 | 3.0418 | 109957260.0 |
| 2006-01-13 10:30:00 | AAPL | Stock | 3.0418 | 3.0539 | 3.0307 | 3.0464 | 69581512.0 |
| 2006-01-13 11:00:00 | AAPL | Stock | 3.0465 | 3.0579 | 3.0368 | 3.0536 | 56797356.0 |
| 2006-01-13 11:30:00 | AAPL | Stock | 3.0543 | 3.0625 | 3.0446 | 3.0464 | 48495468.0 |
| 2006-01-13 12:00:00 | AAPL | Stock | 3.0464 | 3.0489 | 3.0375 | 3.0404 | 33517988.0 |
| 2006-01-13 12:30:00 | AAPL | Stock | 3.0407 | 3.0421 | 3.0286 | 3.0354 | 47179188.0 |
| 2006-01-13 13:00:00 | AAPL | Stock | 3.0357 | 3.0414 | 3.0336 | 3.0404 | 28229348.0 |
| 2006-01-13 13:30:00 | AAPL | Stock | 3.0404 | 3.0411 | 3.0304 | 3.0371 | 23830688.0 |
| 2006-01-13 14:00:00 | AAPL | Stock | 3.0368 | 3.04 | 3.0304 | 3.035 | 31144680.0 |
| 2006-01-13 14:30:00 | AAPL | Stock | 3.035 | 3.0464 | 3.0332 | 3.0464 | 39466672.0 |
| 2006-01-13 15:00:00 | AAPL | Stock | 3.0464 | 3.0475 | 3.0357 | 3.0432 | 35182980.0 |
| 2006-01-13 15:30:00 | AAPL | Stock | 3.0432 | 3.0718 | 3.0357 | 3.0568 | 70221508.0 |
| 2006-01-13 16:00:00 | AAPL | Stock | 3.0575 | 3.0611 | 3.055 | 3.0593 | 3374784.0 |
| 2006-01-13 16:30:00 | AAPL | Stock | 3.0593 | 3.0625 | 3.046 | 3.0621 | 3350872.0 |
| 2006-01-13 17:00:00 | AAPL | Stock | 3.0589 | 3.0618 | 3.0579 | 3.0604 | 127316.0 |
| 2006-01-13 17:30:00 | AAPL | Stock | 3.0607 | 3.0668 | 3.0604 | 3.0661 | 935956.0 |
| 2006-01-13 18:00:00 | AAPL | Stock | 3.0661 | 3.0671 | 3.0632 | 3.0643 | 195860.0 |
| 2006-01-13 06:30:00 | MSFT | Stock | 27.21 | 27.21 | 27.14 | 27.14 | 2773.0 |
| 2006-01-13 07:00:00 | MSFT | Stock | 27.1 | 27.1 | 27.08 | 27.08 | 2496.0 |
| 2006-01-13 08:00:00 | MSFT | Stock | 27.05 | 27.05 | 27.05 | 27.05 | 762.0 |
| 2006-01-13 08:30:00 | MSFT | Stock | 27.06 | 27.08 | 27.05 | 27.07 | 7375.0 |
| 2006-01-13 09:00:00 | MSFT | Stock | 27.07 | 27.08 | 27.02 | 27.03 | 47240.0 |
| 2006-01-13 09:30:00 | MSFT | Stock | 27.03 | 27.25 | 27.02 | 27.22 | 5145744.0 |
| 2006-01-13 10:00:00 | MSFT | Stock | 27.21 | 27.25 | 27.07 | 27.11 | 4480087.0 |
| 2006-01-13 10:30:00 | MSFT | Stock | 27.11 | 27.17 | 27.01 | 27.142 | 4053182.0 |
| 2006-01-13 11:00:00 | MSFT | Stock | 27.15 | 27.19 | 27.15 | 27.17 | 2009699.0 |
| 2006-01-13 11:30:00 | MSFT | Stock | 27.18 | 27.24 | 27.14 | 27.14 | 2604023.0 |
| 2006-01-13 12:00:00 | MSFT | Stock | 27.14 | 27.16 | 27.12 | 27.14 | 1928735.0 |
| 2006-01-13 12:30:00 | MSFT | Stock | 27.14 | 27.14 | 27.05 | 27.09 | 2254856.0 |
| 2006-01-13 13:00:00 | MSFT | Stock | 27.09 | 27.13 | 27.07 | 27.11 | 1582225.0 |
| 2006-01-13 13:30:00 | MSFT | Stock | 27.11 | 27.13 | 27.04 | 27.08 | 2149231.0 |
| 2006-01-13 14:00:00 | MSFT | Stock | 27.08 | 27.11 | 27.02 | 27.05 | 3901683.0 |
| 2006-01-13 14:30:00 | MSFT | Stock | 27.05 | 27.15 | 27.01 | 27.1 | 1967952.0 |
| 2006-01-13 15:00:00 | MSFT | Stock | 27.101 | 27.13 | 27.05 | 27.12 | 2223935.0 |
| 2006-01-13 15:30:00 | MSFT | Stock | 27.13 | 27.21 | 27.1 | 27.18 | 5118122.0 |
| 2006-01-13 16:00:00 | MSFT | Stock | 27.19 | 27.19 | 27.11 | 27.13 | 366106.0 |
| 2006-01-13 16:30:00 | MSFT | Stock | 27.19 | 27.19 | 27.12 | 27.15 | 38816.0 |
| 2006-01-13 08:30:00 | NVDA | Stock | 0.3572 | 0.3572 | 0.3572 | 0.3572 | 36000.0 |
| 2006-01-13 09:00:00 | NVDA | Stock | 0.3564 | 0.3566 | 0.3532 | 0.3564 | 1056000.0 |
| 2006-01-13 09:30:00 | NVDA | Stock | 0.3566 | 0.3595 | 0.3525 | 0.3572 | 53951160.0 |
| 2006-01-13 10:00:00 | NVDA | Stock | 0.3577 | 0.3577 | 0.3525 | 0.3529 | 28934400.0 |
| 2006-01-13 10:30:00 | NVDA | Stock | 0.3528 | 0.3535 | 0.3492 | 0.3514 | 48847200.0 |
| 2006-01-13 11:00:00 | NVDA | Stock | 0.3512 | 0.3543 | 0.3503 | 0.3542 | 38058600.0 |
| 2006-01-13 11:30:00 | NVDA | Stock | 0.3544 | 0.3572 | 0.3521 | 0.3557 | 40472640.0 |
> showing 50 of 47,240 rows — these rows as CSV