PREVIEW / stock_1hour / 2008-07-31
file: by_date/stock_1hour/2008/2008-07-31.parquet size: 840 KB rows: 40,230 symbols: 3,339
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 |
|---|---|---|---|---|---|---|---|
| 2008-07-31 05:00:00 | AAPL | Stock | 5.7164 | 5.7164 | 5.7164 | 5.7164 | 2800.0 |
| 2008-07-31 06:00:00 | AAPL | Stock | 5.6929 | 5.6964 | 5.6929 | 5.6946 | 16800.0 |
| 2008-07-31 07:00:00 | AAPL | Stock | 5.6718 | 5.7229 | 5.6718 | 5.7229 | 137032.0 |
| 2008-07-31 08:00:00 | AAPL | Stock | 5.7143 | 5.7143 | 5.6071 | 5.6271 | 2679208.0 |
| 2008-07-31 09:00:00 | AAPL | Stock | 5.6271 | 5.7518 | 5.6 | 5.6982 | 116895352.0 |
| 2008-07-31 10:00:00 | AAPL | Stock | 5.6982 | 5.7929 | 5.6857 | 5.775 | 134440236.0 |
| 2008-07-31 11:00:00 | AAPL | Stock | 5.7736 | 5.7771 | 5.7247 | 5.7446 | 73590944.0 |
| 2008-07-31 12:00:00 | AAPL | Stock | 5.7457 | 5.7696 | 5.6957 | 5.7565 | 72389520.0 |
| 2008-07-31 13:00:00 | AAPL | Stock | 5.7568 | 5.7725 | 5.7243 | 5.7339 | 47532044.0 |
| 2008-07-31 14:00:00 | AAPL | Stock | 5.7329 | 5.7589 | 5.7321 | 5.7536 | 48405560.0 |
| 2008-07-31 15:00:00 | AAPL | Stock | 5.7536 | 5.765 | 5.6504 | 5.6764 | 114088268.0 |
| 2008-07-31 16:00:00 | AAPL | Stock | 5.6764 | 5.7238 | 5.6718 | 5.6839 | 14325696.0 |
| 2008-07-31 17:00:00 | AAPL | Stock | 5.6839 | 5.6843 | 5.6768 | 5.6786 | 304164.0 |
| 2008-07-31 18:00:00 | AAPL | Stock | 5.6786 | 5.6871 | 5.6786 | 5.6857 | 251804.0 |
| 2008-07-31 19:00:00 | AAPL | Stock | 5.6871 | 5.6871 | 5.6696 | 5.6696 | 454384.0 |
| 2008-07-31 07:00:00 | MSFT | Stock | 26.01 | 26.2 | 26.01 | 26.2 | 400.0 |
| 2008-07-31 08:00:00 | MSFT | Stock | 26.25 | 26.29 | 25.98 | 25.98 | 57475.0 |
| 2008-07-31 09:00:00 | MSFT | Stock | 25.96 | 26.13 | 25.79 | 26.0 | 5881948.0 |
| 2008-07-31 10:00:00 | MSFT | Stock | 26.0 | 26.17 | 25.95 | 26.14 | 8995167.0 |
| 2008-07-31 11:00:00 | MSFT | Stock | 26.13 | 26.28 | 26.11 | 26.17 | 7791113.0 |
| 2008-07-31 12:00:00 | MSFT | Stock | 26.18 | 26.2 | 26.03 | 26.04 | 5938864.0 |
| 2008-07-31 13:00:00 | MSFT | Stock | 26.05 | 26.2 | 26.04 | 26.08 | 4420354.0 |
| 2008-07-31 14:00:00 | MSFT | Stock | 26.09 | 26.23 | 26.08 | 26.13 | 5913252.0 |
| 2008-07-31 15:00:00 | MSFT | Stock | 26.132 | 26.2 | 25.71 | 25.74 | 14571568.0 |
| 2008-07-31 16:00:00 | MSFT | Stock | 25.74 | 26.052 | 25.71 | 25.82 | 3233974.0 |
| 2008-07-31 17:00:00 | MSFT | Stock | 25.82 | 26.052 | 25.72 | 25.86 | 36707.0 |
| 2008-07-31 18:00:00 | MSFT | Stock | 25.86 | 26.01 | 25.72 | 25.98 | 653284.0 |
| 2008-07-31 19:00:00 | MSFT | Stock | 25.95 | 25.95 | 25.88 | 25.88 | 9404.0 |
| 2008-07-31 08:00:00 | NVDA | Stock | 0.2928 | 0.2928 | 0.286 | 0.2875 | 452800.0 |
| 2008-07-31 09:00:00 | NVDA | Stock | 0.2872 | 0.292 | 0.283 | 0.2902 | 61090280.0 |
| 2008-07-31 10:00:00 | NVDA | Stock | 0.29 | 0.2922 | 0.287 | 0.2919 | 93923160.0 |
| 2008-07-31 11:00:00 | NVDA | Stock | 0.2918 | 0.292 | 0.2862 | 0.2872 | 56098160.0 |
| 2008-07-31 12:00:00 | NVDA | Stock | 0.287 | 0.2885 | 0.2845 | 0.2868 | 57067440.0 |
| 2008-07-31 13:00:00 | NVDA | Stock | 0.2865 | 0.29 | 0.2865 | 0.289 | 56601480.0 |
| 2008-07-31 14:00:00 | NVDA | Stock | 0.2888 | 0.29 | 0.288 | 0.2892 | 65286240.0 |
| 2008-07-31 15:00:00 | NVDA | Stock | 0.289 | 0.2898 | 0.2855 | 0.286 | 71743240.0 |
| 2008-07-31 16:00:00 | NVDA | Stock | 0.2858 | 0.29 | 0.285 | 0.29 | 14919400.0 |
| 2008-07-31 17:00:00 | NVDA | Stock | 0.286 | 0.2862 | 0.2858 | 0.2858 | 156360.0 |
| 2008-07-31 18:00:00 | NVDA | Stock | 0.2862 | 0.289 | 0.2862 | 0.289 | 8000.0 |
| 2008-07-31 19:00:00 | NVDA | Stock | 0.2862 | 0.2862 | 0.2862 | 0.2862 | 80000.0 |
| 2008-07-31 08:00:00 | AMZN | Stock | 3.92 | 3.92 | 3.9045 | 3.9045 | 4000.0 |
| 2008-07-31 09:00:00 | AMZN | Stock | 3.8405 | 3.9 | 3.81 | 3.87 | 18429120.0 |
| 2008-07-31 10:00:00 | AMZN | Stock | 3.8685 | 3.9085 | 3.853 | 3.892 | 18388020.0 |
| 2008-07-31 11:00:00 | AMZN | Stock | 3.8915 | 3.8925 | 3.8405 | 3.8585 | 11975340.0 |
| 2008-07-31 12:00:00 | AMZN | Stock | 3.8579 | 3.8735 | 3.825 | 3.846 | 9816240.0 |
| 2008-07-31 13:00:00 | AMZN | Stock | 3.846 | 3.8755 | 3.842 | 3.846 | 7026100.0 |
| 2008-07-31 14:00:00 | AMZN | Stock | 3.846 | 3.8685 | 3.836 | 3.848 | 14956940.0 |
| 2008-07-31 15:00:00 | AMZN | Stock | 3.847 | 3.8615 | 3.805 | 3.819 | 19083420.0 |
| 2008-07-31 16:00:00 | AMZN | Stock | 3.8205 | 3.902 | 3.8005 | 3.817 | 1198440.0 |
| 2008-07-31 17:00:00 | AMZN | Stock | 3.817 | 3.817 | 3.815 | 3.815 | 45960.0 |
> showing 50 of 40,230 rows — these rows as CSV