PREVIEW / stock_5min / 2007-10-16
file: by_date/stock_5min/2007/2007-10-16.parquet size: 4.2 MB rows: 306,095 symbols: 3,148
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-10-16 05:55:00 | AAPL | Stock | 5.9007 | 5.9007 | 5.9007 | 5.9007 | 5600.0 |
| 2007-10-16 06:35:00 | AAPL | Stock | 5.9357 | 5.9357 | 5.9357 | 5.9357 | 5600.0 |
| 2007-10-16 06:45:00 | AAPL | Stock | 5.8882 | 5.8882 | 5.8882 | 5.8882 | 2800.0 |
| 2007-10-16 06:55:00 | AAPL | Stock | 5.9143 | 5.9143 | 5.8886 | 5.8886 | 5600.0 |
| 2007-10-16 07:00:00 | AAPL | Stock | 5.8925 | 5.8929 | 5.8732 | 5.875 | 126000.0 |
| 2007-10-16 07:05:00 | AAPL | Stock | 5.875 | 5.875 | 5.875 | 5.875 | 25200.0 |
| 2007-10-16 07:10:00 | AAPL | Stock | 5.8925 | 5.8925 | 5.8925 | 5.8925 | 2800.0 |
| 2007-10-16 07:15:00 | AAPL | Stock | 5.8882 | 5.8882 | 5.8821 | 5.8821 | 8400.0 |
| 2007-10-16 07:20:00 | AAPL | Stock | 5.875 | 5.875 | 5.875 | 5.875 | 14000.0 |
| 2007-10-16 07:25:00 | AAPL | Stock | 5.8925 | 5.8929 | 5.8907 | 5.8907 | 67060.0 |
| 2007-10-16 07:30:00 | AAPL | Stock | 5.8929 | 5.8929 | 5.8889 | 5.8929 | 53200.0 |
| 2007-10-16 07:35:00 | AAPL | Stock | 5.8929 | 5.8929 | 5.8893 | 5.8893 | 60704.0 |
| 2007-10-16 07:40:00 | AAPL | Stock | 5.8893 | 5.8929 | 5.8893 | 5.8911 | 56000.0 |
| 2007-10-16 07:45:00 | AAPL | Stock | 5.8857 | 5.8857 | 5.8857 | 5.8857 | 28000.0 |
| 2007-10-16 07:50:00 | AAPL | Stock | 5.8911 | 5.9018 | 5.8911 | 5.8968 | 66136.0 |
| 2007-10-16 07:55:00 | AAPL | Stock | 5.9036 | 5.9096 | 5.9036 | 5.9061 | 33600.0 |
| 2007-10-16 08:00:00 | AAPL | Stock | 5.9096 | 5.9246 | 5.8893 | 5.9071 | 834344.0 |
| 2007-10-16 08:05:00 | AAPL | Stock | 5.91 | 5.9107 | 5.8886 | 5.8893 | 677572.0 |
| 2007-10-16 08:10:00 | AAPL | Stock | 5.8921 | 5.9032 | 5.8893 | 5.8929 | 337260.0 |
| 2007-10-16 08:15:00 | AAPL | Stock | 5.8964 | 5.8964 | 5.8857 | 5.8861 | 187880.0 |
| 2007-10-16 08:20:00 | AAPL | Stock | 5.8907 | 5.8929 | 5.8861 | 5.8929 | 339948.0 |
| 2007-10-16 08:25:00 | AAPL | Stock | 5.8939 | 5.9 | 5.8929 | 5.8929 | 164640.0 |
| 2007-10-16 08:30:00 | AAPL | Stock | 5.8929 | 5.9204 | 5.8907 | 5.9089 | 823788.0 |
| 2007-10-16 08:35:00 | AAPL | Stock | 5.9107 | 5.9161 | 5.9011 | 5.9011 | 668052.0 |
| 2007-10-16 08:40:00 | AAPL | Stock | 5.9 | 5.9111 | 5.8946 | 5.9107 | 399084.0 |
| 2007-10-16 08:45:00 | AAPL | Stock | 5.9114 | 5.9193 | 5.9036 | 5.9193 | 994168.0 |
| 2007-10-16 08:50:00 | AAPL | Stock | 5.9171 | 5.9193 | 5.9064 | 5.9168 | 299292.0 |
| 2007-10-16 08:55:00 | AAPL | Stock | 5.9161 | 5.9193 | 5.9129 | 5.9171 | 315588.0 |
| 2007-10-16 09:00:00 | AAPL | Stock | 5.9164 | 5.9179 | 5.9132 | 5.9175 | 305844.0 |
| 2007-10-16 09:05:00 | AAPL | Stock | 5.9168 | 5.9168 | 5.9071 | 5.9075 | 351288.0 |
| 2007-10-16 09:10:00 | AAPL | Stock | 5.9071 | 5.9143 | 5.9071 | 5.9125 | 147728.0 |
| 2007-10-16 09:15:00 | AAPL | Stock | 5.9114 | 5.9143 | 5.9114 | 5.9143 | 167776.0 |
| 2007-10-16 09:20:00 | AAPL | Stock | 5.9136 | 5.9143 | 5.9111 | 5.9125 | 167020.0 |
| 2007-10-16 09:25:00 | AAPL | Stock | 5.9114 | 5.9143 | 5.8989 | 5.9121 | 449596.0 |
| 2007-10-16 09:30:00 | AAPL | Stock | 5.9118 | 5.9371 | 5.8993 | 5.9268 | 24885364.0 |
| 2007-10-16 09:35:00 | AAPL | Stock | 5.9268 | 5.9407 | 5.9107 | 5.9304 | 19200104.0 |
| 2007-10-16 09:40:00 | AAPL | Stock | 5.9307 | 5.9511 | 5.9268 | 5.9418 | 19277132.0 |
| 2007-10-16 09:45:00 | AAPL | Stock | 5.9429 | 5.9489 | 5.9218 | 5.938 | 18147220.0 |
| 2007-10-16 09:50:00 | AAPL | Stock | 5.9374 | 5.9614 | 5.9364 | 5.9464 | 22723484.0 |
| 2007-10-16 09:55:00 | AAPL | Stock | 5.9464 | 5.9764 | 5.9454 | 5.9746 | 24588900.0 |
| 2007-10-16 10:00:00 | AAPL | Stock | 5.9743 | 5.9754 | 5.9561 | 5.9579 | 15085952.0 |
| 2007-10-16 10:05:00 | AAPL | Stock | 5.9596 | 6.0061 | 5.9543 | 6.0046 | 26057724.0 |
| 2007-10-16 10:10:00 | AAPL | Stock | 6.0043 | 6.0093 | 5.9729 | 5.9736 | 21315392.0 |
| 2007-10-16 10:15:00 | AAPL | Stock | 5.9739 | 5.9821 | 5.9604 | 5.98 | 19976068.0 |
| 2007-10-16 10:20:00 | AAPL | Stock | 5.9796 | 5.99 | 5.9704 | 5.9825 | 15681848.0 |
| 2007-10-16 10:25:00 | AAPL | Stock | 5.9818 | 5.9857 | 5.9571 | 5.9793 | 19712924.0 |
| 2007-10-16 10:30:00 | AAPL | Stock | 5.9793 | 5.9929 | 5.9718 | 5.9904 | 13727000.0 |
| 2007-10-16 10:35:00 | AAPL | Stock | 5.99 | 6.005 | 5.9864 | 5.99 | 15948324.0 |
| 2007-10-16 10:40:00 | AAPL | Stock | 5.99 | 6.0036 | 5.9807 | 5.9875 | 11966024.0 |
| 2007-10-16 10:45:00 | AAPL | Stock | 5.9881 | 6.005 | 5.9836 | 6.0024 | 12171348.0 |
> showing 50 of 306,095 rows — these rows as CSV