PREVIEW / stock_5min / 2010-08-19
file: by_date/stock_5min/2010/2010-08-19.parquet size: 4.7 MB rows: 327,167 symbols: 3,476
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-08-19 06:10:00 | AAPL | Stock | 9.065 | 9.0661 | 9.065 | 9.0661 | 9800.0 |
| 2010-08-19 07:20:00 | AAPL | Stock | 9.0643 | 9.0643 | 9.0643 | 9.0643 | 11200.0 |
| 2010-08-19 07:25:00 | AAPL | Stock | 9.0625 | 9.0625 | 9.0625 | 9.0625 | 2800.0 |
| 2010-08-19 07:30:00 | AAPL | Stock | 9.0564 | 9.0564 | 9.0557 | 9.0557 | 27720.0 |
| 2010-08-19 07:40:00 | AAPL | Stock | 9.0532 | 9.0536 | 9.0529 | 9.0529 | 28000.0 |
| 2010-08-19 07:45:00 | AAPL | Stock | 9.0529 | 9.0529 | 9.0529 | 9.0529 | 22400.0 |
| 2010-08-19 07:55:00 | AAPL | Stock | 9.0518 | 9.0518 | 9.0518 | 9.0518 | 2800.0 |
| 2010-08-19 08:00:00 | AAPL | Stock | 9.0589 | 9.0589 | 9.0507 | 9.0571 | 235760.0 |
| 2010-08-19 08:05:00 | AAPL | Stock | 9.0586 | 9.075 | 9.0586 | 9.0714 | 228060.0 |
| 2010-08-19 08:10:00 | AAPL | Stock | 9.075 | 9.075 | 9.0643 | 9.0657 | 134400.0 |
| 2010-08-19 08:15:00 | AAPL | Stock | 9.0671 | 9.0679 | 9.0625 | 9.0625 | 142688.0 |
| 2010-08-19 08:20:00 | AAPL | Stock | 9.0643 | 9.0857 | 9.0643 | 9.0786 | 200144.0 |
| 2010-08-19 08:25:00 | AAPL | Stock | 9.0818 | 9.0857 | 9.0786 | 9.0786 | 177380.0 |
| 2010-08-19 08:30:00 | AAPL | Stock | 9.085 | 9.0854 | 9.0 | 9.0071 | 1338540.0 |
| 2010-08-19 08:35:00 | AAPL | Stock | 9.0061 | 9.0175 | 8.9968 | 9.0136 | 417536.0 |
| 2010-08-19 08:40:00 | AAPL | Stock | 9.0179 | 9.0304 | 9.0011 | 9.0046 | 495600.0 |
| 2010-08-19 08:45:00 | AAPL | Stock | 9.0046 | 9.0146 | 9.0043 | 9.0146 | 156800.0 |
| 2010-08-19 08:50:00 | AAPL | Stock | 9.0146 | 9.0214 | 9.0139 | 9.0175 | 309148.0 |
| 2010-08-19 08:55:00 | AAPL | Stock | 9.0161 | 9.03 | 9.0114 | 9.0268 | 226968.0 |
| 2010-08-19 09:00:00 | AAPL | Stock | 9.0236 | 9.0357 | 9.0225 | 9.0357 | 217700.0 |
| 2010-08-19 09:05:00 | AAPL | Stock | 9.0311 | 9.0479 | 9.0304 | 9.0393 | 305396.0 |
| 2010-08-19 09:10:00 | AAPL | Stock | 9.0375 | 9.0407 | 9.0329 | 9.0357 | 54432.0 |
| 2010-08-19 09:15:00 | AAPL | Stock | 9.0332 | 9.0332 | 9.0311 | 9.0311 | 42000.0 |
| 2010-08-19 09:20:00 | AAPL | Stock | 9.0325 | 9.0425 | 9.0304 | 9.0304 | 61600.0 |
| 2010-08-19 09:25:00 | AAPL | Stock | 9.0304 | 9.0325 | 9.0304 | 9.0321 | 29400.0 |
| 2010-08-19 09:30:00 | AAPL | Stock | 9.0279 | 9.0464 | 9.0029 | 9.0261 | 11401124.0 |
| 2010-08-19 09:35:00 | AAPL | Stock | 9.0257 | 9.0529 | 9.0229 | 9.0373 | 8075116.0 |
| 2010-08-19 09:40:00 | AAPL | Stock | 9.0369 | 9.0482 | 9.0321 | 9.0404 | 3819200.0 |
| 2010-08-19 09:45:00 | AAPL | Stock | 9.04 | 9.0432 | 9.0111 | 9.0193 | 7563556.0 |
| 2010-08-19 09:50:00 | AAPL | Stock | 9.0193 | 9.02 | 8.9996 | 9.0036 | 9094708.0 |
| 2010-08-19 09:55:00 | AAPL | Stock | 9.0025 | 9.0168 | 8.9982 | 9.0125 | 8397508.0 |
| 2010-08-19 10:00:00 | AAPL | Stock | 9.0125 | 9.0129 | 8.9375 | 8.9511 | 20062644.0 |
| 2010-08-19 10:05:00 | AAPL | Stock | 8.9525 | 8.9839 | 8.9454 | 8.9833 | 12592020.0 |
| 2010-08-19 10:10:00 | AAPL | Stock | 8.9822 | 8.9854 | 8.9654 | 8.9682 | 7797832.0 |
| 2010-08-19 10:15:00 | AAPL | Stock | 8.9675 | 8.9886 | 8.9643 | 8.9871 | 5020148.0 |
| 2010-08-19 10:20:00 | AAPL | Stock | 8.9847 | 8.9868 | 8.9696 | 8.9779 | 3719240.0 |
| 2010-08-19 10:25:00 | AAPL | Stock | 8.9775 | 8.9778 | 8.9631 | 8.9682 | 4557784.0 |
| 2010-08-19 10:30:00 | AAPL | Stock | 8.9675 | 8.9704 | 8.9507 | 8.9679 | 5753804.0 |
| 2010-08-19 10:35:00 | AAPL | Stock | 8.9679 | 8.9736 | 8.9479 | 8.9486 | 5745852.0 |
| 2010-08-19 10:40:00 | AAPL | Stock | 8.9496 | 8.9561 | 8.9386 | 8.9507 | 8159368.0 |
| 2010-08-19 10:45:00 | AAPL | Stock | 8.9504 | 8.9675 | 8.9436 | 8.9646 | 4757144.0 |
| 2010-08-19 10:50:00 | AAPL | Stock | 8.9643 | 8.9675 | 8.9436 | 8.9461 | 4598972.0 |
| 2010-08-19 10:55:00 | AAPL | Stock | 8.9482 | 8.9629 | 8.9475 | 8.9525 | 3631880.0 |
| 2010-08-19 11:00:00 | AAPL | Stock | 8.9511 | 8.9532 | 8.9318 | 8.9332 | 7054852.0 |
| 2010-08-19 11:05:00 | AAPL | Stock | 8.9339 | 8.9436 | 8.9304 | 8.9343 | 5829208.0 |
| 2010-08-19 11:10:00 | AAPL | Stock | 8.9352 | 8.9457 | 8.9339 | 8.9368 | 4564588.0 |
| 2010-08-19 11:15:00 | AAPL | Stock | 8.9364 | 8.9404 | 8.9296 | 8.9361 | 3674972.0 |
| 2010-08-19 11:20:00 | AAPL | Stock | 8.9364 | 8.9468 | 8.9321 | 8.9354 | 3726380.0 |
| 2010-08-19 11:25:00 | AAPL | Stock | 8.9357 | 8.9493 | 8.9352 | 8.9429 | 3052364.0 |
| 2010-08-19 11:30:00 | AAPL | Stock | 8.9429 | 8.9432 | 8.9186 | 8.9243 | 10298848.0 |
> showing 50 of 327,167 rows — these rows as CSV