PREVIEW / stock_1hour / 2009-12-14
file: by_date/stock_1hour/2009/2009-12-14.parquet size: 912 KB rows: 43,766 symbols: 3,446
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 |
|---|---|---|---|---|---|---|---|
| 2009-12-14 04:00:00 | AAPL | Stock | 6.9714 | 7.0171 | 6.9714 | 7.0171 | 5600.0 |
| 2009-12-14 05:00:00 | AAPL | Stock | 6.9975 | 6.9975 | 6.9925 | 6.9925 | 8400.0 |
| 2009-12-14 06:00:00 | AAPL | Stock | 6.9864 | 6.9864 | 6.9821 | 6.9821 | 11200.0 |
| 2009-12-14 07:00:00 | AAPL | Stock | 6.9936 | 7.0143 | 6.9932 | 6.9996 | 294224.0 |
| 2009-12-14 08:00:00 | AAPL | Stock | 6.9971 | 7.0164 | 6.9525 | 6.9764 | 3999072.0 |
| 2009-12-14 09:00:00 | AAPL | Stock | 6.9768 | 6.9911 | 6.9082 | 6.9189 | 66932208.0 |
| 2009-12-14 10:00:00 | AAPL | Stock | 6.9179 | 6.9518 | 6.8771 | 6.9505 | 84950992.0 |
| 2009-12-14 11:00:00 | AAPL | Stock | 6.9511 | 7.0086 | 6.9486 | 6.9784 | 68716060.0 |
| 2009-12-14 12:00:00 | AAPL | Stock | 6.9786 | 7.0446 | 6.9786 | 7.0275 | 50455104.0 |
| 2009-12-14 13:00:00 | AAPL | Stock | 7.0271 | 7.0393 | 7.0161 | 7.0311 | 38217844.0 |
| 2009-12-14 14:00:00 | AAPL | Stock | 7.0304 | 7.0489 | 7.0118 | 7.0329 | 52921960.0 |
| 2009-12-14 15:00:00 | AAPL | Stock | 7.0336 | 7.0511 | 7.0086 | 7.0364 | 90469960.0 |
| 2009-12-14 16:00:00 | AAPL | Stock | 7.0364 | 7.0364 | 6.9525 | 7.0336 | 17221596.0 |
| 2009-12-14 17:00:00 | AAPL | Stock | 7.0279 | 7.0354 | 7.0279 | 7.0311 | 690900.0 |
| 2009-12-14 18:00:00 | AAPL | Stock | 7.0321 | 7.035 | 7.0254 | 7.0254 | 296884.0 |
| 2009-12-14 19:00:00 | AAPL | Stock | 7.0254 | 7.0314 | 6.9836 | 7.0196 | 3332812.0 |
| 2009-12-14 06:00:00 | MSFT | Stock | 29.78 | 29.78 | 29.78 | 29.78 | 2000.0 |
| 2009-12-14 07:00:00 | MSFT | Stock | 29.85 | 29.85 | 29.85 | 29.85 | 600.0 |
| 2009-12-14 08:00:00 | MSFT | Stock | 29.88 | 29.98 | 29.85 | 29.96 | 25290.0 |
| 2009-12-14 09:00:00 | MSFT | Stock | 29.96 | 30.09 | 29.9 | 30.055 | 4964585.0 |
| 2009-12-14 10:00:00 | MSFT | Stock | 30.051 | 30.08 | 29.99 | 30.07 | 5607173.0 |
| 2009-12-14 11:00:00 | MSFT | Stock | 30.06 | 30.1 | 30.02 | 30.065 | 4787547.0 |
| 2009-12-14 12:00:00 | MSFT | Stock | 30.06 | 30.1 | 30.045 | 30.05 | 3359060.0 |
| 2009-12-14 13:00:00 | MSFT | Stock | 30.05 | 30.1 | 30.04 | 30.1 | 3478791.0 |
| 2009-12-14 14:00:00 | MSFT | Stock | 30.1 | 30.15 | 30.08 | 30.125 | 3852813.0 |
| 2009-12-14 15:00:00 | MSFT | Stock | 30.125 | 30.16 | 30.09 | 30.12 | 6072020.0 |
| 2009-12-14 16:00:00 | MSFT | Stock | 30.12 | 30.134 | 29.993 | 30.11 | 1915814.0 |
| 2009-12-14 17:00:00 | MSFT | Stock | 30.15 | 30.15 | 30.09 | 30.09 | 4500.0 |
| 2009-12-14 18:00:00 | MSFT | Stock | 30.09 | 30.11 | 29.99 | 29.99 | 29026.0 |
| 2009-12-14 19:00:00 | MSFT | Stock | 30.0 | 30.1 | 30.0 | 30.1 | 700.0 |
| 2009-12-14 08:00:00 | NVDA | Stock | 0.387 | 0.387 | 0.3803 | 0.3845 | 516960.0 |
| 2009-12-14 09:00:00 | NVDA | Stock | 0.385 | 0.3888 | 0.3815 | 0.3873 | 58294280.0 |
| 2009-12-14 10:00:00 | NVDA | Stock | 0.3873 | 0.3915 | 0.3855 | 0.3915 | 81260840.0 |
| 2009-12-14 11:00:00 | NVDA | Stock | 0.3915 | 0.393 | 0.3895 | 0.3913 | 65664240.0 |
| 2009-12-14 12:00:00 | NVDA | Stock | 0.391 | 0.3918 | 0.3902 | 0.3913 | 32120840.0 |
| 2009-12-14 13:00:00 | NVDA | Stock | 0.3913 | 0.3913 | 0.3893 | 0.39 | 30989560.0 |
| 2009-12-14 14:00:00 | NVDA | Stock | 0.39 | 0.392 | 0.3898 | 0.391 | 35964480.0 |
| 2009-12-14 15:00:00 | NVDA | Stock | 0.391 | 0.3922 | 0.3905 | 0.3918 | 82254720.0 |
| 2009-12-14 16:00:00 | NVDA | Stock | 0.3913 | 0.3925 | 0.3897 | 0.3898 | 1894240.0 |
| 2009-12-14 17:00:00 | NVDA | Stock | 0.3803 | 0.3922 | 0.3803 | 0.3922 | 44000.0 |
| 2009-12-14 18:00:00 | NVDA | Stock | 0.3922 | 0.3925 | 0.3922 | 0.3925 | 68000.0 |
| 2009-12-14 04:00:00 | AMZN | Stock | 6.655 | 6.666 | 6.655 | 6.66 | 8000.0 |
| 2009-12-14 05:00:00 | AMZN | Stock | 6.66 | 6.66 | 6.657 | 6.657 | 9680.0 |
| 2009-12-14 06:00:00 | AMZN | Stock | 6.642 | 6.642 | 6.627 | 6.627 | 17000.0 |
| 2009-12-14 07:00:00 | AMZN | Stock | 6.623 | 6.65 | 6.6175 | 6.625 | 170100.0 |
| 2009-12-14 08:00:00 | AMZN | Stock | 6.642 | 6.7075 | 6.615 | 6.635 | 552200.0 |
| 2009-12-14 09:00:00 | AMZN | Stock | 6.63 | 6.655 | 6.5125 | 6.5345 | 42216520.0 |
| 2009-12-14 10:00:00 | AMZN | Stock | 6.533 | 6.542 | 6.4675 | 6.5155 | 45184940.0 |
| 2009-12-14 11:00:00 | AMZN | Stock | 6.5155 | 6.537 | 6.495 | 6.505 | 23876340.0 |
| 2009-12-14 12:00:00 | AMZN | Stock | 6.506 | 6.5495 | 6.491 | 6.53 | 19231160.0 |
> showing 50 of 43,766 rows — these rows as CSV