PREVIEW / stock_1hour / 2001-11-15
file: by_date/stock_1hour/2001/2001-11-15.parquet size: 379 KB rows: 18,054 symbols: 1,352
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-15 08:00:00 | AAPL | Stock | 0.3503 | 0.3507 | 0.35 | 0.35 | 610400.0 |
| 2001-11-15 09:00:00 | AAPL | Stock | 0.3491 | 0.3498 | 0.3434 | 0.3452 | 30413600.0 |
| 2001-11-15 10:00:00 | AAPL | Stock | 0.3453 | 0.3554 | 0.3441 | 0.3536 | 31225600.0 |
| 2001-11-15 11:00:00 | AAPL | Stock | 0.3536 | 0.3554 | 0.3493 | 0.35 | 30094400.0 |
| 2001-11-15 12:00:00 | AAPL | Stock | 0.35 | 0.3534 | 0.348 | 0.3525 | 32267200.0 |
| 2001-11-15 13:00:00 | AAPL | Stock | 0.352 | 0.3523 | 0.3464 | 0.3489 | 21952000.0 |
| 2001-11-15 14:00:00 | AAPL | Stock | 0.348 | 0.3505 | 0.3461 | 0.3488 | 18284000.0 |
| 2001-11-15 15:00:00 | AAPL | Stock | 0.3488 | 0.3489 | 0.3434 | 0.3475 | 35515200.0 |
| 2001-11-15 16:00:00 | AAPL | Stock | 0.3471 | 0.3509 | 0.345 | 0.3468 | 6490400.0 |
| 2001-11-15 17:00:00 | AAPL | Stock | 0.3473 | 0.3473 | 0.3473 | 0.3473 | 828800.0 |
| 2001-11-15 08:00:00 | MSFT | Stock | 32.94 | 33.14 | 32.75 | 32.85 | 121400.0 |
| 2001-11-15 09:00:00 | MSFT | Stock | 32.85 | 33.275 | 32.835 | 33.095 | 12592600.0 |
| 2001-11-15 10:00:00 | MSFT | Stock | 33.094 | 33.525 | 32.975 | 33.375 | 16542600.0 |
| 2001-11-15 11:00:00 | MSFT | Stock | 33.3705 | 33.405 | 33.11 | 33.14 | 7044800.0 |
| 2001-11-15 12:00:00 | MSFT | Stock | 33.141 | 33.2795 | 33.03 | 33.19 | 11029400.0 |
| 2001-11-15 13:00:00 | MSFT | Stock | 33.19 | 33.235 | 32.815 | 32.915 | 6507600.0 |
| 2001-11-15 14:00:00 | MSFT | Stock | 32.91 | 33.05 | 32.775 | 32.83 | 9247200.0 |
| 2001-11-15 15:00:00 | MSFT | Stock | 32.835 | 33.075 | 32.725 | 33.07 | 7223600.0 |
| 2001-11-15 16:00:00 | MSFT | Stock | 33.065 | 33.25 | 32.75 | 32.85 | 5117400.0 |
| 2001-11-15 17:00:00 | MSFT | Stock | 32.85 | 33.0749 | 32.845 | 32.975 | 316000.0 |
| 2001-11-15 18:00:00 | MSFT | Stock | 32.97 | 33.04 | 32.925 | 32.95 | 12400.0 |
| 2001-11-15 08:00:00 | NVDA | Stock | 0.4356 | 0.4374 | 0.4329 | 0.4329 | 876000.0 |
| 2001-11-15 09:00:00 | NVDA | Stock | 0.4329 | 0.439 | 0.4284 | 0.4358 | 136944000.0 |
| 2001-11-15 10:00:00 | NVDA | Stock | 0.4362 | 0.4472 | 0.4347 | 0.4414 | 231720000.0 |
| 2001-11-15 11:00:00 | NVDA | Stock | 0.4412 | 0.4437 | 0.4375 | 0.4383 | 87768000.0 |
| 2001-11-15 12:00:00 | NVDA | Stock | 0.4383 | 0.4432 | 0.4363 | 0.4422 | 50388000.0 |
| 2001-11-15 13:00:00 | NVDA | Stock | 0.4422 | 0.4424 | 0.436 | 0.4367 | 48228000.0 |
| 2001-11-15 14:00:00 | NVDA | Stock | 0.4367 | 0.4424 | 0.4343 | 0.4405 | 139716000.0 |
| 2001-11-15 15:00:00 | NVDA | Stock | 0.4412 | 0.4427 | 0.4392 | 0.4404 | 147300000.0 |
| 2001-11-15 16:00:00 | NVDA | Stock | 0.4412 | 0.4433 | 0.4408 | 0.4408 | 10932000.0 |
| 2001-11-15 17:00:00 | NVDA | Stock | 0.4406 | 0.4421 | 0.4406 | 0.4421 | 852000.0 |
| 2001-11-15 18:00:00 | NVDA | Stock | 0.4417 | 0.4417 | 0.4408 | 0.4408 | 108000.0 |
| 2001-11-15 08:00:00 | AMZN | Stock | 0.4735 | 0.48 | 0.461 | 0.461 | 1934000.0 |
| 2001-11-15 09:00:00 | AMZN | Stock | 0.463 | 0.48 | 0.4425 | 0.4475 | 81114000.0 |
| 2001-11-15 10:00:00 | AMZN | Stock | 0.4455 | 0.495 | 0.445 | 0.489 | 99522000.0 |
| 2001-11-15 11:00:00 | AMZN | Stock | 0.489 | 0.491 | 0.4615 | 0.4665 | 54324000.0 |
| 2001-11-15 12:00:00 | AMZN | Stock | 0.4665 | 0.4725 | 0.46 | 0.4675 | 23390000.0 |
| 2001-11-15 13:00:00 | AMZN | Stock | 0.4675 | 0.469 | 0.4455 | 0.4475 | 48280000.0 |
| 2001-11-15 14:00:00 | AMZN | Stock | 0.447 | 0.4555 | 0.4375 | 0.4555 | 52702000.0 |
| 2001-11-15 15:00:00 | AMZN | Stock | 0.4555 | 0.459 | 0.448 | 0.4525 | 34090000.0 |
| 2001-11-15 16:00:00 | AMZN | Stock | 0.4525 | 0.459 | 0.4435 | 0.4435 | 5632000.0 |
| 2001-11-15 17:00:00 | AMZN | Stock | 0.4525 | 0.4525 | 0.445 | 0.4495 | 236000.0 |
| 2001-11-15 18:00:00 | AMZN | Stock | 0.45 | 0.4525 | 0.45 | 0.4525 | 368000.0 |
| 2001-11-15 09:00:00 | CL | Stock | 28.8 | 29.125 | 28.8 | 29.095 | 204400.0 |
| 2001-11-15 10:00:00 | CL | Stock | 29.08 | 29.225 | 29.025 | 29.125 | 813400.0 |
| 2001-11-15 11:00:00 | CL | Stock | 29.125 | 29.135 | 29.055 | 29.085 | 230200.0 |
| 2001-11-15 12:00:00 | CL | Stock | 29.09 | 29.225 | 29.05 | 29.21 | 272400.0 |
| 2001-11-15 13:00:00 | CL | Stock | 29.205 | 29.225 | 28.8 | 28.8 | 381000.0 |
| 2001-11-15 14:00:00 | CL | Stock | 28.8 | 29.085 | 28.8 | 29.075 | 449400.0 |
| 2001-11-15 15:00:00 | CL | Stock | 29.075 | 29.28 | 29.075 | 29.185 | 1026800.0 |
> showing 50 of 18,054 rows — these rows as CSV