PREVIEW / stock_5min / 2010-10-06
file: by_date/stock_5min/2010/2010-10-06.parquet size: 4.7 MB rows: 326,856 symbols: 3,487
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-06 04:00:00 | AAPL | Stock | 10.3607 | 10.3607 | 10.3607 | 10.3607 | 4508.0 |
| 2010-10-06 06:05:00 | AAPL | Stock | 10.3821 | 10.3821 | 10.3821 | 10.3821 | 2800.0 |
| 2010-10-06 06:30:00 | AAPL | Stock | 10.375 | 10.375 | 10.375 | 10.375 | 16800.0 |
| 2010-10-06 06:35:00 | AAPL | Stock | 10.375 | 10.375 | 10.375 | 10.375 | 9800.0 |
| 2010-10-06 07:00:00 | AAPL | Stock | 10.3571 | 10.3571 | 10.3571 | 10.3571 | 5600.0 |
| 2010-10-06 07:05:00 | AAPL | Stock | 10.3525 | 10.3571 | 10.3525 | 10.3571 | 25200.0 |
| 2010-10-06 07:10:00 | AAPL | Stock | 10.3571 | 10.3661 | 10.3536 | 10.3661 | 53200.0 |
| 2010-10-06 07:15:00 | AAPL | Stock | 10.3671 | 10.3671 | 10.3568 | 10.3568 | 30800.0 |
| 2010-10-06 07:20:00 | AAPL | Stock | 10.3546 | 10.3546 | 10.3546 | 10.3546 | 11200.0 |
| 2010-10-06 07:25:00 | AAPL | Stock | 10.3518 | 10.3539 | 10.3518 | 10.3536 | 32760.0 |
| 2010-10-06 07:30:00 | AAPL | Stock | 10.3571 | 10.3657 | 10.3554 | 10.3643 | 73500.0 |
| 2010-10-06 07:35:00 | AAPL | Stock | 10.3657 | 10.375 | 10.3657 | 10.3679 | 141400.0 |
| 2010-10-06 07:45:00 | AAPL | Stock | 10.3704 | 10.3732 | 10.3675 | 10.3714 | 112000.0 |
| 2010-10-06 07:50:00 | AAPL | Stock | 10.3729 | 10.3818 | 10.3729 | 10.3746 | 131068.0 |
| 2010-10-06 07:55:00 | AAPL | Stock | 10.3729 | 10.375 | 10.3729 | 10.375 | 39172.0 |
| 2010-10-06 08:00:00 | AAPL | Stock | 10.3768 | 10.3821 | 10.3571 | 10.375 | 627368.0 |
| 2010-10-06 08:05:00 | AAPL | Stock | 10.375 | 10.3789 | 10.3689 | 10.3689 | 217644.0 |
| 2010-10-06 08:10:00 | AAPL | Stock | 10.3696 | 10.3796 | 10.3696 | 10.3768 | 286888.0 |
| 2010-10-06 08:15:00 | AAPL | Stock | 10.3725 | 10.3768 | 10.3421 | 10.3575 | 966784.0 |
| 2010-10-06 08:20:00 | AAPL | Stock | 10.3632 | 10.3679 | 10.3582 | 10.3582 | 421708.0 |
| 2010-10-06 08:25:00 | AAPL | Stock | 10.3589 | 10.365 | 10.3518 | 10.3529 | 646352.0 |
| 2010-10-06 08:30:00 | AAPL | Stock | 10.3554 | 10.3554 | 10.3471 | 10.3486 | 380408.0 |
| 2010-10-06 08:35:00 | AAPL | Stock | 10.3489 | 10.3507 | 10.3346 | 10.3479 | 702240.0 |
| 2010-10-06 08:40:00 | AAPL | Stock | 10.3457 | 10.3489 | 10.3418 | 10.3489 | 284424.0 |
| 2010-10-06 08:45:00 | AAPL | Stock | 10.3489 | 10.3507 | 10.3429 | 10.3479 | 114800.0 |
| 2010-10-06 08:50:00 | AAPL | Stock | 10.3439 | 10.35 | 10.3439 | 10.35 | 63700.0 |
| 2010-10-06 08:55:00 | AAPL | Stock | 10.35 | 10.3514 | 10.3439 | 10.3482 | 164920.0 |
| 2010-10-06 09:00:00 | AAPL | Stock | 10.3482 | 10.3518 | 10.3454 | 10.3486 | 178892.0 |
| 2010-10-06 09:05:00 | AAPL | Stock | 10.3486 | 10.3557 | 10.3482 | 10.3554 | 173656.0 |
| 2010-10-06 09:10:00 | AAPL | Stock | 10.3554 | 10.3643 | 10.3554 | 10.3643 | 157444.0 |
| 2010-10-06 09:15:00 | AAPL | Stock | 10.3607 | 10.3607 | 10.3536 | 10.3554 | 103824.0 |
| 2010-10-06 09:20:00 | AAPL | Stock | 10.3571 | 10.3571 | 10.3482 | 10.3482 | 132804.0 |
| 2010-10-06 09:25:00 | AAPL | Stock | 10.3482 | 10.3518 | 10.3414 | 10.3461 | 503272.0 |
| 2010-10-06 09:30:00 | AAPL | Stock | 10.3443 | 10.4 | 10.3425 | 10.3979 | 23860648.0 |
| 2010-10-06 09:35:00 | AAPL | Stock | 10.3993 | 10.4246 | 10.3786 | 10.4104 | 18634392.0 |
| 2010-10-06 09:40:00 | AAPL | Stock | 10.4107 | 10.4282 | 10.3832 | 10.3878 | 18083940.0 |
| 2010-10-06 09:45:00 | AAPL | Stock | 10.3864 | 10.3907 | 10.3429 | 10.355 | 18345796.0 |
| 2010-10-06 09:50:00 | AAPL | Stock | 10.3561 | 10.3754 | 10.3525 | 10.3707 | 9778748.0 |
| 2010-10-06 09:55:00 | AAPL | Stock | 10.37 | 10.3707 | 10.3271 | 10.3437 | 13962536.0 |
| 2010-10-06 10:00:00 | AAPL | Stock | 10.3436 | 10.3743 | 10.3436 | 10.3668 | 10030496.0 |
| 2010-10-06 10:05:00 | AAPL | Stock | 10.3664 | 10.3679 | 10.3457 | 10.3511 | 6804560.0 |
| 2010-10-06 10:10:00 | AAPL | Stock | 10.3496 | 10.3636 | 10.3425 | 10.3515 | 4305812.0 |
| 2010-10-06 10:15:00 | AAPL | Stock | 10.3501 | 10.3604 | 10.3136 | 10.3243 | 13255312.0 |
| 2010-10-06 10:20:00 | AAPL | Stock | 10.3257 | 10.3293 | 10.2754 | 10.2754 | 15827056.0 |
| 2010-10-06 10:25:00 | AAPL | Stock | 10.2777 | 10.3029 | 10.2718 | 10.2936 | 10050656.0 |
| 2010-10-06 10:30:00 | AAPL | Stock | 10.2914 | 10.2941 | 10.275 | 10.2755 | 8118292.0 |
| 2010-10-06 10:35:00 | AAPL | Stock | 10.2754 | 10.2804 | 10.2314 | 10.2439 | 15501024.0 |
| 2010-10-06 10:40:00 | AAPL | Stock | 10.2448 | 10.2711 | 10.2432 | 10.2579 | 11024412.0 |
| 2010-10-06 10:45:00 | AAPL | Stock | 10.2564 | 10.2725 | 10.255 | 10.2675 | 4909856.0 |
| 2010-10-06 10:50:00 | AAPL | Stock | 10.2675 | 10.2689 | 10.2536 | 10.2543 | 5362448.0 |
> showing 50 of 326,856 rows — these rows as CSV