PREVIEW / stock_1hour / 2001-05-22
file: by_date/stock_1hour/2001/2001-05-22.parquet size: 370 KB rows: 17,471 symbols: 1,303
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 |
|---|---|---|---|---|---|---|---|
| 2001-05-22 08:00:00 | AAPL | Stock | 0.4193 | 0.4302 | 0.4188 | 0.4275 | 974400.0 |
| 2001-05-22 09:00:00 | AAPL | Stock | 0.4268 | 0.4309 | 0.4236 | 0.427 | 84257600.0 |
| 2001-05-22 10:00:00 | AAPL | Stock | 0.427 | 0.4304 | 0.4223 | 0.4239 | 63420000.0 |
| 2001-05-22 11:00:00 | AAPL | Stock | 0.4239 | 0.4263 | 0.4179 | 0.4196 | 45701600.0 |
| 2001-05-22 12:00:00 | AAPL | Stock | 0.4196 | 0.4246 | 0.4196 | 0.423 | 21145600.0 |
| 2001-05-22 13:00:00 | AAPL | Stock | 0.4223 | 0.4259 | 0.4193 | 0.4196 | 31992800.0 |
| 2001-05-22 14:00:00 | AAPL | Stock | 0.4196 | 0.4264 | 0.4196 | 0.4248 | 32166400.0 |
| 2001-05-22 15:00:00 | AAPL | Stock | 0.4248 | 0.4254 | 0.4186 | 0.4196 | 84207200.0 |
| 2001-05-22 16:00:00 | AAPL | Stock | 0.4196 | 0.4284 | 0.4179 | 0.4196 | 15316000.0 |
| 2001-05-22 17:00:00 | AAPL | Stock | 0.4205 | 0.4205 | 0.4186 | 0.4196 | 168000.0 |
| 2001-05-22 18:00:00 | AAPL | Stock | 0.4196 | 0.4196 | 0.4196 | 0.4196 | 22400.0 |
| 2001-05-22 08:00:00 | MSFT | Stock | 34.45 | 34.87 | 34.35 | 34.675 | 152600.0 |
| 2001-05-22 09:00:00 | MSFT | Stock | 34.675 | 34.925 | 34.625 | 34.76 | 14982600.0 |
| 2001-05-22 10:00:00 | MSFT | Stock | 34.775 | 34.92 | 34.625 | 34.795 | 13449800.0 |
| 2001-05-22 11:00:00 | MSFT | Stock | 34.66 | 34.825 | 34.57 | 34.735 | 8039400.0 |
| 2001-05-22 12:00:00 | MSFT | Stock | 34.735 | 34.875 | 34.67 | 34.77 | 4578400.0 |
| 2001-05-22 13:00:00 | MSFT | Stock | 34.78 | 35.125 | 34.77 | 34.84 | 8831800.0 |
| 2001-05-22 14:00:00 | MSFT | Stock | 34.835 | 34.87 | 34.59 | 34.77 | 8067800.0 |
| 2001-05-22 15:00:00 | MSFT | Stock | 34.77 | 35.175 | 34.67 | 35.16 | 18559000.0 |
| 2001-05-22 16:00:00 | MSFT | Stock | 35.16 | 35.525 | 34.725 | 35.155 | 3481400.0 |
| 2001-05-22 17:00:00 | MSFT | Stock | 35.155 | 35.5 | 35.155 | 35.375 | 114400.0 |
| 2001-05-22 18:00:00 | MSFT | Stock | 35.395 | 35.395 | 35.35 | 35.35 | 2200.0 |
| 2001-05-22 08:00:00 | NVDA | Stock | 0.3792 | 0.3792 | 0.3792 | 0.3792 | 120000.0 |
| 2001-05-22 09:00:00 | NVDA | Stock | 0.3764 | 0.3827 | 0.3667 | 0.3713 | 149448000.0 |
| 2001-05-22 10:00:00 | NVDA | Stock | 0.3715 | 0.3806 | 0.3713 | 0.3788 | 191376000.0 |
| 2001-05-22 11:00:00 | NVDA | Stock | 0.3788 | 0.38 | 0.375 | 0.3789 | 60528000.0 |
| 2001-05-22 12:00:00 | NVDA | Stock | 0.3788 | 0.3844 | 0.3788 | 0.3833 | 83256000.0 |
| 2001-05-22 13:00:00 | NVDA | Stock | 0.3828 | 0.3908 | 0.3813 | 0.3814 | 157344000.0 |
| 2001-05-22 14:00:00 | NVDA | Stock | 0.3813 | 0.3883 | 0.3806 | 0.3858 | 143328000.0 |
| 2001-05-22 15:00:00 | NVDA | Stock | 0.3858 | 0.3889 | 0.3823 | 0.3862 | 172728000.0 |
| 2001-05-22 16:00:00 | NVDA | Stock | 0.3861 | 0.3887 | 0.3753 | 0.3823 | 40800000.0 |
| 2001-05-22 17:00:00 | NVDA | Stock | 0.3829 | 0.3879 | 0.3795 | 0.3855 | 7248000.0 |
| 2001-05-22 18:00:00 | NVDA | Stock | 0.3855 | 0.3863 | 0.3853 | 0.3855 | 1512000.0 |
| 2001-05-22 08:00:00 | AMZN | Stock | 0.817 | 0.8265 | 0.815 | 0.826 | 292000.0 |
| 2001-05-22 09:00:00 | AMZN | Stock | 0.825 | 0.8495 | 0.821 | 0.8275 | 27962000.0 |
| 2001-05-22 10:00:00 | AMZN | Stock | 0.8275 | 0.848 | 0.825 | 0.832 | 20738000.0 |
| 2001-05-22 11:00:00 | AMZN | Stock | 0.832 | 0.833 | 0.7975 | 0.7975 | 16434000.0 |
| 2001-05-22 12:00:00 | AMZN | Stock | 0.7975 | 0.8395 | 0.795 | 0.835 | 15892000.0 |
| 2001-05-22 13:00:00 | AMZN | Stock | 0.835 | 0.8375 | 0.817 | 0.82 | 9970000.0 |
| 2001-05-22 14:00:00 | AMZN | Stock | 0.8195 | 0.835 | 0.817 | 0.829 | 31232000.0 |
| 2001-05-22 15:00:00 | AMZN | Stock | 0.8285 | 0.83 | 0.8125 | 0.8135 | 11856000.0 |
| 2001-05-22 16:00:00 | AMZN | Stock | 0.8135 | 0.824 | 0.8105 | 0.8125 | 1748000.0 |
| 2001-05-22 17:00:00 | AMZN | Stock | 0.8125 | 0.8125 | 0.8125 | 0.8125 | 62000.0 |
| 2001-05-22 09:00:00 | CL | Stock | 28.475 | 28.55 | 28.325 | 28.55 | 303600.0 |
| 2001-05-22 10:00:00 | CL | Stock | 28.58 | 28.6 | 28.4 | 28.54 | 419200.0 |
| 2001-05-22 11:00:00 | CL | Stock | 28.575 | 28.61 | 28.5 | 28.59 | 195600.0 |
| 2001-05-22 12:00:00 | CL | Stock | 28.61 | 28.63 | 28.5 | 28.5 | 149400.0 |
| 2001-05-22 13:00:00 | CL | Stock | 28.505 | 28.61 | 28.275 | 28.325 | 287200.0 |
| 2001-05-22 14:00:00 | CL | Stock | 28.3 | 28.5 | 28.3 | 28.45 | 314400.0 |
| 2001-05-22 15:00:00 | CL | Stock | 28.46 | 28.475 | 28.085 | 28.145 | 890200.0 |
> showing 50 of 17,471 rows — these rows as CSV