PREVIEW / stock_1hour / 2004-03-12
file: by_date/stock_1hour/2004/2004-03-12.parquet size: 505 KB rows: 23,484 symbols: 1,736
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-12 08:00:00 | AAPL | Stock | 0.4863 | 0.4911 | 0.4855 | 0.4902 | 554400.0 |
| 2004-03-12 09:00:00 | AAPL | Stock | 0.4896 | 0.4961 | 0.4852 | 0.493 | 61819184.0 |
| 2004-03-12 10:00:00 | AAPL | Stock | 0.493 | 0.4933 | 0.4866 | 0.4888 | 85432144.0 |
| 2004-03-12 11:00:00 | AAPL | Stock | 0.4888 | 0.4932 | 0.4875 | 0.4932 | 40940424.0 |
| 2004-03-12 12:00:00 | AAPL | Stock | 0.4932 | 0.4936 | 0.4898 | 0.4907 | 34509664.0 |
| 2004-03-12 13:00:00 | AAPL | Stock | 0.4907 | 0.4909 | 0.4875 | 0.4879 | 19881120.0 |
| 2004-03-12 14:00:00 | AAPL | Stock | 0.4879 | 0.4902 | 0.4875 | 0.4888 | 20611416.0 |
| 2004-03-12 15:00:00 | AAPL | Stock | 0.4888 | 0.4927 | 0.488 | 0.4923 | 49607656.0 |
| 2004-03-12 16:00:00 | AAPL | Stock | 0.4923 | 0.4938 | 0.4911 | 0.4921 | 2691304.0 |
| 2004-03-12 18:00:00 | AAPL | Stock | 0.4929 | 0.4929 | 0.4921 | 0.4921 | 28000.0 |
| 2004-03-12 08:00:00 | MSFT | Stock | 25.17 | 25.37 | 25.17 | 25.36 | 160245.0 |
| 2004-03-12 09:00:00 | MSFT | Stock | 25.37 | 25.43 | 25.29 | 25.37 | 10986243.0 |
| 2004-03-12 10:00:00 | MSFT | Stock | 25.37 | 25.48 | 25.24 | 25.3 | 9880612.0 |
| 2004-03-12 11:00:00 | MSFT | Stock | 25.29 | 25.42 | 25.259 | 25.39 | 7425590.0 |
| 2004-03-12 12:00:00 | MSFT | Stock | 25.39 | 25.4 | 25.24 | 25.27 | 4853791.0 |
| 2004-03-12 13:00:00 | MSFT | Stock | 25.2606 | 25.44 | 25.24 | 25.39 | 6016423.0 |
| 2004-03-12 14:00:00 | MSFT | Stock | 25.39 | 25.48 | 25.32 | 25.36 | 8163375.0 |
| 2004-03-12 15:00:00 | MSFT | Stock | 25.36 | 25.415 | 25.23 | 25.38 | 12245125.0 |
| 2004-03-12 16:00:00 | MSFT | Stock | 25.38 | 25.4 | 25.3216 | 25.4 | 572282.0 |
| 2004-03-12 17:00:00 | MSFT | Stock | 25.38 | 25.4 | 25.38 | 25.39 | 7759.0 |
| 2004-03-12 18:00:00 | MSFT | Stock | 25.39 | 25.39 | 25.33 | 25.38 | 4320.0 |
| 2004-03-12 08:00:00 | NVDA | Stock | 0.1737 | 0.1759 | 0.1737 | 0.1752 | 132000.0 |
| 2004-03-12 09:00:00 | NVDA | Stock | 0.1758 | 0.1762 | 0.1737 | 0.1748 | 47371680.0 |
| 2004-03-12 10:00:00 | NVDA | Stock | 0.1748 | 0.1772 | 0.1747 | 0.1757 | 71416200.0 |
| 2004-03-12 11:00:00 | NVDA | Stock | 0.1757 | 0.1792 | 0.1755 | 0.1791 | 39817320.0 |
| 2004-03-12 12:00:00 | NVDA | Stock | 0.179 | 0.1792 | 0.1762 | 0.1762 | 26583720.0 |
| 2004-03-12 13:00:00 | NVDA | Stock | 0.1764 | 0.1779 | 0.1757 | 0.1779 | 45720240.0 |
| 2004-03-12 14:00:00 | NVDA | Stock | 0.1779 | 0.1787 | 0.1769 | 0.1775 | 48992280.0 |
| 2004-03-12 15:00:00 | NVDA | Stock | 0.1775 | 0.1788 | 0.1767 | 0.1777 | 85506720.0 |
| 2004-03-12 16:00:00 | NVDA | Stock | 0.1773 | 0.1778 | 0.1728 | 0.1778 | 5134800.0 |
| 2004-03-12 18:00:00 | NVDA | Stock | 0.1778 | 0.1778 | 0.1778 | 0.1778 | 12000.0 |
| 2004-03-12 08:00:00 | AMZN | Stock | 2.0745 | 2.085 | 2.0725 | 2.076 | 114000.0 |
| 2004-03-12 09:00:00 | AMZN | Stock | 2.08 | 2.0915 | 2.065 | 2.0825 | 15608120.0 |
| 2004-03-12 10:00:00 | AMZN | Stock | 2.0825 | 2.1125 | 2.082 | 2.101 | 21934260.0 |
| 2004-03-12 11:00:00 | AMZN | Stock | 2.1015 | 2.1175 | 2.1 | 2.1135 | 13771760.0 |
| 2004-03-12 12:00:00 | AMZN | Stock | 2.1135 | 2.1185 | 2.1005 | 2.101 | 11632980.0 |
| 2004-03-12 13:00:00 | AMZN | Stock | 2.1005 | 2.1129 | 2.1 | 2.111 | 7946520.0 |
| 2004-03-12 14:00:00 | AMZN | Stock | 2.11 | 2.1225 | 2.1085 | 2.118 | 16031500.0 |
| 2004-03-12 15:00:00 | AMZN | Stock | 2.1185 | 2.13 | 2.1115 | 2.124 | 32316320.0 |
| 2004-03-12 16:00:00 | AMZN | Stock | 2.124 | 2.13 | 2.1205 | 2.1205 | 1097880.0 |
| 2004-03-12 17:00:00 | AMZN | Stock | 2.1275 | 2.128 | 2.1205 | 2.125 | 129960.0 |
| 2004-03-12 18:00:00 | AMZN | Stock | 2.125 | 2.1275 | 2.125 | 2.127 | 30000.0 |
| 2004-03-12 09:00:00 | CL | Stock | 27.41 | 27.57 | 27.375 | 27.5 | 806600.0 |
| 2004-03-12 10:00:00 | CL | Stock | 27.505 | 27.54 | 27.425 | 27.5 | 1036000.0 |
| 2004-03-12 11:00:00 | CL | Stock | 27.5 | 27.545 | 27.47 | 27.475 | 530000.0 |
| 2004-03-12 12:00:00 | CL | Stock | 27.48 | 27.49 | 27.44 | 27.475 | 259600.0 |
| 2004-03-12 13:00:00 | CL | Stock | 27.48 | 27.495 | 27.35 | 27.35 | 316600.0 |
| 2004-03-12 14:00:00 | CL | Stock | 27.345 | 27.4 | 27.33 | 27.4 | 326200.0 |
| 2004-03-12 15:00:00 | CL | Stock | 27.38 | 27.49 | 27.335 | 27.46 | 727400.0 |
| 2004-03-12 16:00:00 | CL | Stock | 27.45 | 27.46 | 27.45 | 27.46 | 59600.0 |
> showing 50 of 23,484 rows — these rows as CSV