PREVIEW / stock_5min / 2012-01-30
file: by_date/stock_5min/2012/2012-01-30.parquet size: 4.8 MB rows: 320,399 symbols: 3,529
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 |
|---|---|---|---|---|---|---|---|
| 2012-01-30 04:00:00 | AAPL | Stock | 15.9218 | 15.9218 | 15.9204 | 15.9204 | 11200.0 |
| 2012-01-30 04:25:00 | AAPL | Stock | 15.925 | 15.925 | 15.925 | 15.925 | 2800.0 |
| 2012-01-30 04:30:00 | AAPL | Stock | 15.9068 | 15.9068 | 15.9032 | 15.9032 | 5600.0 |
| 2012-01-30 04:35:00 | AAPL | Stock | 15.9021 | 15.9021 | 15.8979 | 15.8979 | 12600.0 |
| 2012-01-30 04:40:00 | AAPL | Stock | 15.8932 | 15.8932 | 15.8929 | 15.8929 | 30940.0 |
| 2012-01-30 04:50:00 | AAPL | Stock | 15.8893 | 15.8893 | 15.8854 | 15.8854 | 16800.0 |
| 2012-01-30 05:00:00 | AAPL | Stock | 15.8964 | 15.9075 | 15.8946 | 15.8946 | 16800.0 |
| 2012-01-30 05:05:00 | AAPL | Stock | 15.8929 | 15.8929 | 15.8929 | 15.8929 | 5600.0 |
| 2012-01-30 05:20:00 | AAPL | Stock | 15.8964 | 15.8964 | 15.8964 | 15.8964 | 5600.0 |
| 2012-01-30 05:30:00 | AAPL | Stock | 15.9075 | 15.9075 | 15.9075 | 15.9075 | 8400.0 |
| 2012-01-30 06:35:00 | AAPL | Stock | 15.9211 | 15.9214 | 15.9211 | 15.9214 | 30800.0 |
| 2012-01-30 06:55:00 | AAPL | Stock | 15.9107 | 15.9107 | 15.9086 | 15.9086 | 28000.0 |
| 2012-01-30 07:00:00 | AAPL | Stock | 15.9214 | 15.9286 | 15.9107 | 15.9179 | 54824.0 |
| 2012-01-30 07:05:00 | AAPL | Stock | 15.9196 | 15.9454 | 15.9196 | 15.9454 | 14000.0 |
| 2012-01-30 07:10:00 | AAPL | Stock | 15.9457 | 15.9507 | 15.9296 | 15.9375 | 56280.0 |
| 2012-01-30 07:15:00 | AAPL | Stock | 15.9296 | 15.9296 | 15.9114 | 15.9114 | 68320.0 |
| 2012-01-30 07:20:00 | AAPL | Stock | 15.9239 | 15.9239 | 15.9196 | 15.9239 | 38920.0 |
| 2012-01-30 07:25:00 | AAPL | Stock | 15.925 | 15.925 | 15.9179 | 15.9196 | 19600.0 |
| 2012-01-30 07:30:00 | AAPL | Stock | 15.9214 | 15.9214 | 15.9179 | 15.9179 | 33320.0 |
| 2012-01-30 07:40:00 | AAPL | Stock | 15.915 | 15.9161 | 15.9075 | 15.9082 | 93828.0 |
| 2012-01-30 07:45:00 | AAPL | Stock | 15.9029 | 15.9032 | 15.9029 | 15.9032 | 9324.0 |
| 2012-01-30 07:50:00 | AAPL | Stock | 15.9139 | 15.9139 | 15.9139 | 15.9139 | 5124.0 |
| 2012-01-30 07:55:00 | AAPL | Stock | 15.915 | 15.9157 | 15.915 | 15.9157 | 5600.0 |
| 2012-01-30 08:00:00 | AAPL | Stock | 15.9154 | 15.9268 | 15.9143 | 15.9214 | 98056.0 |
| 2012-01-30 08:05:00 | AAPL | Stock | 15.95 | 15.95 | 15.9179 | 15.9246 | 84140.0 |
| 2012-01-30 08:10:00 | AAPL | Stock | 15.9214 | 15.9214 | 15.9125 | 15.9179 | 52640.0 |
| 2012-01-30 08:15:00 | AAPL | Stock | 15.9125 | 15.9214 | 15.9107 | 15.9189 | 97860.0 |
| 2012-01-30 08:20:00 | AAPL | Stock | 15.9179 | 15.9196 | 15.9107 | 15.9107 | 49392.0 |
| 2012-01-30 08:25:00 | AAPL | Stock | 15.9171 | 15.9175 | 15.9104 | 15.9104 | 100044.0 |
| 2012-01-30 08:30:00 | AAPL | Stock | 15.9054 | 15.9143 | 15.9054 | 15.9071 | 85792.0 |
| 2012-01-30 08:35:00 | AAPL | Stock | 15.9061 | 15.9107 | 15.8964 | 15.8964 | 211232.0 |
| 2012-01-30 08:40:00 | AAPL | Stock | 15.8982 | 15.905 | 15.8864 | 15.8929 | 445704.0 |
| 2012-01-30 08:45:00 | AAPL | Stock | 15.8939 | 15.9 | 15.8929 | 15.8964 | 82488.0 |
| 2012-01-30 08:50:00 | AAPL | Stock | 15.8964 | 15.9036 | 15.8964 | 15.9036 | 124320.0 |
| 2012-01-30 08:55:00 | AAPL | Stock | 15.9039 | 15.9071 | 15.8929 | 15.8929 | 45836.0 |
| 2012-01-30 09:00:00 | AAPL | Stock | 15.8932 | 15.9111 | 15.8911 | 15.9043 | 359492.0 |
| 2012-01-30 09:05:00 | AAPL | Stock | 15.9036 | 15.9143 | 15.8996 | 15.9107 | 270200.0 |
| 2012-01-30 09:10:00 | AAPL | Stock | 15.9111 | 15.9232 | 15.9107 | 15.9146 | 75600.0 |
| 2012-01-30 09:15:00 | AAPL | Stock | 15.9214 | 15.9264 | 15.9214 | 15.9261 | 79380.0 |
| 2012-01-30 09:20:00 | AAPL | Stock | 15.9282 | 15.9282 | 15.9196 | 15.9196 | 80556.0 |
| 2012-01-30 09:25:00 | AAPL | Stock | 15.9243 | 15.9257 | 15.9175 | 15.9182 | 194264.0 |
| 2012-01-30 09:30:00 | AAPL | Stock | 15.9179 | 15.9718 | 15.9068 | 15.9418 | 10763536.0 |
| 2012-01-30 09:35:00 | AAPL | Stock | 15.9464 | 15.9675 | 15.9179 | 15.9615 | 6182568.0 |
| 2012-01-30 09:40:00 | AAPL | Stock | 15.9589 | 16.0243 | 15.9575 | 16.0064 | 13926668.0 |
| 2012-01-30 09:45:00 | AAPL | Stock | 16.0068 | 16.0125 | 15.9736 | 15.9789 | 5973940.0 |
| 2012-01-30 09:50:00 | AAPL | Stock | 15.9768 | 15.9871 | 15.955 | 15.9839 | 5090148.0 |
| 2012-01-30 09:55:00 | AAPL | Stock | 15.9839 | 16.01 | 15.9732 | 15.9914 | 5128172.0 |
| 2012-01-30 10:00:00 | AAPL | Stock | 15.9896 | 16.0146 | 15.9839 | 16.0121 | 5059796.0 |
| 2012-01-30 10:05:00 | AAPL | Stock | 16.0121 | 16.0211 | 15.9843 | 16.0179 | 6796608.0 |
| 2012-01-30 10:10:00 | AAPL | Stock | 16.0179 | 16.0218 | 15.9825 | 16.0218 | 6266820.0 |
> showing 50 of 320,399 rows — these rows as CSV