PREVIEW / stock_5min / 2009-11-18
file: by_date/stock_5min/2009/2009-11-18.parquet size: 4.6 MB rows: 314,366 symbols: 3,430
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 |
|---|---|---|---|---|---|---|---|
| 2009-11-18 04:15:00 | AAPL | Stock | 7.3964 | 7.4 | 7.3964 | 7.4 | 5600.0 |
| 2009-11-18 06:20:00 | AAPL | Stock | 7.4618 | 7.4618 | 7.4618 | 7.4618 | 5824.0 |
| 2009-11-18 06:25:00 | AAPL | Stock | 7.4618 | 7.4618 | 7.4536 | 7.4536 | 8400.0 |
| 2009-11-18 06:35:00 | AAPL | Stock | 7.4414 | 7.4414 | 7.4411 | 7.4411 | 9800.0 |
| 2009-11-18 07:00:00 | AAPL | Stock | 7.4382 | 7.4382 | 7.4286 | 7.4286 | 28000.0 |
| 2009-11-18 07:10:00 | AAPL | Stock | 7.4289 | 7.4289 | 7.4289 | 7.4289 | 2800.0 |
| 2009-11-18 07:15:00 | AAPL | Stock | 7.4357 | 7.4357 | 7.4286 | 7.4286 | 88032.0 |
| 2009-11-18 07:20:00 | AAPL | Stock | 7.4236 | 7.4236 | 7.4236 | 7.4236 | 2800.0 |
| 2009-11-18 07:25:00 | AAPL | Stock | 7.4279 | 7.4286 | 7.4279 | 7.4286 | 7000.0 |
| 2009-11-18 07:30:00 | AAPL | Stock | 7.4286 | 7.4286 | 7.4286 | 7.4286 | 58800.0 |
| 2009-11-18 07:35:00 | AAPL | Stock | 7.4286 | 7.4318 | 7.4232 | 7.4286 | 115080.0 |
| 2009-11-18 07:45:00 | AAPL | Stock | 7.4286 | 7.4286 | 7.4286 | 7.4286 | 2800.0 |
| 2009-11-18 07:50:00 | AAPL | Stock | 7.4268 | 7.4282 | 7.425 | 7.4282 | 83160.0 |
| 2009-11-18 07:55:00 | AAPL | Stock | 7.4282 | 7.4282 | 7.425 | 7.425 | 14000.0 |
| 2009-11-18 08:00:00 | AAPL | Stock | 7.4232 | 7.4239 | 7.3995 | 7.4039 | 520436.0 |
| 2009-11-18 08:05:00 | AAPL | Stock | 7.4018 | 7.4036 | 7.3929 | 7.3946 | 94136.0 |
| 2009-11-18 08:10:00 | AAPL | Stock | 7.4 | 7.4 | 7.3996 | 7.4 | 51800.0 |
| 2009-11-18 08:15:00 | AAPL | Stock | 7.3971 | 7.4004 | 7.3968 | 7.3975 | 72800.0 |
| 2009-11-18 08:20:00 | AAPL | Stock | 7.4004 | 7.4036 | 7.4004 | 7.4018 | 303688.0 |
| 2009-11-18 08:25:00 | AAPL | Stock | 7.4029 | 7.4071 | 7.4018 | 7.4018 | 85960.0 |
| 2009-11-18 08:30:00 | AAPL | Stock | 7.4018 | 7.4018 | 7.3843 | 7.3929 | 448812.0 |
| 2009-11-18 08:35:00 | AAPL | Stock | 7.3948 | 7.3948 | 7.3914 | 7.3946 | 156100.0 |
| 2009-11-18 08:40:00 | AAPL | Stock | 7.3964 | 7.3979 | 7.3914 | 7.3914 | 176568.0 |
| 2009-11-18 08:45:00 | AAPL | Stock | 7.3911 | 7.3911 | 7.3786 | 7.3871 | 76300.0 |
| 2009-11-18 08:50:00 | AAPL | Stock | 7.3811 | 7.3811 | 7.3789 | 7.3804 | 47740.0 |
| 2009-11-18 08:55:00 | AAPL | Stock | 7.3836 | 7.3902 | 7.3836 | 7.39 | 88900.0 |
| 2009-11-18 09:00:00 | AAPL | Stock | 7.3843 | 7.3871 | 7.3757 | 7.3786 | 115416.0 |
| 2009-11-18 09:05:00 | AAPL | Stock | 7.3754 | 7.3796 | 7.3693 | 7.3725 | 123200.0 |
| 2009-11-18 09:10:00 | AAPL | Stock | 7.3764 | 7.3811 | 7.3761 | 7.3811 | 42140.0 |
| 2009-11-18 09:15:00 | AAPL | Stock | 7.3821 | 7.3875 | 7.3743 | 7.3761 | 46200.0 |
| 2009-11-18 09:20:00 | AAPL | Stock | 7.3789 | 7.3904 | 7.3789 | 7.3893 | 183400.0 |
| 2009-11-18 09:25:00 | AAPL | Stock | 7.3825 | 7.385 | 7.3721 | 7.3725 | 315560.0 |
| 2009-11-18 09:30:00 | AAPL | Stock | 7.3764 | 7.3929 | 7.3643 | 7.3848 | 10629080.0 |
| 2009-11-18 09:35:00 | AAPL | Stock | 7.3846 | 7.3871 | 7.3511 | 7.3529 | 9295412.0 |
| 2009-11-18 09:40:00 | AAPL | Stock | 7.3525 | 7.385 | 7.3514 | 7.3839 | 8384544.0 |
| 2009-11-18 09:45:00 | AAPL | Stock | 7.3829 | 7.3914 | 7.3675 | 7.3714 | 7288568.0 |
| 2009-11-18 09:50:00 | AAPL | Stock | 7.3696 | 7.3714 | 7.3521 | 7.3579 | 8730288.0 |
| 2009-11-18 09:55:00 | AAPL | Stock | 7.3593 | 7.3675 | 7.3511 | 7.3596 | 7160804.0 |
| 2009-11-18 10:00:00 | AAPL | Stock | 7.3596 | 7.3689 | 7.3457 | 7.3493 | 7723464.0 |
| 2009-11-18 10:05:00 | AAPL | Stock | 7.3493 | 7.3561 | 7.3457 | 7.3526 | 6956852.0 |
| 2009-11-18 10:10:00 | AAPL | Stock | 7.3521 | 7.3531 | 7.3375 | 7.3482 | 7940828.0 |
| 2009-11-18 10:15:00 | AAPL | Stock | 7.3486 | 7.36 | 7.3486 | 7.3561 | 5418616.0 |
| 2009-11-18 10:20:00 | AAPL | Stock | 7.3554 | 7.3589 | 7.3521 | 7.3532 | 2946160.0 |
| 2009-11-18 10:25:00 | AAPL | Stock | 7.3536 | 7.3671 | 7.3536 | 7.3645 | 3078600.0 |
| 2009-11-18 10:30:00 | AAPL | Stock | 7.3654 | 7.3696 | 7.3596 | 7.3596 | 3537324.0 |
| 2009-11-18 10:35:00 | AAPL | Stock | 7.36 | 7.3696 | 7.3593 | 7.3654 | 3139892.0 |
| 2009-11-18 10:40:00 | AAPL | Stock | 7.3661 | 7.38 | 7.3661 | 7.3779 | 7000392.0 |
| 2009-11-18 10:45:00 | AAPL | Stock | 7.3786 | 7.3821 | 7.3696 | 7.3771 | 5865412.0 |
| 2009-11-18 10:50:00 | AAPL | Stock | 7.3779 | 7.3786 | 7.3679 | 7.3743 | 2433200.0 |
| 2009-11-18 10:55:00 | AAPL | Stock | 7.3732 | 7.3786 | 7.3679 | 7.3775 | 2612848.0 |
> showing 50 of 314,366 rows — these rows as CSV