PREVIEW / stock_1hour / 2003-05-14
file: by_date/stock_1hour/2003/2003-05-14.parquet size: 419 KB rows: 20,581 symbols: 1,572
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 |
|---|---|---|---|---|---|---|---|
| 2003-05-14 08:00:00 | AAPL | Stock | 0.3329 | 0.3348 | 0.3327 | 0.3348 | 319200.0 |
| 2003-05-14 09:00:00 | AAPL | Stock | 0.3341 | 0.3364 | 0.3316 | 0.3334 | 61113304.0 |
| 2003-05-14 10:00:00 | AAPL | Stock | 0.3334 | 0.3336 | 0.3291 | 0.3304 | 57471456.0 |
| 2003-05-14 11:00:00 | AAPL | Stock | 0.3304 | 0.3337 | 0.33 | 0.3336 | 27382488.0 |
| 2003-05-14 12:00:00 | AAPL | Stock | 0.3334 | 0.3341 | 0.3316 | 0.3334 | 26055456.0 |
| 2003-05-14 13:00:00 | AAPL | Stock | 0.3336 | 0.3343 | 0.3323 | 0.3336 | 16621920.0 |
| 2003-05-14 14:00:00 | AAPL | Stock | 0.3332 | 0.3336 | 0.3295 | 0.3313 | 39683280.0 |
| 2003-05-14 15:00:00 | AAPL | Stock | 0.3313 | 0.3321 | 0.3295 | 0.3313 | 46308752.0 |
| 2003-05-14 16:00:00 | AAPL | Stock | 0.3313 | 0.3327 | 0.3307 | 0.3323 | 16576000.0 |
| 2003-05-14 17:00:00 | AAPL | Stock | 0.3314 | 0.332 | 0.3311 | 0.332 | 324800.0 |
| 2003-05-14 08:00:00 | MSFT | Stock | 26.07 | 26.16 | 26.0 | 26.06 | 120512.0 |
| 2003-05-14 09:00:00 | MSFT | Stock | 26.052 | 26.18 | 25.88 | 25.95 | 6583230.0 |
| 2003-05-14 10:00:00 | MSFT | Stock | 25.94 | 25.95 | 25.61 | 25.621 | 10959831.0 |
| 2003-05-14 11:00:00 | MSFT | Stock | 25.62 | 25.67 | 25.55 | 25.67 | 4151694.0 |
| 2003-05-14 12:00:00 | MSFT | Stock | 25.667 | 25.695 | 25.6 | 25.61 | 2377226.0 |
| 2003-05-14 13:00:00 | MSFT | Stock | 25.61 | 25.691 | 25.58 | 25.63 | 2859989.0 |
| 2003-05-14 14:00:00 | MSFT | Stock | 25.63 | 25.64 | 25.548 | 25.61 | 3492249.0 |
| 2003-05-14 15:00:00 | MSFT | Stock | 25.6 | 25.69 | 25.547 | 25.63 | 6206858.0 |
| 2003-05-14 16:00:00 | MSFT | Stock | 25.64 | 25.67 | 25.59 | 25.62 | 517465.0 |
| 2003-05-14 17:00:00 | MSFT | Stock | 25.62 | 25.68 | 25.62 | 25.67 | 106720.0 |
| 2003-05-14 18:00:00 | MSFT | Stock | 25.67 | 25.67 | 25.64 | 25.66 | 8300.0 |
| 2003-05-14 08:00:00 | NVDA | Stock | 0.1692 | 0.1708 | 0.1683 | 0.1704 | 1824000.0 |
| 2003-05-14 09:00:00 | NVDA | Stock | 0.1703 | 0.1735 | 0.1675 | 0.1686 | 170532960.0 |
| 2003-05-14 10:00:00 | NVDA | Stock | 0.1685 | 0.1693 | 0.1675 | 0.1682 | 176416920.0 |
| 2003-05-14 11:00:00 | NVDA | Stock | 0.1682 | 0.1687 | 0.1679 | 0.1687 | 72589680.0 |
| 2003-05-14 12:00:00 | NVDA | Stock | 0.1687 | 0.1696 | 0.1682 | 0.1684 | 64955880.0 |
| 2003-05-14 13:00:00 | NVDA | Stock | 0.1684 | 0.1697 | 0.1678 | 0.1688 | 67183200.0 |
| 2003-05-14 14:00:00 | NVDA | Stock | 0.1688 | 0.1694 | 0.1682 | 0.1689 | 90829560.0 |
| 2003-05-14 15:00:00 | NVDA | Stock | 0.169 | 0.1697 | 0.1684 | 0.1697 | 143023560.0 |
| 2003-05-14 16:00:00 | NVDA | Stock | 0.1694 | 0.1707 | 0.1694 | 0.17 | 6348600.0 |
| 2003-05-14 17:00:00 | NVDA | Stock | 0.1704 | 0.1704 | 0.1697 | 0.1702 | 612000.0 |
| 2003-05-14 18:00:00 | NVDA | Stock | 0.1702 | 0.1702 | 0.1702 | 0.1702 | 90000.0 |
| 2003-05-14 08:00:00 | AMZN | Stock | 1.6485 | 1.693 | 1.648 | 1.652 | 270000.0 |
| 2003-05-14 09:00:00 | AMZN | Stock | 1.6516 | 1.66 | 1.6335 | 1.6415 | 35001920.0 |
| 2003-05-14 10:00:00 | AMZN | Stock | 1.642 | 1.642 | 1.627 | 1.631 | 30238560.0 |
| 2003-05-14 11:00:00 | AMZN | Stock | 1.6315 | 1.636 | 1.6235 | 1.636 | 15672720.0 |
| 2003-05-14 12:00:00 | AMZN | Stock | 1.6365 | 1.641 | 1.6275 | 1.6295 | 13514980.0 |
| 2003-05-14 13:00:00 | AMZN | Stock | 1.6296 | 1.635 | 1.625 | 1.628 | 9484900.0 |
| 2003-05-14 14:00:00 | AMZN | Stock | 1.6275 | 1.6295 | 1.622 | 1.6285 | 13039780.0 |
| 2003-05-14 15:00:00 | AMZN | Stock | 1.6285 | 1.632 | 1.624 | 1.63 | 15503280.0 |
| 2003-05-14 16:00:00 | AMZN | Stock | 1.63 | 1.635 | 1.6295 | 1.63 | 1157040.0 |
| 2003-05-14 17:00:00 | AMZN | Stock | 1.6335 | 1.6335 | 1.6326 | 1.6326 | 28000.0 |
| 2003-05-14 18:00:00 | AMZN | Stock | 1.6325 | 1.6325 | 1.6325 | 1.6325 | 22000.0 |
| 2003-05-14 09:00:00 | CL | Stock | 28.775 | 28.88 | 28.745 | 28.835 | 508400.0 |
| 2003-05-14 10:00:00 | CL | Stock | 28.835 | 28.885 | 28.76 | 28.84 | 607000.0 |
| 2003-05-14 11:00:00 | CL | Stock | 28.835 | 28.885 | 28.825 | 28.885 | 320200.0 |
| 2003-05-14 12:00:00 | CL | Stock | 28.885 | 28.95 | 28.84 | 28.925 | 235400.0 |
| 2003-05-14 13:00:00 | CL | Stock | 28.925 | 28.995 | 28.89 | 28.94 | 267600.0 |
| 2003-05-14 14:00:00 | CL | Stock | 28.945 | 28.975 | 28.83 | 28.885 | 284600.0 |
| 2003-05-14 15:00:00 | CL | Stock | 28.89 | 28.92 | 28.865 | 28.88 | 586600.0 |
> showing 50 of 20,581 rows — these rows as CSV