PREVIEW / stock_1hour / 2009-02-24
file: by_date/stock_1hour/2009/2009-02-24.parquet size: 861 KB rows: 43,114 symbols: 3,356
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-02-24 06:00:00 | AAPL | Stock | 3.1118 | 3.1118 | 3.1118 | 3.1118 | 2800.0 |
| 2009-02-24 07:00:00 | AAPL | Stock | 3.1214 | 3.1214 | 3.0443 | 3.0761 | 290640.0 |
| 2009-02-24 08:00:00 | AAPL | Stock | 3.0746 | 3.1214 | 3.0746 | 3.1125 | 2124276.0 |
| 2009-02-24 09:00:00 | AAPL | Stock | 3.1125 | 3.1704 | 3.1071 | 3.1439 | 90309548.0 |
| 2009-02-24 10:00:00 | AAPL | Stock | 3.1429 | 3.1971 | 3.1293 | 3.1779 | 133655536.0 |
| 2009-02-24 11:00:00 | AAPL | Stock | 3.1771 | 3.1854 | 3.1379 | 3.1457 | 82207748.0 |
| 2009-02-24 12:00:00 | AAPL | Stock | 3.1457 | 3.1746 | 3.1436 | 3.1718 | 71702176.0 |
| 2009-02-24 13:00:00 | AAPL | Stock | 3.1718 | 3.2114 | 3.1643 | 3.21 | 86039072.0 |
| 2009-02-24 14:00:00 | AAPL | Stock | 3.2093 | 3.2364 | 3.2004 | 3.218 | 110690748.0 |
| 2009-02-24 15:00:00 | AAPL | Stock | 3.2175 | 3.2461 | 3.2093 | 3.2232 | 146596296.0 |
| 2009-02-24 16:00:00 | AAPL | Stock | 3.2232 | 3.2292 | 3.1871 | 3.2214 | 18893532.0 |
| 2009-02-24 17:00:00 | AAPL | Stock | 3.2207 | 3.2275 | 3.2204 | 3.2275 | 1305556.0 |
| 2009-02-24 18:00:00 | AAPL | Stock | 3.2279 | 3.2279 | 3.2232 | 3.2279 | 50776572.0 |
| 2009-02-24 19:00:00 | AAPL | Stock | 3.2268 | 3.2321 | 3.2261 | 3.2314 | 139608.0 |
| 2009-02-24 20:00:00 | AAPL | Stock | 3.1429 | 3.1429 | 3.1429 | 3.1429 | 210000.0 |
| 2009-02-24 07:00:00 | MSFT | Stock | 17.38 | 17.38 | 17.32 | 17.32 | 1500.0 |
| 2009-02-24 08:00:00 | MSFT | Stock | 17.32 | 17.34 | 16.95 | 17.03 | 203681.0 |
| 2009-02-24 09:00:00 | MSFT | Stock | 17.04 | 17.35 | 16.9 | 16.91 | 10000391.0 |
| 2009-02-24 10:00:00 | MSFT | Stock | 16.91 | 17.11 | 16.67 | 16.962 | 20749550.0 |
| 2009-02-24 11:00:00 | MSFT | Stock | 16.97 | 17.02 | 16.62 | 16.64 | 13854442.0 |
| 2009-02-24 12:00:00 | MSFT | Stock | 16.632 | 16.71 | 16.52 | 16.66 | 14687063.0 |
| 2009-02-24 13:00:00 | MSFT | Stock | 16.66 | 16.79 | 16.36 | 16.77 | 19460478.0 |
| 2009-02-24 14:00:00 | MSFT | Stock | 16.77 | 17.02 | 16.73 | 17.0 | 12534124.0 |
| 2009-02-24 15:00:00 | MSFT | Stock | 16.99 | 17.19 | 16.99 | 17.17 | 19279609.0 |
| 2009-02-24 16:00:00 | MSFT | Stock | 17.18 | 17.22 | 16.819 | 17.17 | 6193286.0 |
| 2009-02-24 17:00:00 | MSFT | Stock | 17.17 | 17.24 | 17.16 | 17.24 | 270039.0 |
| 2009-02-24 18:00:00 | MSFT | Stock | 17.19 | 17.23 | 17.18 | 17.23 | 5821.0 |
| 2009-02-24 19:00:00 | MSFT | Stock | 17.23 | 17.24 | 17.18 | 17.24 | 8613.0 |
| 2009-02-24 20:00:00 | MSFT | Stock | 16.7 | 16.7 | 16.7 | 16.7 | 5600.0 |
| 2009-02-24 09:00:00 | NVDA | Stock | 0.183 | 0.1881 | 0.1823 | 0.1853 | 65886920.0 |
| 2009-02-24 10:00:00 | NVDA | Stock | 0.1853 | 0.1895 | 0.1843 | 0.1885 | 90386120.0 |
| 2009-02-24 11:00:00 | NVDA | Stock | 0.1885 | 0.1918 | 0.1883 | 0.1893 | 81985520.0 |
| 2009-02-24 12:00:00 | NVDA | Stock | 0.1895 | 0.192 | 0.1888 | 0.1913 | 48829680.0 |
| 2009-02-24 13:00:00 | NVDA | Stock | 0.1913 | 0.1942 | 0.19 | 0.1942 | 68526760.0 |
| 2009-02-24 14:00:00 | NVDA | Stock | 0.1942 | 0.1965 | 0.1938 | 0.1952 | 82026720.0 |
| 2009-02-24 15:00:00 | NVDA | Stock | 0.1953 | 0.198 | 0.1952 | 0.197 | 181913600.0 |
| 2009-02-24 16:00:00 | NVDA | Stock | 0.1972 | 0.2002 | 0.1921 | 0.1938 | 23600920.0 |
| 2009-02-24 17:00:00 | NVDA | Stock | 0.1978 | 0.1978 | 0.1978 | 0.1978 | 4260440.0 |
| 2009-02-24 19:00:00 | NVDA | Stock | 0.1985 | 0.1985 | 0.1985 | 0.1985 | 4000.0 |
| 2009-02-24 08:00:00 | AMZN | Stock | 3.1 | 3.1 | 3.085 | 3.0875 | 90500.0 |
| 2009-02-24 09:00:00 | AMZN | Stock | 3.0875 | 3.167 | 3.0875 | 3.1438 | 18579540.0 |
| 2009-02-24 10:00:00 | AMZN | Stock | 3.143 | 3.1925 | 3.1274 | 3.1685 | 30894680.0 |
| 2009-02-24 11:00:00 | AMZN | Stock | 3.1695 | 3.197 | 3.166 | 3.177 | 21093640.0 |
| 2009-02-24 12:00:00 | AMZN | Stock | 3.177 | 3.2085 | 3.1725 | 3.194 | 19117500.0 |
| 2009-02-24 13:00:00 | AMZN | Stock | 3.193 | 3.234 | 3.18 | 3.227 | 22167200.0 |
| 2009-02-24 14:00:00 | AMZN | Stock | 3.226 | 3.2595 | 3.2195 | 3.2575 | 33730640.0 |
| 2009-02-24 15:00:00 | AMZN | Stock | 3.2575 | 3.305 | 3.255 | 3.28 | 52352160.0 |
| 2009-02-24 16:00:00 | AMZN | Stock | 3.279 | 3.2805 | 3.2167 | 3.277 | 5477920.0 |
| 2009-02-24 17:00:00 | AMZN | Stock | 3.2765 | 3.2875 | 3.0938 | 3.2875 | 1065120.0 |
| 2009-02-24 18:00:00 | AMZN | Stock | 3.2865 | 3.2865 | 3.28 | 3.28 | 6000.0 |
> showing 50 of 43,114 rows — these rows as CSV