PREVIEW / stock_30min / 2007-05-17
file: by_date/stock_30min/2007/2007-05-17.parquet size: 1.1 MB rows: 63,007 symbols: 2,993
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 |
|---|---|---|---|---|---|---|---|
| 2007-05-17 09:30:00 | AAPL | Stock | 3.8268 | 3.875 | 3.8268 | 3.8626 | 84303632.0 |
| 2007-05-17 10:00:00 | AAPL | Stock | 3.8625 | 3.8779 | 3.8561 | 3.8621 | 61221132.0 |
| 2007-05-17 10:30:00 | AAPL | Stock | 3.8621 | 3.8679 | 3.8536 | 3.8675 | 37877700.0 |
| 2007-05-17 11:00:00 | AAPL | Stock | 3.8671 | 3.8704 | 3.8536 | 3.8536 | 30496760.0 |
| 2007-05-17 11:30:00 | AAPL | Stock | 3.8536 | 3.865 | 3.8504 | 3.8575 | 26642392.0 |
| 2007-05-17 12:00:00 | AAPL | Stock | 3.8579 | 3.8604 | 3.8464 | 3.8507 | 30219364.0 |
| 2007-05-17 12:30:00 | AAPL | Stock | 3.8504 | 3.8536 | 3.8404 | 3.8464 | 23245124.0 |
| 2007-05-17 13:00:00 | AAPL | Stock | 3.8461 | 3.8532 | 3.8429 | 3.8521 | 17745616.0 |
| 2007-05-17 13:30:00 | AAPL | Stock | 3.8521 | 3.8571 | 3.8468 | 3.8521 | 19062092.0 |
| 2007-05-17 14:00:00 | AAPL | Stock | 3.8525 | 3.9025 | 3.8486 | 3.9018 | 96678792.0 |
| 2007-05-17 14:30:00 | AAPL | Stock | 3.9011 | 3.9029 | 3.8675 | 3.8854 | 91668220.0 |
| 2007-05-17 15:00:00 | AAPL | Stock | 3.8854 | 3.9232 | 3.8829 | 3.9171 | 107611140.0 |
| 2007-05-17 15:30:00 | AAPL | Stock | 3.9164 | 3.9239 | 3.9071 | 3.9096 | 91400736.0 |
| 2007-05-17 16:00:00 | AAPL | Stock | 3.9096 | 3.9096 | 3.9086 | 3.9086 | 3207176.0 |
| 2007-05-17 09:30:00 | MSFT | Stock | 31.03 | 31.14 | 30.99 | 31.06 | 4678423.0 |
| 2007-05-17 10:00:00 | MSFT | Stock | 31.05 | 31.09 | 31.03 | 31.06 | 4699368.0 |
| 2007-05-17 10:30:00 | MSFT | Stock | 31.07 | 31.08 | 31.01 | 31.05 | 2583867.0 |
| 2007-05-17 11:00:00 | MSFT | Stock | 31.06 | 31.09 | 31.01 | 31.03 | 3308024.0 |
| 2007-05-17 11:30:00 | MSFT | Stock | 31.04 | 31.07 | 31.03 | 31.03 | 1868738.0 |
| 2007-05-17 12:00:00 | MSFT | Stock | 31.03 | 31.05 | 30.97 | 31.03 | 3112675.0 |
| 2007-05-17 12:30:00 | MSFT | Stock | 31.04 | 31.04 | 30.99 | 31.001 | 1256649.0 |
| 2007-05-17 13:00:00 | MSFT | Stock | 31.01 | 31.02 | 30.96 | 31.01 | 1571026.0 |
| 2007-05-17 13:30:00 | MSFT | Stock | 31.02 | 31.04 | 31.01 | 31.02 | 1646293.0 |
| 2007-05-17 14:00:00 | MSFT | Stock | 31.03 | 31.06 | 31.01 | 31.05 | 1747724.0 |
| 2007-05-17 14:30:00 | MSFT | Stock | 31.06 | 31.06 | 31.02 | 31.042 | 1952396.0 |
| 2007-05-17 15:00:00 | MSFT | Stock | 31.05 | 31.06 | 31.02 | 31.02 | 2206848.0 |
| 2007-05-17 15:30:00 | MSFT | Stock | 31.03 | 31.04 | 30.98 | 30.98 | 3805700.0 |
| 2007-05-17 16:00:00 | MSFT | Stock | 30.98 | 30.99 | 30.97 | 30.98 | 768401.0 |
| 2007-05-17 07:30:00 | NVDA | Stock | 0.5787 | 0.5787 | 0.5787 | 0.5787 | 6000.0 |
| 2007-05-17 08:00:00 | NVDA | Stock | 0.5832 | 0.5832 | 0.5832 | 0.5832 | 6000.0 |
| 2007-05-17 09:00:00 | NVDA | Stock | 0.582 | 0.5825 | 0.5785 | 0.5785 | 131820.0 |
| 2007-05-17 09:30:00 | NVDA | Stock | 0.5803 | 0.582 | 0.575 | 0.579 | 37577280.0 |
| 2007-05-17 10:00:00 | NVDA | Stock | 0.579 | 0.5833 | 0.5783 | 0.5783 | 32822280.0 |
| 2007-05-17 10:30:00 | NVDA | Stock | 0.5783 | 0.5795 | 0.576 | 0.579 | 30667080.0 |
| 2007-05-17 11:00:00 | NVDA | Stock | 0.579 | 0.58 | 0.574 | 0.5747 | 22811940.0 |
| 2007-05-17 11:30:00 | NVDA | Stock | 0.5747 | 0.5777 | 0.5742 | 0.5758 | 22677420.0 |
| 2007-05-17 12:00:00 | NVDA | Stock | 0.576 | 0.5767 | 0.5722 | 0.5722 | 33055680.0 |
| 2007-05-17 12:30:00 | NVDA | Stock | 0.572 | 0.5725 | 0.5702 | 0.5705 | 24052560.0 |
| 2007-05-17 13:00:00 | NVDA | Stock | 0.5705 | 0.5718 | 0.5692 | 0.5712 | 29645400.0 |
| 2007-05-17 13:30:00 | NVDA | Stock | 0.5712 | 0.5728 | 0.5703 | 0.5712 | 30259620.0 |
| 2007-05-17 14:00:00 | NVDA | Stock | 0.5713 | 0.5725 | 0.569 | 0.5723 | 34625400.0 |
| 2007-05-17 14:30:00 | NVDA | Stock | 0.5725 | 0.5753 | 0.5708 | 0.5753 | 32286720.0 |
| 2007-05-17 15:00:00 | NVDA | Stock | 0.5753 | 0.5775 | 0.5732 | 0.5735 | 39070200.0 |
| 2007-05-17 15:30:00 | NVDA | Stock | 0.5733 | 0.5744 | 0.5717 | 0.5728 | 57764040.0 |
| 2007-05-17 16:00:00 | NVDA | Stock | 0.5728 | 0.5728 | 0.5715 | 0.5715 | 4382820.0 |
| 2007-05-17 16:30:00 | NVDA | Stock | 0.5708 | 0.5723 | 0.5708 | 0.5723 | 368880.0 |
| 2007-05-17 17:30:00 | NVDA | Stock | 0.5723 | 0.5723 | 0.5717 | 0.5717 | 5904000.0 |
| 2007-05-17 18:30:00 | NVDA | Stock | 0.5722 | 0.5722 | 0.5722 | 0.5722 | 18000.0 |
| 2007-05-17 07:30:00 | AMZN | Stock | 3.1455 | 3.159 | 3.1455 | 3.159 | 14000.0 |
| 2007-05-17 08:00:00 | AMZN | Stock | 3.1575 | 3.1585 | 3.145 | 3.151 | 273880.0 |
> showing 50 of 63,007 rows — these rows as CSV