PREVIEW / stock_5min / 2007-08-27
file: by_date/stock_5min/2007/2007-08-27.parquet size: 3.9 MB rows: 293,242 symbols: 3,109
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 |
|---|---|---|---|---|---|---|---|
| 2007-08-27 09:30:00 | AAPL | Stock | 4.764 | 4.78 | 4.74 | 4.7543 | 38643108.0 |
| 2007-08-27 09:35:00 | AAPL | Stock | 4.7546 | 4.7704 | 4.7506 | 4.7554 | 26336520.0 |
| 2007-08-27 09:40:00 | AAPL | Stock | 4.755 | 4.7586 | 4.7429 | 4.7532 | 19871684.0 |
| 2007-08-27 09:45:00 | AAPL | Stock | 4.7529 | 4.7589 | 4.7461 | 4.7568 | 12904920.0 |
| 2007-08-27 09:50:00 | AAPL | Stock | 4.7561 | 4.7618 | 4.7479 | 4.76 | 11672612.0 |
| 2007-08-27 09:55:00 | AAPL | Stock | 4.76 | 4.7786 | 4.7591 | 4.7743 | 17462648.0 |
| 2007-08-27 10:00:00 | AAPL | Stock | 4.7746 | 4.7875 | 4.7643 | 4.7704 | 22406496.0 |
| 2007-08-27 10:05:00 | AAPL | Stock | 4.7707 | 4.7736 | 4.7611 | 4.7611 | 11427612.0 |
| 2007-08-27 10:10:00 | AAPL | Stock | 4.7618 | 4.7768 | 4.7564 | 4.7686 | 8523452.0 |
| 2007-08-27 10:15:00 | AAPL | Stock | 4.7679 | 4.7879 | 4.7679 | 4.7857 | 10069948.0 |
| 2007-08-27 10:20:00 | AAPL | Stock | 4.7857 | 4.805 | 4.7811 | 4.7968 | 15703016.0 |
| 2007-08-27 10:25:00 | AAPL | Stock | 4.7971 | 4.8007 | 4.7846 | 4.7944 | 11480560.0 |
| 2007-08-27 10:30:00 | AAPL | Stock | 4.795 | 4.8093 | 4.7932 | 4.7959 | 11524240.0 |
| 2007-08-27 10:35:00 | AAPL | Stock | 4.7954 | 4.7964 | 4.7829 | 4.7854 | 11848956.0 |
| 2007-08-27 10:40:00 | AAPL | Stock | 4.785 | 4.7886 | 4.7754 | 4.7811 | 10077088.0 |
| 2007-08-27 10:45:00 | AAPL | Stock | 4.7804 | 4.7839 | 4.7682 | 4.7764 | 9673132.0 |
| 2007-08-27 10:50:00 | AAPL | Stock | 4.7766 | 4.785 | 4.7729 | 4.7772 | 8945720.0 |
| 2007-08-27 10:55:00 | AAPL | Stock | 4.7782 | 4.785 | 4.7732 | 4.7786 | 5557132.0 |
| 2007-08-27 11:00:00 | AAPL | Stock | 4.7782 | 4.7789 | 4.7654 | 4.7681 | 6728624.0 |
| 2007-08-27 11:05:00 | AAPL | Stock | 4.7682 | 4.7689 | 4.7575 | 4.7589 | 9231264.0 |
| 2007-08-27 11:10:00 | AAPL | Stock | 4.7589 | 4.7611 | 4.7521 | 4.7546 | 8873424.0 |
| 2007-08-27 11:15:00 | AAPL | Stock | 4.7546 | 4.7668 | 4.7543 | 4.7604 | 6452208.0 |
| 2007-08-27 11:20:00 | AAPL | Stock | 4.7607 | 4.7607 | 4.7514 | 4.7557 | 6623092.0 |
| 2007-08-27 11:25:00 | AAPL | Stock | 4.7557 | 4.7657 | 4.755 | 4.7618 | 5377820.0 |
| 2007-08-27 11:30:00 | AAPL | Stock | 4.7614 | 4.7618 | 4.7518 | 4.7557 | 5441492.0 |
| 2007-08-27 11:35:00 | AAPL | Stock | 4.7557 | 4.7614 | 4.7554 | 4.7571 | 3718988.0 |
| 2007-08-27 11:40:00 | AAPL | Stock | 4.7575 | 4.765 | 4.7571 | 4.7634 | 3273900.0 |
| 2007-08-27 11:45:00 | AAPL | Stock | 4.7636 | 4.7711 | 4.7582 | 4.76 | 6338584.0 |
| 2007-08-27 11:50:00 | AAPL | Stock | 4.76 | 4.7639 | 4.7593 | 4.7614 | 4203444.0 |
| 2007-08-27 11:55:00 | AAPL | Stock | 4.7611 | 4.7629 | 4.7582 | 4.7586 | 2507540.0 |
| 2007-08-27 12:00:00 | AAPL | Stock | 4.7589 | 4.76 | 4.7475 | 4.7475 | 10255476.0 |
| 2007-08-27 12:05:00 | AAPL | Stock | 4.7475 | 4.7539 | 4.7464 | 4.7496 | 5338648.0 |
| 2007-08-27 12:10:00 | AAPL | Stock | 4.7504 | 4.7618 | 4.7504 | 4.7618 | 5191620.0 |
| 2007-08-27 12:15:00 | AAPL | Stock | 4.7618 | 4.7636 | 4.755 | 4.7619 | 5578972.0 |
| 2007-08-27 12:20:00 | AAPL | Stock | 4.7614 | 4.7657 | 4.7571 | 4.7575 | 5901896.0 |
| 2007-08-27 12:25:00 | AAPL | Stock | 4.7575 | 4.7614 | 4.7554 | 4.7575 | 3254804.0 |
| 2007-08-27 12:30:00 | AAPL | Stock | 4.7579 | 4.7582 | 4.7557 | 4.7582 | 2144296.0 |
| 2007-08-27 12:35:00 | AAPL | Stock | 4.7582 | 4.7632 | 4.7557 | 4.7593 | 4916268.0 |
| 2007-08-27 12:40:00 | AAPL | Stock | 4.7596 | 4.7707 | 4.7593 | 4.7689 | 8258096.0 |
| 2007-08-27 12:45:00 | AAPL | Stock | 4.7689 | 4.7704 | 4.7636 | 4.7654 | 3674160.0 |
| 2007-08-27 12:50:00 | AAPL | Stock | 4.765 | 4.7657 | 4.7632 | 4.7654 | 2812908.0 |
| 2007-08-27 12:55:00 | AAPL | Stock | 4.7657 | 4.7657 | 4.7575 | 4.7646 | 4018448.0 |
| 2007-08-27 13:00:00 | AAPL | Stock | 4.765 | 4.7725 | 4.7632 | 4.7679 | 4311916.0 |
| 2007-08-27 13:05:00 | AAPL | Stock | 4.7679 | 4.7811 | 4.7661 | 4.7769 | 6992104.0 |
| 2007-08-27 13:10:00 | AAPL | Stock | 4.7775 | 4.7782 | 4.7725 | 4.7736 | 3732792.0 |
| 2007-08-27 13:15:00 | AAPL | Stock | 4.7729 | 4.7768 | 4.7696 | 4.7704 | 4784332.0 |
| 2007-08-27 13:20:00 | AAPL | Stock | 4.7704 | 4.7707 | 4.7621 | 4.7671 | 4423272.0 |
| 2007-08-27 13:25:00 | AAPL | Stock | 4.7668 | 4.7679 | 4.7629 | 4.7679 | 3104276.0 |
| 2007-08-27 13:30:00 | AAPL | Stock | 4.7671 | 4.7711 | 4.7661 | 4.7679 | 2246468.0 |
| 2007-08-27 13:35:00 | AAPL | Stock | 4.7679 | 4.7679 | 4.76 | 4.7604 | 4785004.0 |
> showing 50 of 293,242 rows — these rows as CSV