PREVIEW / stock_1hour / 2004-03-01
file: by_date/stock_1hour/2004/2004-03-01.parquet size: 525 KB rows: 24,268 symbols: 1,729
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-03-01 08:00:00 | AAPL | Stock | 0.4273 | 0.4313 | 0.4271 | 0.4313 | 2570400.0 |
| 2004-03-01 09:00:00 | AAPL | Stock | 0.4304 | 0.4339 | 0.4263 | 0.4273 | 49846104.0 |
| 2004-03-01 10:00:00 | AAPL | Stock | 0.4271 | 0.4302 | 0.4266 | 0.4271 | 34935320.0 |
| 2004-03-01 11:00:00 | AAPL | Stock | 0.4279 | 0.4289 | 0.4268 | 0.4289 | 24995264.0 |
| 2004-03-01 12:00:00 | AAPL | Stock | 0.4289 | 0.4296 | 0.427 | 0.4279 | 21189336.0 |
| 2004-03-01 13:00:00 | AAPL | Stock | 0.4277 | 0.4293 | 0.4271 | 0.4291 | 24470208.0 |
| 2004-03-01 14:00:00 | AAPL | Stock | 0.4293 | 0.4302 | 0.4277 | 0.4295 | 39486552.0 |
| 2004-03-01 15:00:00 | AAPL | Stock | 0.4295 | 0.43 | 0.4282 | 0.43 | 48195000.0 |
| 2004-03-01 16:00:00 | AAPL | Stock | 0.4298 | 0.4304 | 0.4279 | 0.4304 | 6394080.0 |
| 2004-03-01 17:00:00 | AAPL | Stock | 0.4304 | 0.4304 | 0.4276 | 0.4276 | 4463760.0 |
| 2004-03-01 08:00:00 | MSFT | Stock | 26.53 | 26.63 | 26.5 | 26.55 | 70618.0 |
| 2004-03-01 09:00:00 | MSFT | Stock | 26.55 | 26.7 | 26.54 | 26.68 | 4735050.0 |
| 2004-03-01 10:00:00 | MSFT | Stock | 26.67 | 26.72 | 26.56 | 26.57 | 8999531.0 |
| 2004-03-01 11:00:00 | MSFT | Stock | 26.58 | 26.65 | 26.51 | 26.63 | 5327538.0 |
| 2004-03-01 12:00:00 | MSFT | Stock | 26.64 | 26.68 | 26.6 | 26.61 | 4708132.0 |
| 2004-03-01 13:00:00 | MSFT | Stock | 26.61 | 26.68 | 26.6 | 26.66 | 3618878.0 |
| 2004-03-01 14:00:00 | MSFT | Stock | 26.66 | 26.71 | 26.6 | 26.66 | 6737043.0 |
| 2004-03-01 15:00:00 | MSFT | Stock | 26.669 | 26.71 | 26.63 | 26.66 | 7892767.0 |
| 2004-03-01 16:00:00 | MSFT | Stock | 26.7 | 26.72 | 26.636 | 26.7 | 1529791.0 |
| 2004-03-01 17:00:00 | MSFT | Stock | 26.68 | 26.7 | 26.6244 | 26.6425 | 212375.0 |
| 2004-03-01 18:00:00 | MSFT | Stock | 26.68 | 26.68 | 26.68 | 26.68 | 500.0 |
| 2004-03-01 08:00:00 | NVDA | Stock | 0.1852 | 0.1858 | 0.1852 | 0.1858 | 12324000.0 |
| 2004-03-01 09:00:00 | NVDA | Stock | 0.1858 | 0.1873 | 0.1848 | 0.1857 | 39822000.0 |
| 2004-03-01 10:00:00 | NVDA | Stock | 0.1858 | 0.1878 | 0.1854 | 0.1866 | 83707440.0 |
| 2004-03-01 11:00:00 | NVDA | Stock | 0.1866 | 0.187 | 0.1855 | 0.1858 | 24247680.0 |
| 2004-03-01 12:00:00 | NVDA | Stock | 0.1858 | 0.187 | 0.1857 | 0.1868 | 17845080.0 |
| 2004-03-01 13:00:00 | NVDA | Stock | 0.1868 | 0.1875 | 0.1862 | 0.1872 | 25932360.0 |
| 2004-03-01 14:00:00 | NVDA | Stock | 0.1872 | 0.1875 | 0.1872 | 0.1874 | 62743680.0 |
| 2004-03-01 15:00:00 | NVDA | Stock | 0.1874 | 0.1885 | 0.1869 | 0.1882 | 162945720.0 |
| 2004-03-01 16:00:00 | NVDA | Stock | 0.1881 | 0.1883 | 0.1872 | 0.1879 | 2722680.0 |
| 2004-03-01 17:00:00 | NVDA | Stock | 0.1882 | 0.1882 | 0.1882 | 0.1882 | 1140000.0 |
| 2004-03-01 08:00:00 | AMZN | Stock | 2.1575 | 2.1575 | 2.1505 | 2.155 | 72000.0 |
| 2004-03-01 09:00:00 | AMZN | Stock | 2.155 | 2.174 | 2.144 | 2.166 | 10631440.0 |
| 2004-03-01 10:00:00 | AMZN | Stock | 2.166 | 2.1715 | 2.158 | 2.1618 | 10726300.0 |
| 2004-03-01 11:00:00 | AMZN | Stock | 2.161 | 2.1625 | 2.1375 | 2.142 | 8227660.0 |
| 2004-03-01 12:00:00 | AMZN | Stock | 2.142 | 2.148 | 2.129 | 2.1375 | 14761400.0 |
| 2004-03-01 13:00:00 | AMZN | Stock | 2.1375 | 2.1475 | 2.1345 | 2.1441 | 6191240.0 |
| 2004-03-01 14:00:00 | AMZN | Stock | 2.144 | 2.154 | 2.143 | 2.1523 | 12743860.0 |
| 2004-03-01 15:00:00 | AMZN | Stock | 2.1523 | 2.155 | 2.1445 | 2.1485 | 19922560.0 |
| 2004-03-01 16:00:00 | AMZN | Stock | 2.1485 | 2.171 | 2.1356 | 2.1485 | 1135620.0 |
| 2004-03-01 17:00:00 | AMZN | Stock | 2.1485 | 2.1485 | 2.1465 | 2.1475 | 256320.0 |
| 2004-03-01 18:00:00 | AMZN | Stock | 2.1485 | 2.1485 | 2.1485 | 2.1485 | 24000.0 |
| 2004-03-01 09:00:00 | CL | Stock | 27.825 | 28.04 | 27.775 | 27.995 | 413600.0 |
| 2004-03-01 10:00:00 | CL | Stock | 27.995 | 28.085 | 27.925 | 27.925 | 506200.0 |
| 2004-03-01 11:00:00 | CL | Stock | 27.92 | 28.065 | 27.875 | 28.025 | 455000.0 |
| 2004-03-01 12:00:00 | CL | Stock | 28.025 | 28.045 | 28.0 | 28.025 | 203800.0 |
| 2004-03-01 13:00:00 | CL | Stock | 28.03 | 28.075 | 27.98 | 28.075 | 233800.0 |
| 2004-03-01 14:00:00 | CL | Stock | 28.075 | 28.175 | 28.045 | 28.165 | 498000.0 |
| 2004-03-01 15:00:00 | CL | Stock | 28.175 | 28.175 | 28.075 | 28.12 | 857000.0 |
| 2004-03-01 16:00:00 | CL | Stock | 28.12 | 28.12 | 28.12 | 28.12 | 4000.0 |
> showing 50 of 24,268 rows — these rows as CSV