PREVIEW / stock_1hour / 2009-03-10
file: by_date/stock_1hour/2009/2009-03-10.parquet size: 824 KB rows: 40,744 symbols: 3,361
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-03-10 04:00:00 | AAPL | Stock | 3.0046 | 3.0046 | 3.0046 | 3.0046 | 28000.0 |
| 2009-03-10 06:00:00 | AAPL | Stock | 3.0136 | 3.0136 | 3.0136 | 3.0136 | 2800.0 |
| 2009-03-10 07:00:00 | AAPL | Stock | 3.0146 | 3.0264 | 3.0146 | 3.0179 | 145600.0 |
| 2009-03-10 08:00:00 | AAPL | Stock | 3.0179 | 3.0489 | 3.0179 | 3.0411 | 2054080.0 |
| 2009-03-10 09:00:00 | AAPL | Stock | 3.0386 | 3.0946 | 3.0129 | 3.0496 | 111629224.0 |
| 2009-03-10 10:00:00 | AAPL | Stock | 3.0497 | 3.1371 | 3.0482 | 3.1239 | 149349004.0 |
| 2009-03-10 11:00:00 | AAPL | Stock | 3.1239 | 3.1471 | 3.0986 | 3.1461 | 85762404.0 |
| 2009-03-10 12:00:00 | AAPL | Stock | 3.1464 | 3.1663 | 3.1396 | 3.1446 | 80226216.0 |
| 2009-03-10 13:00:00 | AAPL | Stock | 3.1454 | 3.1846 | 3.1443 | 3.1629 | 78147636.0 |
| 2009-03-10 14:00:00 | AAPL | Stock | 3.1632 | 3.1746 | 3.1254 | 3.155 | 115621156.0 |
| 2009-03-10 15:00:00 | AAPL | Stock | 3.155 | 3.1782 | 3.129 | 3.1586 | 159436228.0 |
| 2009-03-10 16:00:00 | AAPL | Stock | 3.1621 | 3.1696 | 3.1278 | 3.1661 | 51232748.0 |
| 2009-03-10 17:00:00 | AAPL | Stock | 3.1671 | 3.1704 | 3.1294 | 3.1686 | 368004.0 |
| 2009-03-10 18:00:00 | AAPL | Stock | 3.1682 | 3.1768 | 3.1654 | 3.1754 | 1581692.0 |
| 2009-03-10 19:00:00 | AAPL | Stock | 3.1754 | 3.1818 | 3.1714 | 3.1789 | 163464.0 |
| 2009-03-10 06:00:00 | MSFT | Stock | 15.32 | 15.4 | 15.32 | 15.4 | 690.0 |
| 2009-03-10 07:00:00 | MSFT | Stock | 15.4 | 15.5 | 15.36 | 15.36 | 3376.0 |
| 2009-03-10 08:00:00 | MSFT | Stock | 15.39 | 15.4 | 15.3 | 15.36 | 62292.0 |
| 2009-03-10 09:00:00 | MSFT | Stock | 15.39 | 15.73 | 15.25 | 15.61 | 10702566.0 |
| 2009-03-10 10:00:00 | MSFT | Stock | 15.6 | 16.09 | 15.59 | 16.03 | 12822902.0 |
| 2009-03-10 11:00:00 | MSFT | Stock | 16.02 | 16.37 | 15.945 | 16.36 | 12511343.0 |
| 2009-03-10 12:00:00 | MSFT | Stock | 16.36 | 16.42 | 16.15 | 16.184 | 9701858.0 |
| 2009-03-10 13:00:00 | MSFT | Stock | 16.18 | 16.42 | 16.15 | 16.26 | 6787230.0 |
| 2009-03-10 14:00:00 | MSFT | Stock | 16.26 | 16.34 | 16.13 | 16.31 | 8574325.0 |
| 2009-03-10 15:00:00 | MSFT | Stock | 16.31 | 16.62 | 16.28 | 16.62 | 19332111.0 |
| 2009-03-10 16:00:00 | MSFT | Stock | 16.62 | 16.62 | 15.729 | 16.5 | 13605382.0 |
| 2009-03-10 17:00:00 | MSFT | Stock | 16.48 | 16.51 | 16.46 | 16.51 | 11133.0 |
| 2009-03-10 18:00:00 | MSFT | Stock | 16.5 | 16.55 | 16.48 | 16.52 | 367111.0 |
| 2009-03-10 19:00:00 | MSFT | Stock | 16.51 | 16.56 | 16.5 | 16.53 | 5400.0 |
| 2009-03-10 08:00:00 | NVDA | Stock | 0.2112 | 0.2138 | 0.2112 | 0.2138 | 144000.0 |
| 2009-03-10 09:00:00 | NVDA | Stock | 0.217 | 0.2263 | 0.213 | 0.2192 | 201471920.0 |
| 2009-03-10 10:00:00 | NVDA | Stock | 0.2188 | 0.23 | 0.2188 | 0.2283 | 211490760.0 |
| 2009-03-10 11:00:00 | NVDA | Stock | 0.2283 | 0.2283 | 0.223 | 0.2275 | 172566040.0 |
| 2009-03-10 12:00:00 | NVDA | Stock | 0.2278 | 0.2303 | 0.2272 | 0.2278 | 134235920.0 |
| 2009-03-10 13:00:00 | NVDA | Stock | 0.2275 | 0.2278 | 0.2245 | 0.2248 | 100448880.0 |
| 2009-03-10 14:00:00 | NVDA | Stock | 0.225 | 0.225 | 0.2223 | 0.225 | 147092160.0 |
| 2009-03-10 15:00:00 | NVDA | Stock | 0.225 | 0.2265 | 0.2238 | 0.2255 | 221747320.0 |
| 2009-03-10 16:00:00 | NVDA | Stock | 0.2255 | 0.2263 | 0.2246 | 0.2255 | 39495680.0 |
| 2009-03-10 17:00:00 | NVDA | Stock | 0.2258 | 0.2263 | 0.2258 | 0.2263 | 98720.0 |
| 2009-03-10 18:00:00 | NVDA | Stock | 0.227 | 0.227 | 0.2252 | 0.2252 | 48000.0 |
| 2009-03-10 19:00:00 | NVDA | Stock | 0.2252 | 0.2252 | 0.225 | 0.225 | 10240.0 |
| 2009-03-10 04:00:00 | AMZN | Stock | 3.05 | 3.05 | 3.05 | 3.05 | 4000.0 |
| 2009-03-10 07:00:00 | AMZN | Stock | 3.075 | 3.084 | 3.075 | 3.084 | 6000.0 |
| 2009-03-10 08:00:00 | AMZN | Stock | 3.085 | 3.1 | 3.075 | 3.09 | 649800.0 |
| 2009-03-10 09:00:00 | AMZN | Stock | 3.09 | 3.149 | 3.089 | 3.122 | 35942100.0 |
| 2009-03-10 10:00:00 | AMZN | Stock | 3.116 | 3.1815 | 3.116 | 3.1678 | 49339940.0 |
| 2009-03-10 11:00:00 | AMZN | Stock | 3.1665 | 3.204 | 3.1605 | 3.2035 | 32708620.0 |
| 2009-03-10 12:00:00 | AMZN | Stock | 3.204 | 3.2275 | 3.194 | 3.2125 | 30351920.0 |
| 2009-03-10 13:00:00 | AMZN | Stock | 3.213 | 3.2495 | 3.206 | 3.2335 | 28215940.0 |
| 2009-03-10 14:00:00 | AMZN | Stock | 3.233 | 3.269 | 3.2112 | 3.2675 | 45962220.0 |
> showing 50 of 40,744 rows — these rows as CSV