PREVIEW / stock_5min / 2010-01-13
file: by_date/stock_5min/2010/2010-01-13.parquet size: 4.7 MB rows: 319,785 symbols: 3,445
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-13 04:15:00 | AAPL | Stock | 7.4261 | 7.4261 | 7.4261 | 7.4261 | 5600.0 |
| 2010-01-13 06:40:00 | AAPL | Stock | 7.4557 | 7.4557 | 7.4557 | 7.4557 | 2800.0 |
| 2010-01-13 07:05:00 | AAPL | Stock | 7.4518 | 7.4557 | 7.4518 | 7.4557 | 8400.0 |
| 2010-01-13 07:10:00 | AAPL | Stock | 7.4439 | 7.4439 | 7.4436 | 7.4436 | 10080.0 |
| 2010-01-13 07:15:00 | AAPL | Stock | 7.4407 | 7.4407 | 7.4339 | 7.4339 | 5880.0 |
| 2010-01-13 07:20:00 | AAPL | Stock | 7.4386 | 7.4386 | 7.4286 | 7.4286 | 11984.0 |
| 2010-01-13 07:25:00 | AAPL | Stock | 7.4286 | 7.4286 | 7.4214 | 7.4214 | 8400.0 |
| 2010-01-13 07:35:00 | AAPL | Stock | 7.4446 | 7.4446 | 7.4446 | 7.4446 | 8400.0 |
| 2010-01-13 07:50:00 | AAPL | Stock | 7.4429 | 7.4429 | 7.4429 | 7.4429 | 25200.0 |
| 2010-01-13 07:55:00 | AAPL | Stock | 7.4457 | 7.4457 | 7.4429 | 7.4429 | 125804.0 |
| 2010-01-13 08:00:00 | AAPL | Stock | 7.4346 | 7.4464 | 7.4286 | 7.4357 | 120400.0 |
| 2010-01-13 08:05:00 | AAPL | Stock | 7.4354 | 7.4357 | 7.4286 | 7.4318 | 97776.0 |
| 2010-01-13 08:10:00 | AAPL | Stock | 7.4289 | 7.4321 | 7.4246 | 7.4282 | 66500.0 |
| 2010-01-13 08:15:00 | AAPL | Stock | 7.4268 | 7.4268 | 7.4143 | 7.4179 | 96180.0 |
| 2010-01-13 08:20:00 | AAPL | Stock | 7.4268 | 7.4268 | 7.4125 | 7.4125 | 51240.0 |
| 2010-01-13 08:25:00 | AAPL | Stock | 7.4161 | 7.4186 | 7.4129 | 7.4129 | 11200.0 |
| 2010-01-13 08:30:00 | AAPL | Stock | 7.4186 | 7.4257 | 7.4186 | 7.4193 | 75432.0 |
| 2010-01-13 08:35:00 | AAPL | Stock | 7.4218 | 7.4221 | 7.4218 | 7.4221 | 8400.0 |
| 2010-01-13 08:40:00 | AAPL | Stock | 7.4264 | 7.4271 | 7.4232 | 7.4268 | 79128.0 |
| 2010-01-13 08:45:00 | AAPL | Stock | 7.4239 | 7.4239 | 7.4161 | 7.4161 | 72800.0 |
| 2010-01-13 08:50:00 | AAPL | Stock | 7.4179 | 7.4286 | 7.4179 | 7.4179 | 175028.0 |
| 2010-01-13 08:55:00 | AAPL | Stock | 7.4179 | 7.4186 | 7.4043 | 7.4073 | 245364.0 |
| 2010-01-13 09:00:00 | AAPL | Stock | 7.4071 | 7.4125 | 7.4071 | 7.4125 | 79520.0 |
| 2010-01-13 09:05:00 | AAPL | Stock | 7.4129 | 7.4129 | 7.4054 | 7.4064 | 56000.0 |
| 2010-01-13 09:10:00 | AAPL | Stock | 7.4071 | 7.4125 | 7.4071 | 7.4107 | 151200.0 |
| 2010-01-13 09:15:00 | AAPL | Stock | 7.4125 | 7.4132 | 7.4125 | 7.4132 | 11200.0 |
| 2010-01-13 09:20:00 | AAPL | Stock | 7.4136 | 7.4143 | 7.4136 | 7.4143 | 28000.0 |
| 2010-01-13 09:25:00 | AAPL | Stock | 7.4161 | 7.4264 | 7.4161 | 7.425 | 266000.0 |
| 2010-01-13 09:30:00 | AAPL | Stock | 7.4239 | 7.4457 | 7.3964 | 7.4346 | 12910744.0 |
| 2010-01-13 09:35:00 | AAPL | Stock | 7.4336 | 7.4393 | 7.3904 | 7.3989 | 13117440.0 |
| 2010-01-13 09:40:00 | AAPL | Stock | 7.3982 | 7.4018 | 7.3775 | 7.3814 | 11828152.0 |
| 2010-01-13 09:45:00 | AAPL | Stock | 7.3814 | 7.4104 | 7.3813 | 7.3846 | 13447140.0 |
| 2010-01-13 09:50:00 | AAPL | Stock | 7.3861 | 7.4025 | 7.3843 | 7.3989 | 6042960.0 |
| 2010-01-13 09:55:00 | AAPL | Stock | 7.3982 | 7.4036 | 7.3829 | 7.3832 | 9683464.0 |
| 2010-01-13 10:00:00 | AAPL | Stock | 7.3832 | 7.3893 | 7.3507 | 7.3571 | 20458648.0 |
| 2010-01-13 10:05:00 | AAPL | Stock | 7.3562 | 7.3582 | 7.3218 | 7.3236 | 22435504.0 |
| 2010-01-13 10:10:00 | AAPL | Stock | 7.3257 | 7.33 | 7.2893 | 7.3296 | 28959224.0 |
| 2010-01-13 10:15:00 | AAPL | Stock | 7.3296 | 7.3339 | 7.3146 | 7.3307 | 11665248.0 |
| 2010-01-13 10:20:00 | AAPL | Stock | 7.3329 | 7.3329 | 7.3111 | 7.3114 | 11290972.0 |
| 2010-01-13 10:25:00 | AAPL | Stock | 7.3111 | 7.3286 | 7.2936 | 7.3275 | 12096588.0 |
| 2010-01-13 10:30:00 | AAPL | Stock | 7.325 | 7.3425 | 7.3214 | 7.3425 | 11740316.0 |
| 2010-01-13 10:35:00 | AAPL | Stock | 7.3411 | 7.3571 | 7.3364 | 7.3464 | 10641456.0 |
| 2010-01-13 10:40:00 | AAPL | Stock | 7.3464 | 7.3518 | 7.3414 | 7.3461 | 5055428.0 |
| 2010-01-13 10:45:00 | AAPL | Stock | 7.3461 | 7.3629 | 7.3407 | 7.3407 | 7565600.0 |
| 2010-01-13 10:50:00 | AAPL | Stock | 7.3421 | 7.3464 | 7.3379 | 7.3464 | 5417048.0 |
| 2010-01-13 10:55:00 | AAPL | Stock | 7.3464 | 7.3571 | 7.3439 | 7.3504 | 7452872.0 |
| 2010-01-13 11:00:00 | AAPL | Stock | 7.35 | 7.3504 | 7.3364 | 7.3386 | 5250896.0 |
| 2010-01-13 11:05:00 | AAPL | Stock | 7.3386 | 7.345 | 7.3329 | 7.3389 | 4355260.0 |
| 2010-01-13 11:10:00 | AAPL | Stock | 7.3386 | 7.3429 | 7.3221 | 7.3268 | 5971168.0 |
| 2010-01-13 11:15:00 | AAPL | Stock | 7.3271 | 7.3421 | 7.3246 | 7.3404 | 3876124.0 |
> showing 50 of 319,785 rows — these rows as CSV