PREVIEW / stock_30min / 2006-12-18
file: by_date/stock_30min/2006/2006-12-18.parquet size: 983 KB rows: 52,988 symbols: 2,494
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-12-18 06:30:00 | AAPL | Stock | 3.1368 | 3.1368 | 3.1368 | 3.1368 | 5600.0 |
| 2006-12-18 07:00:00 | AAPL | Stock | 3.1411 | 3.1571 | 3.1411 | 3.1525 | 53200.0 |
| 2006-12-18 07:30:00 | AAPL | Stock | 3.1482 | 3.1661 | 3.1482 | 3.1611 | 191800.0 |
| 2006-12-18 08:00:00 | AAPL | Stock | 3.1657 | 3.1668 | 3.1486 | 3.1518 | 1385972.0 |
| 2006-12-18 08:30:00 | AAPL | Stock | 3.1511 | 3.1514 | 3.1443 | 3.1471 | 666148.0 |
| 2006-12-18 09:00:00 | AAPL | Stock | 3.145 | 3.145 | 3.1271 | 3.1271 | 2358132.0 |
| 2006-12-18 09:30:00 | AAPL | Stock | 3.1295 | 3.1429 | 3.1018 | 3.1301 | 83230784.0 |
| 2006-12-18 10:00:00 | AAPL | Stock | 3.1304 | 3.1371 | 3.1154 | 3.1154 | 45989496.0 |
| 2006-12-18 10:30:00 | AAPL | Stock | 3.1154 | 3.1179 | 3.0954 | 3.1054 | 59765440.0 |
| 2006-12-18 11:00:00 | AAPL | Stock | 3.1054 | 3.1086 | 3.0918 | 3.1006 | 39482156.0 |
| 2006-12-18 11:30:00 | AAPL | Stock | 3.1007 | 3.1046 | 3.0861 | 3.0914 | 36627192.0 |
| 2006-12-18 12:00:00 | AAPL | Stock | 3.0911 | 3.0939 | 3.0807 | 3.09 | 40181148.0 |
| 2006-12-18 12:30:00 | AAPL | Stock | 3.09 | 3.1046 | 3.0896 | 3.1014 | 32972268.0 |
| 2006-12-18 13:00:00 | AAPL | Stock | 3.1018 | 3.1046 | 3.09 | 3.0957 | 23221072.0 |
| 2006-12-18 13:30:00 | AAPL | Stock | 3.0957 | 3.0979 | 3.0882 | 3.0954 | 21067536.0 |
| 2006-12-18 14:00:00 | AAPL | Stock | 3.0961 | 3.0961 | 3.0857 | 3.0861 | 17054240.0 |
| 2006-12-18 14:30:00 | AAPL | Stock | 3.0861 | 3.095 | 3.0482 | 3.0521 | 82128340.0 |
| 2006-12-18 15:00:00 | AAPL | Stock | 3.0521 | 3.0564 | 3.0211 | 3.0425 | 125426504.0 |
| 2006-12-18 15:30:00 | AAPL | Stock | 3.0432 | 3.0679 | 3.0407 | 3.0511 | 96214636.0 |
| 2006-12-18 16:00:00 | AAPL | Stock | 3.0507 | 3.055 | 3.0464 | 3.0493 | 1952552.0 |
| 2006-12-18 16:30:00 | AAPL | Stock | 3.0493 | 3.0529 | 3.0486 | 3.0525 | 521024.0 |
| 2006-12-18 17:00:00 | AAPL | Stock | 3.0525 | 3.0525 | 3.0489 | 3.0514 | 2782892.0 |
| 2006-12-18 17:30:00 | AAPL | Stock | 3.0514 | 3.0525 | 3.0468 | 3.0468 | 149800.0 |
| 2006-12-18 18:00:00 | AAPL | Stock | 3.0475 | 3.0475 | 3.0439 | 3.0461 | 328412.0 |
| 2006-12-18 18:30:00 | AAPL | Stock | 3.0454 | 3.0493 | 3.045 | 3.0464 | 254548.0 |
| 2006-12-18 19:00:00 | AAPL | Stock | 3.0461 | 3.0464 | 3.0454 | 3.0464 | 38696.0 |
| 2006-12-18 19:30:00 | AAPL | Stock | 3.0464 | 3.0471 | 3.0446 | 3.0464 | 182196.0 |
| 2006-12-18 07:30:00 | MSFT | Stock | 30.2 | 30.2 | 30.2 | 30.2 | 1036.0 |
| 2006-12-18 08:00:00 | MSFT | Stock | 30.21 | 30.25 | 30.17 | 30.25 | 21430.0 |
| 2006-12-18 08:30:00 | MSFT | Stock | 30.28 | 30.28 | 30.23 | 30.28 | 38200.0 |
| 2006-12-18 09:00:00 | MSFT | Stock | 30.28 | 30.28 | 30.19 | 30.2 | 166618.0 |
| 2006-12-18 09:30:00 | MSFT | Stock | 30.19 | 30.26 | 30.09 | 30.19 | 5745585.0 |
| 2006-12-18 10:00:00 | MSFT | Stock | 30.2 | 30.25 | 30.12 | 30.17 | 3046177.0 |
| 2006-12-18 10:30:00 | MSFT | Stock | 30.18 | 30.26 | 30.15 | 30.2 | 3108240.0 |
| 2006-12-18 11:00:00 | MSFT | Stock | 30.202 | 30.21 | 30.15 | 30.17 | 1796522.0 |
| 2006-12-18 11:30:00 | MSFT | Stock | 30.17 | 30.172 | 30.05 | 30.06 | 2186249.0 |
| 2006-12-18 12:00:00 | MSFT | Stock | 30.05 | 30.06 | 29.9 | 29.93 | 3466790.0 |
| 2006-12-18 12:30:00 | MSFT | Stock | 29.92 | 30.04 | 29.92 | 29.97 | 2027527.0 |
| 2006-12-18 13:00:00 | MSFT | Stock | 29.96 | 30.02 | 29.91 | 29.97 | 2875480.0 |
| 2006-12-18 13:30:00 | MSFT | Stock | 29.97 | 30.0 | 29.95 | 29.97 | 2033962.0 |
| 2006-12-18 14:00:00 | MSFT | Stock | 29.96 | 29.97 | 29.92 | 29.94 | 1712546.0 |
| 2006-12-18 14:30:00 | MSFT | Stock | 29.94 | 29.99 | 29.78 | 29.9 | 4850666.0 |
| 2006-12-18 15:00:00 | MSFT | Stock | 29.9 | 29.91 | 29.8 | 29.87 | 4363604.0 |
| 2006-12-18 15:30:00 | MSFT | Stock | 29.86 | 30.0 | 29.85 | 29.87 | 9446464.0 |
| 2006-12-18 16:00:00 | MSFT | Stock | 29.89 | 29.9 | 29.85 | 29.88 | 3043110.0 |
| 2006-12-18 16:30:00 | MSFT | Stock | 29.87 | 29.89 | 29.85 | 29.85 | 1509200.0 |
| 2006-12-18 17:00:00 | MSFT | Stock | 29.82 | 29.85 | 29.8 | 29.81 | 15900.0 |
| 2006-12-18 17:30:00 | MSFT | Stock | 29.8 | 29.89 | 29.8 | 29.89 | 79944.0 |
| 2006-12-18 19:00:00 | MSFT | Stock | 29.84 | 29.85 | 29.84 | 29.85 | 3500.0 |
| 2006-12-18 07:30:00 | NVDA | Stock | 0.625 | 0.625 | 0.625 | 0.625 | 30000.0 |
> showing 50 of 52,988 rows — these rows as CSV