PREVIEW / stock_5min / 2010-10-22
file: by_date/stock_5min/2010/2010-10-22.parquet size: 4.5 MB rows: 310,524 symbols: 3,491
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-10-22 05:15:00 | AAPL | Stock | 10.9643 | 10.9643 | 10.9643 | 10.9643 | 11200.0 |
| 2010-10-22 05:40:00 | AAPL | Stock | 10.9643 | 10.9643 | 10.9643 | 10.9643 | 11200.0 |
| 2010-10-22 07:00:00 | AAPL | Stock | 10.9925 | 11.0157 | 10.9925 | 11.0061 | 25396.0 |
| 2010-10-22 07:05:00 | AAPL | Stock | 11.0 | 11.0054 | 11.0 | 11.0054 | 20804.0 |
| 2010-10-22 07:10:00 | AAPL | Stock | 11.0007 | 11.0007 | 11.0007 | 11.0007 | 2800.0 |
| 2010-10-22 07:20:00 | AAPL | Stock | 11.0107 | 11.0107 | 11.0107 | 11.0107 | 8400.0 |
| 2010-10-22 07:25:00 | AAPL | Stock | 11.0161 | 11.0161 | 11.0161 | 11.0161 | 2800.0 |
| 2010-10-22 07:30:00 | AAPL | Stock | 11.0154 | 11.0161 | 11.0089 | 11.0089 | 16464.0 |
| 2010-10-22 07:35:00 | AAPL | Stock | 11.0107 | 11.0143 | 11.0107 | 11.0143 | 22400.0 |
| 2010-10-22 07:40:00 | AAPL | Stock | 11.0246 | 11.025 | 11.0214 | 11.0214 | 42000.0 |
| 2010-10-22 07:50:00 | AAPL | Stock | 11.0207 | 11.0207 | 11.0182 | 11.0182 | 5600.0 |
| 2010-10-22 07:55:00 | AAPL | Stock | 11.0182 | 11.025 | 11.0179 | 11.025 | 33600.0 |
| 2010-10-22 08:00:00 | AAPL | Stock | 11.0214 | 11.0429 | 11.0089 | 11.0304 | 480592.0 |
| 2010-10-22 08:05:00 | AAPL | Stock | 11.0232 | 11.0311 | 11.0107 | 11.0107 | 155624.0 |
| 2010-10-22 08:10:00 | AAPL | Stock | 11.0039 | 11.0107 | 11.0039 | 11.0107 | 66164.0 |
| 2010-10-22 08:15:00 | AAPL | Stock | 11.0107 | 11.0154 | 11.0061 | 11.0061 | 222600.0 |
| 2010-10-22 08:20:00 | AAPL | Stock | 11.0071 | 11.0125 | 11.0054 | 11.0125 | 86100.0 |
| 2010-10-22 08:25:00 | AAPL | Stock | 11.0125 | 11.0243 | 11.0082 | 11.0243 | 106400.0 |
| 2010-10-22 08:30:00 | AAPL | Stock | 11.0239 | 11.0389 | 11.0239 | 11.0354 | 380632.0 |
| 2010-10-22 08:35:00 | AAPL | Stock | 11.0368 | 11.0368 | 11.0254 | 11.0289 | 184100.0 |
| 2010-10-22 08:40:00 | AAPL | Stock | 11.0282 | 11.0282 | 11.0161 | 11.0161 | 305956.0 |
| 2010-10-22 08:45:00 | AAPL | Stock | 11.0154 | 11.0236 | 11.0139 | 11.0139 | 370440.0 |
| 2010-10-22 08:50:00 | AAPL | Stock | 11.0143 | 11.0286 | 11.0114 | 11.0264 | 208908.0 |
| 2010-10-22 08:55:00 | AAPL | Stock | 11.0311 | 11.0411 | 11.0311 | 11.0357 | 114828.0 |
| 2010-10-22 09:00:00 | AAPL | Stock | 11.0357 | 11.0625 | 11.0293 | 11.0564 | 399308.0 |
| 2010-10-22 09:05:00 | AAPL | Stock | 11.0586 | 11.0632 | 11.0536 | 11.055 | 347452.0 |
| 2010-10-22 09:10:00 | AAPL | Stock | 11.0554 | 11.0814 | 11.0554 | 11.0596 | 1126384.0 |
| 2010-10-22 09:15:00 | AAPL | Stock | 11.0589 | 11.0604 | 11.0411 | 11.0464 | 458080.0 |
| 2010-10-22 09:20:00 | AAPL | Stock | 11.0464 | 11.0482 | 11.0454 | 11.0454 | 44156.0 |
| 2010-10-22 09:25:00 | AAPL | Stock | 11.0464 | 11.0532 | 11.0329 | 11.0425 | 495824.0 |
| 2010-10-22 09:30:00 | AAPL | Stock | 11.0396 | 11.0482 | 10.9939 | 11.0229 | 18987724.0 |
| 2010-10-22 09:35:00 | AAPL | Stock | 11.0229 | 11.0668 | 11.0036 | 11.0668 | 9218440.0 |
| 2010-10-22 09:40:00 | AAPL | Stock | 11.0632 | 11.0729 | 11.0511 | 11.0561 | 10943828.0 |
| 2010-10-22 09:45:00 | AAPL | Stock | 11.0564 | 11.0593 | 11.0214 | 11.0271 | 8249108.0 |
| 2010-10-22 09:50:00 | AAPL | Stock | 11.0287 | 11.0307 | 11.0093 | 11.0143 | 7466312.0 |
| 2010-10-22 09:55:00 | AAPL | Stock | 11.0139 | 11.0293 | 11.0071 | 11.0136 | 6049064.0 |
| 2010-10-22 10:00:00 | AAPL | Stock | 11.0139 | 11.0139 | 10.975 | 10.9982 | 10229800.0 |
| 2010-10-22 10:05:00 | AAPL | Stock | 10.9995 | 11.0093 | 10.9871 | 10.9954 | 5374040.0 |
| 2010-10-22 10:10:00 | AAPL | Stock | 10.9961 | 11.0007 | 10.9689 | 10.9934 | 6877696.0 |
| 2010-10-22 10:15:00 | AAPL | Stock | 10.9954 | 10.9957 | 10.9689 | 10.9882 | 6695332.0 |
| 2010-10-22 10:20:00 | AAPL | Stock | 10.9855 | 11.0 | 10.975 | 10.9864 | 5769036.0 |
| 2010-10-22 10:25:00 | AAPL | Stock | 10.9864 | 11.0 | 10.9861 | 10.9964 | 4689076.0 |
| 2010-10-22 10:30:00 | AAPL | Stock | 10.9964 | 11.0264 | 10.9939 | 11.0252 | 6403264.0 |
| 2010-10-22 10:35:00 | AAPL | Stock | 11.0252 | 11.0261 | 11.0071 | 11.0118 | 3680376.0 |
| 2010-10-22 10:40:00 | AAPL | Stock | 11.0125 | 11.02 | 11.0071 | 11.015 | 2399992.0 |
| 2010-10-22 10:45:00 | AAPL | Stock | 11.0125 | 11.0293 | 11.0107 | 11.0257 | 3532144.0 |
| 2010-10-22 10:50:00 | AAPL | Stock | 11.0264 | 11.0393 | 11.0225 | 11.0393 | 5175072.0 |
| 2010-10-22 10:55:00 | AAPL | Stock | 11.0389 | 11.0568 | 11.0321 | 11.0405 | 7340564.0 |
| 2010-10-22 11:00:00 | AAPL | Stock | 11.0393 | 11.0529 | 11.0282 | 11.0525 | 4481848.0 |
| 2010-10-22 11:05:00 | AAPL | Stock | 11.0525 | 11.0536 | 11.0314 | 11.0322 | 4225396.0 |
> showing 50 of 310,524 rows — these rows as CSV