PREVIEW / stock_1min / 2002-05-16
file: by_date/stock_1min/2002/2002-05-16.parquet size: 3.9 MB rows: 311,670 symbols: 1,166
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 |
|---|---|---|---|---|---|---|---|
| 2002-05-16 08:02:00 | AAPL | Stock | 0.4513 | 0.4513 | 0.4513 | 0.4513 | 61600.0 |
| 2002-05-16 08:09:00 | AAPL | Stock | 0.4571 | 0.4571 | 0.4571 | 0.4571 | 5600.0 |
| 2002-05-16 08:10:00 | AAPL | Stock | 0.4607 | 0.4607 | 0.4607 | 0.4607 | 16800.0 |
| 2002-05-16 08:15:00 | AAPL | Stock | 0.4861 | 0.4861 | 0.4589 | 0.4589 | 33600.0 |
| 2002-05-16 08:17:00 | AAPL | Stock | 0.4589 | 0.4589 | 0.4589 | 0.4589 | 5600.0 |
| 2002-05-16 08:32:00 | AAPL | Stock | 0.4572 | 0.4572 | 0.4571 | 0.4571 | 28000.0 |
| 2002-05-16 08:35:00 | AAPL | Stock | 0.4554 | 0.4554 | 0.4523 | 0.4523 | 112000.0 |
| 2002-05-16 08:36:00 | AAPL | Stock | 0.4511 | 0.4511 | 0.4511 | 0.4511 | 33600.0 |
| 2002-05-16 09:03:00 | AAPL | Stock | 0.4513 | 0.4513 | 0.4482 | 0.4482 | 212800.0 |
| 2002-05-16 09:04:00 | AAPL | Stock | 0.4482 | 0.4482 | 0.4482 | 0.4482 | 61600.0 |
| 2002-05-16 09:05:00 | AAPL | Stock | 0.4482 | 0.4482 | 0.448 | 0.448 | 11200.0 |
| 2002-05-16 09:11:00 | AAPL | Stock | 0.4479 | 0.4479 | 0.4479 | 0.4479 | 11200.0 |
| 2002-05-16 09:13:00 | AAPL | Stock | 0.4482 | 0.4482 | 0.4482 | 0.4482 | 61600.0 |
| 2002-05-16 09:21:00 | AAPL | Stock | 0.448 | 0.448 | 0.448 | 0.448 | 39200.0 |
| 2002-05-16 09:24:00 | AAPL | Stock | 0.4482 | 0.4482 | 0.4482 | 0.4482 | 28000.0 |
| 2002-05-16 09:28:00 | AAPL | Stock | 0.448 | 0.448 | 0.4475 | 0.4475 | 67200.0 |
| 2002-05-16 09:29:00 | AAPL | Stock | 0.4475 | 0.4475 | 0.4475 | 0.4475 | 84000.0 |
| 2002-05-16 09:30:00 | AAPL | Stock | 0.4475 | 0.4491 | 0.4473 | 0.4475 | 2884000.0 |
| 2002-05-16 09:31:00 | AAPL | Stock | 0.4482 | 0.4491 | 0.4455 | 0.4455 | 1422400.0 |
| 2002-05-16 09:32:00 | AAPL | Stock | 0.4454 | 0.4463 | 0.4446 | 0.445 | 1545600.0 |
| 2002-05-16 09:33:00 | AAPL | Stock | 0.4446 | 0.4452 | 0.4445 | 0.4445 | 963200.0 |
| 2002-05-16 09:34:00 | AAPL | Stock | 0.4445 | 0.4446 | 0.4443 | 0.4446 | 2167200.0 |
| 2002-05-16 09:35:00 | AAPL | Stock | 0.4446 | 0.4468 | 0.4446 | 0.4468 | 1433600.0 |
| 2002-05-16 09:36:00 | AAPL | Stock | 0.4468 | 0.447 | 0.4461 | 0.447 | 2088800.0 |
| 2002-05-16 09:37:00 | AAPL | Stock | 0.447 | 0.4482 | 0.4468 | 0.4482 | 1237600.0 |
| 2002-05-16 09:38:00 | AAPL | Stock | 0.4482 | 0.4495 | 0.4482 | 0.4495 | 1461600.0 |
| 2002-05-16 09:39:00 | AAPL | Stock | 0.4495 | 0.4496 | 0.4482 | 0.4484 | 1069600.0 |
| 2002-05-16 09:40:00 | AAPL | Stock | 0.4482 | 0.4489 | 0.4482 | 0.4482 | 537600.0 |
| 2002-05-16 09:41:00 | AAPL | Stock | 0.4482 | 0.4486 | 0.448 | 0.4486 | 151200.0 |
| 2002-05-16 09:42:00 | AAPL | Stock | 0.4479 | 0.4479 | 0.4466 | 0.4466 | 448000.0 |
| 2002-05-16 09:43:00 | AAPL | Stock | 0.4464 | 0.4477 | 0.4464 | 0.4477 | 929600.0 |
| 2002-05-16 09:44:00 | AAPL | Stock | 0.4471 | 0.4477 | 0.4471 | 0.4477 | 106400.0 |
| 2002-05-16 09:45:00 | AAPL | Stock | 0.4471 | 0.4475 | 0.4464 | 0.4466 | 1047200.0 |
| 2002-05-16 09:46:00 | AAPL | Stock | 0.4473 | 0.4473 | 0.4448 | 0.4448 | 1058400.0 |
| 2002-05-16 09:47:00 | AAPL | Stock | 0.4457 | 0.4464 | 0.4452 | 0.4454 | 492800.0 |
| 2002-05-16 09:48:00 | AAPL | Stock | 0.4452 | 0.4459 | 0.445 | 0.445 | 515200.0 |
| 2002-05-16 09:49:00 | AAPL | Stock | 0.445 | 0.4464 | 0.4445 | 0.4464 | 980000.0 |
| 2002-05-16 09:50:00 | AAPL | Stock | 0.4464 | 0.4464 | 0.4455 | 0.4457 | 386400.0 |
| 2002-05-16 09:51:00 | AAPL | Stock | 0.4457 | 0.4464 | 0.4457 | 0.4461 | 1338400.0 |
| 2002-05-16 09:52:00 | AAPL | Stock | 0.4461 | 0.4463 | 0.4461 | 0.4463 | 280000.0 |
| 2002-05-16 09:53:00 | AAPL | Stock | 0.4457 | 0.4463 | 0.4446 | 0.4446 | 1176000.0 |
| 2002-05-16 09:54:00 | AAPL | Stock | 0.4448 | 0.4461 | 0.4446 | 0.4454 | 492800.0 |
| 2002-05-16 09:55:00 | AAPL | Stock | 0.4454 | 0.4457 | 0.4454 | 0.4457 | 296800.0 |
| 2002-05-16 09:56:00 | AAPL | Stock | 0.4461 | 0.4465 | 0.4457 | 0.4457 | 548800.0 |
| 2002-05-16 09:57:00 | AAPL | Stock | 0.4454 | 0.4454 | 0.4443 | 0.4445 | 252000.0 |
| 2002-05-16 09:58:00 | AAPL | Stock | 0.4444 | 0.4444 | 0.4425 | 0.4432 | 2436000.0 |
| 2002-05-16 09:59:00 | AAPL | Stock | 0.4432 | 0.445 | 0.4429 | 0.4434 | 560000.0 |
| 2002-05-16 10:00:00 | AAPL | Stock | 0.4446 | 0.445 | 0.4438 | 0.4438 | 515200.0 |
| 2002-05-16 10:01:00 | AAPL | Stock | 0.4438 | 0.4441 | 0.4434 | 0.4441 | 453600.0 |
| 2002-05-16 10:02:00 | AAPL | Stock | 0.4448 | 0.4455 | 0.4445 | 0.4455 | 873600.0 |
> showing 50 of 311,670 rows — these rows as CSV