PREVIEW / stock_1hour / 2004-02-26
file: by_date/stock_1hour/2004/2004-02-26.parquet size: 510 KB rows: 23,354 symbols: 1,727
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-02-26 08:00:00 | AAPL | Stock | 0.4089 | 0.4089 | 0.4089 | 0.4089 | 78400.0 |
| 2004-02-26 09:00:00 | AAPL | Stock | 0.4079 | 0.4111 | 0.4071 | 0.4098 | 30662688.0 |
| 2004-02-26 10:00:00 | AAPL | Stock | 0.4098 | 0.4127 | 0.4095 | 0.4113 | 33923400.0 |
| 2004-02-26 11:00:00 | AAPL | Stock | 0.4114 | 0.4134 | 0.4111 | 0.4125 | 23467976.0 |
| 2004-02-26 12:00:00 | AAPL | Stock | 0.4125 | 0.4139 | 0.4114 | 0.4123 | 20601952.0 |
| 2004-02-26 13:00:00 | AAPL | Stock | 0.4123 | 0.4134 | 0.4121 | 0.4132 | 16147376.0 |
| 2004-02-26 14:00:00 | AAPL | Stock | 0.4134 | 0.4134 | 0.4116 | 0.4127 | 21891464.0 |
| 2004-02-26 15:00:00 | AAPL | Stock | 0.4127 | 0.4136 | 0.4116 | 0.4127 | 31294088.0 |
| 2004-02-26 16:00:00 | AAPL | Stock | 0.4125 | 0.4127 | 0.41 | 0.4114 | 13167952.0 |
| 2004-02-26 17:00:00 | AAPL | Stock | 0.4114 | 0.4114 | 0.4114 | 0.4114 | 23520.0 |
| 2004-02-26 08:00:00 | MSFT | Stock | 26.62 | 26.71 | 26.5 | 26.58 | 89980.0 |
| 2004-02-26 09:00:00 | MSFT | Stock | 26.59 | 26.65 | 26.52 | 26.6 | 6963228.0 |
| 2004-02-26 10:00:00 | MSFT | Stock | 26.6 | 26.61 | 26.52 | 26.56 | 8038785.0 |
| 2004-02-26 11:00:00 | MSFT | Stock | 26.56 | 26.6 | 26.46 | 26.52 | 14510860.0 |
| 2004-02-26 12:00:00 | MSFT | Stock | 26.51 | 26.58 | 26.5 | 26.53 | 8120188.0 |
| 2004-02-26 13:00:00 | MSFT | Stock | 26.53 | 26.55 | 26.44 | 26.5 | 7652910.0 |
| 2004-02-26 14:00:00 | MSFT | Stock | 26.5 | 26.52 | 26.42 | 26.44 | 7515319.0 |
| 2004-02-26 15:00:00 | MSFT | Stock | 26.44 | 26.51 | 26.41 | 26.45 | 9896836.0 |
| 2004-02-26 16:00:00 | MSFT | Stock | 26.45 | 26.5028 | 26.41 | 26.45 | 1320070.0 |
| 2004-02-26 17:00:00 | MSFT | Stock | 26.43 | 26.48 | 26.43 | 26.48 | 10082.0 |
| 2004-02-26 18:00:00 | MSFT | Stock | 26.47 | 26.47 | 26.47 | 26.47 | 1502.0 |
| 2004-02-26 08:00:00 | NVDA | Stock | 0.1867 | 0.1876 | 0.1867 | 0.1876 | 132000.0 |
| 2004-02-26 09:00:00 | NVDA | Stock | 0.1871 | 0.1906 | 0.1871 | 0.1877 | 68463120.0 |
| 2004-02-26 10:00:00 | NVDA | Stock | 0.1877 | 0.1887 | 0.1864 | 0.1877 | 69680880.0 |
| 2004-02-26 11:00:00 | NVDA | Stock | 0.1877 | 0.1891 | 0.1877 | 0.1887 | 56088720.0 |
| 2004-02-26 12:00:00 | NVDA | Stock | 0.1888 | 0.1901 | 0.1887 | 0.19 | 45341520.0 |
| 2004-02-26 13:00:00 | NVDA | Stock | 0.19 | 0.19 | 0.1887 | 0.1893 | 30889680.0 |
| 2004-02-26 14:00:00 | NVDA | Stock | 0.1893 | 0.1897 | 0.1877 | 0.1892 | 28103160.0 |
| 2004-02-26 15:00:00 | NVDA | Stock | 0.1892 | 0.1895 | 0.1884 | 0.189 | 27638520.0 |
| 2004-02-26 16:00:00 | NVDA | Stock | 0.189 | 0.1892 | 0.1883 | 0.1887 | 2422560.0 |
| 2004-02-26 17:00:00 | NVDA | Stock | 0.1892 | 0.1892 | 0.1883 | 0.1883 | 221160.0 |
| 2004-02-26 08:00:00 | AMZN | Stock | 2.1575 | 2.167 | 2.151 | 2.1555 | 181400.0 |
| 2004-02-26 09:00:00 | AMZN | Stock | 2.1555 | 2.1875 | 2.149 | 2.183 | 29938080.0 |
| 2004-02-26 10:00:00 | AMZN | Stock | 2.183 | 2.1875 | 2.1715 | 2.1785 | 22420480.0 |
| 2004-02-26 11:00:00 | AMZN | Stock | 2.179 | 2.1875 | 2.1775 | 2.178 | 14254000.0 |
| 2004-02-26 12:00:00 | AMZN | Stock | 2.1785 | 2.1875 | 2.176 | 2.1836 | 10697780.0 |
| 2004-02-26 13:00:00 | AMZN | Stock | 2.1835 | 2.192 | 2.1805 | 2.1865 | 9809500.0 |
| 2004-02-26 14:00:00 | AMZN | Stock | 2.1869 | 2.1925 | 2.175 | 2.177 | 12475440.0 |
| 2004-02-26 15:00:00 | AMZN | Stock | 2.176 | 2.184 | 2.1675 | 2.181 | 14778020.0 |
| 2004-02-26 16:00:00 | AMZN | Stock | 2.1805 | 2.185 | 2.1715 | 2.183 | 1197140.0 |
| 2004-02-26 17:00:00 | AMZN | Stock | 2.1825 | 2.185 | 2.1825 | 2.1845 | 93360.0 |
| 2004-02-26 18:00:00 | AMZN | Stock | 2.185 | 2.185 | 2.185 | 2.185 | 20000.0 |
| 2004-02-26 09:00:00 | CL | Stock | 27.49 | 27.525 | 27.475 | 27.52 | 378400.0 |
| 2004-02-26 10:00:00 | CL | Stock | 27.52 | 27.55 | 27.48 | 27.55 | 499800.0 |
| 2004-02-26 11:00:00 | CL | Stock | 27.55 | 27.64 | 27.55 | 27.6 | 357600.0 |
| 2004-02-26 12:00:00 | CL | Stock | 27.6 | 27.72 | 27.565 | 27.715 | 181400.0 |
| 2004-02-26 13:00:00 | CL | Stock | 27.715 | 27.725 | 27.645 | 27.7 | 220800.0 |
| 2004-02-26 14:00:00 | CL | Stock | 27.7 | 27.765 | 27.69 | 27.76 | 273600.0 |
| 2004-02-26 15:00:00 | CL | Stock | 27.76 | 27.79 | 27.724 | 27.74 | 554000.0 |
| 2004-02-26 16:00:00 | CL | Stock | 27.7365 | 27.7365 | 27.735 | 27.735 | 101800.0 |
> showing 50 of 23,354 rows — these rows as CSV