PREVIEW / stock_1hour / 2009-02-27
file: by_date/stock_1hour/2009/2009-02-27.parquet size: 837 KB rows: 40,834 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-02-27 07:00:00 | AAPL | Stock | 3.1518 | 3.1518 | 3.1418 | 3.1418 | 43400.0 |
| 2009-02-27 08:00:00 | AAPL | Stock | 3.1493 | 3.15 | 3.125 | 3.1482 | 1059940.0 |
| 2009-02-27 09:00:00 | AAPL | Stock | 3.1471 | 3.2357 | 3.1304 | 3.2204 | 100335704.0 |
| 2009-02-27 10:00:00 | AAPL | Stock | 3.22 | 3.2607 | 3.1964 | 3.2111 | 109649288.0 |
| 2009-02-27 11:00:00 | AAPL | Stock | 3.2107 | 3.235 | 3.1821 | 3.2243 | 84003612.0 |
| 2009-02-27 12:00:00 | AAPL | Stock | 3.2239 | 3.2379 | 3.1807 | 3.1968 | 64130304.0 |
| 2009-02-27 13:00:00 | AAPL | Stock | 3.1971 | 3.2121 | 3.1696 | 3.2047 | 71387148.0 |
| 2009-02-27 14:00:00 | AAPL | Stock | 3.2043 | 3.225 | 3.1846 | 3.22 | 84046788.0 |
| 2009-02-27 15:00:00 | AAPL | Stock | 3.22 | 3.2346 | 3.1889 | 3.19 | 142504432.0 |
| 2009-02-27 16:00:00 | AAPL | Stock | 3.1896 | 3.2123 | 3.1825 | 3.1875 | 35788704.0 |
| 2009-02-27 17:00:00 | AAPL | Stock | 3.1875 | 3.1912 | 3.1875 | 3.1912 | 1436904.0 |
| 2009-02-27 18:00:00 | AAPL | Stock | 3.1896 | 3.1907 | 3.1879 | 3.1907 | 3109540.0 |
| 2009-02-27 19:00:00 | AAPL | Stock | 3.1886 | 3.1946 | 3.1886 | 3.1946 | 42140.0 |
| 2009-02-27 07:00:00 | MSFT | Stock | 16.45 | 16.45 | 16.45 | 16.45 | 700.0 |
| 2009-02-27 08:00:00 | MSFT | Stock | 16.42 | 16.44 | 16.23 | 16.27 | 77881.0 |
| 2009-02-27 09:00:00 | MSFT | Stock | 16.27 | 16.37 | 16.1 | 16.32 | 13435762.0 |
| 2009-02-27 10:00:00 | MSFT | Stock | 16.31 | 16.51 | 16.27 | 16.39 | 10684139.0 |
| 2009-02-27 11:00:00 | MSFT | Stock | 16.39 | 16.44 | 16.25 | 16.431 | 9669671.0 |
| 2009-02-27 12:00:00 | MSFT | Stock | 16.43 | 16.47 | 16.31 | 16.4 | 7569935.0 |
| 2009-02-27 13:00:00 | MSFT | Stock | 16.398 | 16.51 | 16.32 | 16.5 | 7830685.0 |
| 2009-02-27 14:00:00 | MSFT | Stock | 16.5 | 16.52 | 16.31 | 16.42 | 8766648.0 |
| 2009-02-27 15:00:00 | MSFT | Stock | 16.41 | 16.45 | 16.14 | 16.15 | 21139130.0 |
| 2009-02-27 16:00:00 | MSFT | Stock | 16.14 | 16.5 | 16.12 | 16.19 | 10886478.0 |
| 2009-02-27 17:00:00 | MSFT | Stock | 16.157 | 16.406 | 16.146 | 16.2 | 475795.0 |
| 2009-02-27 18:00:00 | MSFT | Stock | 16.2 | 16.2 | 16.17 | 16.17 | 720.0 |
| 2009-02-27 19:00:00 | MSFT | Stock | 16.2 | 16.22 | 16.2 | 16.22 | 5704.0 |
| 2009-02-27 08:00:00 | NVDA | Stock | 0.2038 | 0.205 | 0.2038 | 0.2038 | 48000.0 |
| 2009-02-27 09:00:00 | NVDA | Stock | 0.204 | 0.207 | 0.1998 | 0.2058 | 113554360.0 |
| 2009-02-27 10:00:00 | NVDA | Stock | 0.2058 | 0.2118 | 0.205 | 0.209 | 141023000.0 |
| 2009-02-27 11:00:00 | NVDA | Stock | 0.209 | 0.21 | 0.2055 | 0.2092 | 65377000.0 |
| 2009-02-27 12:00:00 | NVDA | Stock | 0.2095 | 0.21 | 0.2065 | 0.2088 | 63018520.0 |
| 2009-02-27 13:00:00 | NVDA | Stock | 0.2088 | 0.21 | 0.207 | 0.2098 | 55341680.0 |
| 2009-02-27 14:00:00 | NVDA | Stock | 0.21 | 0.2108 | 0.2078 | 0.2102 | 82545520.0 |
| 2009-02-27 15:00:00 | NVDA | Stock | 0.2102 | 0.2105 | 0.2062 | 0.2068 | 179081760.0 |
| 2009-02-27 16:00:00 | NVDA | Stock | 0.2065 | 0.2091 | 0.2023 | 0.207 | 49291880.0 |
| 2009-02-27 17:00:00 | NVDA | Stock | 0.2069 | 0.2075 | 0.2069 | 0.2075 | 875880.0 |
| 2009-02-27 18:00:00 | NVDA | Stock | 0.2075 | 0.2075 | 0.207 | 0.207 | 29640.0 |
| 2009-02-27 07:00:00 | AMZN | Stock | 3.1225 | 3.1685 | 3.1225 | 3.1685 | 8000.0 |
| 2009-02-27 08:00:00 | AMZN | Stock | 3.103 | 3.103 | 3.066 | 3.073 | 89600.0 |
| 2009-02-27 09:00:00 | AMZN | Stock | 3.0725 | 3.165 | 3.047 | 3.1535 | 28933400.0 |
| 2009-02-27 10:00:00 | AMZN | Stock | 3.1525 | 3.1975 | 3.1355 | 3.143 | 25892640.0 |
| 2009-02-27 11:00:00 | AMZN | Stock | 3.144 | 3.1875 | 3.128 | 3.176 | 20711380.0 |
| 2009-02-27 12:00:00 | AMZN | Stock | 3.1775 | 3.2 | 3.1635 | 3.184 | 18821700.0 |
| 2009-02-27 13:00:00 | AMZN | Stock | 3.184 | 3.215 | 3.1775 | 3.2135 | 24228620.0 |
| 2009-02-27 14:00:00 | AMZN | Stock | 3.2125 | 3.2415 | 3.1955 | 3.238 | 31259340.0 |
| 2009-02-27 15:00:00 | AMZN | Stock | 3.239 | 3.254 | 3.198 | 3.2343 | 55086540.0 |
| 2009-02-27 16:00:00 | AMZN | Stock | 3.232 | 3.241 | 3.1854 | 3.234 | 21754600.0 |
| 2009-02-27 17:00:00 | AMZN | Stock | 3.233 | 3.241 | 3.2325 | 3.241 | 994940.0 |
| 2009-02-27 18:00:00 | AMZN | Stock | 3.2325 | 3.2345 | 3.231 | 3.2345 | 40000.0 |
| 2009-02-27 19:00:00 | AMZN | Stock | 3.2375 | 3.25 | 3.2335 | 3.2335 | 98580.0 |
> showing 50 of 40,834 rows — these rows as CSV