PREVIEW / stock_1hour / 2000-12-19
file: by_date/stock_1hour/2000/2000-12-19.parquet size: 325 KB rows: 16,760 symbols: 1,270
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 |
|---|---|---|---|---|---|---|---|
| 2000-12-19 08:00:00 | AAPL | Stock | 0.255 | 0.2578 | 0.2545 | 0.2567 | 823200.0 |
| 2000-12-19 09:00:00 | AAPL | Stock | 0.2545 | 0.2578 | 0.2511 | 0.2567 | 29904000.0 |
| 2000-12-19 10:00:00 | AAPL | Stock | 0.2567 | 0.26 | 0.2556 | 0.2578 | 45813600.0 |
| 2000-12-19 11:00:00 | AAPL | Stock | 0.2578 | 0.26 | 0.2567 | 0.2589 | 27910400.0 |
| 2000-12-19 12:00:00 | AAPL | Stock | 0.2589 | 0.2634 | 0.2589 | 0.2623 | 33510400.0 |
| 2000-12-19 13:00:00 | AAPL | Stock | 0.2623 | 0.2723 | 0.2623 | 0.2679 | 66343200.0 |
| 2000-12-19 14:00:00 | AAPL | Stock | 0.2679 | 0.2701 | 0.2545 | 0.2545 | 69585600.0 |
| 2000-12-19 15:00:00 | AAPL | Stock | 0.2545 | 0.2567 | 0.25 | 0.25 | 70436800.0 |
| 2000-12-19 16:00:00 | AAPL | Stock | 0.25 | 0.2723 | 0.2444 | 0.2455 | 8864800.0 |
| 2000-12-19 17:00:00 | AAPL | Stock | 0.2478 | 0.25 | 0.2478 | 0.25 | 974400.0 |
| 2000-12-19 18:00:00 | AAPL | Stock | 0.2511 | 0.2511 | 0.25 | 0.25 | 123200.0 |
| 2000-12-19 08:00:00 | MSFT | Stock | 23.9219 | 24.1875 | 23.8438 | 24.0 | 273200.0 |
| 2000-12-19 09:00:00 | MSFT | Stock | 24.0 | 24.0625 | 23.0 | 23.8438 | 15326800.0 |
| 2000-12-19 10:00:00 | MSFT | Stock | 23.8594 | 23.9062 | 23.25 | 23.3438 | 13883200.0 |
| 2000-12-19 11:00:00 | MSFT | Stock | 23.3438 | 23.625 | 23.2188 | 23.5312 | 11790800.0 |
| 2000-12-19 12:00:00 | MSFT | Stock | 23.5312 | 23.5625 | 23.375 | 23.4688 | 7139000.0 |
| 2000-12-19 13:00:00 | MSFT | Stock | 23.4688 | 23.75 | 23.4062 | 23.625 | 8196400.0 |
| 2000-12-19 14:00:00 | MSFT | Stock | 23.6562 | 23.6562 | 22.8125 | 22.8438 | 21642600.0 |
| 2000-12-19 15:00:00 | MSFT | Stock | 22.8125 | 23.0312 | 22.25 | 22.4375 | 25772600.0 |
| 2000-12-19 16:00:00 | MSFT | Stock | 22.4375 | 23.4219 | 21.8125 | 22.0 | 4630600.0 |
| 2000-12-19 17:00:00 | MSFT | Stock | 22.0625 | 22.125 | 21.8594 | 22.0312 | 83800.0 |
| 2000-12-19 18:00:00 | MSFT | Stock | 22.1562 | 22.25 | 22.0312 | 22.125 | 49200.0 |
| 2000-12-19 09:00:00 | NVDA | Stock | 0.162 | 0.1635 | 0.1539 | 0.1609 | 45528000.0 |
| 2000-12-19 10:00:00 | NVDA | Stock | 0.1609 | 0.1635 | 0.1586 | 0.1617 | 73920000.0 |
| 2000-12-19 11:00:00 | NVDA | Stock | 0.1617 | 0.1625 | 0.1594 | 0.162 | 73440000.0 |
| 2000-12-19 12:00:00 | NVDA | Stock | 0.162 | 0.174 | 0.1615 | 0.1688 | 109008000.0 |
| 2000-12-19 13:00:00 | NVDA | Stock | 0.169 | 0.1781 | 0.163 | 0.1768 | 145920000.0 |
| 2000-12-19 14:00:00 | NVDA | Stock | 0.1768 | 0.1776 | 0.1695 | 0.1729 | 119256000.0 |
| 2000-12-19 15:00:00 | NVDA | Stock | 0.1729 | 0.1732 | 0.1458 | 0.1484 | 255912000.0 |
| 2000-12-19 16:00:00 | NVDA | Stock | 0.1487 | 0.149 | 0.1458 | 0.1464 | 16536000.0 |
| 2000-12-19 17:00:00 | NVDA | Stock | 0.1458 | 0.1458 | 0.1458 | 0.1458 | 24000.0 |
| 2000-12-19 08:00:00 | AMZN | Stock | 1.0156 | 1.1031 | 0.9938 | 1.0062 | 204000.0 |
| 2000-12-19 09:00:00 | AMZN | Stock | 1.0 | 1.0344 | 0.9938 | 1.0188 | 36484000.0 |
| 2000-12-19 10:00:00 | AMZN | Stock | 1.0156 | 1.0438 | 1.0031 | 1.0125 | 36466000.0 |
| 2000-12-19 11:00:00 | AMZN | Stock | 1.0094 | 1.0125 | 0.9875 | 0.9969 | 16624000.0 |
| 2000-12-19 12:00:00 | AMZN | Stock | 0.9969 | 1.0031 | 0.9906 | 0.9969 | 14934000.0 |
| 2000-12-19 13:00:00 | AMZN | Stock | 0.9969 | 1.0031 | 0.9938 | 1.0 | 12094000.0 |
| 2000-12-19 14:00:00 | AMZN | Stock | 1.0 | 1.0031 | 0.8938 | 0.8969 | 44092000.0 |
| 2000-12-19 15:00:00 | AMZN | Stock | 0.8969 | 0.9156 | 0.8688 | 0.9062 | 83598000.0 |
| 2000-12-19 16:00:00 | AMZN | Stock | 0.9 | 1.0125 | 0.875 | 0.875 | 5314000.0 |
| 2000-12-19 17:00:00 | AMZN | Stock | 0.9125 | 0.9125 | 0.8766 | 0.8844 | 92000.0 |
| 2000-12-19 18:00:00 | AMZN | Stock | 0.8812 | 0.8812 | 0.8812 | 0.8812 | 8000.0 |
| 2000-12-19 09:00:00 | CL | Stock | 29.625 | 30.0 | 29.625 | 29.99 | 284200.0 |
| 2000-12-19 10:00:00 | CL | Stock | 29.99 | 29.99 | 29.5 | 29.525 | 287400.0 |
| 2000-12-19 11:00:00 | CL | Stock | 29.505 | 29.55 | 29.25 | 29.275 | 261000.0 |
| 2000-12-19 12:00:00 | CL | Stock | 29.275 | 29.35 | 29.15 | 29.35 | 253600.0 |
| 2000-12-19 13:00:00 | CL | Stock | 29.37 | 30.075 | 29.31 | 29.995 | 377000.0 |
| 2000-12-19 14:00:00 | CL | Stock | 29.985 | 30.0 | 29.825 | 29.83 | 482800.0 |
| 2000-12-19 15:00:00 | CL | Stock | 29.83 | 29.83 | 29.55 | 29.55 | 507400.0 |
| 2000-12-19 16:00:00 | CL | Stock | 29.55 | 29.665 | 29.5 | 29.665 | 186000.0 |
> showing 50 of 16,760 rows — these rows as CSV