PREVIEW / stock_1hour / 2001-11-21
file: by_date/stock_1hour/2001/2001-11-21.parquet size: 366 KB rows: 17,566 symbols: 1,353
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-11-21 08:00:00 | AAPL | Stock | 0.3495 | 0.3495 | 0.3438 | 0.3495 | 907200.0 |
| 2001-11-21 09:00:00 | AAPL | Stock | 0.3484 | 0.3536 | 0.3482 | 0.3502 | 21940800.0 |
| 2001-11-21 10:00:00 | AAPL | Stock | 0.35 | 0.3534 | 0.3446 | 0.3454 | 36019200.0 |
| 2001-11-21 11:00:00 | AAPL | Stock | 0.3457 | 0.3504 | 0.3439 | 0.3471 | 26006400.0 |
| 2001-11-21 12:00:00 | AAPL | Stock | 0.3471 | 0.3495 | 0.3468 | 0.3477 | 17572800.0 |
| 2001-11-21 13:00:00 | AAPL | Stock | 0.3477 | 0.3529 | 0.3473 | 0.3529 | 24679200.0 |
| 2001-11-21 14:00:00 | AAPL | Stock | 0.353 | 0.353 | 0.35 | 0.3514 | 35436800.0 |
| 2001-11-21 15:00:00 | AAPL | Stock | 0.3516 | 0.3536 | 0.35 | 0.3514 | 27344800.0 |
| 2001-11-21 16:00:00 | AAPL | Stock | 0.3516 | 0.3529 | 0.3477 | 0.3514 | 6300000.0 |
| 2001-11-21 08:00:00 | MSFT | Stock | 31.705 | 32.995 | 31.625 | 32.175 | 657600.0 |
| 2001-11-21 09:00:00 | MSFT | Stock | 32.175 | 32.3 | 31.925 | 32.0995 | 10932000.0 |
| 2001-11-21 10:00:00 | MSFT | Stock | 32.085 | 32.295 | 31.815 | 31.885 | 10651400.0 |
| 2001-11-21 11:00:00 | MSFT | Stock | 31.875 | 32.025 | 31.84 | 31.8505 | 4527000.0 |
| 2001-11-21 12:00:00 | MSFT | Stock | 31.855 | 31.99 | 31.825 | 31.91 | 4405400.0 |
| 2001-11-21 13:00:00 | MSFT | Stock | 31.905 | 32.2 | 31.815 | 32.185 | 5241000.0 |
| 2001-11-21 14:00:00 | MSFT | Stock | 32.18 | 32.1805 | 31.95 | 31.98 | 3978000.0 |
| 2001-11-21 15:00:00 | MSFT | Stock | 31.98 | 32.085 | 31.7445 | 32.06 | 6133400.0 |
| 2001-11-21 16:00:00 | MSFT | Stock | 32.04 | 32.195 | 31.82 | 32.035 | 3555200.0 |
| 2001-11-21 17:00:00 | MSFT | Stock | 32.035 | 32.1 | 32.035 | 32.1 | 5600.0 |
| 2001-11-21 18:00:00 | MSFT | Stock | 32.115 | 32.125 | 32.1 | 32.125 | 2600.0 |
| 2001-11-21 08:00:00 | NVDA | Stock | 0.4133 | 0.4146 | 0.4062 | 0.4104 | 1404000.0 |
| 2001-11-21 09:00:00 | NVDA | Stock | 0.4109 | 0.4158 | 0.4067 | 0.4092 | 116244000.0 |
| 2001-11-21 10:00:00 | NVDA | Stock | 0.4092 | 0.4214 | 0.4023 | 0.4037 | 202032000.0 |
| 2001-11-21 11:00:00 | NVDA | Stock | 0.4034 | 0.4079 | 0.4025 | 0.4042 | 81840000.0 |
| 2001-11-21 12:00:00 | NVDA | Stock | 0.4045 | 0.4062 | 0.3983 | 0.4006 | 77232000.0 |
| 2001-11-21 13:00:00 | NVDA | Stock | 0.4007 | 0.4083 | 0.4 | 0.4083 | 72516000.0 |
| 2001-11-21 14:00:00 | NVDA | Stock | 0.4083 | 0.4096 | 0.406 | 0.4067 | 62244000.0 |
| 2001-11-21 15:00:00 | NVDA | Stock | 0.4072 | 0.4112 | 0.4058 | 0.4102 | 72072000.0 |
| 2001-11-21 16:00:00 | NVDA | Stock | 0.4105 | 0.4125 | 0.4006 | 0.4125 | 16188000.0 |
| 2001-11-21 17:00:00 | NVDA | Stock | 0.4105 | 0.4125 | 0.4105 | 0.4112 | 504000.0 |
| 2001-11-21 18:00:00 | NVDA | Stock | 0.4107 | 0.4107 | 0.4106 | 0.4106 | 72000.0 |
| 2001-11-21 08:00:00 | AMZN | Stock | 0.4335 | 0.4435 | 0.4325 | 0.437 | 448000.0 |
| 2001-11-21 09:00:00 | AMZN | Stock | 0.435 | 0.4375 | 0.4125 | 0.419 | 29070000.0 |
| 2001-11-21 10:00:00 | AMZN | Stock | 0.4195 | 0.4215 | 0.408 | 0.4085 | 41096000.0 |
| 2001-11-21 11:00:00 | AMZN | Stock | 0.4085 | 0.4135 | 0.402 | 0.4105 | 16826000.0 |
| 2001-11-21 12:00:00 | AMZN | Stock | 0.41 | 0.418 | 0.408 | 0.4155 | 10448000.0 |
| 2001-11-21 13:00:00 | AMZN | Stock | 0.4155 | 0.4255 | 0.4135 | 0.424 | 13044000.0 |
| 2001-11-21 14:00:00 | AMZN | Stock | 0.4245 | 0.4485 | 0.4245 | 0.4375 | 25058000.0 |
| 2001-11-21 15:00:00 | AMZN | Stock | 0.437 | 0.445 | 0.435 | 0.44 | 19342000.0 |
| 2001-11-21 16:00:00 | AMZN | Stock | 0.44 | 0.443 | 0.4145 | 0.44 | 1466000.0 |
| 2001-11-21 17:00:00 | AMZN | Stock | 0.44 | 0.4415 | 0.44 | 0.4415 | 130000.0 |
| 2001-11-21 18:00:00 | AMZN | Stock | 0.4425 | 0.4425 | 0.441 | 0.4425 | 84000.0 |
| 2001-11-21 09:00:00 | CL | Stock | 29.275 | 29.335 | 29.125 | 29.3 | 162600.0 |
| 2001-11-21 10:00:00 | CL | Stock | 29.3 | 29.495 | 29.225 | 29.475 | 387400.0 |
| 2001-11-21 11:00:00 | CL | Stock | 29.48 | 29.48 | 29.355 | 29.405 | 114200.0 |
| 2001-11-21 12:00:00 | CL | Stock | 29.4 | 29.4 | 29.3 | 29.3 | 160200.0 |
| 2001-11-21 13:00:00 | CL | Stock | 29.3 | 29.45 | 29.28 | 29.4 | 262600.0 |
| 2001-11-21 14:00:00 | CL | Stock | 29.4 | 29.4 | 29.255 | 29.305 | 364000.0 |
| 2001-11-21 15:00:00 | CL | Stock | 29.305 | 29.35 | 29.21 | 29.29 | 349200.0 |
| 2001-11-21 16:00:00 | CL | Stock | 29.29 | 29.495 | 29.29 | 29.495 | 42600.0 |
> showing 50 of 17,566 rows — these rows as CSV