PREVIEW / stock_5min / 2010-01-22
file: by_date/stock_5min/2010/2010-01-22.parquet size: 4.9 MB rows: 328,495 symbols: 3,447
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-01-22 04:25:00 | AAPL | Stock | 7.4554 | 7.4554 | 7.4554 | 7.4554 | 2800.0 |
| 2010-01-22 05:35:00 | AAPL | Stock | 7.4389 | 7.4389 | 7.4389 | 7.4389 | 2800.0 |
| 2010-01-22 05:50:00 | AAPL | Stock | 7.4311 | 7.4311 | 7.4311 | 7.4311 | 2800.0 |
| 2010-01-22 06:25:00 | AAPL | Stock | 7.4264 | 7.4264 | 7.4264 | 7.4264 | 5600.0 |
| 2010-01-22 06:40:00 | AAPL | Stock | 7.4143 | 7.4143 | 7.4143 | 7.4143 | 16800.0 |
| 2010-01-22 06:45:00 | AAPL | Stock | 7.4229 | 7.4229 | 7.4057 | 7.4057 | 5600.0 |
| 2010-01-22 06:50:00 | AAPL | Stock | 7.4054 | 7.4054 | 7.4021 | 7.4021 | 14448.0 |
| 2010-01-22 07:00:00 | AAPL | Stock | 7.395 | 7.395 | 7.395 | 7.395 | 4732.0 |
| 2010-01-22 07:05:00 | AAPL | Stock | 7.3982 | 7.3982 | 7.3939 | 7.3939 | 5600.0 |
| 2010-01-22 07:10:00 | AAPL | Stock | 7.3968 | 7.3968 | 7.3968 | 7.3968 | 11200.0 |
| 2010-01-22 07:15:00 | AAPL | Stock | 7.3964 | 7.3964 | 7.3911 | 7.3943 | 16800.0 |
| 2010-01-22 07:25:00 | AAPL | Stock | 7.39 | 7.4018 | 7.39 | 7.3911 | 11368.0 |
| 2010-01-22 07:30:00 | AAPL | Stock | 7.4018 | 7.4018 | 7.4018 | 7.4018 | 5600.0 |
| 2010-01-22 07:45:00 | AAPL | Stock | 7.4007 | 7.41 | 7.3932 | 7.3932 | 36400.0 |
| 2010-01-22 08:00:00 | AAPL | Stock | 7.4232 | 7.4254 | 7.4107 | 7.4116 | 117124.0 |
| 2010-01-22 08:05:00 | AAPL | Stock | 7.4179 | 7.4211 | 7.4079 | 7.4111 | 110992.0 |
| 2010-01-22 08:10:00 | AAPL | Stock | 7.4125 | 7.4125 | 7.4071 | 7.4107 | 57988.0 |
| 2010-01-22 08:15:00 | AAPL | Stock | 7.4071 | 7.4071 | 7.4054 | 7.4071 | 28924.0 |
| 2010-01-22 08:20:00 | AAPL | Stock | 7.4107 | 7.4136 | 7.4054 | 7.4136 | 125244.0 |
| 2010-01-22 08:25:00 | AAPL | Stock | 7.4136 | 7.4282 | 7.4132 | 7.4261 | 549836.0 |
| 2010-01-22 08:30:00 | AAPL | Stock | 7.4246 | 7.435 | 7.4243 | 7.4282 | 180236.0 |
| 2010-01-22 08:35:00 | AAPL | Stock | 7.4307 | 7.4307 | 7.425 | 7.4282 | 46200.0 |
| 2010-01-22 08:40:00 | AAPL | Stock | 7.4279 | 7.4279 | 7.4204 | 7.4225 | 128800.0 |
| 2010-01-22 08:45:00 | AAPL | Stock | 7.42 | 7.4279 | 7.42 | 7.4246 | 173880.0 |
| 2010-01-22 08:50:00 | AAPL | Stock | 7.4239 | 7.4279 | 7.4214 | 7.4275 | 220640.0 |
| 2010-01-22 08:55:00 | AAPL | Stock | 7.4279 | 7.4321 | 7.4179 | 7.4179 | 202888.0 |
| 2010-01-22 09:00:00 | AAPL | Stock | 7.4121 | 7.4232 | 7.4121 | 7.4232 | 141008.0 |
| 2010-01-22 09:05:00 | AAPL | Stock | 7.4218 | 7.4346 | 7.4214 | 7.4286 | 201796.0 |
| 2010-01-22 09:10:00 | AAPL | Stock | 7.4279 | 7.4286 | 7.4071 | 7.4105 | 405300.0 |
| 2010-01-22 09:15:00 | AAPL | Stock | 7.41 | 7.4146 | 7.3957 | 7.4036 | 435428.0 |
| 2010-01-22 09:20:00 | AAPL | Stock | 7.3993 | 7.4071 | 7.3893 | 7.3964 | 462784.0 |
| 2010-01-22 09:25:00 | AAPL | Stock | 7.3993 | 7.3993 | 7.3839 | 7.3846 | 540232.0 |
| 2010-01-22 09:30:00 | AAPL | Stock | 7.385 | 7.4018 | 7.3232 | 7.3638 | 28925848.0 |
| 2010-01-22 09:35:00 | AAPL | Stock | 7.3638 | 7.38 | 7.3479 | 7.3736 | 18313960.0 |
| 2010-01-22 09:40:00 | AAPL | Stock | 7.3771 | 7.4089 | 7.3736 | 7.4018 | 19608624.0 |
| 2010-01-22 09:45:00 | AAPL | Stock | 7.4004 | 7.4107 | 7.3786 | 7.4104 | 11533116.0 |
| 2010-01-22 09:50:00 | AAPL | Stock | 7.4086 | 7.4107 | 7.3286 | 7.3489 | 19933368.0 |
| 2010-01-22 09:55:00 | AAPL | Stock | 7.35 | 7.3743 | 7.345 | 7.3682 | 8407280.0 |
| 2010-01-22 10:00:00 | AAPL | Stock | 7.3641 | 7.3671 | 7.3268 | 7.3277 | 11187400.0 |
| 2010-01-22 10:05:00 | AAPL | Stock | 7.3293 | 7.3304 | 7.2797 | 7.2821 | 28202608.0 |
| 2010-01-22 10:10:00 | AAPL | Stock | 7.2814 | 7.3036 | 7.2596 | 7.2968 | 22264004.0 |
| 2010-01-22 10:15:00 | AAPL | Stock | 7.295 | 7.2996 | 7.27 | 7.2932 | 12064640.0 |
| 2010-01-22 10:20:00 | AAPL | Stock | 7.2932 | 7.3125 | 7.2825 | 7.3121 | 10316208.0 |
| 2010-01-22 10:25:00 | AAPL | Stock | 7.3086 | 7.3357 | 7.3004 | 7.3279 | 11016768.0 |
| 2010-01-22 10:30:00 | AAPL | Stock | 7.3257 | 7.3279 | 7.3075 | 7.3114 | 7270984.0 |
| 2010-01-22 10:35:00 | AAPL | Stock | 7.3143 | 7.315 | 7.2996 | 7.306 | 7156408.0 |
| 2010-01-22 10:40:00 | AAPL | Stock | 7.3057 | 7.3282 | 7.2975 | 7.3096 | 9743636.0 |
| 2010-01-22 10:45:00 | AAPL | Stock | 7.3107 | 7.311 | 7.2829 | 7.2842 | 8757560.0 |
| 2010-01-22 10:50:00 | AAPL | Stock | 7.2848 | 7.2954 | 7.2825 | 7.2929 | 5447988.0 |
| 2010-01-22 10:55:00 | AAPL | Stock | 7.2929 | 7.3036 | 7.2875 | 7.2982 | 4791808.0 |
> showing 50 of 328,495 rows — these rows as CSV