PREVIEW / stock_1hour / 2001-03-05
file: by_date/stock_1hour/2001/2001-03-05.parquet size: 348 KB rows: 16,119 symbols: 1,259
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 |
|---|---|---|---|---|---|---|---|
| 2001-03-05 08:00:00 | AAPL | Stock | 0.3415 | 0.346 | 0.3415 | 0.346 | 1461600.0 |
| 2001-03-05 09:00:00 | AAPL | Stock | 0.3454 | 0.3516 | 0.3404 | 0.3493 | 54493600.0 |
| 2001-03-05 10:00:00 | AAPL | Stock | 0.3493 | 0.3605 | 0.3493 | 0.3594 | 58917600.0 |
| 2001-03-05 11:00:00 | AAPL | Stock | 0.3605 | 0.3616 | 0.3583 | 0.3605 | 58352000.0 |
| 2001-03-05 12:00:00 | AAPL | Stock | 0.3594 | 0.3616 | 0.3493 | 0.3583 | 29338400.0 |
| 2001-03-05 13:00:00 | AAPL | Stock | 0.3583 | 0.3661 | 0.3571 | 0.3594 | 27983200.0 |
| 2001-03-05 14:00:00 | AAPL | Stock | 0.3594 | 0.3655 | 0.3571 | 0.3616 | 25082400.0 |
| 2001-03-05 15:00:00 | AAPL | Stock | 0.3616 | 0.365 | 0.3571 | 0.3633 | 37542400.0 |
| 2001-03-05 16:00:00 | AAPL | Stock | 0.3638 | 0.3661 | 0.3516 | 0.3638 | 8523200.0 |
| 2001-03-05 17:00:00 | AAPL | Stock | 0.3616 | 0.3616 | 0.3616 | 0.3616 | 28000.0 |
| 2001-03-05 18:00:00 | AAPL | Stock | 0.3638 | 0.3638 | 0.3638 | 0.3638 | 11200.0 |
| 2001-03-05 08:00:00 | MSFT | Stock | 28.5 | 28.9375 | 28.25 | 28.5312 | 43600.0 |
| 2001-03-05 09:00:00 | MSFT | Stock | 28.5312 | 28.9688 | 28.4062 | 28.9062 | 7742400.0 |
| 2001-03-05 10:00:00 | MSFT | Stock | 28.875 | 29.3125 | 28.7188 | 28.875 | 11145800.0 |
| 2001-03-05 11:00:00 | MSFT | Stock | 28.9062 | 29.0312 | 28.6562 | 28.6562 | 5908200.0 |
| 2001-03-05 12:00:00 | MSFT | Stock | 28.6875 | 28.75 | 28.2812 | 28.5312 | 5968600.0 |
| 2001-03-05 13:00:00 | MSFT | Stock | 28.5625 | 28.9375 | 28.375 | 28.7812 | 3858200.0 |
| 2001-03-05 14:00:00 | MSFT | Stock | 28.75 | 28.8125 | 28.4062 | 28.4062 | 4450800.0 |
| 2001-03-05 15:00:00 | MSFT | Stock | 28.4062 | 28.7812 | 28.375 | 28.7188 | 6946600.0 |
| 2001-03-05 16:00:00 | MSFT | Stock | 28.6875 | 29.0625 | 28.4375 | 28.7188 | 1898200.0 |
| 2001-03-05 17:00:00 | MSFT | Stock | 28.625 | 28.7188 | 28.5625 | 28.7188 | 6200.0 |
| 2001-03-05 18:00:00 | MSFT | Stock | 28.7188 | 28.7188 | 28.7188 | 28.7188 | 3000.0 |
| 2001-03-05 08:00:00 | NVDA | Stock | 0.1813 | 0.1833 | 0.1755 | 0.1802 | 1848000.0 |
| 2001-03-05 09:00:00 | NVDA | Stock | 0.1802 | 0.1815 | 0.1734 | 0.176 | 150240000.0 |
| 2001-03-05 10:00:00 | NVDA | Stock | 0.1755 | 0.1786 | 0.1734 | 0.176 | 128256000.0 |
| 2001-03-05 11:00:00 | NVDA | Stock | 0.1766 | 0.1792 | 0.1755 | 0.1768 | 52080000.0 |
| 2001-03-05 12:00:00 | NVDA | Stock | 0.1768 | 0.1786 | 0.1755 | 0.1773 | 27096000.0 |
| 2001-03-05 13:00:00 | NVDA | Stock | 0.1773 | 0.1789 | 0.175 | 0.1763 | 71376000.0 |
| 2001-03-05 14:00:00 | NVDA | Stock | 0.1763 | 0.188 | 0.176 | 0.1828 | 139176000.0 |
| 2001-03-05 15:00:00 | NVDA | Stock | 0.1828 | 0.1836 | 0.1799 | 0.1828 | 134424000.0 |
| 2001-03-05 16:00:00 | NVDA | Stock | 0.1833 | 0.1833 | 0.1822 | 0.1833 | 3864000.0 |
| 2001-03-05 17:00:00 | NVDA | Stock | 0.1784 | 0.1784 | 0.1784 | 0.1784 | 24000.0 |
| 2001-03-05 08:00:00 | AMZN | Stock | 0.6125 | 0.625 | 0.525 | 0.5969 | 20282000.0 |
| 2001-03-05 09:00:00 | AMZN | Stock | 0.5969 | 0.6375 | 0.575 | 0.5812 | 100040000.0 |
| 2001-03-05 10:00:00 | AMZN | Stock | 0.5812 | 0.6094 | 0.5781 | 0.6094 | 63096000.0 |
| 2001-03-05 11:00:00 | AMZN | Stock | 0.6094 | 0.625 | 0.6031 | 0.6188 | 60962000.0 |
| 2001-03-05 12:00:00 | AMZN | Stock | 0.6188 | 0.6531 | 0.6156 | 0.6281 | 74906000.0 |
| 2001-03-05 13:00:00 | AMZN | Stock | 0.6281 | 0.6406 | 0.6281 | 0.6313 | 45446000.0 |
| 2001-03-05 14:00:00 | AMZN | Stock | 0.6313 | 0.6469 | 0.6188 | 0.6375 | 42860000.0 |
| 2001-03-05 15:00:00 | AMZN | Stock | 0.6344 | 0.6438 | 0.6188 | 0.6281 | 43730000.0 |
| 2001-03-05 16:00:00 | AMZN | Stock | 0.6281 | 0.6375 | 0.6031 | 0.6313 | 4546000.0 |
| 2001-03-05 17:00:00 | AMZN | Stock | 0.6281 | 0.6344 | 0.625 | 0.6344 | 242000.0 |
| 2001-03-05 18:00:00 | AMZN | Stock | 0.6375 | 0.6375 | 0.6313 | 0.6344 | 32000.0 |
| 2001-03-05 09:00:00 | CL | Stock | 29.1 | 29.15 | 28.8 | 28.8 | 297600.0 |
| 2001-03-05 10:00:00 | CL | Stock | 28.785 | 28.955 | 28.725 | 28.93 | 362600.0 |
| 2001-03-05 11:00:00 | CL | Stock | 28.945 | 29.125 | 28.945 | 28.98 | 248800.0 |
| 2001-03-05 12:00:00 | CL | Stock | 28.985 | 29.09 | 28.84 | 28.935 | 159000.0 |
| 2001-03-05 13:00:00 | CL | Stock | 28.925 | 29.1 | 28.9 | 28.965 | 221200.0 |
| 2001-03-05 14:00:00 | CL | Stock | 28.96 | 29.2 | 28.95 | 29.19 | 287200.0 |
| 2001-03-05 15:00:00 | CL | Stock | 29.19 | 29.3 | 29.18 | 29.225 | 324200.0 |
> showing 50 of 16,119 rows — these rows as CSV