PREVIEW / stock_30min / 2006-10-06
file: by_date/stock_30min/2006/2006-10-06.parquet size: 914 KB rows: 49,430 symbols: 2,379
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-10-06 08:00:00 | AAPL | Stock | 2.6661 | 2.6704 | 2.6607 | 2.6704 | 200452.0 |
| 2006-10-06 08:30:00 | AAPL | Stock | 2.6679 | 2.6714 | 2.6611 | 2.6611 | 934920.0 |
| 2006-10-06 09:00:00 | AAPL | Stock | 2.6607 | 2.6625 | 2.6546 | 2.6579 | 684516.0 |
| 2006-10-06 09:30:00 | AAPL | Stock | 2.6579 | 2.6679 | 2.6421 | 2.6664 | 74857972.0 |
| 2006-10-06 10:00:00 | AAPL | Stock | 2.6657 | 2.6757 | 2.6611 | 2.6664 | 55826456.0 |
| 2006-10-06 10:30:00 | AAPL | Stock | 2.6664 | 2.68 | 2.6561 | 2.6736 | 42227808.0 |
| 2006-10-06 11:00:00 | AAPL | Stock | 2.6732 | 2.6736 | 2.6636 | 2.6689 | 23516136.0 |
| 2006-10-06 11:30:00 | AAPL | Stock | 2.6689 | 2.6711 | 2.6525 | 2.6593 | 21020300.0 |
| 2006-10-06 12:00:00 | AAPL | Stock | 2.6593 | 2.6621 | 2.6543 | 2.6564 | 13158516.0 |
| 2006-10-06 12:30:00 | AAPL | Stock | 2.6564 | 2.6618 | 2.6482 | 2.6611 | 23804984.0 |
| 2006-10-06 13:00:00 | AAPL | Stock | 2.6611 | 2.6632 | 2.6529 | 2.6554 | 19346068.0 |
| 2006-10-06 13:30:00 | AAPL | Stock | 2.655 | 2.6589 | 2.6504 | 2.6517 | 18828572.0 |
| 2006-10-06 14:00:00 | AAPL | Stock | 2.6516 | 2.6543 | 2.6482 | 2.65 | 21678496.0 |
| 2006-10-06 14:30:00 | AAPL | Stock | 2.6496 | 2.655 | 2.6482 | 2.6493 | 29669080.0 |
| 2006-10-06 15:00:00 | AAPL | Stock | 2.6489 | 2.6496 | 2.6371 | 2.6421 | 41759284.0 |
| 2006-10-06 15:30:00 | AAPL | Stock | 2.6421 | 2.6589 | 2.6361 | 2.6504 | 64422400.0 |
| 2006-10-06 16:00:00 | AAPL | Stock | 2.6514 | 2.6589 | 2.6504 | 2.6518 | 947520.0 |
| 2006-10-06 16:30:00 | AAPL | Stock | 2.6521 | 2.6554 | 2.6521 | 2.6536 | 286300.0 |
| 2006-10-06 17:00:00 | AAPL | Stock | 2.6536 | 2.6564 | 2.6536 | 2.6536 | 51660.0 |
| 2006-10-06 17:30:00 | AAPL | Stock | 2.6539 | 2.6561 | 2.6539 | 2.6539 | 50400.0 |
| 2006-10-06 18:00:00 | AAPL | Stock | 2.6536 | 2.6536 | 2.6536 | 2.6536 | 14000.0 |
| 2006-10-06 18:30:00 | AAPL | Stock | 2.6561 | 2.6561 | 2.6561 | 2.6561 | 30800.0 |
| 2006-10-06 19:30:00 | AAPL | Stock | 2.6568 | 2.6568 | 2.6568 | 2.6568 | 5600.0 |
| 2006-10-06 07:30:00 | MSFT | Stock | 27.92 | 27.92 | 27.92 | 27.92 | 1000.0 |
| 2006-10-06 08:00:00 | MSFT | Stock | 27.92 | 27.92 | 27.83 | 27.92 | 13550.0 |
| 2006-10-06 08:30:00 | MSFT | Stock | 27.87 | 27.91 | 27.8 | 27.8 | 21950.0 |
| 2006-10-06 09:00:00 | MSFT | Stock | 27.8 | 27.83 | 27.71 | 27.74 | 130501.0 |
| 2006-10-06 09:30:00 | MSFT | Stock | 27.76 | 27.84 | 27.7 | 27.75 | 3724687.0 |
| 2006-10-06 10:00:00 | MSFT | Stock | 27.758 | 27.86 | 27.73 | 27.818 | 2892272.0 |
| 2006-10-06 10:30:00 | MSFT | Stock | 27.81 | 27.9 | 27.78 | 27.84 | 3141333.0 |
| 2006-10-06 11:00:00 | MSFT | Stock | 27.84 | 27.86 | 27.78 | 27.85 | 1961513.0 |
| 2006-10-06 11:30:00 | MSFT | Stock | 27.85 | 27.86 | 27.74 | 27.75 | 1353431.0 |
| 2006-10-06 12:00:00 | MSFT | Stock | 27.75 | 27.76 | 27.65 | 27.71 | 2266948.0 |
| 2006-10-06 12:30:00 | MSFT | Stock | 27.72 | 27.81 | 27.71 | 27.77 | 941454.0 |
| 2006-10-06 13:00:00 | MSFT | Stock | 27.77 | 27.84 | 27.75 | 27.78 | 1204530.0 |
| 2006-10-06 13:30:00 | MSFT | Stock | 27.78 | 27.84 | 27.75 | 27.822 | 1057708.0 |
| 2006-10-06 14:00:00 | MSFT | Stock | 27.822 | 27.9 | 27.81 | 27.89 | 2469708.0 |
| 2006-10-06 14:30:00 | MSFT | Stock | 27.89 | 27.97 | 27.87 | 27.93 | 2818613.0 |
| 2006-10-06 15:00:00 | MSFT | Stock | 27.93 | 28.0 | 27.91 | 27.942 | 5693940.0 |
| 2006-10-06 15:30:00 | MSFT | Stock | 27.94 | 27.95 | 27.8 | 27.9 | 4923132.0 |
| 2006-10-06 16:00:00 | MSFT | Stock | 27.89 | 27.94 | 27.87 | 27.94 | 88642.0 |
| 2006-10-06 16:30:00 | MSFT | Stock | 27.93 | 27.94 | 27.832 | 27.93 | 13108.0 |
| 2006-10-06 17:00:00 | MSFT | Stock | 27.94 | 27.94 | 27.94 | 27.94 | 1310.0 |
| 2006-10-06 17:30:00 | MSFT | Stock | 27.876 | 27.876 | 27.876 | 27.876 | 517.0 |
| 2006-10-06 18:00:00 | MSFT | Stock | 27.93 | 27.93 | 27.89 | 27.93 | 9300.0 |
| 2006-10-06 19:00:00 | MSFT | Stock | 27.89 | 27.89 | 27.88 | 27.88 | 812.0 |
| 2006-10-06 08:00:00 | NVDA | Stock | 0.5033 | 0.5117 | 0.5033 | 0.5063 | 1603800.0 |
| 2006-10-06 08:30:00 | NVDA | Stock | 0.5058 | 0.5063 | 0.5038 | 0.5063 | 333600.0 |
| 2006-10-06 09:00:00 | NVDA | Stock | 0.5063 | 0.5063 | 0.5017 | 0.5042 | 1848000.0 |
| 2006-10-06 09:30:00 | NVDA | Stock | 0.5042 | 0.5167 | 0.5027 | 0.5152 | 110763120.0 |
> showing 50 of 49,430 rows — these rows as CSV