PREVIEW / stock_1hour / 2009-02-26
file: by_date/stock_1hour/2009/2009-02-26.parquet size: 817 KB rows: 40,034 symbols: 3,304
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-26 06:00:00 | AAPL | Stock | 3.2918 | 3.2918 | 3.2918 | 3.2918 | 16800.0 |
| 2009-02-26 07:00:00 | AAPL | Stock | 3.2936 | 3.2946 | 3.2854 | 3.2946 | 198660.0 |
| 2009-02-26 08:00:00 | AAPL | Stock | 3.2946 | 3.2964 | 3.2718 | 3.2843 | 525392.0 |
| 2009-02-26 09:00:00 | AAPL | Stock | 3.2857 | 3.2975 | 3.2343 | 3.2564 | 71429540.0 |
| 2009-02-26 10:00:00 | AAPL | Stock | 3.2571 | 3.3186 | 3.25 | 3.3161 | 99309168.0 |
| 2009-02-26 11:00:00 | AAPL | Stock | 3.3157 | 3.3186 | 3.2568 | 3.2807 | 75645108.0 |
| 2009-02-26 12:00:00 | AAPL | Stock | 3.2807 | 3.2918 | 3.2429 | 3.2471 | 54294100.0 |
| 2009-02-26 13:00:00 | AAPL | Stock | 3.2471 | 3.2557 | 3.2171 | 3.2421 | 78134000.0 |
| 2009-02-26 14:00:00 | AAPL | Stock | 3.2418 | 3.2554 | 3.2036 | 3.2114 | 71155140.0 |
| 2009-02-26 15:00:00 | AAPL | Stock | 3.2121 | 3.2164 | 3.1771 | 3.1793 | 136093132.0 |
| 2009-02-26 16:00:00 | AAPL | Stock | 3.1804 | 3.2492 | 3.1429 | 3.1854 | 28765464.0 |
| 2009-02-26 17:00:00 | AAPL | Stock | 3.1857 | 3.2646 | 3.1818 | 3.1821 | 200032.0 |
| 2009-02-26 18:00:00 | AAPL | Stock | 3.1854 | 3.1854 | 3.1714 | 3.1714 | 12676524.0 |
| 2009-02-26 19:00:00 | AAPL | Stock | 3.1807 | 3.1807 | 3.1721 | 3.1732 | 157192.0 |
| 2009-02-26 08:00:00 | MSFT | Stock | 17.1 | 17.15 | 17.03 | 17.08 | 55136.0 |
| 2009-02-26 09:00:00 | MSFT | Stock | 17.08 | 17.15 | 16.63 | 16.725 | 7328848.0 |
| 2009-02-26 10:00:00 | MSFT | Stock | 16.72 | 16.96 | 16.65 | 16.79 | 12014414.0 |
| 2009-02-26 11:00:00 | MSFT | Stock | 16.79 | 16.8 | 16.52 | 16.63 | 8208568.0 |
| 2009-02-26 12:00:00 | MSFT | Stock | 16.63 | 16.69 | 16.52 | 16.59 | 5513853.0 |
| 2009-02-26 13:00:00 | MSFT | Stock | 16.59 | 16.77 | 16.53 | 16.683 | 6902266.0 |
| 2009-02-26 14:00:00 | MSFT | Stock | 16.68 | 16.88 | 16.62 | 16.63 | 16509308.0 |
| 2009-02-26 15:00:00 | MSFT | Stock | 16.63 | 16.68 | 16.43 | 16.43 | 22221692.0 |
| 2009-02-26 16:00:00 | MSFT | Stock | 16.43 | 16.712 | 16.39 | 16.42 | 3057104.0 |
| 2009-02-26 17:00:00 | MSFT | Stock | 16.41 | 16.621 | 16.4 | 16.45 | 31810.0 |
| 2009-02-26 18:00:00 | MSFT | Stock | 16.45 | 16.48 | 16.42 | 16.43 | 10162.0 |
| 2009-02-26 19:00:00 | MSFT | Stock | 16.43 | 16.48 | 16.43 | 16.48 | 15805.0 |
| 2009-02-26 07:00:00 | NVDA | Stock | 0.2072 | 0.2072 | 0.2072 | 0.2072 | 40000.0 |
| 2009-02-26 09:00:00 | NVDA | Stock | 0.2062 | 0.2112 | 0.2043 | 0.2092 | 164982760.0 |
| 2009-02-26 10:00:00 | NVDA | Stock | 0.209 | 0.2135 | 0.2082 | 0.2125 | 214997680.0 |
| 2009-02-26 11:00:00 | NVDA | Stock | 0.2125 | 0.2128 | 0.206 | 0.2082 | 144233680.0 |
| 2009-02-26 12:00:00 | NVDA | Stock | 0.2085 | 0.2102 | 0.2062 | 0.2095 | 122169600.0 |
| 2009-02-26 13:00:00 | NVDA | Stock | 0.2098 | 0.2112 | 0.207 | 0.21 | 120079280.0 |
| 2009-02-26 14:00:00 | NVDA | Stock | 0.21 | 0.2105 | 0.204 | 0.205 | 112972760.0 |
| 2009-02-26 15:00:00 | NVDA | Stock | 0.2047 | 0.2092 | 0.2043 | 0.2065 | 214618200.0 |
| 2009-02-26 16:00:00 | NVDA | Stock | 0.2065 | 0.2089 | 0.205 | 0.2081 | 13553240.0 |
| 2009-02-26 17:00:00 | NVDA | Stock | 0.2065 | 0.2075 | 0.2065 | 0.2075 | 112000.0 |
| 2009-02-26 19:00:00 | NVDA | Stock | 0.2065 | 0.2065 | 0.2065 | 0.2065 | 12000.0 |
| 2009-02-26 06:00:00 | AMZN | Stock | 3.21 | 3.21 | 3.21 | 3.21 | 2000.0 |
| 2009-02-26 07:00:00 | AMZN | Stock | 3.225 | 3.225 | 3.225 | 3.225 | 8000.0 |
| 2009-02-26 08:00:00 | AMZN | Stock | 3.2225 | 3.2225 | 3.2 | 3.2175 | 32820.0 |
| 2009-02-26 09:00:00 | AMZN | Stock | 3.2175 | 3.2175 | 3.1385 | 3.177 | 16286360.0 |
| 2009-02-26 10:00:00 | AMZN | Stock | 3.177 | 3.2365 | 3.167 | 3.2145 | 20353160.0 |
| 2009-02-26 11:00:00 | AMZN | Stock | 3.216 | 3.2195 | 3.186 | 3.2135 | 15425860.0 |
| 2009-02-26 12:00:00 | AMZN | Stock | 3.2125 | 3.2215 | 3.1605 | 3.1635 | 13724100.0 |
| 2009-02-26 13:00:00 | AMZN | Stock | 3.1635 | 3.1745 | 3.1295 | 3.1565 | 19318780.0 |
| 2009-02-26 14:00:00 | AMZN | Stock | 3.1555 | 3.171 | 3.125 | 3.1315 | 17101640.0 |
| 2009-02-26 15:00:00 | AMZN | Stock | 3.131 | 3.156 | 3.117 | 3.117 | 32229340.0 |
| 2009-02-26 16:00:00 | AMZN | Stock | 3.1185 | 3.1676 | 3.1155 | 3.117 | 1516860.0 |
| 2009-02-26 17:00:00 | AMZN | Stock | 3.1714 | 3.1714 | 3.1714 | 3.1714 | 10000.0 |
| 2009-02-26 18:00:00 | AMZN | Stock | 3.1175 | 3.12 | 3.1175 | 3.12 | 5940.0 |
> showing 50 of 40,034 rows — these rows as CSV