PREVIEW / stock_1hour / 2001-08-16
file: by_date/stock_1hour/2001/2001-08-16.parquet size: 354 KB rows: 16,903 symbols: 1,332
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-08-16 08:00:00 | AAPL | Stock | 0.3291 | 0.3291 | 0.3259 | 0.3259 | 431200.0 |
| 2001-08-16 09:00:00 | AAPL | Stock | 0.3268 | 0.3293 | 0.3214 | 0.3223 | 36780800.0 |
| 2001-08-16 10:00:00 | AAPL | Stock | 0.322 | 0.3239 | 0.3209 | 0.3229 | 55412000.0 |
| 2001-08-16 11:00:00 | AAPL | Stock | 0.3227 | 0.325 | 0.3211 | 0.3223 | 45197600.0 |
| 2001-08-16 12:00:00 | AAPL | Stock | 0.3223 | 0.3239 | 0.3213 | 0.3225 | 28224000.0 |
| 2001-08-16 13:00:00 | AAPL | Stock | 0.3229 | 0.3246 | 0.3213 | 0.3239 | 47040000.0 |
| 2001-08-16 14:00:00 | AAPL | Stock | 0.3241 | 0.3266 | 0.3225 | 0.3245 | 22584800.0 |
| 2001-08-16 15:00:00 | AAPL | Stock | 0.3246 | 0.3348 | 0.323 | 0.333 | 31718400.0 |
| 2001-08-16 16:00:00 | AAPL | Stock | 0.333 | 0.3339 | 0.3232 | 0.3338 | 9643200.0 |
| 2001-08-16 17:00:00 | AAPL | Stock | 0.3348 | 0.3348 | 0.3348 | 0.3348 | 22400.0 |
| 2001-08-16 18:00:00 | AAPL | Stock | 0.3314 | 0.3314 | 0.3314 | 0.3314 | 5600.0 |
| 2001-08-16 08:00:00 | MSFT | Stock | 31.5 | 31.69 | 31.5 | 31.595 | 86800.0 |
| 2001-08-16 09:00:00 | MSFT | Stock | 31.55 | 31.625 | 31.35 | 31.465 | 7244600.0 |
| 2001-08-16 10:00:00 | MSFT | Stock | 31.46 | 31.715 | 31.45 | 31.535 | 8591400.0 |
| 2001-08-16 11:00:00 | MSFT | Stock | 31.53 | 31.675 | 31.485 | 31.57 | 4404600.0 |
| 2001-08-16 12:00:00 | MSFT | Stock | 31.565 | 31.63 | 31.505 | 31.58 | 4925600.0 |
| 2001-08-16 13:00:00 | MSFT | Stock | 31.565 | 31.97 | 31.525 | 31.95 | 3939600.0 |
| 2001-08-16 14:00:00 | MSFT | Stock | 31.955 | 32.185 | 31.925 | 32.125 | 4699000.0 |
| 2001-08-16 15:00:00 | MSFT | Stock | 32.115 | 32.355 | 32.0 | 32.315 | 6274400.0 |
| 2001-08-16 16:00:00 | MSFT | Stock | 32.35 | 32.445 | 31.425 | 32.2 | 2306200.0 |
| 2001-08-16 17:00:00 | MSFT | Stock | 32.2 | 32.25 | 32.2 | 32.25 | 8600.0 |
| 2001-08-16 18:00:00 | MSFT | Stock | 32.2 | 32.25 | 32.15 | 32.175 | 9000.0 |
| 2001-08-16 08:00:00 | NVDA | Stock | 0.3526 | 0.3533 | 0.35 | 0.3532 | 3528000.0 |
| 2001-08-16 09:00:00 | NVDA | Stock | 0.3533 | 0.3584 | 0.3459 | 0.3583 | 168144000.0 |
| 2001-08-16 10:00:00 | NVDA | Stock | 0.3583 | 0.3613 | 0.3547 | 0.3583 | 200040000.0 |
| 2001-08-16 11:00:00 | NVDA | Stock | 0.3585 | 0.3621 | 0.3585 | 0.3604 | 86040000.0 |
| 2001-08-16 12:00:00 | NVDA | Stock | 0.3602 | 0.3609 | 0.3583 | 0.359 | 71520000.0 |
| 2001-08-16 13:00:00 | NVDA | Stock | 0.359 | 0.3621 | 0.3584 | 0.3613 | 50040000.0 |
| 2001-08-16 14:00:00 | NVDA | Stock | 0.3613 | 0.3725 | 0.3606 | 0.3706 | 198120000.0 |
| 2001-08-16 15:00:00 | NVDA | Stock | 0.3705 | 0.3738 | 0.3673 | 0.3731 | 192984000.0 |
| 2001-08-16 16:00:00 | NVDA | Stock | 0.3732 | 0.374 | 0.3624 | 0.3713 | 17880000.0 |
| 2001-08-16 17:00:00 | NVDA | Stock | 0.3713 | 0.3729 | 0.3592 | 0.3729 | 624000.0 |
| 2001-08-16 18:00:00 | NVDA | Stock | 0.3567 | 0.3732 | 0.3567 | 0.3723 | 480000.0 |
| 2001-08-16 08:00:00 | AMZN | Stock | 0.5005 | 0.5015 | 0.5005 | 0.5015 | 30000.0 |
| 2001-08-16 09:00:00 | AMZN | Stock | 0.5005 | 0.508 | 0.481 | 0.482 | 10992000.0 |
| 2001-08-16 10:00:00 | AMZN | Stock | 0.4825 | 0.491 | 0.478 | 0.4825 | 23750000.0 |
| 2001-08-16 11:00:00 | AMZN | Stock | 0.4825 | 0.488 | 0.4775 | 0.4785 | 14432000.0 |
| 2001-08-16 12:00:00 | AMZN | Stock | 0.4785 | 0.4815 | 0.47 | 0.475 | 16108000.0 |
| 2001-08-16 13:00:00 | AMZN | Stock | 0.477 | 0.4825 | 0.475 | 0.477 | 8694000.0 |
| 2001-08-16 14:00:00 | AMZN | Stock | 0.4775 | 0.485 | 0.473 | 0.483 | 23050000.0 |
| 2001-08-16 15:00:00 | AMZN | Stock | 0.483 | 0.4915 | 0.481 | 0.49 | 17998000.0 |
| 2001-08-16 16:00:00 | AMZN | Stock | 0.4905 | 0.4935 | 0.481 | 0.4925 | 2848000.0 |
| 2001-08-16 17:00:00 | AMZN | Stock | 0.4935 | 0.4935 | 0.493 | 0.493 | 8000.0 |
| 2001-08-16 18:00:00 | AMZN | Stock | 0.493 | 0.495 | 0.493 | 0.495 | 26000.0 |
| 2001-08-16 09:00:00 | CL | Stock | 27.35 | 27.675 | 27.35 | 27.57 | 382200.0 |
| 2001-08-16 10:00:00 | CL | Stock | 27.56 | 27.675 | 27.3 | 27.42 | 679200.0 |
| 2001-08-16 11:00:00 | CL | Stock | 27.42 | 27.605 | 27.41 | 27.555 | 293800.0 |
| 2001-08-16 12:00:00 | CL | Stock | 27.555 | 27.64 | 27.405 | 27.6 | 192200.0 |
| 2001-08-16 13:00:00 | CL | Stock | 27.59 | 27.65 | 27.5 | 27.62 | 220800.0 |
| 2001-08-16 14:00:00 | CL | Stock | 27.61 | 27.71 | 27.575 | 27.645 | 617400.0 |
> showing 50 of 16,903 rows — these rows as CSV