PREVIEW / stock_30min / 2006-11-01
file: by_date/stock_30min/2006/2006-11-01.parquet size: 961 KB rows: 51,839 symbols: 2,434
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-11-01 07:30:00 | AAPL | Stock | 2.8946 | 2.8946 | 2.8946 | 2.8946 | 2800.0 |
| 2006-11-01 08:00:00 | AAPL | Stock | 2.8946 | 2.8957 | 2.8925 | 2.8946 | 718676.0 |
| 2006-11-01 08:30:00 | AAPL | Stock | 2.8925 | 2.8946 | 2.8768 | 2.8925 | 536480.0 |
| 2006-11-01 09:00:00 | AAPL | Stock | 2.8925 | 2.8964 | 2.8925 | 2.8964 | 709408.0 |
| 2006-11-01 09:30:00 | AAPL | Stock | 2.8964 | 2.9064 | 2.8929 | 2.8986 | 41886936.0 |
| 2006-11-01 10:00:00 | AAPL | Stock | 2.8982 | 2.8986 | 2.8557 | 2.8668 | 102748492.0 |
| 2006-11-01 10:30:00 | AAPL | Stock | 2.8664 | 2.8725 | 2.86 | 2.8657 | 38154844.0 |
| 2006-11-01 11:00:00 | AAPL | Stock | 2.8661 | 2.8711 | 2.8575 | 2.8593 | 31616508.0 |
| 2006-11-01 11:30:00 | AAPL | Stock | 2.8589 | 2.86 | 2.8332 | 2.8371 | 70713188.0 |
| 2006-11-01 12:00:00 | AAPL | Stock | 2.8375 | 2.8529 | 2.8357 | 2.8432 | 30815652.0 |
| 2006-11-01 12:30:00 | AAPL | Stock | 2.8429 | 2.8561 | 2.8386 | 2.85 | 23060940.0 |
| 2006-11-01 13:00:00 | AAPL | Stock | 2.8496 | 2.8589 | 2.845 | 2.8586 | 15283436.0 |
| 2006-11-01 13:30:00 | AAPL | Stock | 2.8586 | 2.8657 | 2.8554 | 2.8624 | 20048784.0 |
| 2006-11-01 14:00:00 | AAPL | Stock | 2.8621 | 2.8657 | 2.8482 | 2.8564 | 31484432.0 |
| 2006-11-01 14:30:00 | AAPL | Stock | 2.8564 | 2.8571 | 2.8393 | 2.8393 | 25039812.0 |
| 2006-11-01 15:00:00 | AAPL | Stock | 2.8396 | 2.8418 | 2.8132 | 2.8168 | 69001268.0 |
| 2006-11-01 15:30:00 | AAPL | Stock | 2.8168 | 2.8621 | 2.7986 | 2.8271 | 94357396.0 |
| 2006-11-01 16:00:00 | AAPL | Stock | 2.8264 | 2.8661 | 2.8229 | 2.825 | 993748.0 |
| 2006-11-01 16:30:00 | AAPL | Stock | 2.825 | 2.8286 | 2.825 | 2.8282 | 426188.0 |
| 2006-11-01 17:00:00 | AAPL | Stock | 2.8282 | 2.8282 | 2.8261 | 2.8261 | 29568.0 |
| 2006-11-01 17:30:00 | AAPL | Stock | 2.825 | 2.825 | 2.825 | 2.825 | 5600.0 |
| 2006-11-01 18:00:00 | AAPL | Stock | 2.825 | 2.8271 | 2.825 | 2.8271 | 99736.0 |
| 2006-11-01 18:30:00 | AAPL | Stock | 2.8286 | 2.8293 | 2.8286 | 2.8293 | 11200.0 |
| 2006-11-01 19:00:00 | AAPL | Stock | 2.8311 | 2.8311 | 2.8311 | 2.8311 | 12236.0 |
| 2006-11-01 19:30:00 | AAPL | Stock | 2.8311 | 2.8311 | 2.8293 | 2.8293 | 13356.0 |
| 2006-11-01 08:00:00 | MSFT | Stock | 28.71 | 28.75 | 28.71 | 28.75 | 1199.0 |
| 2006-11-01 08:30:00 | MSFT | Stock | 28.79 | 28.8 | 28.79 | 28.8 | 41400.0 |
| 2006-11-01 09:00:00 | MSFT | Stock | 28.79 | 28.8 | 28.73 | 28.8 | 60667.0 |
| 2006-11-01 09:30:00 | MSFT | Stock | 28.78 | 28.99 | 28.78 | 28.9 | 9732864.0 |
| 2006-11-01 10:00:00 | MSFT | Stock | 28.9 | 28.97 | 28.78 | 28.8 | 10183437.0 |
| 2006-11-01 10:30:00 | MSFT | Stock | 28.79 | 28.88 | 28.75 | 28.839 | 5071781.0 |
| 2006-11-01 11:00:00 | MSFT | Stock | 28.84 | 28.93 | 28.82 | 28.84 | 2617209.0 |
| 2006-11-01 11:30:00 | MSFT | Stock | 28.84 | 28.88 | 28.78 | 28.85 | 5613904.0 |
| 2006-11-01 12:00:00 | MSFT | Stock | 28.86 | 28.87 | 28.79 | 28.85 | 2730931.0 |
| 2006-11-01 12:30:00 | MSFT | Stock | 28.84 | 28.95 | 28.79 | 28.84 | 2707661.0 |
| 2006-11-01 13:00:00 | MSFT | Stock | 28.847 | 28.88 | 28.82 | 28.87 | 2260000.0 |
| 2006-11-01 13:30:00 | MSFT | Stock | 28.87 | 28.88 | 28.84 | 28.85 | 1572041.0 |
| 2006-11-01 14:00:00 | MSFT | Stock | 28.85 | 28.86 | 28.77 | 28.82 | 3122658.0 |
| 2006-11-01 14:30:00 | MSFT | Stock | 28.82 | 28.83 | 28.75 | 28.79 | 4133564.0 |
| 2006-11-01 15:00:00 | MSFT | Stock | 28.79 | 28.81 | 28.7 | 28.77 | 6360588.0 |
| 2006-11-01 15:30:00 | MSFT | Stock | 28.78 | 28.82 | 28.73 | 28.8 | 7330850.0 |
| 2006-11-01 16:00:00 | MSFT | Stock | 28.81 | 28.841 | 28.71 | 28.82 | 400731.0 |
| 2006-11-01 16:30:00 | MSFT | Stock | 28.8 | 28.86 | 28.8 | 28.81 | 13250.0 |
| 2006-11-01 17:30:00 | MSFT | Stock | 28.78 | 28.78 | 28.78 | 28.78 | 1020.0 |
| 2006-11-01 18:00:00 | MSFT | Stock | 28.79 | 28.81 | 28.75 | 28.81 | 17703.0 |
| 2006-11-01 19:00:00 | MSFT | Stock | 28.77 | 28.77 | 28.77 | 28.77 | 2300.0 |
| 2006-11-01 08:00:00 | NVDA | Stock | 0.5832 | 0.5833 | 0.579 | 0.583 | 368400.0 |
| 2006-11-01 08:30:00 | NVDA | Stock | 0.5812 | 0.5828 | 0.5795 | 0.5798 | 251160.0 |
| 2006-11-01 09:00:00 | NVDA | Stock | 0.5802 | 0.5802 | 0.5735 | 0.575 | 2474880.0 |
| 2006-11-01 09:30:00 | NVDA | Stock | 0.5735 | 0.5788 | 0.565 | 0.5665 | 108105420.0 |
> showing 50 of 51,839 rows — these rows as CSV