PREVIEW / stock_5min / 2010-05-21
file: by_date/stock_5min/2010/2010-05-21.parquet size: 5.2 MB rows: 348,591 symbols: 3,492
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-05-21 04:10:00 | AAPL | Stock | 8.4182 | 8.4182 | 8.4182 | 8.4182 | 14000.0 |
| 2010-05-21 04:15:00 | AAPL | Stock | 8.4336 | 8.4336 | 8.4336 | 8.4336 | 2800.0 |
| 2010-05-21 04:25:00 | AAPL | Stock | 8.4311 | 8.4311 | 8.4304 | 8.4304 | 25844.0 |
| 2010-05-21 04:35:00 | AAPL | Stock | 8.4593 | 8.4593 | 8.4593 | 8.4593 | 11200.0 |
| 2010-05-21 04:40:00 | AAPL | Stock | 8.4993 | 8.4993 | 8.4993 | 8.4993 | 2800.0 |
| 2010-05-21 05:00:00 | AAPL | Stock | 8.4993 | 8.4993 | 8.4993 | 8.4993 | 2800.0 |
| 2010-05-21 05:10:00 | AAPL | Stock | 8.4993 | 8.4993 | 8.4993 | 8.4993 | 2800.0 |
| 2010-05-21 05:20:00 | AAPL | Stock | 8.4904 | 8.4904 | 8.4893 | 8.4893 | 14000.0 |
| 2010-05-21 05:25:00 | AAPL | Stock | 8.5136 | 8.5136 | 8.5136 | 8.5136 | 2800.0 |
| 2010-05-21 05:55:00 | AAPL | Stock | 8.4607 | 8.4607 | 8.4607 | 8.4607 | 2800.0 |
| 2010-05-21 06:20:00 | AAPL | Stock | 8.4571 | 8.4571 | 8.4571 | 8.4571 | 2800.0 |
| 2010-05-21 06:35:00 | AAPL | Stock | 8.4182 | 8.4182 | 8.4182 | 8.4182 | 14000.0 |
| 2010-05-21 06:40:00 | AAPL | Stock | 8.4282 | 8.4286 | 8.4282 | 8.4286 | 5600.0 |
| 2010-05-21 07:00:00 | AAPL | Stock | 8.4179 | 8.4289 | 8.4179 | 8.4289 | 39200.0 |
| 2010-05-21 07:05:00 | AAPL | Stock | 8.4286 | 8.4286 | 8.4104 | 8.4129 | 81228.0 |
| 2010-05-21 07:10:00 | AAPL | Stock | 8.3929 | 8.4018 | 8.3929 | 8.4018 | 96180.0 |
| 2010-05-21 07:15:00 | AAPL | Stock | 8.3989 | 8.4007 | 8.3857 | 8.3907 | 103180.0 |
| 2010-05-21 07:20:00 | AAPL | Stock | 8.3921 | 8.3921 | 8.3571 | 8.3746 | 141064.0 |
| 2010-05-21 07:25:00 | AAPL | Stock | 8.3589 | 8.3675 | 8.3268 | 8.3286 | 203840.0 |
| 2010-05-21 07:30:00 | AAPL | Stock | 8.3268 | 8.33 | 8.2504 | 8.2846 | 578592.0 |
| 2010-05-21 07:35:00 | AAPL | Stock | 8.2786 | 8.3089 | 8.2675 | 8.3089 | 284900.0 |
| 2010-05-21 07:40:00 | AAPL | Stock | 8.3018 | 8.3175 | 8.2989 | 8.3161 | 314692.0 |
| 2010-05-21 07:45:00 | AAPL | Stock | 8.3143 | 8.3143 | 8.2861 | 8.2982 | 110880.0 |
| 2010-05-21 07:50:00 | AAPL | Stock | 8.2982 | 8.3389 | 8.2946 | 8.3389 | 350840.0 |
| 2010-05-21 07:55:00 | AAPL | Stock | 8.3321 | 8.3643 | 8.3304 | 8.3479 | 211764.0 |
| 2010-05-21 08:00:00 | AAPL | Stock | 8.3671 | 8.3732 | 8.3279 | 8.3579 | 771316.0 |
| 2010-05-21 08:05:00 | AAPL | Stock | 8.3582 | 8.3746 | 8.3536 | 8.3557 | 783272.0 |
| 2010-05-21 08:10:00 | AAPL | Stock | 8.3529 | 8.3679 | 8.3521 | 8.3575 | 477568.0 |
| 2010-05-21 08:15:00 | AAPL | Stock | 8.3575 | 8.3639 | 8.3396 | 8.34 | 480312.0 |
| 2010-05-21 08:20:00 | AAPL | Stock | 8.3402 | 8.3564 | 8.3339 | 8.3489 | 331240.0 |
| 2010-05-21 08:25:00 | AAPL | Stock | 8.3511 | 8.3561 | 8.335 | 8.335 | 546644.0 |
| 2010-05-21 08:30:00 | AAPL | Stock | 8.3371 | 8.3554 | 8.3361 | 8.3371 | 771400.0 |
| 2010-05-21 08:35:00 | AAPL | Stock | 8.3379 | 8.3571 | 8.3304 | 8.3571 | 823144.0 |
| 2010-05-21 08:40:00 | AAPL | Stock | 8.3593 | 8.3868 | 8.3546 | 8.3743 | 1219428.0 |
| 2010-05-21 08:45:00 | AAPL | Stock | 8.3746 | 8.4168 | 8.3725 | 8.4164 | 766640.0 |
| 2010-05-21 08:50:00 | AAPL | Stock | 8.4168 | 8.4182 | 8.3846 | 8.3982 | 1073128.0 |
| 2010-05-21 08:55:00 | AAPL | Stock | 8.4 | 8.4161 | 8.3975 | 8.4143 | 855512.0 |
| 2010-05-21 09:00:00 | AAPL | Stock | 8.4111 | 8.4111 | 8.3829 | 8.3864 | 449820.0 |
| 2010-05-21 09:05:00 | AAPL | Stock | 8.3825 | 8.3836 | 8.3661 | 8.3661 | 1196664.0 |
| 2010-05-21 09:10:00 | AAPL | Stock | 8.3625 | 8.3636 | 8.3482 | 8.35 | 517216.0 |
| 2010-05-21 09:15:00 | AAPL | Stock | 8.3521 | 8.3636 | 8.3468 | 8.3579 | 702996.0 |
| 2010-05-21 09:20:00 | AAPL | Stock | 8.3582 | 8.3605 | 8.3429 | 8.3525 | 531160.0 |
| 2010-05-21 09:25:00 | AAPL | Stock | 8.3536 | 8.3536 | 8.2982 | 8.3036 | 3318448.0 |
| 2010-05-21 09:30:00 | AAPL | Stock | 8.315 | 8.3405 | 8.2625 | 8.2931 | 113876952.0 |
| 2010-05-21 09:35:00 | AAPL | Stock | 8.2939 | 8.3886 | 8.2838 | 8.3846 | 37030196.0 |
| 2010-05-21 09:40:00 | AAPL | Stock | 8.3846 | 8.4189 | 8.3607 | 8.3886 | 33818260.0 |
| 2010-05-21 09:45:00 | AAPL | Stock | 8.39 | 8.4514 | 8.3821 | 8.4436 | 25656792.0 |
| 2010-05-21 09:50:00 | AAPL | Stock | 8.4461 | 8.5064 | 8.4371 | 8.5064 | 41786164.0 |
| 2010-05-21 09:55:00 | AAPL | Stock | 8.5068 | 8.5493 | 8.4697 | 8.4775 | 35000532.0 |
| 2010-05-21 10:00:00 | AAPL | Stock | 8.4743 | 8.5286 | 8.4521 | 8.5007 | 23536128.0 |
> showing 50 of 348,591 rows — these rows as CSV