PREVIEW / stock_5min / 2010-03-10
file: by_date/stock_5min/2010/2010-03-10.parquet size: 4.8 MB rows: 329,445 symbols: 3,452
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 |
|---|---|---|---|---|---|---|---|
| 2010-03-10 06:30:00 | AAPL | Stock | 8.0007 | 8.0007 | 8.0007 | 8.0007 | 4424.0 |
| 2010-03-10 06:55:00 | AAPL | Stock | 8.0007 | 8.0007 | 8.0007 | 8.0007 | 8400.0 |
| 2010-03-10 07:05:00 | AAPL | Stock | 8.0 | 8.0004 | 7.9964 | 7.9968 | 49840.0 |
| 2010-03-10 07:10:00 | AAPL | Stock | 7.9993 | 7.9993 | 7.9989 | 7.9989 | 11200.0 |
| 2010-03-10 07:15:00 | AAPL | Stock | 8.0036 | 8.0036 | 8.0032 | 8.0032 | 28140.0 |
| 2010-03-10 07:20:00 | AAPL | Stock | 8.0 | 8.0 | 8.0 | 8.0 | 25200.0 |
| 2010-03-10 07:30:00 | AAPL | Stock | 7.9964 | 7.9964 | 7.9964 | 7.9964 | 2800.0 |
| 2010-03-10 07:35:00 | AAPL | Stock | 8.0 | 8.0 | 7.9946 | 7.9957 | 14000.0 |
| 2010-03-10 07:45:00 | AAPL | Stock | 7.9936 | 7.9936 | 7.9932 | 7.9932 | 16800.0 |
| 2010-03-10 07:50:00 | AAPL | Stock | 7.9971 | 8.0014 | 7.9964 | 8.0014 | 46200.0 |
| 2010-03-10 07:55:00 | AAPL | Stock | 8.0 | 8.0 | 8.0 | 8.0 | 8400.0 |
| 2010-03-10 08:00:00 | AAPL | Stock | 7.9946 | 8.0096 | 7.9946 | 8.0048 | 837396.0 |
| 2010-03-10 08:05:00 | AAPL | Stock | 8.0029 | 8.0054 | 8.0014 | 8.0054 | 327264.0 |
| 2010-03-10 08:10:00 | AAPL | Stock | 8.0071 | 8.0093 | 8.0029 | 8.0036 | 219100.0 |
| 2010-03-10 08:15:00 | AAPL | Stock | 8.0054 | 8.0075 | 8.0029 | 8.0071 | 108108.0 |
| 2010-03-10 08:20:00 | AAPL | Stock | 8.0071 | 8.0086 | 8.0061 | 8.0082 | 42280.0 |
| 2010-03-10 08:25:00 | AAPL | Stock | 8.0046 | 8.0164 | 8.0046 | 8.0143 | 264264.0 |
| 2010-03-10 08:30:00 | AAPL | Stock | 8.0143 | 8.0157 | 8.0111 | 8.0139 | 213528.0 |
| 2010-03-10 08:35:00 | AAPL | Stock | 8.0141 | 8.0155 | 8.0111 | 8.0129 | 99960.0 |
| 2010-03-10 08:40:00 | AAPL | Stock | 8.0125 | 8.0161 | 8.0039 | 8.0154 | 395612.0 |
| 2010-03-10 08:45:00 | AAPL | Stock | 8.015 | 8.0161 | 8.0139 | 8.0139 | 201292.0 |
| 2010-03-10 08:50:00 | AAPL | Stock | 8.0132 | 8.015 | 8.0114 | 8.0129 | 197400.0 |
| 2010-03-10 08:55:00 | AAPL | Stock | 8.0114 | 8.0125 | 8.0071 | 8.0071 | 133532.0 |
| 2010-03-10 09:00:00 | AAPL | Stock | 8.0073 | 8.0079 | 8.0036 | 8.0057 | 170884.0 |
| 2010-03-10 09:05:00 | AAPL | Stock | 8.0068 | 8.0068 | 8.0036 | 8.0036 | 209664.0 |
| 2010-03-10 09:10:00 | AAPL | Stock | 8.0037 | 8.0037 | 7.995 | 7.9979 | 256312.0 |
| 2010-03-10 09:15:00 | AAPL | Stock | 7.9982 | 8.005 | 7.9982 | 8.0029 | 274400.0 |
| 2010-03-10 09:20:00 | AAPL | Stock | 8.0046 | 8.01 | 8.0046 | 8.0079 | 71484.0 |
| 2010-03-10 09:25:00 | AAPL | Stock | 8.0061 | 8.0064 | 7.9879 | 7.9946 | 345716.0 |
| 2010-03-10 09:30:00 | AAPL | Stock | 7.9932 | 8.0318 | 7.9889 | 8.0168 | 17274964.0 |
| 2010-03-10 09:35:00 | AAPL | Stock | 8.0175 | 8.0221 | 8.0007 | 8.0164 | 15720740.0 |
| 2010-03-10 09:40:00 | AAPL | Stock | 8.0164 | 8.0175 | 7.9932 | 8.0054 | 12708556.0 |
| 2010-03-10 09:45:00 | AAPL | Stock | 8.0053 | 8.0086 | 7.9782 | 7.9921 | 13612816.0 |
| 2010-03-10 09:50:00 | AAPL | Stock | 7.9918 | 7.9921 | 7.9714 | 7.9868 | 12537000.0 |
| 2010-03-10 09:55:00 | AAPL | Stock | 7.9857 | 8.0029 | 7.9821 | 7.9957 | 9175208.0 |
| 2010-03-10 10:00:00 | AAPL | Stock | 7.9957 | 8.0113 | 7.9929 | 8.0035 | 10255084.0 |
| 2010-03-10 10:05:00 | AAPL | Stock | 8.0021 | 8.0179 | 7.9964 | 8.0168 | 8919064.0 |
| 2010-03-10 10:10:00 | AAPL | Stock | 8.0166 | 8.0179 | 8.0093 | 8.0093 | 7950796.0 |
| 2010-03-10 10:15:00 | AAPL | Stock | 8.0089 | 8.0114 | 7.9936 | 7.9936 | 9375240.0 |
| 2010-03-10 10:20:00 | AAPL | Stock | 7.9936 | 8.0046 | 7.9893 | 7.9893 | 6044808.0 |
| 2010-03-10 10:25:00 | AAPL | Stock | 7.9893 | 8.0175 | 7.9893 | 8.0146 | 9232776.0 |
| 2010-03-10 10:30:00 | AAPL | Stock | 8.015 | 8.0175 | 8.0064 | 8.0082 | 6706280.0 |
| 2010-03-10 10:35:00 | AAPL | Stock | 8.0075 | 8.025 | 8.0043 | 8.0246 | 8069684.0 |
| 2010-03-10 10:40:00 | AAPL | Stock | 8.025 | 8.0302 | 8.0189 | 8.0243 | 9257892.0 |
| 2010-03-10 10:45:00 | AAPL | Stock | 8.0243 | 8.025 | 8.0143 | 8.0179 | 4261964.0 |
| 2010-03-10 10:50:00 | AAPL | Stock | 8.0175 | 8.0236 | 8.0143 | 8.0168 | 5127500.0 |
| 2010-03-10 10:55:00 | AAPL | Stock | 8.0171 | 8.0261 | 8.0157 | 8.0186 | 3984204.0 |
| 2010-03-10 11:00:00 | AAPL | Stock | 8.0193 | 8.0341 | 8.0193 | 8.0339 | 10101056.0 |
| 2010-03-10 11:05:00 | AAPL | Stock | 8.0332 | 8.0343 | 8.0225 | 8.0275 | 5618872.0 |
| 2010-03-10 11:10:00 | AAPL | Stock | 8.0282 | 8.0307 | 8.02 | 8.0239 | 4341120.0 |
> showing 50 of 329,445 rows — these rows as CSV