PREVIEW / stock_1hour / 2001-12-21
file: by_date/stock_1hour/2001/2001-12-21.parquet size: 423 KB rows: 19,795 symbols: 1,370
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-12-21 08:00:00 | AAPL | Stock | 0.3704 | 0.3704 | 0.3689 | 0.3689 | 112000.0 |
| 2001-12-21 09:00:00 | AAPL | Stock | 0.3727 | 0.3875 | 0.3714 | 0.382 | 38259200.0 |
| 2001-12-21 10:00:00 | AAPL | Stock | 0.382 | 0.3821 | 0.3739 | 0.3768 | 23671200.0 |
| 2001-12-21 11:00:00 | AAPL | Stock | 0.3766 | 0.377 | 0.3734 | 0.3752 | 14576800.0 |
| 2001-12-21 12:00:00 | AAPL | Stock | 0.375 | 0.3768 | 0.3725 | 0.3741 | 11104800.0 |
| 2001-12-21 13:00:00 | AAPL | Stock | 0.3732 | 0.3761 | 0.3732 | 0.3759 | 10236800.0 |
| 2001-12-21 14:00:00 | AAPL | Stock | 0.3759 | 0.3809 | 0.3752 | 0.3784 | 23822400.0 |
| 2001-12-21 15:00:00 | AAPL | Stock | 0.3786 | 0.3796 | 0.3748 | 0.375 | 30956800.0 |
| 2001-12-21 16:00:00 | AAPL | Stock | 0.375 | 0.3804 | 0.3747 | 0.3751 | 32037600.0 |
| 2001-12-21 17:00:00 | AAPL | Stock | 0.3753 | 0.3753 | 0.3746 | 0.375 | 20104000.0 |
| 2001-12-21 08:00:00 | MSFT | Stock | 33.42 | 33.75 | 33.3825 | 33.7 | 262800.0 |
| 2001-12-21 09:00:00 | MSFT | Stock | 33.675 | 34.7 | 33.625 | 33.745 | 15275800.0 |
| 2001-12-21 10:00:00 | MSFT | Stock | 33.745 | 34.01 | 33.5 | 33.96 | 9444600.0 |
| 2001-12-21 11:00:00 | MSFT | Stock | 33.96 | 33.975 | 33.65 | 33.7 | 5414600.0 |
| 2001-12-21 12:00:00 | MSFT | Stock | 33.7 | 33.825 | 33.6345 | 33.68 | 3953200.0 |
| 2001-12-21 13:00:00 | MSFT | Stock | 33.68 | 33.74 | 33.64 | 33.695 | 3822600.0 |
| 2001-12-21 14:00:00 | MSFT | Stock | 33.705 | 33.865 | 33.67 | 33.795 | 5445800.0 |
| 2001-12-21 15:00:00 | MSFT | Stock | 33.795 | 33.915 | 33.655 | 33.78 | 7481000.0 |
| 2001-12-21 16:00:00 | MSFT | Stock | 33.765 | 34.4 | 33.725 | 34.006 | 8189200.0 |
| 2001-12-21 17:00:00 | MSFT | Stock | 33.77 | 33.78 | 33.755 | 33.78 | 4068400.0 |
| 2001-12-21 18:00:00 | MSFT | Stock | 33.75 | 33.75 | 33.75 | 33.75 | 800.0 |
| 2001-12-21 08:00:00 | NVDA | Stock | 0.5258 | 0.5296 | 0.5167 | 0.5246 | 552000.0 |
| 2001-12-21 09:00:00 | NVDA | Stock | 0.5233 | 0.5287 | 0.5208 | 0.5282 | 121356000.0 |
| 2001-12-21 10:00:00 | NVDA | Stock | 0.5286 | 0.533 | 0.5257 | 0.5319 | 135912000.0 |
| 2001-12-21 11:00:00 | NVDA | Stock | 0.5319 | 0.5352 | 0.5293 | 0.5303 | 61536000.0 |
| 2001-12-21 12:00:00 | NVDA | Stock | 0.5305 | 0.5333 | 0.5275 | 0.5275 | 34884000.0 |
| 2001-12-21 13:00:00 | NVDA | Stock | 0.5278 | 0.53 | 0.5248 | 0.5282 | 53424000.0 |
| 2001-12-21 14:00:00 | NVDA | Stock | 0.5282 | 0.5367 | 0.5279 | 0.534 | 73692000.0 |
| 2001-12-21 15:00:00 | NVDA | Stock | 0.5342 | 0.5417 | 0.5292 | 0.5382 | 108612000.0 |
| 2001-12-21 16:00:00 | NVDA | Stock | 0.5382 | 0.5408 | 0.5298 | 0.5383 | 51444000.0 |
| 2001-12-21 17:00:00 | NVDA | Stock | 0.5385 | 0.5409 | 0.538 | 0.5382 | 20856000.0 |
| 2001-12-21 08:00:00 | AMZN | Stock | 0.505 | 0.515 | 0.505 | 0.5135 | 192000.0 |
| 2001-12-21 09:00:00 | AMZN | Stock | 0.5135 | 0.5225 | 0.51 | 0.5175 | 19016000.0 |
| 2001-12-21 10:00:00 | AMZN | Stock | 0.5175 | 0.553 | 0.515 | 0.55 | 61548000.0 |
| 2001-12-21 11:00:00 | AMZN | Stock | 0.55 | 0.5525 | 0.514 | 0.519 | 38024000.0 |
| 2001-12-21 12:00:00 | AMZN | Stock | 0.519 | 0.5225 | 0.5145 | 0.518 | 17400000.0 |
| 2001-12-21 13:00:00 | AMZN | Stock | 0.518 | 0.529 | 0.516 | 0.527 | 32732000.0 |
| 2001-12-21 14:00:00 | AMZN | Stock | 0.527 | 0.5295 | 0.517 | 0.52 | 26600000.0 |
| 2001-12-21 15:00:00 | AMZN | Stock | 0.5185 | 0.5215 | 0.5 | 0.5 | 40970000.0 |
| 2001-12-21 16:00:00 | AMZN | Stock | 0.5 | 0.523 | 0.4975 | 0.505 | 22722000.0 |
| 2001-12-21 17:00:00 | AMZN | Stock | 0.5 | 0.5085 | 0.499 | 0.5085 | 870000.0 |
| 2001-12-21 18:00:00 | AMZN | Stock | 0.507 | 0.509 | 0.5 | 0.509 | 238000.0 |
| 2001-12-21 09:00:00 | CL | Stock | 29.125 | 29.165 | 28.85 | 28.925 | 1454800.0 |
| 2001-12-21 10:00:00 | CL | Stock | 28.95 | 28.99 | 28.875 | 28.89 | 333800.0 |
| 2001-12-21 11:00:00 | CL | Stock | 28.88 | 28.905 | 28.675 | 28.68 | 255600.0 |
| 2001-12-21 12:00:00 | CL | Stock | 28.685 | 28.695 | 28.505 | 28.52 | 378800.0 |
| 2001-12-21 13:00:00 | CL | Stock | 28.52 | 28.575 | 28.45 | 28.465 | 292600.0 |
| 2001-12-21 14:00:00 | CL | Stock | 28.485 | 28.55 | 28.4 | 28.55 | 436400.0 |
| 2001-12-21 15:00:00 | CL | Stock | 28.55 | 28.925 | 28.545 | 28.825 | 559600.0 |
| 2001-12-21 16:00:00 | CL | Stock | 28.84 | 28.84 | 28.635 | 28.84 | 515800.0 |
> showing 50 of 19,795 rows — these rows as CSV