PREVIEW / stock_5min / 2007-09-18
file: by_date/stock_5min/2007/2007-09-18.parquet size: 4.1 MB rows: 296,125 symbols: 3,121
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 |
|---|---|---|---|---|---|---|---|
| 2007-09-18 09:30:00 | AAPL | Stock | 4.9664 | 4.975 | 4.9411 | 4.945 | 21863352.0 |
| 2007-09-18 09:35:00 | AAPL | Stock | 4.9461 | 4.9461 | 4.9293 | 4.9346 | 16790396.0 |
| 2007-09-18 09:40:00 | AAPL | Stock | 4.9357 | 4.9593 | 4.9339 | 4.9571 | 14414288.0 |
| 2007-09-18 09:45:00 | AAPL | Stock | 4.9561 | 4.9571 | 4.9457 | 4.9465 | 7513996.0 |
| 2007-09-18 09:50:00 | AAPL | Stock | 4.9457 | 4.9459 | 4.9257 | 4.9386 | 13280540.0 |
| 2007-09-18 09:55:00 | AAPL | Stock | 4.9386 | 4.9446 | 4.9325 | 4.9404 | 6757408.0 |
| 2007-09-18 10:00:00 | AAPL | Stock | 4.94 | 4.94 | 4.9304 | 4.9373 | 6944168.0 |
| 2007-09-18 10:05:00 | AAPL | Stock | 4.9371 | 4.9429 | 4.9296 | 4.9429 | 7427532.0 |
| 2007-09-18 10:10:00 | AAPL | Stock | 4.9429 | 4.9536 | 4.9425 | 4.9464 | 10355072.0 |
| 2007-09-18 10:15:00 | AAPL | Stock | 4.9461 | 4.9475 | 4.9311 | 4.9326 | 7338856.0 |
| 2007-09-18 10:20:00 | AAPL | Stock | 4.9329 | 4.9393 | 4.9296 | 4.9332 | 11731244.0 |
| 2007-09-18 10:25:00 | AAPL | Stock | 4.9325 | 4.9414 | 4.9225 | 4.9404 | 12094096.0 |
| 2007-09-18 10:30:00 | AAPL | Stock | 4.9404 | 4.9475 | 4.935 | 4.9396 | 8712424.0 |
| 2007-09-18 10:35:00 | AAPL | Stock | 4.9394 | 4.9394 | 4.9304 | 4.933 | 6647060.0 |
| 2007-09-18 10:40:00 | AAPL | Stock | 4.9329 | 4.9407 | 4.9318 | 4.9364 | 5981416.0 |
| 2007-09-18 10:45:00 | AAPL | Stock | 4.9357 | 4.9382 | 4.9332 | 4.9364 | 2976288.0 |
| 2007-09-18 10:50:00 | AAPL | Stock | 4.9361 | 4.9457 | 4.935 | 4.9429 | 6828948.0 |
| 2007-09-18 10:55:00 | AAPL | Stock | 4.9425 | 4.9532 | 4.9425 | 4.9514 | 9771552.0 |
| 2007-09-18 11:00:00 | AAPL | Stock | 4.9525 | 4.9593 | 4.9454 | 4.9586 | 10926888.0 |
| 2007-09-18 11:05:00 | AAPL | Stock | 4.9589 | 4.9643 | 4.9568 | 4.9611 | 10549280.0 |
| 2007-09-18 11:10:00 | AAPL | Stock | 4.9607 | 4.9768 | 4.9607 | 4.9721 | 20083448.0 |
| 2007-09-18 11:15:00 | AAPL | Stock | 4.9729 | 4.975 | 4.9625 | 4.9632 | 8485148.0 |
| 2007-09-18 11:20:00 | AAPL | Stock | 4.9632 | 4.9686 | 4.9589 | 4.9636 | 5986232.0 |
| 2007-09-18 11:25:00 | AAPL | Stock | 4.9636 | 4.9668 | 4.9539 | 4.9543 | 7406644.0 |
| 2007-09-18 11:30:00 | AAPL | Stock | 4.9539 | 4.9586 | 4.9518 | 4.9557 | 6237392.0 |
| 2007-09-18 11:35:00 | AAPL | Stock | 4.9571 | 4.9611 | 4.9554 | 4.9579 | 5380368.0 |
| 2007-09-18 11:40:00 | AAPL | Stock | 4.9586 | 4.9607 | 4.9536 | 4.9543 | 4734016.0 |
| 2007-09-18 11:45:00 | AAPL | Stock | 4.9546 | 4.9571 | 4.9529 | 4.9546 | 3269420.0 |
| 2007-09-18 11:50:00 | AAPL | Stock | 4.9546 | 4.9582 | 4.9514 | 4.9557 | 3620652.0 |
| 2007-09-18 11:55:00 | AAPL | Stock | 4.9557 | 4.9571 | 4.9518 | 4.9521 | 3397828.0 |
| 2007-09-18 12:00:00 | AAPL | Stock | 4.9521 | 4.9561 | 4.95 | 4.9502 | 2789808.0 |
| 2007-09-18 12:05:00 | AAPL | Stock | 4.9504 | 4.9504 | 4.9443 | 4.9472 | 5067720.0 |
| 2007-09-18 12:10:00 | AAPL | Stock | 4.9471 | 4.95 | 4.9443 | 4.9482 | 3338580.0 |
| 2007-09-18 12:15:00 | AAPL | Stock | 4.9489 | 4.9529 | 4.9479 | 4.9511 | 2813020.0 |
| 2007-09-18 12:20:00 | AAPL | Stock | 4.9514 | 4.9564 | 4.9501 | 4.9521 | 3774064.0 |
| 2007-09-18 12:25:00 | AAPL | Stock | 4.9518 | 4.9554 | 4.95 | 4.9536 | 1975708.0 |
| 2007-09-18 12:30:00 | AAPL | Stock | 4.9529 | 4.9607 | 4.9521 | 4.9607 | 3103212.0 |
| 2007-09-18 12:35:00 | AAPL | Stock | 4.9607 | 4.9625 | 4.9554 | 4.9561 | 3010784.0 |
| 2007-09-18 12:40:00 | AAPL | Stock | 4.9561 | 4.9621 | 4.9546 | 4.9621 | 2968336.0 |
| 2007-09-18 12:45:00 | AAPL | Stock | 4.9624 | 4.9654 | 4.96 | 4.9607 | 3846892.0 |
| 2007-09-18 12:50:00 | AAPL | Stock | 4.9611 | 4.9636 | 4.9607 | 4.9618 | 1807792.0 |
| 2007-09-18 12:55:00 | AAPL | Stock | 4.9618 | 4.9625 | 4.9579 | 4.9582 | 2286508.0 |
| 2007-09-18 13:00:00 | AAPL | Stock | 4.9586 | 4.9611 | 4.9554 | 4.9557 | 2720088.0 |
| 2007-09-18 13:05:00 | AAPL | Stock | 4.9556 | 4.9557 | 4.9425 | 4.9439 | 6532148.0 |
| 2007-09-18 13:10:00 | AAPL | Stock | 4.9439 | 4.9497 | 4.9432 | 4.9464 | 4098276.0 |
| 2007-09-18 13:15:00 | AAPL | Stock | 4.9462 | 4.9504 | 4.945 | 4.9475 | 2932860.0 |
| 2007-09-18 13:20:00 | AAPL | Stock | 4.9475 | 4.9479 | 4.9443 | 4.9471 | 3021116.0 |
| 2007-09-18 13:25:00 | AAPL | Stock | 4.9471 | 4.9514 | 4.9449 | 4.9493 | 3766168.0 |
| 2007-09-18 13:30:00 | AAPL | Stock | 4.9489 | 4.9514 | 4.9482 | 4.95 | 2247532.0 |
| 2007-09-18 13:35:00 | AAPL | Stock | 4.95 | 4.9507 | 4.9468 | 4.9482 | 1723792.0 |
> showing 50 of 296,125 rows — these rows as CSV