PREVIEW / stock_1hour / 2009-11-27
file: by_date/stock_1hour/2009/2009-11-27.parquet size: 600 KB rows: 26,739 symbols: 3,333
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 |
|---|---|---|---|---|---|---|---|
| 2009-11-27 04:00:00 | AAPL | Stock | 7.0707 | 7.1161 | 7.0707 | 7.1025 | 53200.0 |
| 2009-11-27 05:00:00 | AAPL | Stock | 7.0596 | 7.0596 | 7.0336 | 7.0336 | 105000.0 |
| 2009-11-27 06:00:00 | AAPL | Stock | 7.0514 | 7.0775 | 7.0514 | 7.0732 | 138292.0 |
| 2009-11-27 07:00:00 | AAPL | Stock | 7.0736 | 7.1154 | 7.0736 | 7.115 | 1271480.0 |
| 2009-11-27 08:00:00 | AAPL | Stock | 7.115 | 7.1421 | 7.1036 | 7.1071 | 4275684.0 |
| 2009-11-27 09:00:00 | AAPL | Stock | 7.1071 | 7.1696 | 7.0846 | 7.1582 | 88619160.0 |
| 2009-11-27 10:00:00 | AAPL | Stock | 7.1586 | 7.2411 | 7.1564 | 7.2243 | 79853312.0 |
| 2009-11-27 11:00:00 | AAPL | Stock | 7.2232 | 7.2486 | 7.2054 | 7.2236 | 47485816.0 |
| 2009-11-27 12:00:00 | AAPL | Stock | 7.2236 | 7.2321 | 7.1643 | 7.1707 | 60745328.0 |
| 2009-11-27 13:00:00 | AAPL | Stock | 7.1654 | 7.2277 | 7.1554 | 7.1732 | 9269400.0 |
| 2009-11-27 14:00:00 | AAPL | Stock | 7.1711 | 7.1761 | 7.1671 | 7.1696 | 184016.0 |
| 2009-11-27 15:00:00 | AAPL | Stock | 7.1671 | 7.1732 | 7.1607 | 7.1614 | 126448.0 |
| 2009-11-27 16:00:00 | AAPL | Stock | 7.1768 | 7.1836 | 7.1675 | 7.1732 | 73556.0 |
| 2009-11-27 04:00:00 | MSFT | Stock | 29.29 | 29.29 | 29.11 | 29.15 | 1000.0 |
| 2009-11-27 06:00:00 | MSFT | Stock | 29.15 | 29.18 | 29.03 | 29.03 | 2600.0 |
| 2009-11-27 07:00:00 | MSFT | Stock | 29.11 | 29.2 | 29.04 | 29.2 | 13131.0 |
| 2009-11-27 08:00:00 | MSFT | Stock | 29.2 | 29.39 | 29.12 | 29.12 | 60756.0 |
| 2009-11-27 09:00:00 | MSFT | Stock | 29.11 | 29.35 | 28.75 | 29.1 | 6944199.0 |
| 2009-11-27 10:00:00 | MSFT | Stock | 29.1 | 29.29 | 29.1 | 29.183 | 7822672.0 |
| 2009-11-27 11:00:00 | MSFT | Stock | 29.204 | 29.29 | 29.15 | 29.27 | 4913195.0 |
| 2009-11-27 12:00:00 | MSFT | Stock | 29.27 | 29.39 | 29.18 | 29.24 | 6030741.0 |
| 2009-11-27 13:00:00 | MSFT | Stock | 29.23 | 29.31 | 29.192 | 29.23 | 1748608.0 |
| 2009-11-27 14:00:00 | MSFT | Stock | 29.38 | 29.38 | 29.22 | 29.22 | 11231.0 |
| 2009-11-27 15:00:00 | MSFT | Stock | 29.22 | 29.22 | 29.2 | 29.2 | 3973.0 |
| 2009-11-27 16:00:00 | MSFT | Stock | 29.19 | 29.19 | 29.19 | 29.19 | 150.0 |
| 2009-11-27 07:00:00 | NVDA | Stock | 0.315 | 0.315 | 0.315 | 0.315 | 4000.0 |
| 2009-11-27 08:00:00 | NVDA | Stock | 0.317 | 0.3188 | 0.315 | 0.3188 | 299800.0 |
| 2009-11-27 09:00:00 | NVDA | Stock | 0.3178 | 0.3208 | 0.3133 | 0.3198 | 65442280.0 |
| 2009-11-27 10:00:00 | NVDA | Stock | 0.3198 | 0.3223 | 0.3188 | 0.3213 | 73406920.0 |
| 2009-11-27 11:00:00 | NVDA | Stock | 0.3213 | 0.3235 | 0.3195 | 0.3196 | 58011240.0 |
| 2009-11-27 12:00:00 | NVDA | Stock | 0.3195 | 0.3218 | 0.3188 | 0.3198 | 67778000.0 |
| 2009-11-27 13:00:00 | NVDA | Stock | 0.3198 | 0.3233 | 0.3185 | 0.3233 | 8418480.0 |
| 2009-11-27 04:00:00 | AMZN | Stock | 6.6 | 6.6 | 6.454 | 6.4545 | 50820.0 |
| 2009-11-27 05:00:00 | AMZN | Stock | 6.442 | 6.442 | 6.346 | 6.346 | 140680.0 |
| 2009-11-27 06:00:00 | AMZN | Stock | 6.3865 | 6.45 | 6.3865 | 6.45 | 39200.0 |
| 2009-11-27 07:00:00 | AMZN | Stock | 6.46 | 6.5025 | 6.425 | 6.495 | 244380.0 |
| 2009-11-27 08:00:00 | AMZN | Stock | 6.4449 | 6.5435 | 6.4449 | 6.5285 | 848440.0 |
| 2009-11-27 09:00:00 | AMZN | Stock | 6.5325 | 6.5875 | 6.494 | 6.5502 | 24905040.0 |
| 2009-11-27 10:00:00 | AMZN | Stock | 6.5495 | 6.62 | 6.5465 | 6.616 | 24877780.0 |
| 2009-11-27 11:00:00 | AMZN | Stock | 6.6175 | 6.65 | 6.608 | 6.6155 | 14361000.0 |
| 2009-11-27 12:00:00 | AMZN | Stock | 6.6135 | 6.6365 | 6.58 | 6.5855 | 19289000.0 |
| 2009-11-27 13:00:00 | AMZN | Stock | 6.5855 | 6.5878 | 6.5535 | 6.564 | 3007100.0 |
| 2009-11-27 14:00:00 | AMZN | Stock | 6.576 | 6.576 | 6.5705 | 6.5725 | 50020.0 |
| 2009-11-27 15:00:00 | AMZN | Stock | 6.5735 | 6.5875 | 6.5735 | 6.5875 | 41160.0 |
| 2009-11-27 16:00:00 | AMZN | Stock | 6.5875 | 6.5875 | 6.5845 | 6.585 | 11420.0 |
| 2009-11-27 08:00:00 | TLT | Stock | 96.92 | 96.94 | 96.31 | 96.37 | 37725.0 |
| 2009-11-27 09:00:00 | TLT | Stock | 96.31 | 96.56 | 96.1 | 96.18 | 692662.0 |
| 2009-11-27 10:00:00 | TLT | Stock | 96.18 | 96.43 | 96.09 | 96.2 | 572875.0 |
| 2009-11-27 11:00:00 | TLT | Stock | 96.19 | 96.38 | 96.12 | 96.2899 | 284111.0 |
| 2009-11-27 12:00:00 | TLT | Stock | 96.29 | 96.55 | 96.16 | 96.461 | 619745.0 |
> showing 50 of 26,739 rows — these rows as CSV