PREVIEW / stock_1hour / 2004-03-04
file: by_date/stock_1hour/2004/2004-03-04.parquet size: 500 KB rows: 23,135 symbols: 1,728
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-04 08:00:00 | AAPL | Stock | 0.4298 | 0.4304 | 0.4277 | 0.4277 | 140000.0 |
| 2004-03-04 09:00:00 | AAPL | Stock | 0.4271 | 0.433 | 0.4266 | 0.4318 | 26150936.0 |
| 2004-03-04 10:00:00 | AAPL | Stock | 0.4317 | 0.4371 | 0.4317 | 0.437 | 45835496.0 |
| 2004-03-04 11:00:00 | AAPL | Stock | 0.4368 | 0.4375 | 0.4345 | 0.4354 | 35889112.0 |
| 2004-03-04 12:00:00 | AAPL | Stock | 0.4354 | 0.4382 | 0.4354 | 0.4375 | 32899888.0 |
| 2004-03-04 13:00:00 | AAPL | Stock | 0.4384 | 0.4402 | 0.4375 | 0.4384 | 74692352.0 |
| 2004-03-04 14:00:00 | AAPL | Stock | 0.4383 | 0.4408 | 0.4368 | 0.4407 | 46886728.0 |
| 2004-03-04 15:00:00 | AAPL | Stock | 0.4407 | 0.4504 | 0.4396 | 0.4495 | 269474520.0 |
| 2004-03-04 16:00:00 | AAPL | Stock | 0.4495 | 0.4505 | 0.4323 | 0.45 | 51162496.0 |
| 2004-03-04 17:00:00 | AAPL | Stock | 0.45 | 0.4509 | 0.4484 | 0.4509 | 604800.0 |
| 2004-03-04 18:00:00 | AAPL | Stock | 0.4484 | 0.4484 | 0.4484 | 0.4484 | 11200.0 |
| 2004-03-04 08:00:00 | MSFT | Stock | 26.37 | 26.42 | 26.37 | 26.37 | 118900.0 |
| 2004-03-04 09:00:00 | MSFT | Stock | 26.43 | 26.45 | 26.33 | 26.35 | 3159713.0 |
| 2004-03-04 10:00:00 | MSFT | Stock | 26.35 | 26.37 | 26.21 | 26.24 | 5925608.0 |
| 2004-03-04 11:00:00 | MSFT | Stock | 26.239 | 26.33 | 26.23 | 26.28 | 4531458.0 |
| 2004-03-04 12:00:00 | MSFT | Stock | 26.27 | 26.33 | 26.24 | 26.32 | 4232456.0 |
| 2004-03-04 13:00:00 | MSFT | Stock | 26.32 | 26.36 | 26.26 | 26.28 | 5084967.0 |
| 2004-03-04 14:00:00 | MSFT | Stock | 26.27 | 26.36 | 26.27 | 26.29 | 4952439.0 |
| 2004-03-04 15:00:00 | MSFT | Stock | 26.29 | 26.4 | 26.249 | 26.37 | 8849429.0 |
| 2004-03-04 16:00:00 | MSFT | Stock | 26.37 | 26.42 | 26.27 | 26.36 | 962120.0 |
| 2004-03-04 17:00:00 | MSFT | Stock | 26.35 | 26.39 | 26.31 | 26.33 | 61260.0 |
| 2004-03-04 18:00:00 | MSFT | Stock | 26.35 | 26.35 | 26.35 | 26.35 | 2150.0 |
| 2004-03-04 08:00:00 | NVDA | Stock | 0.1833 | 0.1833 | 0.1792 | 0.1792 | 235200.0 |
| 2004-03-04 09:00:00 | NVDA | Stock | 0.1833 | 0.185 | 0.1825 | 0.1843 | 57566040.0 |
| 2004-03-04 10:00:00 | NVDA | Stock | 0.1843 | 0.1844 | 0.1826 | 0.1835 | 46765320.0 |
| 2004-03-04 11:00:00 | NVDA | Stock | 0.1833 | 0.1848 | 0.1832 | 0.1846 | 52734600.0 |
| 2004-03-04 12:00:00 | NVDA | Stock | 0.1847 | 0.1856 | 0.1846 | 0.1851 | 41593560.0 |
| 2004-03-04 13:00:00 | NVDA | Stock | 0.1851 | 0.1866 | 0.185 | 0.1853 | 59774760.0 |
| 2004-03-04 14:00:00 | NVDA | Stock | 0.1853 | 0.1862 | 0.1852 | 0.1858 | 52065960.0 |
| 2004-03-04 15:00:00 | NVDA | Stock | 0.1858 | 0.1864 | 0.185 | 0.1863 | 41153280.0 |
| 2004-03-04 16:00:00 | NVDA | Stock | 0.1863 | 0.1863 | 0.185 | 0.185 | 1090920.0 |
| 2004-03-04 17:00:00 | NVDA | Stock | 0.1862 | 0.1862 | 0.1846 | 0.1846 | 580800.0 |
| 2004-03-04 08:00:00 | AMZN | Stock | 2.1565 | 2.161 | 2.1565 | 2.1575 | 20000.0 |
| 2004-03-04 09:00:00 | AMZN | Stock | 2.16 | 2.1975 | 2.1555 | 2.195 | 25770380.0 |
| 2004-03-04 10:00:00 | AMZN | Stock | 2.195 | 2.198 | 2.173 | 2.191 | 25338620.0 |
| 2004-03-04 11:00:00 | AMZN | Stock | 2.192 | 2.1988 | 2.183 | 2.1945 | 12471940.0 |
| 2004-03-04 12:00:00 | AMZN | Stock | 2.1945 | 2.207 | 2.1935 | 2.2 | 11521600.0 |
| 2004-03-04 13:00:00 | AMZN | Stock | 2.2 | 2.208 | 2.1995 | 2.2005 | 9650340.0 |
| 2004-03-04 14:00:00 | AMZN | Stock | 2.2 | 2.2135 | 2.2 | 2.2085 | 12478900.0 |
| 2004-03-04 15:00:00 | AMZN | Stock | 2.2085 | 2.22 | 2.203 | 2.219 | 21485360.0 |
| 2004-03-04 16:00:00 | AMZN | Stock | 2.2195 | 2.2195 | 2.215 | 2.219 | 3436420.0 |
| 2004-03-04 17:00:00 | AMZN | Stock | 2.219 | 2.219 | 2.2156 | 2.217 | 155140.0 |
| 2004-03-04 09:00:00 | CL | Stock | 28.175 | 28.195 | 28.055 | 28.055 | 154800.0 |
| 2004-03-04 10:00:00 | CL | Stock | 28.05 | 28.095 | 28.035 | 28.065 | 190600.0 |
| 2004-03-04 11:00:00 | CL | Stock | 28.065 | 28.115 | 28.045 | 28.055 | 233600.0 |
| 2004-03-04 12:00:00 | CL | Stock | 28.055 | 28.1 | 28.04 | 28.075 | 366000.0 |
| 2004-03-04 13:00:00 | CL | Stock | 28.075 | 28.075 | 28.03 | 28.035 | 171400.0 |
| 2004-03-04 14:00:00 | CL | Stock | 28.03 | 28.04 | 28.01 | 28.02 | 221400.0 |
| 2004-03-04 15:00:00 | CL | Stock | 28.02 | 28.055 | 27.98 | 28.025 | 801400.0 |
| 2004-03-04 16:00:00 | CL | Stock | 28.02 | 28.02 | 28.02 | 28.02 | 3200.0 |
> showing 50 of 23,135 rows — these rows as CSV