PREVIEW / stock_1hour / 2004-06-08
file: by_date/stock_1hour/2004/2004-06-08.parquet size: 491 KB rows: 23,725 symbols: 1,784
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 |
|---|---|---|---|---|---|---|---|
| 2004-06-08 08:00:00 | AAPL | Stock | 0.5338 | 0.5402 | 0.5332 | 0.5366 | 2169608.0 |
| 2004-06-08 09:00:00 | AAPL | Stock | 0.5355 | 0.5436 | 0.5327 | 0.535 | 103865832.0 |
| 2004-06-08 10:00:00 | AAPL | Stock | 0.535 | 0.5432 | 0.535 | 0.5382 | 94145912.0 |
| 2004-06-08 11:00:00 | AAPL | Stock | 0.5382 | 0.5396 | 0.5357 | 0.538 | 35290528.0 |
| 2004-06-08 12:00:00 | AAPL | Stock | 0.538 | 0.5414 | 0.5375 | 0.5398 | 31761744.0 |
| 2004-06-08 13:00:00 | AAPL | Stock | 0.5398 | 0.54 | 0.5373 | 0.5382 | 24505656.0 |
| 2004-06-08 14:00:00 | AAPL | Stock | 0.5382 | 0.5413 | 0.5373 | 0.5413 | 34593664.0 |
| 2004-06-08 15:00:00 | AAPL | Stock | 0.5413 | 0.5427 | 0.5373 | 0.5411 | 61718272.0 |
| 2004-06-08 16:00:00 | AAPL | Stock | 0.5411 | 0.542 | 0.5389 | 0.542 | 7463176.0 |
| 2004-06-08 18:00:00 | AAPL | Stock | 0.5405 | 0.5405 | 0.5405 | 0.5405 | 11200.0 |
| 2004-06-08 08:00:00 | MSFT | Stock | 26.4 | 26.4 | 26.35 | 26.38 | 16100.0 |
| 2004-06-08 09:00:00 | MSFT | Stock | 26.37 | 26.571 | 26.24 | 26.44 | 7936094.0 |
| 2004-06-08 10:00:00 | MSFT | Stock | 26.44 | 26.49 | 26.35 | 26.45 | 11187586.0 |
| 2004-06-08 11:00:00 | MSFT | Stock | 26.46 | 26.48 | 26.41 | 26.47 | 5692864.0 |
| 2004-06-08 12:00:00 | MSFT | Stock | 26.47 | 26.5702 | 26.46 | 26.56 | 8694142.0 |
| 2004-06-08 13:00:00 | MSFT | Stock | 26.56 | 26.57 | 26.46 | 26.5 | 5384132.0 |
| 2004-06-08 14:00:00 | MSFT | Stock | 26.51 | 26.59 | 26.46 | 26.53 | 5256356.0 |
| 2004-06-08 15:00:00 | MSFT | Stock | 26.53 | 26.61 | 26.41 | 26.58 | 11785963.0 |
| 2004-06-08 16:00:00 | MSFT | Stock | 26.58 | 26.61 | 26.54 | 26.6 | 1028355.0 |
| 2004-06-08 17:00:00 | MSFT | Stock | 26.6 | 26.62 | 26.59 | 26.6 | 7620.0 |
| 2004-06-08 18:00:00 | MSFT | Stock | 26.6 | 26.6 | 26.59 | 26.59 | 3290.0 |
| 2004-06-08 08:00:00 | NVDA | Stock | 0.1854 | 0.1854 | 0.1853 | 0.1853 | 48000.0 |
| 2004-06-08 09:00:00 | NVDA | Stock | 0.1853 | 0.1869 | 0.1809 | 0.1836 | 145775280.0 |
| 2004-06-08 10:00:00 | NVDA | Stock | 0.1836 | 0.1852 | 0.1824 | 0.1842 | 107063280.0 |
| 2004-06-08 11:00:00 | NVDA | Stock | 0.1842 | 0.1846 | 0.1832 | 0.184 | 79472400.0 |
| 2004-06-08 12:00:00 | NVDA | Stock | 0.184 | 0.1844 | 0.1834 | 0.1842 | 43781280.0 |
| 2004-06-08 13:00:00 | NVDA | Stock | 0.1842 | 0.1846 | 0.184 | 0.1844 | 27089160.0 |
| 2004-06-08 14:00:00 | NVDA | Stock | 0.1844 | 0.1848 | 0.1839 | 0.1841 | 47755680.0 |
| 2004-06-08 15:00:00 | NVDA | Stock | 0.1842 | 0.1842 | 0.1823 | 0.1842 | 125324640.0 |
| 2004-06-08 16:00:00 | NVDA | Stock | 0.1837 | 0.1845 | 0.1833 | 0.1837 | 6396360.0 |
| 2004-06-08 08:00:00 | AMZN | Stock | 2.581 | 2.5861 | 2.57 | 2.574 | 644000.0 |
| 2004-06-08 09:00:00 | AMZN | Stock | 2.5735 | 2.586 | 2.565 | 2.57 | 13116820.0 |
| 2004-06-08 10:00:00 | AMZN | Stock | 2.5695 | 2.582 | 2.5625 | 2.572 | 16372400.0 |
| 2004-06-08 11:00:00 | AMZN | Stock | 2.573 | 2.573 | 2.555 | 2.568 | 16793720.0 |
| 2004-06-08 12:00:00 | AMZN | Stock | 2.568 | 2.5805 | 2.562 | 2.573 | 11368480.0 |
| 2004-06-08 13:00:00 | AMZN | Stock | 2.5728 | 2.6 | 2.5695 | 2.595 | 15156400.0 |
| 2004-06-08 14:00:00 | AMZN | Stock | 2.595 | 2.606 | 2.587 | 2.5905 | 18973140.0 |
| 2004-06-08 15:00:00 | AMZN | Stock | 2.5895 | 2.5975 | 2.572 | 2.5975 | 23760240.0 |
| 2004-06-08 16:00:00 | AMZN | Stock | 2.5955 | 2.5975 | 2.5792 | 2.593 | 1639760.0 |
| 2004-06-08 17:00:00 | AMZN | Stock | 2.593 | 2.5945 | 2.593 | 2.593 | 96000.0 |
| 2004-06-08 09:00:00 | CL | Stock | 28.625 | 28.715 | 28.555 | 28.58 | 223400.0 |
| 2004-06-08 10:00:00 | CL | Stock | 28.58 | 28.645 | 28.53 | 28.625 | 322800.0 |
| 2004-06-08 11:00:00 | CL | Stock | 28.625 | 28.745 | 28.61 | 28.74 | 274800.0 |
| 2004-06-08 12:00:00 | CL | Stock | 28.75 | 28.75 | 28.66 | 28.735 | 156000.0 |
| 2004-06-08 13:00:00 | CL | Stock | 28.735 | 28.775 | 28.72 | 28.77 | 114800.0 |
| 2004-06-08 14:00:00 | CL | Stock | 28.77 | 28.83 | 28.745 | 28.81 | 318800.0 |
| 2004-06-08 15:00:00 | CL | Stock | 28.81 | 28.925 | 28.755 | 28.89 | 1090200.0 |
> showing 47 of 23,725 rows — these rows as CSV