PREVIEW / stock_1hour / 2003-05-28
file: by_date/stock_1hour/2003/2003-05-28.parquet size: 457 KB rows: 22,247 symbols: 1,582
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-28 08:00:00 | AAPL | Stock | 0.3371 | 0.3373 | 0.3357 | 0.3373 | 280000.0 |
| 2003-05-28 09:00:00 | AAPL | Stock | 0.3361 | 0.3368 | 0.3254 | 0.3293 | 58611280.0 |
| 2003-05-28 10:00:00 | AAPL | Stock | 0.3296 | 0.33 | 0.3259 | 0.3288 | 48973120.0 |
| 2003-05-28 11:00:00 | AAPL | Stock | 0.3288 | 0.3305 | 0.3288 | 0.3298 | 21958832.0 |
| 2003-05-28 12:00:00 | AAPL | Stock | 0.3297 | 0.3298 | 0.327 | 0.3272 | 19896632.0 |
| 2003-05-28 13:00:00 | AAPL | Stock | 0.3273 | 0.3273 | 0.3241 | 0.3255 | 66433136.0 |
| 2003-05-28 14:00:00 | AAPL | Stock | 0.3255 | 0.3277 | 0.3243 | 0.3268 | 24025680.0 |
| 2003-05-28 15:00:00 | AAPL | Stock | 0.3268 | 0.328 | 0.3259 | 0.3261 | 46245024.0 |
| 2003-05-28 16:00:00 | AAPL | Stock | 0.3259 | 0.3264 | 0.3259 | 0.3264 | 15691200.0 |
| 2003-05-28 17:00:00 | AAPL | Stock | 0.3264 | 0.3264 | 0.3264 | 0.3264 | 6311200.0 |
| 2003-05-28 18:00:00 | AAPL | Stock | 0.3266 | 0.3266 | 0.3266 | 0.3266 | 28000.0 |
| 2003-05-28 08:00:00 | MSFT | Stock | 24.83 | 24.99 | 24.71 | 24.92 | 293876.0 |
| 2003-05-28 09:00:00 | MSFT | Stock | 24.919 | 24.93 | 24.61 | 24.73 | 13947172.0 |
| 2003-05-28 10:00:00 | MSFT | Stock | 24.73 | 24.77 | 24.51 | 24.77 | 14872967.0 |
| 2003-05-28 11:00:00 | MSFT | Stock | 24.77 | 24.871 | 24.74 | 24.75 | 11496456.0 |
| 2003-05-28 12:00:00 | MSFT | Stock | 24.75 | 24.76 | 24.63 | 24.64 | 7065194.0 |
| 2003-05-28 13:00:00 | MSFT | Stock | 24.64 | 24.665 | 24.4111 | 24.46 | 10959436.0 |
| 2003-05-28 14:00:00 | MSFT | Stock | 24.46 | 24.514 | 24.3 | 24.4 | 9862843.0 |
| 2003-05-28 15:00:00 | MSFT | Stock | 24.4 | 24.5 | 24.373 | 24.41 | 10920770.0 |
| 2003-05-28 16:00:00 | MSFT | Stock | 24.41 | 24.45 | 24.362 | 24.37 | 400650.0 |
| 2003-05-28 17:00:00 | MSFT | Stock | 24.36 | 24.41 | 24.27 | 24.3 | 2757865.0 |
| 2003-05-28 18:00:00 | MSFT | Stock | 24.31 | 24.34 | 24.3 | 24.34 | 38385.0 |
| 2003-05-28 08:00:00 | NVDA | Stock | 0.1894 | 0.1904 | 0.1867 | 0.1873 | 6612120.0 |
| 2003-05-28 09:00:00 | NVDA | Stock | 0.1868 | 0.1896 | 0.1854 | 0.1878 | 235135200.0 |
| 2003-05-28 10:00:00 | NVDA | Stock | 0.1877 | 0.1883 | 0.1842 | 0.1878 | 248593440.0 |
| 2003-05-28 11:00:00 | NVDA | Stock | 0.1878 | 0.1893 | 0.1869 | 0.188 | 130392480.0 |
| 2003-05-28 12:00:00 | NVDA | Stock | 0.1879 | 0.1885 | 0.1872 | 0.1878 | 114680760.0 |
| 2003-05-28 13:00:00 | NVDA | Stock | 0.1878 | 0.1882 | 0.1872 | 0.1874 | 75710640.0 |
| 2003-05-28 14:00:00 | NVDA | Stock | 0.1873 | 0.1885 | 0.1868 | 0.1881 | 99891000.0 |
| 2003-05-28 15:00:00 | NVDA | Stock | 0.1881 | 0.1908 | 0.1879 | 0.1887 | 193192920.0 |
| 2003-05-28 16:00:00 | NVDA | Stock | 0.1888 | 0.1896 | 0.1875 | 0.1888 | 7300680.0 |
| 2003-05-28 17:00:00 | NVDA | Stock | 0.1884 | 0.1887 | 0.1884 | 0.1886 | 7340040.0 |
| 2003-05-28 18:00:00 | NVDA | Stock | 0.1889 | 0.1889 | 0.1884 | 0.1884 | 1144800.0 |
| 2003-05-28 08:00:00 | AMZN | Stock | 1.74 | 1.7725 | 1.7265 | 1.753 | 500640.0 |
| 2003-05-28 09:00:00 | AMZN | Stock | 1.753 | 1.767 | 1.7425 | 1.7613 | 29487120.0 |
| 2003-05-28 10:00:00 | AMZN | Stock | 1.762 | 1.764 | 1.743 | 1.758 | 31209320.0 |
| 2003-05-28 11:00:00 | AMZN | Stock | 1.758 | 1.7865 | 1.7565 | 1.776 | 26237460.0 |
| 2003-05-28 12:00:00 | AMZN | Stock | 1.7765 | 1.777 | 1.75 | 1.753 | 21428860.0 |
| 2003-05-28 13:00:00 | AMZN | Stock | 1.753 | 1.7545 | 1.7425 | 1.7465 | 16515260.0 |
| 2003-05-28 14:00:00 | AMZN | Stock | 1.7465 | 1.751 | 1.7325 | 1.7455 | 17448320.0 |
| 2003-05-28 15:00:00 | AMZN | Stock | 1.7445 | 1.756 | 1.7325 | 1.742 | 19420920.0 |
| 2003-05-28 16:00:00 | AMZN | Stock | 1.7425 | 1.7535 | 1.7415 | 1.743 | 561000.0 |
| 2003-05-28 17:00:00 | AMZN | Stock | 1.742 | 1.7495 | 1.742 | 1.745 | 242200.0 |
| 2003-05-28 18:00:00 | AMZN | Stock | 1.745 | 1.745 | 1.743 | 1.743 | 4000.0 |
| 2003-05-28 09:00:00 | CL | Stock | 29.485 | 29.49 | 29.365 | 29.45 | 253000.0 |
| 2003-05-28 10:00:00 | CL | Stock | 29.45 | 29.485 | 29.355 | 29.385 | 444600.0 |
| 2003-05-28 11:00:00 | CL | Stock | 29.385 | 29.48 | 29.375 | 29.46 | 310600.0 |
| 2003-05-28 12:00:00 | CL | Stock | 29.46 | 29.51 | 29.375 | 29.49 | 453800.0 |
| 2003-05-28 13:00:00 | CL | Stock | 29.49 | 29.5 | 29.375 | 29.385 | 272400.0 |
| 2003-05-28 14:00:00 | CL | Stock | 29.385 | 29.495 | 29.365 | 29.485 | 404200.0 |
> showing 50 of 22,247 rows — these rows as CSV