PREVIEW / stock_5min / 2010-10-08
file: by_date/stock_5min/2010/2010-10-08.parquet size: 4.6 MB rows: 316,873 symbols: 3,484
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-08 06:05:00 | AAPL | Stock | 10.3071 | 10.3071 | 10.3071 | 10.3071 | 14000.0 |
| 2010-10-08 07:00:00 | AAPL | Stock | 10.3054 | 10.3282 | 10.3054 | 10.3282 | 8400.0 |
| 2010-10-08 07:05:00 | AAPL | Stock | 10.2961 | 10.2961 | 10.2961 | 10.2961 | 5600.0 |
| 2010-10-08 07:20:00 | AAPL | Stock | 10.3121 | 10.3214 | 10.3121 | 10.3214 | 18200.0 |
| 2010-10-08 07:25:00 | AAPL | Stock | 10.3146 | 10.3146 | 10.3146 | 10.3146 | 2800.0 |
| 2010-10-08 07:30:00 | AAPL | Stock | 10.3125 | 10.3196 | 10.3125 | 10.3196 | 16800.0 |
| 2010-10-08 07:35:00 | AAPL | Stock | 10.3175 | 10.3175 | 10.3175 | 10.3175 | 2800.0 |
| 2010-10-08 07:40:00 | AAPL | Stock | 10.3193 | 10.3193 | 10.3193 | 10.3193 | 2800.0 |
| 2010-10-08 07:45:00 | AAPL | Stock | 10.3193 | 10.3193 | 10.3125 | 10.3125 | 14560.0 |
| 2010-10-08 07:50:00 | AAPL | Stock | 10.3139 | 10.3146 | 10.3139 | 10.3146 | 8400.0 |
| 2010-10-08 07:55:00 | AAPL | Stock | 10.3157 | 10.3157 | 10.3157 | 10.3157 | 2800.0 |
| 2010-10-08 08:00:00 | AAPL | Stock | 10.3111 | 10.3168 | 10.3039 | 10.3132 | 424424.0 |
| 2010-10-08 08:05:00 | AAPL | Stock | 10.3139 | 10.3143 | 10.3043 | 10.3125 | 166320.0 |
| 2010-10-08 08:10:00 | AAPL | Stock | 10.3125 | 10.3168 | 10.3093 | 10.3168 | 326872.0 |
| 2010-10-08 08:15:00 | AAPL | Stock | 10.3161 | 10.3257 | 10.3154 | 10.3214 | 238028.0 |
| 2010-10-08 08:20:00 | AAPL | Stock | 10.3286 | 10.3336 | 10.3218 | 10.3282 | 268520.0 |
| 2010-10-08 08:25:00 | AAPL | Stock | 10.3268 | 10.3268 | 10.3104 | 10.3196 | 351876.0 |
| 2010-10-08 08:30:00 | AAPL | Stock | 10.3179 | 10.375 | 10.25 | 10.36 | 2882264.0 |
| 2010-10-08 08:35:00 | AAPL | Stock | 10.3625 | 10.3746 | 10.3464 | 10.3621 | 1627220.0 |
| 2010-10-08 08:40:00 | AAPL | Stock | 10.3621 | 10.3768 | 10.3521 | 10.3521 | 1681456.0 |
| 2010-10-08 08:45:00 | AAPL | Stock | 10.3543 | 10.3711 | 10.3532 | 10.3557 | 699104.0 |
| 2010-10-08 08:50:00 | AAPL | Stock | 10.3564 | 10.3564 | 10.3429 | 10.3429 | 691880.0 |
| 2010-10-08 08:55:00 | AAPL | Stock | 10.3429 | 10.3482 | 10.34 | 10.3429 | 393680.0 |
| 2010-10-08 09:00:00 | AAPL | Stock | 10.3446 | 10.3464 | 10.3336 | 10.3432 | 247492.0 |
| 2010-10-08 09:05:00 | AAPL | Stock | 10.3446 | 10.3643 | 10.3429 | 10.3625 | 299656.0 |
| 2010-10-08 09:10:00 | AAPL | Stock | 10.3607 | 10.3979 | 10.3575 | 10.3979 | 2984268.0 |
| 2010-10-08 09:15:00 | AAPL | Stock | 10.3979 | 10.4179 | 10.3957 | 10.4154 | 2118648.0 |
| 2010-10-08 09:20:00 | AAPL | Stock | 10.4161 | 10.4321 | 10.4039 | 10.4282 | 1643992.0 |
| 2010-10-08 09:25:00 | AAPL | Stock | 10.4275 | 10.4293 | 10.4179 | 10.4189 | 687596.0 |
| 2010-10-08 09:30:00 | AAPL | Stock | 10.4225 | 10.4536 | 10.3939 | 10.4379 | 34005272.0 |
| 2010-10-08 09:35:00 | AAPL | Stock | 10.4375 | 10.4411 | 10.3789 | 10.4129 | 21286160.0 |
| 2010-10-08 09:40:00 | AAPL | Stock | 10.4139 | 10.4425 | 10.4007 | 10.4318 | 12834836.0 |
| 2010-10-08 09:45:00 | AAPL | Stock | 10.4324 | 10.4371 | 10.4036 | 10.4096 | 12872972.0 |
| 2010-10-08 09:50:00 | AAPL | Stock | 10.4089 | 10.4411 | 10.4054 | 10.425 | 11146828.0 |
| 2010-10-08 09:55:00 | AAPL | Stock | 10.425 | 10.4375 | 10.4229 | 10.4268 | 6905640.0 |
| 2010-10-08 10:00:00 | AAPL | Stock | 10.4275 | 10.4382 | 10.4071 | 10.4111 | 10988880.0 |
| 2010-10-08 10:05:00 | AAPL | Stock | 10.4119 | 10.4346 | 10.4057 | 10.4082 | 10636668.0 |
| 2010-10-08 10:10:00 | AAPL | Stock | 10.4075 | 10.4182 | 10.3911 | 10.4068 | 10225404.0 |
| 2010-10-08 10:15:00 | AAPL | Stock | 10.4061 | 10.4164 | 10.3804 | 10.3839 | 11198992.0 |
| 2010-10-08 10:20:00 | AAPL | Stock | 10.3921 | 10.3925 | 10.3793 | 10.3907 | 8406216.0 |
| 2010-10-08 10:25:00 | AAPL | Stock | 10.3893 | 10.3907 | 10.3571 | 10.3646 | 13086276.0 |
| 2010-10-08 10:30:00 | AAPL | Stock | 10.3636 | 10.3721 | 10.3571 | 10.3694 | 9910740.0 |
| 2010-10-08 10:35:00 | AAPL | Stock | 10.3685 | 10.3886 | 10.3607 | 10.3886 | 7922796.0 |
| 2010-10-08 10:40:00 | AAPL | Stock | 10.3877 | 10.4018 | 10.3825 | 10.3986 | 7411208.0 |
| 2010-10-08 10:45:00 | AAPL | Stock | 10.3996 | 10.4011 | 10.3825 | 10.3846 | 3494932.0 |
| 2010-10-08 10:50:00 | AAPL | Stock | 10.3832 | 10.41 | 10.3829 | 10.4065 | 4155312.0 |
| 2010-10-08 10:55:00 | AAPL | Stock | 10.4075 | 10.4225 | 10.405 | 10.4168 | 6573504.0 |
| 2010-10-08 11:00:00 | AAPL | Stock | 10.4171 | 10.4279 | 10.4107 | 10.4185 | 5387788.0 |
| 2010-10-08 11:05:00 | AAPL | Stock | 10.4179 | 10.4318 | 10.4175 | 10.4257 | 7746676.0 |
| 2010-10-08 11:10:00 | AAPL | Stock | 10.4257 | 10.4407 | 10.4225 | 10.4289 | 8889692.0 |
> showing 50 of 316,873 rows — these rows as CSV