PREVIEW / stock_1hour / 2009-07-28
file: by_date/stock_1hour/2009/2009-07-28.parquet size: 859 KB rows: 42,142 symbols: 3,353
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-07-28 07:00:00 | AAPL | Stock | 5.6804 | 5.6804 | 5.675 | 5.6786 | 126868.0 |
| 2009-07-28 08:00:00 | AAPL | Stock | 5.67 | 5.7179 | 5.6696 | 5.6718 | 896728.0 |
| 2009-07-28 09:00:00 | AAPL | Stock | 5.6721 | 5.6957 | 5.6436 | 5.6736 | 62582464.0 |
| 2009-07-28 10:00:00 | AAPL | Stock | 5.6736 | 5.6757 | 5.645 | 5.66 | 51259208.0 |
| 2009-07-28 11:00:00 | AAPL | Stock | 5.6593 | 5.6596 | 5.6286 | 5.6536 | 49109760.0 |
| 2009-07-28 12:00:00 | AAPL | Stock | 5.6536 | 5.6579 | 5.6389 | 5.6571 | 23292220.0 |
| 2009-07-28 13:00:00 | AAPL | Stock | 5.6568 | 5.6925 | 5.6482 | 5.6904 | 42898744.0 |
| 2009-07-28 14:00:00 | AAPL | Stock | 5.6898 | 5.718 | 5.6768 | 5.6939 | 57699628.0 |
| 2009-07-28 15:00:00 | AAPL | Stock | 5.6939 | 5.7143 | 5.6718 | 5.7139 | 66014760.0 |
| 2009-07-28 16:00:00 | AAPL | Stock | 5.7139 | 5.7154 | 5.674 | 5.7118 | 6106576.0 |
| 2009-07-28 17:00:00 | AAPL | Stock | 5.7118 | 5.7125 | 5.6692 | 5.7089 | 150752.0 |
| 2009-07-28 18:00:00 | AAPL | Stock | 5.7143 | 5.7143 | 5.6975 | 5.698 | 226660.0 |
| 2009-07-28 19:00:00 | AAPL | Stock | 5.6979 | 5.7071 | 5.6786 | 5.7071 | 196672.0 |
| 2009-07-28 07:00:00 | MSFT | Stock | 23.06 | 23.06 | 22.95 | 22.98 | 10630.0 |
| 2009-07-28 08:00:00 | MSFT | Stock | 22.99 | 23.11 | 22.93 | 22.93 | 47192.0 |
| 2009-07-28 09:00:00 | MSFT | Stock | 22.93 | 23.12 | 22.91 | 23.08 | 7700003.0 |
| 2009-07-28 10:00:00 | MSFT | Stock | 23.08 | 23.14 | 22.97 | 23.035 | 8728554.0 |
| 2009-07-28 11:00:00 | MSFT | Stock | 23.04 | 23.04 | 22.9 | 23.0 | 9183096.0 |
| 2009-07-28 12:00:00 | MSFT | Stock | 23.005 | 23.06 | 22.97 | 23.04 | 5103036.0 |
| 2009-07-28 13:00:00 | MSFT | Stock | 23.05 | 23.39 | 23.02 | 23.35 | 11255091.0 |
| 2009-07-28 14:00:00 | MSFT | Stock | 23.358 | 23.48 | 23.31 | 23.34 | 9654255.0 |
| 2009-07-28 15:00:00 | MSFT | Stock | 23.33 | 23.55 | 23.3 | 23.48 | 15314125.0 |
| 2009-07-28 16:00:00 | MSFT | Stock | 23.48 | 23.52 | 22.97 | 23.5 | 2088265.0 |
| 2009-07-28 17:00:00 | MSFT | Stock | 23.48 | 23.48 | 23.053 | 23.42 | 9850.0 |
| 2009-07-28 18:00:00 | MSFT | Stock | 23.47 | 23.52 | 23.42 | 23.5 | 30355.0 |
| 2009-07-28 19:00:00 | MSFT | Stock | 23.51 | 23.53 | 23.5 | 23.51 | 13858.0 |
| 2009-07-28 07:00:00 | NVDA | Stock | 0.3275 | 0.3275 | 0.3275 | 0.3275 | 20000.0 |
| 2009-07-28 08:00:00 | NVDA | Stock | 0.3255 | 0.3255 | 0.3213 | 0.3213 | 28000.0 |
| 2009-07-28 09:00:00 | NVDA | Stock | 0.3223 | 0.3295 | 0.3223 | 0.3283 | 72146000.0 |
| 2009-07-28 10:00:00 | NVDA | Stock | 0.328 | 0.329 | 0.3233 | 0.3275 | 113569440.0 |
| 2009-07-28 11:00:00 | NVDA | Stock | 0.3275 | 0.3275 | 0.3205 | 0.322 | 105164600.0 |
| 2009-07-28 12:00:00 | NVDA | Stock | 0.322 | 0.3225 | 0.3205 | 0.3225 | 37475720.0 |
| 2009-07-28 13:00:00 | NVDA | Stock | 0.3224 | 0.3255 | 0.3218 | 0.3253 | 50144160.0 |
| 2009-07-28 14:00:00 | NVDA | Stock | 0.3253 | 0.3285 | 0.3248 | 0.325 | 76228960.0 |
| 2009-07-28 15:00:00 | NVDA | Stock | 0.3253 | 0.3268 | 0.3243 | 0.326 | 99683160.0 |
| 2009-07-28 16:00:00 | NVDA | Stock | 0.326 | 0.3263 | 0.3249 | 0.326 | 4641920.0 |
| 2009-07-28 17:00:00 | NVDA | Stock | 0.3268 | 0.3268 | 0.3268 | 0.3268 | 16000.0 |
| 2009-07-28 18:00:00 | NVDA | Stock | 0.3268 | 0.3268 | 0.3268 | 0.3268 | 145720.0 |
| 2009-07-28 19:00:00 | NVDA | Stock | 0.3258 | 0.3258 | 0.3255 | 0.3255 | 42000.0 |
| 2009-07-28 08:00:00 | AMZN | Stock | 4.212 | 4.212 | 4.17 | 4.1845 | 178940.0 |
| 2009-07-28 09:00:00 | AMZN | Stock | 4.1775 | 4.2 | 4.1525 | 4.1665 | 23732620.0 |
| 2009-07-28 10:00:00 | AMZN | Stock | 4.1665 | 4.17 | 4.13 | 4.157 | 30444120.0 |
| 2009-07-28 11:00:00 | AMZN | Stock | 4.157 | 4.1675 | 4.13 | 4.1592 | 16302340.0 |
| 2009-07-28 12:00:00 | AMZN | Stock | 4.1583 | 4.173 | 4.146 | 4.1655 | 12584780.0 |
| 2009-07-28 13:00:00 | AMZN | Stock | 4.1648 | 4.237 | 4.158 | 4.2355 | 27691380.0 |
| 2009-07-28 14:00:00 | AMZN | Stock | 4.2355 | 4.282 | 4.2215 | 4.247 | 29658140.0 |
| 2009-07-28 15:00:00 | AMZN | Stock | 4.249 | 4.2525 | 4.217 | 4.246 | 31572680.0 |
| 2009-07-28 16:00:00 | AMZN | Stock | 4.249 | 4.2495 | 4.1961 | 4.241 | 2549460.0 |
| 2009-07-28 17:00:00 | AMZN | Stock | 4.241 | 4.247 | 4.1392 | 4.1392 | 34020.0 |
| 2009-07-28 18:00:00 | AMZN | Stock | 4.249 | 4.249 | 4.2405 | 4.2405 | 159080.0 |
> showing 50 of 42,142 rows — these rows as CSV