PREVIEW / stock_5min / 2005-07-08
file: by_date/stock_5min/2005/2005-07-08.parquet size: 2.7 MB rows: 199,284 symbols: 2,025
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 |
|---|---|---|---|---|---|---|---|
| 2005-07-08 08:15:00 | AAPL | Stock | 1.35 | 1.35 | 1.35 | 1.35 | 26740.0 |
| 2005-07-08 08:20:00 | AAPL | Stock | 1.3511 | 1.3518 | 1.3511 | 1.3518 | 67200.0 |
| 2005-07-08 08:25:00 | AAPL | Stock | 1.3546 | 1.3546 | 1.3543 | 1.3546 | 56000.0 |
| 2005-07-08 08:30:00 | AAPL | Stock | 1.3518 | 1.3518 | 1.3507 | 1.3514 | 25200.0 |
| 2005-07-08 08:35:00 | AAPL | Stock | 1.3521 | 1.3521 | 1.3521 | 1.3521 | 19600.0 |
| 2005-07-08 08:40:00 | AAPL | Stock | 1.3539 | 1.355 | 1.3536 | 1.3546 | 266840.0 |
| 2005-07-08 08:45:00 | AAPL | Stock | 1.3543 | 1.3543 | 1.3518 | 1.3518 | 47600.0 |
| 2005-07-08 08:50:00 | AAPL | Stock | 1.3507 | 1.3507 | 1.3504 | 1.3504 | 142800.0 |
| 2005-07-08 08:55:00 | AAPL | Stock | 1.3525 | 1.3525 | 1.345 | 1.3525 | 319200.0 |
| 2005-07-08 09:00:00 | AAPL | Stock | 1.3525 | 1.3525 | 1.3504 | 1.3504 | 58800.0 |
| 2005-07-08 09:05:00 | AAPL | Stock | 1.3511 | 1.3511 | 1.3511 | 1.3511 | 11200.0 |
| 2005-07-08 09:10:00 | AAPL | Stock | 1.3511 | 1.3543 | 1.3507 | 1.3543 | 414400.0 |
| 2005-07-08 09:20:00 | AAPL | Stock | 1.3518 | 1.3536 | 1.3518 | 1.3536 | 56000.0 |
| 2005-07-08 09:25:00 | AAPL | Stock | 1.3507 | 1.3525 | 1.3479 | 1.3521 | 486500.0 |
| 2005-07-08 09:30:00 | AAPL | Stock | 1.3525 | 1.3539 | 1.3464 | 1.3493 | 13570088.0 |
| 2005-07-08 09:35:00 | AAPL | Stock | 1.3482 | 1.35 | 1.3432 | 1.3464 | 8640968.0 |
| 2005-07-08 09:40:00 | AAPL | Stock | 1.3454 | 1.3521 | 1.345 | 1.3493 | 7370888.0 |
| 2005-07-08 09:45:00 | AAPL | Stock | 1.3493 | 1.3518 | 1.3489 | 1.3507 | 2796500.0 |
| 2005-07-08 09:50:00 | AAPL | Stock | 1.3504 | 1.3518 | 1.3496 | 1.35 | 3458476.0 |
| 2005-07-08 09:55:00 | AAPL | Stock | 1.35 | 1.3504 | 1.3454 | 1.3464 | 4397680.0 |
| 2005-07-08 10:00:00 | AAPL | Stock | 1.3468 | 1.3475 | 1.3421 | 1.3425 | 5395348.0 |
| 2005-07-08 10:05:00 | AAPL | Stock | 1.3425 | 1.3432 | 1.3389 | 1.3389 | 8385468.0 |
| 2005-07-08 10:10:00 | AAPL | Stock | 1.3389 | 1.3425 | 1.3382 | 1.3418 | 4690504.0 |
| 2005-07-08 10:15:00 | AAPL | Stock | 1.3418 | 1.3421 | 1.3396 | 1.34 | 3402560.0 |
| 2005-07-08 10:20:00 | AAPL | Stock | 1.3404 | 1.3421 | 1.3396 | 1.3414 | 3544352.0 |
| 2005-07-08 10:25:00 | AAPL | Stock | 1.3414 | 1.3443 | 1.3404 | 1.3443 | 3093580.0 |
| 2005-07-08 10:30:00 | AAPL | Stock | 1.3439 | 1.3461 | 1.3421 | 1.3439 | 3722040.0 |
| 2005-07-08 10:35:00 | AAPL | Stock | 1.3436 | 1.3457 | 1.3425 | 1.3429 | 2142728.0 |
| 2005-07-08 10:40:00 | AAPL | Stock | 1.3429 | 1.3432 | 1.34 | 1.3429 | 3857000.0 |
| 2005-07-08 10:45:00 | AAPL | Stock | 1.3429 | 1.345 | 1.3421 | 1.3446 | 3477068.0 |
| 2005-07-08 10:50:00 | AAPL | Stock | 1.3446 | 1.3457 | 1.3429 | 1.3432 | 2716784.0 |
| 2005-07-08 10:55:00 | AAPL | Stock | 1.3429 | 1.3436 | 1.3411 | 1.3432 | 2286116.0 |
| 2005-07-08 11:00:00 | AAPL | Stock | 1.3436 | 1.3436 | 1.3393 | 1.34 | 3433024.0 |
| 2005-07-08 11:05:00 | AAPL | Stock | 1.34 | 1.3418 | 1.3393 | 1.3396 | 2878988.0 |
| 2005-07-08 11:10:00 | AAPL | Stock | 1.34 | 1.3418 | 1.3396 | 1.3411 | 2534168.0 |
| 2005-07-08 11:15:00 | AAPL | Stock | 1.3417 | 1.3429 | 1.34 | 1.3404 | 2418052.0 |
| 2005-07-08 11:20:00 | AAPL | Stock | 1.3404 | 1.3429 | 1.34 | 1.3425 | 2741844.0 |
| 2005-07-08 11:25:00 | AAPL | Stock | 1.3425 | 1.3432 | 1.34 | 1.3407 | 1980832.0 |
| 2005-07-08 11:30:00 | AAPL | Stock | 1.3407 | 1.3436 | 1.3407 | 1.3432 | 1624112.0 |
| 2005-07-08 11:35:00 | AAPL | Stock | 1.3432 | 1.3432 | 1.3407 | 1.3407 | 1597512.0 |
| 2005-07-08 11:40:00 | AAPL | Stock | 1.3407 | 1.3425 | 1.3407 | 1.3414 | 1315468.0 |
| 2005-07-08 11:45:00 | AAPL | Stock | 1.3411 | 1.3418 | 1.3407 | 1.3407 | 944468.0 |
| 2005-07-08 11:50:00 | AAPL | Stock | 1.3411 | 1.3425 | 1.3407 | 1.3421 | 1509900.0 |
| 2005-07-08 11:55:00 | AAPL | Stock | 1.3418 | 1.3425 | 1.3407 | 1.3418 | 1896804.0 |
| 2005-07-08 12:00:00 | AAPL | Stock | 1.3418 | 1.3464 | 1.3414 | 1.3457 | 5421724.0 |
| 2005-07-08 12:05:00 | AAPL | Stock | 1.3457 | 1.3486 | 1.3457 | 1.3468 | 2821896.0 |
| 2005-07-08 12:10:00 | AAPL | Stock | 1.3468 | 1.3511 | 1.3468 | 1.3489 | 3985604.0 |
| 2005-07-08 12:15:00 | AAPL | Stock | 1.3493 | 1.3493 | 1.3479 | 1.3479 | 1366708.0 |
| 2005-07-08 12:20:00 | AAPL | Stock | 1.3479 | 1.3496 | 1.3475 | 1.3496 | 1498028.0 |
| 2005-07-08 12:25:00 | AAPL | Stock | 1.35 | 1.3521 | 1.3493 | 1.3521 | 3825276.0 |
> showing 50 of 199,284 rows — these rows as CSV