PREVIEW / stock_5min / 2009-12-15
file: by_date/stock_5min/2009/2009-12-15.parquet size: 4.7 MB rows: 325,117 symbols: 3,432
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 |
|---|---|---|---|---|---|---|---|
| 2009-12-15 04:30:00 | AAPL | Stock | 6.9989 | 6.9989 | 6.9989 | 6.9989 | 2800.0 |
| 2009-12-15 07:30:00 | AAPL | Stock | 7.0018 | 7.0018 | 7.0018 | 7.0018 | 8400.0 |
| 2009-12-15 07:50:00 | AAPL | Stock | 6.9989 | 6.9989 | 6.9989 | 6.9989 | 2800.0 |
| 2009-12-15 07:55:00 | AAPL | Stock | 7.0004 | 7.0004 | 7.0004 | 7.0004 | 7000.0 |
| 2009-12-15 08:00:00 | AAPL | Stock | 7.0179 | 7.0179 | 6.9936 | 7.0154 | 180320.0 |
| 2009-12-15 08:10:00 | AAPL | Stock | 7.0071 | 7.0071 | 6.9946 | 6.9968 | 61824.0 |
| 2009-12-15 08:15:00 | AAPL | Stock | 7.0 | 7.0007 | 6.9964 | 7.0004 | 205940.0 |
| 2009-12-15 08:20:00 | AAPL | Stock | 7.0004 | 7.0029 | 7.0004 | 7.0029 | 16800.0 |
| 2009-12-15 08:25:00 | AAPL | Stock | 7.0025 | 7.0054 | 7.0025 | 7.0054 | 50400.0 |
| 2009-12-15 08:30:00 | AAPL | Stock | 7.0011 | 7.0054 | 6.9857 | 6.9857 | 519680.0 |
| 2009-12-15 08:35:00 | AAPL | Stock | 6.9868 | 6.9886 | 6.9836 | 6.9857 | 148680.0 |
| 2009-12-15 08:40:00 | AAPL | Stock | 6.9857 | 6.9857 | 6.9821 | 6.985 | 137480.0 |
| 2009-12-15 08:45:00 | AAPL | Stock | 6.985 | 6.9911 | 6.985 | 6.9868 | 44520.0 |
| 2009-12-15 08:50:00 | AAPL | Stock | 6.9921 | 6.9957 | 6.9921 | 6.9954 | 22400.0 |
| 2009-12-15 08:55:00 | AAPL | Stock | 6.9957 | 7.0071 | 6.9957 | 7.0064 | 373800.0 |
| 2009-12-15 09:00:00 | AAPL | Stock | 7.0064 | 7.0075 | 6.9968 | 7.0018 | 159040.0 |
| 2009-12-15 09:05:00 | AAPL | Stock | 6.9979 | 7.0007 | 6.9964 | 6.9971 | 198800.0 |
| 2009-12-15 09:10:00 | AAPL | Stock | 6.9946 | 6.9946 | 6.9839 | 6.9921 | 92260.0 |
| 2009-12-15 09:15:00 | AAPL | Stock | 6.9904 | 7.0 | 6.9889 | 6.9982 | 137844.0 |
| 2009-12-15 09:20:00 | AAPL | Stock | 7.0032 | 7.0032 | 6.9907 | 6.9907 | 144928.0 |
| 2009-12-15 09:25:00 | AAPL | Stock | 6.9911 | 6.9968 | 6.9907 | 6.9907 | 93800.0 |
| 2009-12-15 09:30:00 | AAPL | Stock | 6.9939 | 7.0004 | 6.9714 | 6.9736 | 12174988.0 |
| 2009-12-15 09:35:00 | AAPL | Stock | 6.9743 | 6.9911 | 6.9554 | 6.9557 | 13094116.0 |
| 2009-12-15 09:40:00 | AAPL | Stock | 6.9571 | 6.9725 | 6.9507 | 6.9646 | 10718344.0 |
| 2009-12-15 09:45:00 | AAPL | Stock | 6.965 | 6.9754 | 6.9607 | 6.9643 | 7457660.0 |
| 2009-12-15 09:50:00 | AAPL | Stock | 6.9657 | 6.9779 | 6.9643 | 6.9754 | 6224288.0 |
| 2009-12-15 09:55:00 | AAPL | Stock | 6.9757 | 6.9764 | 6.9686 | 6.9689 | 5010600.0 |
| 2009-12-15 10:00:00 | AAPL | Stock | 6.9682 | 6.9875 | 6.9614 | 6.9837 | 8322608.0 |
| 2009-12-15 10:05:00 | AAPL | Stock | 6.9839 | 6.9989 | 6.9743 | 6.9951 | 6063624.0 |
| 2009-12-15 10:10:00 | AAPL | Stock | 6.9954 | 6.9954 | 6.9807 | 6.9818 | 4416580.0 |
| 2009-12-15 10:15:00 | AAPL | Stock | 6.9814 | 6.9982 | 6.9807 | 6.9925 | 7967036.0 |
| 2009-12-15 10:20:00 | AAPL | Stock | 6.9925 | 7.0057 | 6.9914 | 7.002 | 8036588.0 |
| 2009-12-15 10:25:00 | AAPL | Stock | 7.0032 | 7.0139 | 7.0021 | 7.0029 | 7406980.0 |
| 2009-12-15 10:30:00 | AAPL | Stock | 7.0039 | 7.0132 | 6.9986 | 7.01 | 6664756.0 |
| 2009-12-15 10:35:00 | AAPL | Stock | 7.01 | 7.0125 | 7.0007 | 7.0036 | 2968560.0 |
| 2009-12-15 10:40:00 | AAPL | Stock | 7.0039 | 7.0271 | 7.0039 | 7.0221 | 7057932.0 |
| 2009-12-15 10:45:00 | AAPL | Stock | 7.0218 | 7.04 | 7.0207 | 7.0373 | 7883036.0 |
| 2009-12-15 10:50:00 | AAPL | Stock | 7.0375 | 7.0539 | 7.0371 | 7.0416 | 9489368.0 |
| 2009-12-15 10:55:00 | AAPL | Stock | 7.0424 | 7.0461 | 7.0325 | 7.0343 | 6116544.0 |
| 2009-12-15 11:00:00 | AAPL | Stock | 7.035 | 7.0386 | 7.0136 | 7.0154 | 8114372.0 |
| 2009-12-15 11:05:00 | AAPL | Stock | 7.0157 | 7.0246 | 7.0143 | 7.0225 | 4285148.0 |
| 2009-12-15 11:10:00 | AAPL | Stock | 7.0221 | 7.0264 | 7.0093 | 7.015 | 4647664.0 |
| 2009-12-15 11:15:00 | AAPL | Stock | 7.015 | 7.0196 | 7.0093 | 7.0171 | 3465448.0 |
| 2009-12-15 11:20:00 | AAPL | Stock | 7.0179 | 7.0193 | 6.9914 | 6.9926 | 6235068.0 |
| 2009-12-15 11:25:00 | AAPL | Stock | 6.9939 | 7.0029 | 6.9929 | 6.9986 | 4500552.0 |
| 2009-12-15 11:30:00 | AAPL | Stock | 6.9979 | 7.0136 | 6.9971 | 7.0111 | 4357388.0 |
| 2009-12-15 11:35:00 | AAPL | Stock | 7.0121 | 7.0157 | 7.0096 | 7.0132 | 2724176.0 |
| 2009-12-15 11:40:00 | AAPL | Stock | 7.0125 | 7.0139 | 7.0075 | 7.0096 | 1665524.0 |
| 2009-12-15 11:45:00 | AAPL | Stock | 7.0107 | 7.0214 | 7.0075 | 7.0089 | 4764648.0 |
| 2009-12-15 11:50:00 | AAPL | Stock | 7.0089 | 7.0096 | 6.9996 | 7.0036 | 3364704.0 |
> showing 50 of 325,117 rows — these rows as CSV