PREVIEW / stock_5min / 2007-08-15
file: by_date/stock_5min/2007/2007-08-15.parquet size: 4.2 MB rows: 306,878 symbols: 3,122
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-08-15 09:30:00 | AAPL | Stock | 4.3836 | 4.4054 | 4.3493 | 4.3754 | 31938284.0 |
| 2007-08-15 09:35:00 | AAPL | Stock | 4.3754 | 4.4018 | 4.3515 | 4.3879 | 23389156.0 |
| 2007-08-15 09:40:00 | AAPL | Stock | 4.3886 | 4.3904 | 4.3571 | 4.3807 | 24914120.0 |
| 2007-08-15 09:45:00 | AAPL | Stock | 4.3807 | 4.4179 | 4.38 | 4.4018 | 26938324.0 |
| 2007-08-15 09:50:00 | AAPL | Stock | 4.4025 | 4.4286 | 4.3907 | 4.4239 | 16604616.0 |
| 2007-08-15 09:55:00 | AAPL | Stock | 4.425 | 4.4593 | 4.4243 | 4.4357 | 27241760.0 |
| 2007-08-15 10:00:00 | AAPL | Stock | 4.435 | 4.4426 | 4.4004 | 4.4079 | 17344572.0 |
| 2007-08-15 10:05:00 | AAPL | Stock | 4.4071 | 4.4296 | 4.4046 | 4.4232 | 15298136.0 |
| 2007-08-15 10:10:00 | AAPL | Stock | 4.4243 | 4.4314 | 4.4061 | 4.4282 | 11082400.0 |
| 2007-08-15 10:15:00 | AAPL | Stock | 4.4279 | 4.4321 | 4.4204 | 4.4225 | 4165448.0 |
| 2007-08-15 10:20:00 | AAPL | Stock | 4.4225 | 4.4375 | 4.4089 | 4.4314 | 12071332.0 |
| 2007-08-15 10:25:00 | AAPL | Stock | 4.4314 | 4.4393 | 4.425 | 4.4357 | 11802196.0 |
| 2007-08-15 10:30:00 | AAPL | Stock | 4.4357 | 4.4357 | 4.415 | 4.4164 | 11599812.0 |
| 2007-08-15 10:35:00 | AAPL | Stock | 4.4161 | 4.4229 | 4.4036 | 4.4089 | 8934828.0 |
| 2007-08-15 10:40:00 | AAPL | Stock | 4.4086 | 4.4193 | 4.3989 | 4.4121 | 9234904.0 |
| 2007-08-15 10:45:00 | AAPL | Stock | 4.4121 | 4.4175 | 4.3979 | 4.4096 | 8620332.0 |
| 2007-08-15 10:50:00 | AAPL | Stock | 4.4104 | 4.4161 | 4.3964 | 4.4021 | 6719328.0 |
| 2007-08-15 10:55:00 | AAPL | Stock | 4.4025 | 4.4068 | 4.3882 | 4.3925 | 8516536.0 |
| 2007-08-15 11:00:00 | AAPL | Stock | 4.3925 | 4.3993 | 4.3914 | 4.3968 | 9309944.0 |
| 2007-08-15 11:05:00 | AAPL | Stock | 4.3954 | 4.3954 | 4.3654 | 4.3675 | 14655508.0 |
| 2007-08-15 11:10:00 | AAPL | Stock | 4.3671 | 4.3761 | 4.3607 | 4.3729 | 11229904.0 |
| 2007-08-15 11:15:00 | AAPL | Stock | 4.3729 | 4.38 | 4.3636 | 4.3757 | 9272032.0 |
| 2007-08-15 11:20:00 | AAPL | Stock | 4.3757 | 4.3821 | 4.3739 | 4.3807 | 5559036.0 |
| 2007-08-15 11:25:00 | AAPL | Stock | 4.38 | 4.4011 | 4.38 | 4.3961 | 11032364.0 |
| 2007-08-15 11:30:00 | AAPL | Stock | 4.3957 | 4.3982 | 4.3768 | 4.3768 | 7756728.0 |
| 2007-08-15 11:35:00 | AAPL | Stock | 4.3768 | 4.3823 | 4.3654 | 4.3707 | 8889944.0 |
| 2007-08-15 11:40:00 | AAPL | Stock | 4.3704 | 4.3821 | 4.3693 | 4.38 | 9290092.0 |
| 2007-08-15 11:45:00 | AAPL | Stock | 4.3804 | 4.3836 | 4.3589 | 4.3596 | 9874508.0 |
| 2007-08-15 11:50:00 | AAPL | Stock | 4.3593 | 4.3625 | 4.3457 | 4.3536 | 19566680.0 |
| 2007-08-15 11:55:00 | AAPL | Stock | 4.3536 | 4.3621 | 4.3371 | 4.3393 | 18024328.0 |
| 2007-08-15 12:00:00 | AAPL | Stock | 4.3393 | 4.3489 | 4.3346 | 4.3479 | 14603876.0 |
| 2007-08-15 12:05:00 | AAPL | Stock | 4.3479 | 4.3621 | 4.3471 | 4.3496 | 10579716.0 |
| 2007-08-15 12:10:00 | AAPL | Stock | 4.3496 | 4.3571 | 4.3464 | 4.355 | 6106884.0 |
| 2007-08-15 12:15:00 | AAPL | Stock | 4.3557 | 4.3714 | 4.355 | 4.3561 | 9919784.0 |
| 2007-08-15 12:20:00 | AAPL | Stock | 4.3564 | 4.3661 | 4.35 | 4.3621 | 7163296.0 |
| 2007-08-15 12:25:00 | AAPL | Stock | 4.3621 | 4.3679 | 4.3539 | 4.3543 | 6916476.0 |
| 2007-08-15 12:30:00 | AAPL | Stock | 4.3543 | 4.3579 | 4.3479 | 4.3568 | 6067824.0 |
| 2007-08-15 12:35:00 | AAPL | Stock | 4.3557 | 4.3571 | 4.35 | 4.3571 | 4191516.0 |
| 2007-08-15 12:40:00 | AAPL | Stock | 4.3571 | 4.3639 | 4.3554 | 4.3625 | 5351668.0 |
| 2007-08-15 12:45:00 | AAPL | Stock | 4.3618 | 4.3793 | 4.3611 | 4.3668 | 8186248.0 |
| 2007-08-15 12:50:00 | AAPL | Stock | 4.3675 | 4.3675 | 4.3607 | 4.3643 | 5462016.0 |
| 2007-08-15 12:55:00 | AAPL | Stock | 4.3657 | 4.3696 | 4.355 | 4.3586 | 4907420.0 |
| 2007-08-15 13:00:00 | AAPL | Stock | 4.3579 | 4.3593 | 4.3475 | 4.3546 | 5928216.0 |
| 2007-08-15 13:05:00 | AAPL | Stock | 4.3546 | 4.3625 | 4.3521 | 4.355 | 5088440.0 |
| 2007-08-15 13:10:00 | AAPL | Stock | 4.3546 | 4.3579 | 4.3489 | 4.35 | 4851896.0 |
| 2007-08-15 13:15:00 | AAPL | Stock | 4.35 | 4.3643 | 4.3489 | 4.3639 | 7954856.0 |
| 2007-08-15 13:20:00 | AAPL | Stock | 4.3636 | 4.3711 | 4.3582 | 4.3696 | 5558644.0 |
| 2007-08-15 13:25:00 | AAPL | Stock | 4.37 | 4.3782 | 4.3625 | 4.3714 | 8463252.0 |
| 2007-08-15 13:30:00 | AAPL | Stock | 4.3718 | 4.4071 | 4.3714 | 4.4061 | 13159580.0 |
| 2007-08-15 13:35:00 | AAPL | Stock | 4.4071 | 4.415 | 4.3943 | 4.3971 | 13260156.0 |
> showing 50 of 306,878 rows — these rows as CSV