PREVIEW / stock_1min / 2007-06-21
file: by_date/stock_1min/2007/2007-06-21.parquet size: 11.4 MB rows: 934,349 symbols: 2,501
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-06-21 09:30:00 | AAPL | Stock | 4.3464 | 4.3536 | 4.3436 | 4.3536 | 8591632.0 |
| 2007-06-21 09:31:00 | AAPL | Stock | 4.3536 | 4.3579 | 4.3447 | 4.35 | 4664324.0 |
| 2007-06-21 09:32:00 | AAPL | Stock | 4.35 | 4.3579 | 4.3457 | 4.3489 | 3029712.0 |
| 2007-06-21 09:33:00 | AAPL | Stock | 4.3486 | 4.3621 | 4.3486 | 4.3618 | 3216388.0 |
| 2007-06-21 09:34:00 | AAPL | Stock | 4.3618 | 4.3675 | 4.3532 | 4.3614 | 4386200.0 |
| 2007-06-21 09:35:00 | AAPL | Stock | 4.3636 | 4.3689 | 4.3632 | 4.3654 | 3582236.0 |
| 2007-06-21 09:36:00 | AAPL | Stock | 4.3654 | 4.3664 | 4.3575 | 4.3593 | 3281180.0 |
| 2007-06-21 09:37:00 | AAPL | Stock | 4.3593 | 4.3611 | 4.3571 | 4.3575 | 3562104.0 |
| 2007-06-21 09:38:00 | AAPL | Stock | 4.3586 | 4.3604 | 4.3411 | 4.3411 | 6617408.0 |
| 2007-06-21 09:39:00 | AAPL | Stock | 4.3411 | 4.3419 | 4.3314 | 4.3332 | 6856360.0 |
| 2007-06-21 09:40:00 | AAPL | Stock | 4.3336 | 4.3432 | 4.3229 | 4.3248 | 6350148.0 |
| 2007-06-21 09:41:00 | AAPL | Stock | 4.3246 | 4.325 | 4.3154 | 4.3171 | 7914256.0 |
| 2007-06-21 09:42:00 | AAPL | Stock | 4.3179 | 4.3257 | 4.3114 | 4.3232 | 6330184.0 |
| 2007-06-21 09:43:00 | AAPL | Stock | 4.3232 | 4.325 | 4.3189 | 4.3229 | 3071096.0 |
| 2007-06-21 09:44:00 | AAPL | Stock | 4.3229 | 4.3246 | 4.3132 | 4.3142 | 2942912.0 |
| 2007-06-21 09:45:00 | AAPL | Stock | 4.3139 | 4.3293 | 4.3139 | 4.3282 | 3950100.0 |
| 2007-06-21 09:46:00 | AAPL | Stock | 4.3277 | 4.3346 | 4.3246 | 4.3339 | 3131884.0 |
| 2007-06-21 09:47:00 | AAPL | Stock | 4.3339 | 4.3357 | 4.3261 | 4.3311 | 2763852.0 |
| 2007-06-21 09:48:00 | AAPL | Stock | 4.3318 | 4.3514 | 4.3311 | 4.3414 | 5034876.0 |
| 2007-06-21 09:49:00 | AAPL | Stock | 4.3414 | 4.3464 | 4.3375 | 4.3457 | 3952704.0 |
| 2007-06-21 09:50:00 | AAPL | Stock | 4.3457 | 4.3518 | 4.3418 | 4.3514 | 3703168.0 |
| 2007-06-21 09:51:00 | AAPL | Stock | 4.3521 | 4.3532 | 4.3489 | 4.3518 | 3032932.0 |
| 2007-06-21 09:52:00 | AAPL | Stock | 4.3493 | 4.3579 | 4.3493 | 4.3518 | 3348716.0 |
| 2007-06-21 09:53:00 | AAPL | Stock | 4.3518 | 4.3521 | 4.3439 | 4.3454 | 2173192.0 |
| 2007-06-21 09:54:00 | AAPL | Stock | 4.3457 | 4.3486 | 4.3454 | 4.3468 | 1967196.0 |
| 2007-06-21 09:55:00 | AAPL | Stock | 4.3461 | 4.3511 | 4.3454 | 4.3482 | 1960056.0 |
| 2007-06-21 09:56:00 | AAPL | Stock | 4.3482 | 4.3489 | 4.3354 | 4.3354 | 3808448.0 |
| 2007-06-21 09:57:00 | AAPL | Stock | 4.3354 | 4.3393 | 4.3335 | 4.3336 | 2460976.0 |
| 2007-06-21 09:58:00 | AAPL | Stock | 4.3339 | 4.335 | 4.3218 | 4.3264 | 3812816.0 |
| 2007-06-21 09:59:00 | AAPL | Stock | 4.3261 | 4.3371 | 4.3239 | 4.3329 | 3272752.0 |
| 2007-06-21 10:00:00 | AAPL | Stock | 4.3324 | 4.3461 | 4.3324 | 4.3454 | 3510136.0 |
| 2007-06-21 10:01:00 | AAPL | Stock | 4.3454 | 4.3507 | 4.3346 | 4.3486 | 3962140.0 |
| 2007-06-21 10:02:00 | AAPL | Stock | 4.3475 | 4.3564 | 4.3468 | 4.3521 | 4210668.0 |
| 2007-06-21 10:03:00 | AAPL | Stock | 4.3529 | 4.355 | 4.3421 | 4.3429 | 3615500.0 |
| 2007-06-21 10:04:00 | AAPL | Stock | 4.3436 | 4.3611 | 4.3421 | 4.3582 | 4766748.0 |
| 2007-06-21 10:05:00 | AAPL | Stock | 4.3579 | 4.3643 | 4.3536 | 4.3625 | 4846884.0 |
| 2007-06-21 10:06:00 | AAPL | Stock | 4.3625 | 4.3636 | 4.3504 | 4.3507 | 3001432.0 |
| 2007-06-21 10:07:00 | AAPL | Stock | 4.3507 | 4.3593 | 4.3507 | 4.3593 | 3053400.0 |
| 2007-06-21 10:08:00 | AAPL | Stock | 4.3596 | 4.3686 | 4.3582 | 4.3646 | 4342156.0 |
| 2007-06-21 10:09:00 | AAPL | Stock | 4.3643 | 4.3721 | 4.3643 | 4.3715 | 4093180.0 |
| 2007-06-21 10:10:00 | AAPL | Stock | 4.3721 | 4.3721 | 4.3671 | 4.3707 | 3912468.0 |
| 2007-06-21 10:11:00 | AAPL | Stock | 4.3711 | 4.3714 | 4.3654 | 4.3686 | 2829176.0 |
| 2007-06-21 10:12:00 | AAPL | Stock | 4.3682 | 4.3711 | 4.3589 | 4.3636 | 2817556.0 |
| 2007-06-21 10:13:00 | AAPL | Stock | 4.3629 | 4.3646 | 4.3589 | 4.3596 | 2751028.0 |
| 2007-06-21 10:14:00 | AAPL | Stock | 4.3596 | 4.3621 | 4.3536 | 4.3614 | 2529688.0 |
| 2007-06-21 10:15:00 | AAPL | Stock | 4.3614 | 4.3671 | 4.3607 | 4.3643 | 2451148.0 |
| 2007-06-21 10:16:00 | AAPL | Stock | 4.3643 | 4.3754 | 4.3643 | 4.3746 | 5362280.0 |
| 2007-06-21 10:17:00 | AAPL | Stock | 4.3746 | 4.3836 | 4.3714 | 4.3807 | 5178124.0 |
| 2007-06-21 10:18:00 | AAPL | Stock | 4.3811 | 4.3839 | 4.3789 | 4.3818 | 3780980.0 |
| 2007-06-21 10:19:00 | AAPL | Stock | 4.3818 | 4.3875 | 4.3814 | 4.3857 | 4165672.0 |
> showing 50 of 934,349 rows — these rows as CSV