PREVIEW / stock_5min / 2005-10-20
file: by_date/stock_5min/2005/2005-10-20.parquet size: 2.9 MB rows: 203,363 symbols: 2,091
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-10-20 08:00:00 | AAPL | Stock | 1.9464 | 1.9596 | 1.9464 | 1.9571 | 103600.0 |
| 2005-10-20 08:10:00 | AAPL | Stock | 1.9521 | 1.9536 | 1.9521 | 1.9521 | 31080.0 |
| 2005-10-20 08:15:00 | AAPL | Stock | 1.9536 | 1.9536 | 1.9536 | 1.9536 | 56000.0 |
| 2005-10-20 08:20:00 | AAPL | Stock | 1.9536 | 1.9536 | 1.9532 | 1.9536 | 39200.0 |
| 2005-10-20 08:25:00 | AAPL | Stock | 1.9536 | 1.9554 | 1.9536 | 1.9536 | 14000.0 |
| 2005-10-20 08:30:00 | AAPL | Stock | 1.9532 | 1.9539 | 1.9507 | 1.9539 | 14000.0 |
| 2005-10-20 08:35:00 | AAPL | Stock | 1.9546 | 1.9546 | 1.9546 | 1.9546 | 2800.0 |
| 2005-10-20 08:40:00 | AAPL | Stock | 1.9543 | 1.955 | 1.9543 | 1.9543 | 88200.0 |
| 2005-10-20 08:45:00 | AAPL | Stock | 1.9543 | 1.9543 | 1.9532 | 1.9532 | 109480.0 |
| 2005-10-20 08:50:00 | AAPL | Stock | 1.9529 | 1.955 | 1.9507 | 1.955 | 172480.0 |
| 2005-10-20 08:55:00 | AAPL | Stock | 1.955 | 1.9557 | 1.9543 | 1.9554 | 376740.0 |
| 2005-10-20 09:00:00 | AAPL | Stock | 1.9557 | 1.9557 | 1.955 | 1.955 | 114436.0 |
| 2005-10-20 09:05:00 | AAPL | Stock | 1.9554 | 1.9554 | 1.955 | 1.955 | 25200.0 |
| 2005-10-20 09:10:00 | AAPL | Stock | 1.9543 | 1.9543 | 1.9518 | 1.9536 | 151340.0 |
| 2005-10-20 09:15:00 | AAPL | Stock | 1.9525 | 1.9532 | 1.9518 | 1.9532 | 67200.0 |
| 2005-10-20 09:20:00 | AAPL | Stock | 1.9532 | 1.9536 | 1.9518 | 1.9536 | 46200.0 |
| 2005-10-20 09:25:00 | AAPL | Stock | 1.9536 | 1.9536 | 1.9454 | 1.9454 | 1593508.0 |
| 2005-10-20 09:30:00 | AAPL | Stock | 1.9454 | 1.9643 | 1.9411 | 1.9607 | 33438132.0 |
| 2005-10-20 09:35:00 | AAPL | Stock | 1.9614 | 1.9643 | 1.9554 | 1.9589 | 27199144.0 |
| 2005-10-20 09:40:00 | AAPL | Stock | 1.9589 | 1.9986 | 1.9579 | 1.9954 | 73884216.0 |
| 2005-10-20 09:45:00 | AAPL | Stock | 1.9957 | 1.9979 | 1.9839 | 1.9871 | 42758940.0 |
| 2005-10-20 09:50:00 | AAPL | Stock | 1.985 | 1.9871 | 1.9679 | 1.9725 | 34789916.0 |
| 2005-10-20 09:55:00 | AAPL | Stock | 1.9725 | 1.9796 | 1.9686 | 1.9768 | 28500164.0 |
| 2005-10-20 10:00:00 | AAPL | Stock | 1.9768 | 1.9775 | 1.9711 | 1.9743 | 18522280.0 |
| 2005-10-20 10:05:00 | AAPL | Stock | 1.9746 | 1.975 | 1.9496 | 1.9532 | 30606492.0 |
| 2005-10-20 10:10:00 | AAPL | Stock | 1.9507 | 1.9614 | 1.9507 | 1.9582 | 16688252.0 |
| 2005-10-20 10:15:00 | AAPL | Stock | 1.9582 | 1.9718 | 1.9564 | 1.9689 | 18672444.0 |
| 2005-10-20 10:20:00 | AAPL | Stock | 1.9693 | 1.9729 | 1.9586 | 1.9675 | 19981640.0 |
| 2005-10-20 10:25:00 | AAPL | Stock | 1.9675 | 1.9696 | 1.9654 | 1.9686 | 8431696.0 |
| 2005-10-20 10:30:00 | AAPL | Stock | 1.9686 | 1.9818 | 1.9682 | 1.9814 | 20000596.0 |
| 2005-10-20 10:35:00 | AAPL | Stock | 1.9814 | 1.985 | 1.9757 | 1.9804 | 25452504.0 |
| 2005-10-20 10:40:00 | AAPL | Stock | 1.9797 | 1.9868 | 1.975 | 1.9868 | 16124808.0 |
| 2005-10-20 10:45:00 | AAPL | Stock | 1.9861 | 1.9918 | 1.9829 | 1.9904 | 24763172.0 |
| 2005-10-20 10:50:00 | AAPL | Stock | 1.99 | 1.9925 | 1.9857 | 1.9914 | 19842228.0 |
| 2005-10-20 10:55:00 | AAPL | Stock | 1.9921 | 1.9957 | 1.9871 | 1.9889 | 28937552.0 |
| 2005-10-20 11:00:00 | AAPL | Stock | 1.9889 | 1.9911 | 1.9793 | 1.9811 | 15380680.0 |
| 2005-10-20 11:05:00 | AAPL | Stock | 1.9811 | 1.9879 | 1.9779 | 1.9854 | 12001640.0 |
| 2005-10-20 11:10:00 | AAPL | Stock | 1.9854 | 1.9868 | 1.9786 | 1.9807 | 6799408.0 |
| 2005-10-20 11:15:00 | AAPL | Stock | 1.9807 | 1.9811 | 1.9721 | 1.9775 | 13702472.0 |
| 2005-10-20 11:20:00 | AAPL | Stock | 1.9775 | 1.9854 | 1.9764 | 1.985 | 8063468.0 |
| 2005-10-20 11:25:00 | AAPL | Stock | 1.985 | 1.9893 | 1.9804 | 1.9864 | 12956748.0 |
| 2005-10-20 11:30:00 | AAPL | Stock | 1.9864 | 1.9871 | 1.9839 | 1.9843 | 7377188.0 |
| 2005-10-20 11:35:00 | AAPL | Stock | 1.9846 | 1.9939 | 1.9843 | 1.9918 | 14079828.0 |
| 2005-10-20 11:40:00 | AAPL | Stock | 1.9918 | 1.9925 | 1.9875 | 1.99 | 13500004.0 |
| 2005-10-20 11:45:00 | AAPL | Stock | 1.99 | 1.9921 | 1.9861 | 1.9921 | 5108152.0 |
| 2005-10-20 11:50:00 | AAPL | Stock | 1.9918 | 1.9929 | 1.9882 | 1.99 | 5129936.0 |
| 2005-10-20 11:55:00 | AAPL | Stock | 1.9896 | 1.9936 | 1.9871 | 1.9925 | 10851344.0 |
| 2005-10-20 12:00:00 | AAPL | Stock | 1.9925 | 1.9979 | 1.9918 | 1.9964 | 22830752.0 |
| 2005-10-20 12:05:00 | AAPL | Stock | 1.9961 | 1.9979 | 1.9889 | 1.9896 | 11614176.0 |
| 2005-10-20 12:10:00 | AAPL | Stock | 1.9896 | 1.9939 | 1.9875 | 1.9939 | 13367956.0 |
> showing 50 of 203,363 rows — these rows as CSV