PREVIEW / stock_5min / 2003-12-19
file: by_date/stock_5min/2003/2003-12-19.parquet size: 2.4 MB rows: 172,018 symbols: 1,702
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 |
|---|---|---|---|---|---|---|---|
| 2003-12-19 08:00:00 | AAPL | Stock | 0.3579 | 0.3579 | 0.3579 | 0.3579 | 649600.0 |
| 2003-12-19 08:40:00 | AAPL | Stock | 0.358 | 0.358 | 0.358 | 0.358 | 5600.0 |
| 2003-12-19 08:50:00 | AAPL | Stock | 0.358 | 0.358 | 0.358 | 0.358 | 56000.0 |
| 2003-12-19 08:55:00 | AAPL | Stock | 0.3579 | 0.3579 | 0.3579 | 0.3579 | 11200.0 |
| 2003-12-19 09:15:00 | AAPL | Stock | 0.3589 | 0.3596 | 0.3589 | 0.3596 | 100800.0 |
| 2003-12-19 09:20:00 | AAPL | Stock | 0.3607 | 0.3607 | 0.3598 | 0.36 | 252000.0 |
| 2003-12-19 09:25:00 | AAPL | Stock | 0.36 | 0.3616 | 0.3586 | 0.3609 | 5436648.0 |
| 2003-12-19 09:30:00 | AAPL | Stock | 0.3589 | 0.3646 | 0.3566 | 0.3618 | 30325904.0 |
| 2003-12-19 09:35:00 | AAPL | Stock | 0.3618 | 0.3636 | 0.3602 | 0.3618 | 9019808.0 |
| 2003-12-19 09:40:00 | AAPL | Stock | 0.3619 | 0.3621 | 0.3607 | 0.3607 | 5882352.0 |
| 2003-12-19 09:45:00 | AAPL | Stock | 0.3607 | 0.3607 | 0.3588 | 0.3588 | 4624032.0 |
| 2003-12-19 09:50:00 | AAPL | Stock | 0.3588 | 0.3593 | 0.3548 | 0.3552 | 8867992.0 |
| 2003-12-19 09:55:00 | AAPL | Stock | 0.3552 | 0.3589 | 0.3546 | 0.3584 | 9150568.0 |
| 2003-12-19 10:00:00 | AAPL | Stock | 0.3586 | 0.3586 | 0.3571 | 0.3573 | 4071704.0 |
| 2003-12-19 10:05:00 | AAPL | Stock | 0.3571 | 0.3577 | 0.357 | 0.3574 | 3794336.0 |
| 2003-12-19 10:10:00 | AAPL | Stock | 0.3573 | 0.3579 | 0.3571 | 0.3575 | 1824536.0 |
| 2003-12-19 10:15:00 | AAPL | Stock | 0.3575 | 0.3575 | 0.3559 | 0.3559 | 4195576.0 |
| 2003-12-19 10:20:00 | AAPL | Stock | 0.3563 | 0.3568 | 0.3563 | 0.3566 | 3340008.0 |
| 2003-12-19 10:25:00 | AAPL | Stock | 0.3566 | 0.358 | 0.3566 | 0.358 | 3480960.0 |
| 2003-12-19 10:30:00 | AAPL | Stock | 0.358 | 0.3584 | 0.3579 | 0.3582 | 2506504.0 |
| 2003-12-19 10:35:00 | AAPL | Stock | 0.3584 | 0.3596 | 0.3582 | 0.3593 | 3117744.0 |
| 2003-12-19 10:40:00 | AAPL | Stock | 0.3593 | 0.3609 | 0.3593 | 0.3605 | 5696656.0 |
| 2003-12-19 10:45:00 | AAPL | Stock | 0.3604 | 0.3605 | 0.3584 | 0.3584 | 2800448.0 |
| 2003-12-19 10:50:00 | AAPL | Stock | 0.3584 | 0.3593 | 0.3584 | 0.3589 | 1224944.0 |
| 2003-12-19 10:55:00 | AAPL | Stock | 0.3589 | 0.3589 | 0.358 | 0.3588 | 1918280.0 |
| 2003-12-19 11:00:00 | AAPL | Stock | 0.3588 | 0.3596 | 0.3588 | 0.3596 | 1479800.0 |
| 2003-12-19 11:05:00 | AAPL | Stock | 0.3596 | 0.3596 | 0.3589 | 0.3589 | 1209600.0 |
| 2003-12-19 11:10:00 | AAPL | Stock | 0.3591 | 0.3593 | 0.3588 | 0.3593 | 740712.0 |
| 2003-12-19 11:15:00 | AAPL | Stock | 0.3591 | 0.3596 | 0.3589 | 0.3596 | 709296.0 |
| 2003-12-19 11:20:00 | AAPL | Stock | 0.3596 | 0.3598 | 0.3596 | 0.3596 | 605920.0 |
| 2003-12-19 11:25:00 | AAPL | Stock | 0.3598 | 0.3598 | 0.3595 | 0.3596 | 1585248.0 |
| 2003-12-19 11:30:00 | AAPL | Stock | 0.3595 | 0.3596 | 0.3595 | 0.3595 | 728000.0 |
| 2003-12-19 11:35:00 | AAPL | Stock | 0.3595 | 0.3596 | 0.3571 | 0.3573 | 2871736.0 |
| 2003-12-19 11:40:00 | AAPL | Stock | 0.3573 | 0.3575 | 0.3566 | 0.3568 | 4793936.0 |
| 2003-12-19 11:45:00 | AAPL | Stock | 0.3568 | 0.357 | 0.3559 | 0.357 | 3199000.0 |
| 2003-12-19 11:50:00 | AAPL | Stock | 0.3568 | 0.357 | 0.3559 | 0.3566 | 1965488.0 |
| 2003-12-19 11:55:00 | AAPL | Stock | 0.3566 | 0.358 | 0.3563 | 0.3579 | 2513392.0 |
| 2003-12-19 12:00:00 | AAPL | Stock | 0.3575 | 0.3575 | 0.3554 | 0.3557 | 3337544.0 |
| 2003-12-19 12:05:00 | AAPL | Stock | 0.3554 | 0.3568 | 0.3554 | 0.3554 | 2775976.0 |
| 2003-12-19 12:10:00 | AAPL | Stock | 0.3554 | 0.3559 | 0.355 | 0.3557 | 2464168.0 |
| 2003-12-19 12:15:00 | AAPL | Stock | 0.3557 | 0.357 | 0.3555 | 0.3566 | 2957528.0 |
| 2003-12-19 12:20:00 | AAPL | Stock | 0.3568 | 0.357 | 0.3564 | 0.357 | 986160.0 |
| 2003-12-19 12:25:00 | AAPL | Stock | 0.3568 | 0.357 | 0.3555 | 0.3557 | 1340864.0 |
| 2003-12-19 12:30:00 | AAPL | Stock | 0.3557 | 0.3561 | 0.3555 | 0.3555 | 1184568.0 |
| 2003-12-19 12:35:00 | AAPL | Stock | 0.3555 | 0.3557 | 0.3553 | 0.3554 | 2556400.0 |
| 2003-12-19 12:40:00 | AAPL | Stock | 0.3554 | 0.3555 | 0.3548 | 0.3551 | 1444856.0 |
| 2003-12-19 12:45:00 | AAPL | Stock | 0.355 | 0.355 | 0.3546 | 0.3546 | 2210320.0 |
| 2003-12-19 12:50:00 | AAPL | Stock | 0.3546 | 0.355 | 0.3546 | 0.355 | 1794240.0 |
| 2003-12-19 12:55:00 | AAPL | Stock | 0.3548 | 0.3555 | 0.3546 | 0.3552 | 1524096.0 |
| 2003-12-19 13:00:00 | AAPL | Stock | 0.3552 | 0.3554 | 0.3548 | 0.3548 | 1604064.0 |
> showing 50 of 172,018 rows — these rows as CSV