PREVIEW / stock_1hour / 2004-03-16
file: by_date/stock_1hour/2004/2004-03-16.parquet size: 539 KB rows: 25,006 symbols: 1,739
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-16 08:00:00 | AAPL | Stock | 0.4724 | 0.4748 | 0.4679 | 0.4732 | 1400000.0 |
| 2004-03-16 09:00:00 | AAPL | Stock | 0.4732 | 0.4752 | 0.4571 | 0.4586 | 137039616.0 |
| 2004-03-16 10:00:00 | AAPL | Stock | 0.4586 | 0.4605 | 0.4534 | 0.4584 | 174852160.0 |
| 2004-03-16 11:00:00 | AAPL | Stock | 0.4586 | 0.4634 | 0.4582 | 0.4613 | 72879072.0 |
| 2004-03-16 12:00:00 | AAPL | Stock | 0.4613 | 0.4614 | 0.4554 | 0.4598 | 37732856.0 |
| 2004-03-16 13:00:00 | AAPL | Stock | 0.4598 | 0.4614 | 0.4577 | 0.458 | 40338872.0 |
| 2004-03-16 14:00:00 | AAPL | Stock | 0.458 | 0.4602 | 0.4541 | 0.4557 | 59932432.0 |
| 2004-03-16 15:00:00 | AAPL | Stock | 0.4557 | 0.4618 | 0.455 | 0.4614 | 59785544.0 |
| 2004-03-16 16:00:00 | AAPL | Stock | 0.4614 | 0.462 | 0.4595 | 0.4602 | 1220408.0 |
| 2004-03-16 17:00:00 | AAPL | Stock | 0.4595 | 0.4607 | 0.4595 | 0.4607 | 3204376.0 |
| 2004-03-16 08:00:00 | MSFT | Stock | 25.26 | 25.31 | 25.2 | 25.27 | 214930.0 |
| 2004-03-16 09:00:00 | MSFT | Stock | 25.27 | 25.35 | 25.17 | 25.34 | 7295134.0 |
| 2004-03-16 10:00:00 | MSFT | Stock | 25.33 | 25.37 | 25.21 | 25.24 | 8200462.0 |
| 2004-03-16 11:00:00 | MSFT | Stock | 25.23 | 25.25 | 25.12 | 25.14 | 7301477.0 |
| 2004-03-16 12:00:00 | MSFT | Stock | 25.14 | 25.21 | 25.0999 | 25.14 | 7594791.0 |
| 2004-03-16 13:00:00 | MSFT | Stock | 25.14 | 25.24 | 25.11 | 25.19 | 6209740.0 |
| 2004-03-16 14:00:00 | MSFT | Stock | 25.2 | 25.33 | 25.12 | 25.12 | 11137578.0 |
| 2004-03-16 15:00:00 | MSFT | Stock | 25.12 | 25.37 | 25.1 | 25.18 | 14159849.0 |
| 2004-03-16 16:00:00 | MSFT | Stock | 25.18 | 25.2834 | 25.15 | 25.27 | 797611.0 |
| 2004-03-16 17:00:00 | MSFT | Stock | 25.27 | 25.35 | 25.17 | 25.25 | 514932.0 |
| 2004-03-16 18:00:00 | MSFT | Stock | 25.29 | 25.29 | 25.29 | 25.29 | 100.0 |
| 2004-03-16 09:00:00 | NVDA | Stock | 0.1727 | 0.1776 | 0.1727 | 0.1758 | 45230640.0 |
| 2004-03-16 10:00:00 | NVDA | Stock | 0.1759 | 0.1802 | 0.1758 | 0.1794 | 114168600.0 |
| 2004-03-16 11:00:00 | NVDA | Stock | 0.1793 | 0.1801 | 0.1772 | 0.1781 | 63025440.0 |
| 2004-03-16 12:00:00 | NVDA | Stock | 0.1782 | 0.1782 | 0.1755 | 0.1762 | 56283840.0 |
| 2004-03-16 13:00:00 | NVDA | Stock | 0.1762 | 0.1792 | 0.1761 | 0.1789 | 60213000.0 |
| 2004-03-16 14:00:00 | NVDA | Stock | 0.1789 | 0.1807 | 0.1772 | 0.1773 | 121816680.0 |
| 2004-03-16 15:00:00 | NVDA | Stock | 0.1773 | 0.1812 | 0.1768 | 0.1797 | 124076160.0 |
| 2004-03-16 16:00:00 | NVDA | Stock | 0.1795 | 0.1814 | 0.1792 | 0.1814 | 1584960.0 |
| 2004-03-16 17:00:00 | NVDA | Stock | 0.1807 | 0.1813 | 0.1795 | 0.1804 | 2508120.0 |
| 2004-03-16 18:00:00 | NVDA | Stock | 0.1801 | 0.1801 | 0.1799 | 0.1799 | 48000.0 |
| 2004-03-16 08:00:00 | AMZN | Stock | 2.0635 | 2.0635 | 2.05 | 2.0605 | 16000.0 |
| 2004-03-16 09:00:00 | AMZN | Stock | 2.07 | 2.102 | 2.054 | 2.083 | 18766040.0 |
| 2004-03-16 10:00:00 | AMZN | Stock | 2.084 | 2.0935 | 2.077 | 2.0795 | 15889800.0 |
| 2004-03-16 11:00:00 | AMZN | Stock | 2.0785 | 2.084 | 2.066 | 2.071 | 9081840.0 |
| 2004-03-16 12:00:00 | AMZN | Stock | 2.071 | 2.085 | 2.063 | 2.0805 | 11894940.0 |
| 2004-03-16 13:00:00 | AMZN | Stock | 2.081 | 2.0995 | 2.076 | 2.0945 | 11586440.0 |
| 2004-03-16 14:00:00 | AMZN | Stock | 2.094 | 2.112 | 2.0825 | 2.0905 | 27840360.0 |
| 2004-03-16 15:00:00 | AMZN | Stock | 2.091 | 2.118 | 2.082 | 2.1045 | 26051980.0 |
| 2004-03-16 16:00:00 | AMZN | Stock | 2.104 | 2.1085 | 2.1035 | 2.1075 | 700160.0 |
| 2004-03-16 17:00:00 | AMZN | Stock | 2.104 | 2.108 | 2.104 | 2.108 | 647900.0 |
| 2004-03-16 09:00:00 | CL | Stock | 27.275 | 27.325 | 27.23 | 27.275 | 336200.0 |
| 2004-03-16 10:00:00 | CL | Stock | 27.27 | 27.45 | 27.24 | 27.435 | 437000.0 |
| 2004-03-16 11:00:00 | CL | Stock | 27.435 | 27.505 | 27.375 | 27.38 | 761400.0 |
| 2004-03-16 12:00:00 | CL | Stock | 27.375 | 27.38 | 27.235 | 27.35 | 353800.0 |
| 2004-03-16 13:00:00 | CL | Stock | 27.355 | 27.415 | 27.29 | 27.32 | 245000.0 |
| 2004-03-16 14:00:00 | CL | Stock | 27.32 | 27.425 | 27.22 | 27.22 | 608000.0 |
| 2004-03-16 15:00:00 | CL | Stock | 27.22 | 27.395 | 27.22 | 27.335 | 1266000.0 |
| 2004-03-16 16:00:00 | CL | Stock | 27.37 | 27.37 | 27.33 | 27.33 | 64200.0 |
| 2004-03-16 17:00:00 | CL | Stock | 27.33 | 27.33 | 27.33 | 27.33 | 11400.0 |
> showing 50 of 25,006 rows — these rows as CSV