PREVIEW / stock_30min / 2007-06-07
file: by_date/stock_30min/2007/2007-06-07.parquet size: 1.1 MB rows: 63,325 symbols: 3,019
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-06-07 09:30:00 | AAPL | Stock | 4.4639 | 4.5411 | 4.4157 | 4.5339 | 282585072.0 |
| 2007-06-07 10:00:00 | AAPL | Stock | 4.5339 | 4.5575 | 4.5204 | 4.5275 | 188413932.0 |
| 2007-06-07 10:30:00 | AAPL | Stock | 4.5271 | 4.5557 | 4.515 | 4.5514 | 132548416.0 |
| 2007-06-07 11:00:00 | AAPL | Stock | 4.5514 | 4.5536 | 4.5 | 4.5139 | 170142196.0 |
| 2007-06-07 11:30:00 | AAPL | Stock | 4.5139 | 4.5189 | 4.4993 | 4.5086 | 90669740.0 |
| 2007-06-07 12:00:00 | AAPL | Stock | 4.5082 | 4.5229 | 4.505 | 4.5164 | 79083480.0 |
| 2007-06-07 12:30:00 | AAPL | Stock | 4.5164 | 4.5168 | 4.4804 | 4.4975 | 97622560.0 |
| 2007-06-07 13:00:00 | AAPL | Stock | 4.4979 | 4.5046 | 4.4636 | 4.4854 | 100893212.0 |
| 2007-06-07 13:30:00 | AAPL | Stock | 4.4854 | 4.5318 | 4.42 | 4.4732 | 174939324.0 |
| 2007-06-07 14:00:00 | AAPL | Stock | 4.4732 | 4.48 | 4.3996 | 4.4325 | 151198516.0 |
| 2007-06-07 14:30:00 | AAPL | Stock | 4.4321 | 4.4686 | 4.4257 | 4.4643 | 114684248.0 |
| 2007-06-07 15:00:00 | AAPL | Stock | 4.4636 | 4.4882 | 4.4554 | 4.4621 | 129249428.0 |
| 2007-06-07 15:30:00 | AAPL | Stock | 4.4625 | 4.4807 | 4.3929 | 4.4293 | 141425200.0 |
| 2007-06-07 16:00:00 | AAPL | Stock | 4.4293 | 4.4311 | 4.4293 | 4.431 | 10100300.0 |
| 2007-06-07 09:30:00 | MSFT | Stock | 30.02 | 30.29 | 30.0 | 30.21 | 7452192.0 |
| 2007-06-07 10:00:00 | MSFT | Stock | 30.2 | 30.22 | 30.04 | 30.1 | 4464386.0 |
| 2007-06-07 10:30:00 | MSFT | Stock | 30.1 | 30.2 | 30.08 | 30.13 | 4487243.0 |
| 2007-06-07 11:00:00 | MSFT | Stock | 30.13 | 30.165 | 30.05 | 30.15 | 3997138.0 |
| 2007-06-07 11:30:00 | MSFT | Stock | 30.15 | 30.17 | 30.11 | 30.13 | 1860621.0 |
| 2007-06-07 12:00:00 | MSFT | Stock | 30.13 | 30.18 | 30.1 | 30.15 | 2215964.0 |
| 2007-06-07 12:30:00 | MSFT | Stock | 30.15 | 30.15 | 29.94 | 30.03 | 4822719.0 |
| 2007-06-07 13:00:00 | MSFT | Stock | 30.03 | 30.07 | 29.86 | 29.87 | 3742996.0 |
| 2007-06-07 13:30:00 | MSFT | Stock | 29.87 | 29.93 | 29.66 | 29.767 | 7708849.0 |
| 2007-06-07 14:00:00 | MSFT | Stock | 29.77 | 29.85 | 29.72 | 29.81 | 4252921.0 |
| 2007-06-07 14:30:00 | MSFT | Stock | 29.81 | 29.86 | 29.78 | 29.78 | 4023346.0 |
| 2007-06-07 15:00:00 | MSFT | Stock | 29.78 | 29.91 | 29.75 | 29.81 | 5641837.0 |
| 2007-06-07 15:30:00 | MSFT | Stock | 29.82 | 29.88 | 29.59 | 29.6 | 10178748.0 |
| 2007-06-07 16:00:00 | MSFT | Stock | 29.6 | 29.62 | 29.6 | 29.62 | 1239338.0 |
| 2007-06-07 08:00:00 | NVDA | Stock | 0.613 | 0.613 | 0.6092 | 0.6092 | 72000.0 |
| 2007-06-07 08:30:00 | NVDA | Stock | 0.6018 | 0.6018 | 0.6018 | 0.6018 | 36000.0 |
| 2007-06-07 09:00:00 | NVDA | Stock | 0.6025 | 0.6045 | 0.6025 | 0.6027 | 605100.0 |
| 2007-06-07 09:30:00 | NVDA | Stock | 0.6035 | 0.6122 | 0.602 | 0.6083 | 68553240.0 |
| 2007-06-07 10:00:00 | NVDA | Stock | 0.6085 | 0.6125 | 0.6048 | 0.6082 | 73354980.0 |
| 2007-06-07 10:30:00 | NVDA | Stock | 0.6083 | 0.6122 | 0.6072 | 0.6083 | 48782340.0 |
| 2007-06-07 11:00:00 | NVDA | Stock | 0.6083 | 0.6085 | 0.6048 | 0.606 | 61143480.0 |
| 2007-06-07 11:30:00 | NVDA | Stock | 0.6058 | 0.6068 | 0.6055 | 0.606 | 59049960.0 |
| 2007-06-07 12:00:00 | NVDA | Stock | 0.606 | 0.607 | 0.6058 | 0.6062 | 26438400.0 |
| 2007-06-07 12:30:00 | NVDA | Stock | 0.6062 | 0.6067 | 0.6048 | 0.6063 | 66520080.0 |
| 2007-06-07 13:00:00 | NVDA | Stock | 0.6063 | 0.6067 | 0.6045 | 0.605 | 47769180.0 |
| 2007-06-07 13:30:00 | NVDA | Stock | 0.605 | 0.6062 | 0.6022 | 0.6055 | 93826020.0 |
| 2007-06-07 14:00:00 | NVDA | Stock | 0.6053 | 0.6055 | 0.6003 | 0.602 | 66196800.0 |
| 2007-06-07 14:30:00 | NVDA | Stock | 0.602 | 0.6047 | 0.6005 | 0.6033 | 40612380.0 |
| 2007-06-07 15:00:00 | NVDA | Stock | 0.6034 | 0.607 | 0.603 | 0.6038 | 46424760.0 |
| 2007-06-07 15:30:00 | NVDA | Stock | 0.6038 | 0.6055 | 0.5997 | 0.5998 | 75375480.0 |
| 2007-06-07 16:00:00 | NVDA | Stock | 0.6003 | 0.602 | 0.5998 | 0.602 | 3253800.0 |
| 2007-06-07 16:30:00 | NVDA | Stock | 0.6005 | 0.6005 | 0.6 | 0.6 | 29700.0 |
| 2007-06-07 17:00:00 | NVDA | Stock | 0.5998 | 0.5998 | 0.5998 | 0.5998 | 149340.0 |
| 2007-06-07 19:30:00 | NVDA | Stock | 0.6002 | 0.6002 | 0.5998 | 0.5998 | 241140.0 |
| 2007-06-07 06:30:00 | AMZN | Stock | 3.62 | 3.62 | 3.62 | 3.62 | 7060.0 |
| 2007-06-07 07:00:00 | AMZN | Stock | 3.625 | 3.625 | 3.625 | 3.625 | 4000.0 |
> showing 50 of 63,325 rows — these rows as CSV