PREVIEW / stock_1hour / 2004-05-06
file: by_date/stock_1hour/2004/2004-05-06.parquet size: 500 KB rows: 23,738 symbols: 1,773
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-05-06 08:00:00 | AAPL | Stock | 0.4759 | 0.4759 | 0.4732 | 0.4732 | 16800.0 |
| 2004-05-06 09:00:00 | AAPL | Stock | 0.473 | 0.4736 | 0.4671 | 0.4713 | 24558632.0 |
| 2004-05-06 10:00:00 | AAPL | Stock | 0.4713 | 0.4764 | 0.4654 | 0.4686 | 48696480.0 |
| 2004-05-06 11:00:00 | AAPL | Stock | 0.4686 | 0.4691 | 0.4643 | 0.465 | 26915504.0 |
| 2004-05-06 12:00:00 | AAPL | Stock | 0.4652 | 0.4661 | 0.4625 | 0.4652 | 43210720.0 |
| 2004-05-06 13:00:00 | AAPL | Stock | 0.4654 | 0.4693 | 0.4648 | 0.4671 | 12812408.0 |
| 2004-05-06 14:00:00 | AAPL | Stock | 0.4671 | 0.4714 | 0.4661 | 0.4709 | 15608600.0 |
| 2004-05-06 15:00:00 | AAPL | Stock | 0.4707 | 0.4777 | 0.4704 | 0.4745 | 60388104.0 |
| 2004-05-06 16:00:00 | AAPL | Stock | 0.4745 | 0.4786 | 0.4745 | 0.4752 | 1852872.0 |
| 2004-05-06 17:00:00 | AAPL | Stock | 0.4752 | 0.4752 | 0.4746 | 0.4746 | 8978480.0 |
| 2004-05-06 08:00:00 | MSFT | Stock | 26.25 | 26.26 | 26.18 | 26.25 | 154532.0 |
| 2004-05-06 09:00:00 | MSFT | Stock | 26.22 | 26.29 | 26.13 | 26.26 | 6725553.0 |
| 2004-05-06 10:00:00 | MSFT | Stock | 26.26 | 26.34 | 26.0699 | 26.16 | 11011743.0 |
| 2004-05-06 11:00:00 | MSFT | Stock | 26.17 | 26.19 | 26.06 | 26.16 | 7703507.0 |
| 2004-05-06 12:00:00 | MSFT | Stock | 26.15 | 26.18 | 26.029 | 26.05 | 7469557.0 |
| 2004-05-06 13:00:00 | MSFT | Stock | 26.04 | 26.18 | 26.03 | 26.14 | 7406138.0 |
| 2004-05-06 14:00:00 | MSFT | Stock | 26.14 | 26.22 | 26.1 | 26.16 | 6523348.0 |
| 2004-05-06 15:00:00 | MSFT | Stock | 26.16 | 26.25 | 26.1 | 26.13 | 11962232.0 |
| 2004-05-06 16:00:00 | MSFT | Stock | 26.13 | 26.2 | 26.1 | 26.15 | 1359750.0 |
| 2004-05-06 17:00:00 | MSFT | Stock | 26.12 | 26.1762 | 26.12 | 26.16 | 190996.0 |
| 2004-05-06 18:00:00 | MSFT | Stock | 26.15 | 26.16 | 26.15 | 26.16 | 700.0 |
| 2004-05-06 08:00:00 | NVDA | Stock | 0.1792 | 0.18 | 0.1787 | 0.1798 | 336000.0 |
| 2004-05-06 09:00:00 | NVDA | Stock | 0.1792 | 0.1819 | 0.1754 | 0.1812 | 64710360.0 |
| 2004-05-06 10:00:00 | NVDA | Stock | 0.1812 | 0.1817 | 0.1789 | 0.1795 | 56369160.0 |
| 2004-05-06 11:00:00 | NVDA | Stock | 0.1796 | 0.1799 | 0.1779 | 0.1787 | 36791760.0 |
| 2004-05-06 12:00:00 | NVDA | Stock | 0.1786 | 0.1787 | 0.1764 | 0.1769 | 56924160.0 |
| 2004-05-06 13:00:00 | NVDA | Stock | 0.1768 | 0.1784 | 0.1767 | 0.1783 | 86819160.0 |
| 2004-05-06 14:00:00 | NVDA | Stock | 0.1784 | 0.1818 | 0.178 | 0.1807 | 92468760.0 |
| 2004-05-06 15:00:00 | NVDA | Stock | 0.1808 | 0.184 | 0.1797 | 0.1825 | 136913760.0 |
| 2004-05-06 16:00:00 | NVDA | Stock | 0.1825 | 0.1962 | 0.1825 | 0.1889 | 112545720.0 |
| 2004-05-06 17:00:00 | NVDA | Stock | 0.1885 | 0.1935 | 0.1826 | 0.1886 | 72742680.0 |
| 2004-05-06 18:00:00 | NVDA | Stock | 0.1885 | 0.1885 | 0.187 | 0.1875 | 3163200.0 |
| 2004-05-06 08:00:00 | AMZN | Stock | 2.2128 | 2.2128 | 2.1925 | 2.1925 | 131100.0 |
| 2004-05-06 09:00:00 | AMZN | Stock | 2.1925 | 2.2125 | 2.1645 | 2.187 | 18079480.0 |
| 2004-05-06 10:00:00 | AMZN | Stock | 2.1865 | 2.2045 | 2.155 | 2.1635 | 24292160.0 |
| 2004-05-06 11:00:00 | AMZN | Stock | 2.164 | 2.165 | 2.15 | 2.161 | 19537300.0 |
| 2004-05-06 12:00:00 | AMZN | Stock | 2.16 | 2.1705 | 2.1545 | 2.161 | 12599640.0 |
| 2004-05-06 13:00:00 | AMZN | Stock | 2.161 | 2.165 | 2.1445 | 2.1545 | 9107560.0 |
| 2004-05-06 14:00:00 | AMZN | Stock | 2.1535 | 2.1615 | 2.1385 | 2.153 | 20120400.0 |
| 2004-05-06 15:00:00 | AMZN | Stock | 2.154 | 2.1645 | 2.141 | 2.157 | 45751960.0 |
| 2004-05-06 16:00:00 | AMZN | Stock | 2.157 | 2.1645 | 2.156 | 2.1625 | 2299920.0 |
| 2004-05-06 17:00:00 | AMZN | Stock | 2.1625 | 2.165 | 2.16 | 2.1649 | 311120.0 |
| 2004-05-06 18:00:00 | AMZN | Stock | 2.1735 | 2.1735 | 2.1735 | 2.1735 | 6000.0 |
| 2004-05-06 09:00:00 | CL | Stock | 29.15 | 29.17 | 28.955 | 29.01 | 446800.0 |
| 2004-05-06 10:00:00 | CL | Stock | 29.005 | 29.075 | 28.935 | 28.97 | 691000.0 |
| 2004-05-06 11:00:00 | CL | Stock | 28.965 | 28.995 | 28.89 | 28.97 | 387600.0 |
| 2004-05-06 12:00:00 | CL | Stock | 28.98 | 29.205 | 28.975 | 29.205 | 455800.0 |
| 2004-05-06 13:00:00 | CL | Stock | 29.205 | 29.225 | 29.13 | 29.165 | 227800.0 |
| 2004-05-06 14:00:00 | CL | Stock | 29.165 | 29.335 | 29.15 | 29.27 | 364600.0 |
| 2004-05-06 15:00:00 | CL | Stock | 29.265 | 29.3 | 29.185 | 29.26 | 773200.0 |
> showing 50 of 23,738 rows — these rows as CSV