PREVIEW / stock_5min / 2005-07-06
file: by_date/stock_5min/2005/2005-07-06.parquet size: 2.7 MB rows: 197,456 symbols: 2,016
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 |
|---|---|---|---|---|---|---|---|
| 2005-07-06 08:00:00 | AAPL | Stock | 1.3571 | 1.3571 | 1.3571 | 1.3571 | 107408.0 |
| 2005-07-06 08:05:00 | AAPL | Stock | 1.35 | 1.35 | 1.35 | 1.35 | 8400.0 |
| 2005-07-06 08:10:00 | AAPL | Stock | 1.3518 | 1.3518 | 1.3518 | 1.3518 | 14000.0 |
| 2005-07-06 08:15:00 | AAPL | Stock | 1.3507 | 1.3511 | 1.35 | 1.3511 | 36400.0 |
| 2005-07-06 08:20:00 | AAPL | Stock | 1.3511 | 1.3511 | 1.3511 | 1.3511 | 21000.0 |
| 2005-07-06 08:25:00 | AAPL | Stock | 1.3543 | 1.3543 | 1.3543 | 1.3543 | 11200.0 |
| 2005-07-06 08:30:00 | AAPL | Stock | 1.3518 | 1.3518 | 1.3518 | 1.3518 | 97440.0 |
| 2005-07-06 08:35:00 | AAPL | Stock | 1.3536 | 1.3536 | 1.3536 | 1.3536 | 58800.0 |
| 2005-07-06 08:40:00 | AAPL | Stock | 1.3518 | 1.3536 | 1.3493 | 1.3493 | 203840.0 |
| 2005-07-06 08:45:00 | AAPL | Stock | 1.3525 | 1.3525 | 1.3464 | 1.3464 | 60592.0 |
| 2005-07-06 08:50:00 | AAPL | Stock | 1.3464 | 1.3475 | 1.3461 | 1.3464 | 70000.0 |
| 2005-07-06 08:55:00 | AAPL | Stock | 1.3471 | 1.3489 | 1.3464 | 1.3464 | 51408.0 |
| 2005-07-06 09:00:00 | AAPL | Stock | 1.3464 | 1.3482 | 1.3454 | 1.3479 | 115500.0 |
| 2005-07-06 09:05:00 | AAPL | Stock | 1.3479 | 1.35 | 1.3464 | 1.35 | 175448.0 |
| 2005-07-06 09:15:00 | AAPL | Stock | 1.3507 | 1.3507 | 1.3507 | 1.3507 | 2800.0 |
| 2005-07-06 09:20:00 | AAPL | Stock | 1.3468 | 1.35 | 1.3464 | 1.3464 | 238000.0 |
| 2005-07-06 09:25:00 | AAPL | Stock | 1.3496 | 1.35 | 1.3468 | 1.3475 | 507248.0 |
| 2005-07-06 09:30:00 | AAPL | Stock | 1.3468 | 1.3529 | 1.3446 | 1.3468 | 14099092.0 |
| 2005-07-06 09:35:00 | AAPL | Stock | 1.3468 | 1.35 | 1.3454 | 1.3468 | 9668484.0 |
| 2005-07-06 09:40:00 | AAPL | Stock | 1.3468 | 1.3536 | 1.3468 | 1.3489 | 8078504.0 |
| 2005-07-06 09:45:00 | AAPL | Stock | 1.3493 | 1.3507 | 1.3464 | 1.3479 | 5288136.0 |
| 2005-07-06 09:50:00 | AAPL | Stock | 1.3475 | 1.3514 | 1.3429 | 1.345 | 7990780.0 |
| 2005-07-06 09:55:00 | AAPL | Stock | 1.3454 | 1.3489 | 1.3432 | 1.3468 | 6166916.0 |
| 2005-07-06 10:00:00 | AAPL | Stock | 1.3464 | 1.35 | 1.3443 | 1.3465 | 7908684.0 |
| 2005-07-06 10:05:00 | AAPL | Stock | 1.3465 | 1.3486 | 1.3457 | 1.3482 | 5524036.0 |
| 2005-07-06 10:10:00 | AAPL | Stock | 1.3486 | 1.3518 | 1.3482 | 1.3504 | 5028996.0 |
| 2005-07-06 10:15:00 | AAPL | Stock | 1.3504 | 1.3507 | 1.3482 | 1.3486 | 5963328.0 |
| 2005-07-06 10:20:00 | AAPL | Stock | 1.3486 | 1.35 | 1.3479 | 1.3496 | 3599904.0 |
| 2005-07-06 10:25:00 | AAPL | Stock | 1.3496 | 1.3511 | 1.3486 | 1.3493 | 4040988.0 |
| 2005-07-06 10:30:00 | AAPL | Stock | 1.3489 | 1.35 | 1.3479 | 1.3489 | 2784264.0 |
| 2005-07-06 10:35:00 | AAPL | Stock | 1.3489 | 1.3507 | 1.3479 | 1.3496 | 3483508.0 |
| 2005-07-06 10:40:00 | AAPL | Stock | 1.35 | 1.3508 | 1.3486 | 1.3493 | 2964864.0 |
| 2005-07-06 10:45:00 | AAPL | Stock | 1.3493 | 1.3507 | 1.3482 | 1.3504 | 3918264.0 |
| 2005-07-06 10:50:00 | AAPL | Stock | 1.35 | 1.3518 | 1.3496 | 1.3511 | 2515044.0 |
| 2005-07-06 10:55:00 | AAPL | Stock | 1.351 | 1.3536 | 1.35 | 1.3525 | 5709900.0 |
| 2005-07-06 11:00:00 | AAPL | Stock | 1.3521 | 1.3536 | 1.3521 | 1.3529 | 2830772.0 |
| 2005-07-06 11:05:00 | AAPL | Stock | 1.3532 | 1.3536 | 1.3514 | 1.3532 | 2235828.0 |
| 2005-07-06 11:10:00 | AAPL | Stock | 1.3532 | 1.3564 | 1.3525 | 1.3557 | 7041692.0 |
| 2005-07-06 11:15:00 | AAPL | Stock | 1.3557 | 1.3629 | 1.3554 | 1.3582 | 14563892.0 |
| 2005-07-06 11:20:00 | AAPL | Stock | 1.3582 | 1.3621 | 1.3568 | 1.36 | 6448008.0 |
| 2005-07-06 11:25:00 | AAPL | Stock | 1.3601 | 1.3607 | 1.3589 | 1.3607 | 3743292.0 |
| 2005-07-06 11:30:00 | AAPL | Stock | 1.3607 | 1.3629 | 1.3596 | 1.36 | 4979828.0 |
| 2005-07-06 11:35:00 | AAPL | Stock | 1.36 | 1.3611 | 1.3571 | 1.3596 | 5000576.0 |
| 2005-07-06 11:40:00 | AAPL | Stock | 1.3596 | 1.3604 | 1.3575 | 1.3593 | 3061016.0 |
| 2005-07-06 11:45:00 | AAPL | Stock | 1.3593 | 1.36 | 1.3575 | 1.3593 | 3520076.0 |
| 2005-07-06 11:50:00 | AAPL | Stock | 1.3593 | 1.3618 | 1.3593 | 1.3596 | 4116392.0 |
| 2005-07-06 11:55:00 | AAPL | Stock | 1.36 | 1.3604 | 1.3575 | 1.3579 | 3426528.0 |
| 2005-07-06 12:00:00 | AAPL | Stock | 1.3579 | 1.3582 | 1.3536 | 1.3557 | 5241040.0 |
| 2005-07-06 12:05:00 | AAPL | Stock | 1.3554 | 1.3561 | 1.3514 | 1.3518 | 5035912.0 |
| 2005-07-06 12:10:00 | AAPL | Stock | 1.3518 | 1.3518 | 1.3486 | 1.3507 | 5861632.0 |
> showing 50 of 197,456 rows — these rows as CSV