PREVIEW / stock_1hour / 2009-08-11
file: by_date/stock_1hour/2009/2009-08-11.parquet size: 869 KB rows: 42,155 symbols: 3,357
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-08-11 06:00:00 | AAPL | Stock | 5.8932 | 5.8932 | 5.8932 | 5.8932 | 14000.0 |
| 2009-08-11 08:00:00 | AAPL | Stock | 5.8875 | 5.8875 | 5.8579 | 5.8579 | 282716.0 |
| 2009-08-11 09:00:00 | AAPL | Stock | 5.8579 | 5.8711 | 5.8311 | 5.8686 | 53500272.0 |
| 2009-08-11 10:00:00 | AAPL | Stock | 5.8679 | 5.8679 | 5.7946 | 5.8096 | 76932492.0 |
| 2009-08-11 11:00:00 | AAPL | Stock | 5.8094 | 5.8146 | 5.785 | 5.7875 | 44424604.0 |
| 2009-08-11 12:00:00 | AAPL | Stock | 5.7868 | 5.7996 | 5.7814 | 5.7857 | 30283120.0 |
| 2009-08-11 13:00:00 | AAPL | Stock | 5.7854 | 5.8036 | 5.7846 | 5.7971 | 27415696.0 |
| 2009-08-11 14:00:00 | AAPL | Stock | 5.7971 | 5.8304 | 5.7971 | 5.8275 | 49623952.0 |
| 2009-08-11 15:00:00 | AAPL | Stock | 5.8275 | 5.8425 | 5.8154 | 5.8168 | 59840144.0 |
| 2009-08-11 16:00:00 | AAPL | Stock | 5.8168 | 5.8761 | 5.8139 | 5.8179 | 7976136.0 |
| 2009-08-11 17:00:00 | AAPL | Stock | 5.8699 | 5.8699 | 5.8107 | 5.8107 | 108052.0 |
| 2009-08-11 18:00:00 | AAPL | Stock | 5.8129 | 5.8179 | 5.8111 | 5.8125 | 373940.0 |
| 2009-08-11 19:00:00 | AAPL | Stock | 5.8171 | 5.8243 | 5.8132 | 5.8179 | 108556.0 |
| 2009-08-11 04:00:00 | MSFT | Stock | 23.55 | 23.62 | 23.55 | 23.62 | 600.0 |
| 2009-08-11 07:00:00 | MSFT | Stock | 23.5 | 23.55 | 23.5 | 23.55 | 1600.0 |
| 2009-08-11 08:00:00 | MSFT | Stock | 23.46 | 23.5 | 23.37 | 23.45 | 8154.0 |
| 2009-08-11 09:00:00 | MSFT | Stock | 23.45 | 23.48 | 23.15 | 23.16 | 5577202.0 |
| 2009-08-11 10:00:00 | MSFT | Stock | 23.16 | 23.23 | 23.05 | 23.129 | 6517630.0 |
| 2009-08-11 11:00:00 | MSFT | Stock | 23.12 | 23.23 | 23.09 | 23.19 | 3543071.0 |
| 2009-08-11 12:00:00 | MSFT | Stock | 23.19 | 23.2 | 23.11 | 23.14 | 2072158.0 |
| 2009-08-11 13:00:00 | MSFT | Stock | 23.14 | 23.17 | 23.1 | 23.122 | 3239818.0 |
| 2009-08-11 14:00:00 | MSFT | Stock | 23.13 | 23.24 | 23.125 | 23.23 | 4041714.0 |
| 2009-08-11 15:00:00 | MSFT | Stock | 23.23 | 23.27 | 23.12 | 23.14 | 5599321.0 |
| 2009-08-11 16:00:00 | MSFT | Stock | 23.15 | 23.2 | 23.12 | 23.18 | 2080973.0 |
| 2009-08-11 17:00:00 | MSFT | Stock | 23.368 | 23.368 | 23.15 | 23.19 | 9353.0 |
| 2009-08-11 18:00:00 | MSFT | Stock | 23.19 | 23.19 | 23.15 | 23.15 | 1130.0 |
| 2009-08-11 19:00:00 | MSFT | Stock | 23.21 | 23.21 | 23.19 | 23.21 | 900.0 |
| 2009-08-11 20:00:00 | MSFT | Stock | 23.11 | 23.2 | 23.11 | 23.2 | 2339.0 |
| 2009-08-11 08:00:00 | NVDA | Stock | 0.3325 | 0.3325 | 0.3325 | 0.3325 | 28000.0 |
| 2009-08-11 09:00:00 | NVDA | Stock | 0.3303 | 0.3342 | 0.3263 | 0.3308 | 63335760.0 |
| 2009-08-11 10:00:00 | NVDA | Stock | 0.3305 | 0.3305 | 0.323 | 0.3243 | 132386000.0 |
| 2009-08-11 11:00:00 | NVDA | Stock | 0.3242 | 0.3258 | 0.3233 | 0.3253 | 70121400.0 |
| 2009-08-11 12:00:00 | NVDA | Stock | 0.3253 | 0.3253 | 0.3233 | 0.3235 | 39881240.0 |
| 2009-08-11 13:00:00 | NVDA | Stock | 0.3234 | 0.3243 | 0.322 | 0.3225 | 54090640.0 |
| 2009-08-11 14:00:00 | NVDA | Stock | 0.3228 | 0.3245 | 0.3225 | 0.3243 | 43288320.0 |
| 2009-08-11 15:00:00 | NVDA | Stock | 0.3243 | 0.3248 | 0.3228 | 0.3233 | 66151600.0 |
| 2009-08-11 16:00:00 | NVDA | Stock | 0.3238 | 0.3255 | 0.322 | 0.3238 | 2848680.0 |
| 2009-08-11 17:00:00 | NVDA | Stock | 0.323 | 0.3245 | 0.323 | 0.3245 | 24280.0 |
| 2009-08-11 18:00:00 | NVDA | Stock | 0.3225 | 0.3245 | 0.3225 | 0.3243 | 140000.0 |
| 2009-08-11 19:00:00 | NVDA | Stock | 0.3228 | 0.3228 | 0.3228 | 0.3228 | 92280.0 |
| 2009-08-11 20:00:00 | NVDA | Stock | 0.3315 | 0.3315 | 0.3315 | 0.3315 | 44000.0 |
| 2009-08-11 08:00:00 | AMZN | Stock | 4.2135 | 4.2135 | 4.2135 | 4.2135 | 10000.0 |
| 2009-08-11 09:00:00 | AMZN | Stock | 4.202 | 4.22 | 4.1275 | 4.1635 | 18363560.0 |
| 2009-08-11 10:00:00 | AMZN | Stock | 4.1615 | 4.1615 | 4.1325 | 4.1355 | 13754240.0 |
| 2009-08-11 11:00:00 | AMZN | Stock | 4.1345 | 4.1405 | 4.1225 | 4.1405 | 11877520.0 |
| 2009-08-11 12:00:00 | AMZN | Stock | 4.14 | 4.174 | 4.134 | 4.141 | 9306600.0 |
| 2009-08-11 13:00:00 | AMZN | Stock | 4.1405 | 4.18 | 4.1405 | 4.1684 | 8669240.0 |
| 2009-08-11 14:00:00 | AMZN | Stock | 4.17 | 4.1835 | 4.158 | 4.1655 | 11496320.0 |
| 2009-08-11 15:00:00 | AMZN | Stock | 4.1658 | 4.1995 | 4.1658 | 4.1775 | 23884480.0 |
| 2009-08-11 16:00:00 | AMZN | Stock | 4.1775 | 4.1824 | 4.1592 | 4.176 | 2284060.0 |
> showing 50 of 42,155 rows — these rows as CSV