PREVIEW / stock_5min / 2007-08-20
file: by_date/stock_5min/2007/2007-08-20.parquet size: 4.1 MB rows: 302,910 symbols: 3,123
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 |
|---|---|---|---|---|---|---|---|
| 2007-08-20 09:25:00 | AAPL | Stock | 4.4271 | 4.4271 | 4.4271 | 4.4271 | 2800.0 |
| 2007-08-20 09:30:00 | AAPL | Stock | 4.4282 | 4.4464 | 4.405 | 4.4304 | 32613616.0 |
| 2007-08-20 09:35:00 | AAPL | Stock | 4.4311 | 4.439 | 4.4039 | 4.4071 | 20437760.0 |
| 2007-08-20 09:40:00 | AAPL | Stock | 4.4079 | 4.4286 | 4.4018 | 4.4146 | 19357436.0 |
| 2007-08-20 09:45:00 | AAPL | Stock | 4.4146 | 4.4286 | 4.3968 | 4.3971 | 18689524.0 |
| 2007-08-20 09:50:00 | AAPL | Stock | 4.3971 | 4.4046 | 4.3893 | 4.3921 | 18824316.0 |
| 2007-08-20 09:55:00 | AAPL | Stock | 4.3911 | 4.4107 | 4.3836 | 4.3978 | 17478160.0 |
| 2007-08-20 10:00:00 | AAPL | Stock | 4.3979 | 4.4107 | 4.3971 | 4.405 | 12880224.0 |
| 2007-08-20 10:05:00 | AAPL | Stock | 4.405 | 4.4161 | 4.4046 | 4.4104 | 12774384.0 |
| 2007-08-20 10:10:00 | AAPL | Stock | 4.41 | 4.4154 | 4.4004 | 4.4032 | 10330628.0 |
| 2007-08-20 10:15:00 | AAPL | Stock | 4.4032 | 4.4096 | 4.3986 | 4.4064 | 7032228.0 |
| 2007-08-20 10:20:00 | AAPL | Stock | 4.4061 | 4.4107 | 4.4 | 4.4021 | 7635012.0 |
| 2007-08-20 10:25:00 | AAPL | Stock | 4.4014 | 4.4044 | 4.4007 | 4.4011 | 891044.0 |
| 2007-08-20 10:30:00 | AAPL | Stock | 4.3775 | 4.3875 | 4.375 | 4.3839 | 8537564.0 |
| 2007-08-20 10:35:00 | AAPL | Stock | 4.3839 | 4.3875 | 4.3661 | 4.3736 | 13221348.0 |
| 2007-08-20 10:40:00 | AAPL | Stock | 4.3742 | 4.3829 | 4.3696 | 4.3757 | 8162280.0 |
| 2007-08-20 10:45:00 | AAPL | Stock | 4.3762 | 4.3804 | 4.3582 | 4.3632 | 11446960.0 |
| 2007-08-20 10:50:00 | AAPL | Stock | 4.3629 | 4.3668 | 4.3446 | 4.3539 | 17046932.0 |
| 2007-08-20 10:55:00 | AAPL | Stock | 4.3539 | 4.3604 | 4.3439 | 4.3593 | 13535284.0 |
| 2007-08-20 11:00:00 | AAPL | Stock | 4.3593 | 4.3636 | 4.3436 | 4.3446 | 11558764.0 |
| 2007-08-20 11:05:00 | AAPL | Stock | 4.3446 | 4.3496 | 4.3311 | 4.3461 | 12711356.0 |
| 2007-08-20 11:10:00 | AAPL | Stock | 4.3471 | 4.3704 | 4.3468 | 4.3654 | 11380880.0 |
| 2007-08-20 11:15:00 | AAPL | Stock | 4.3657 | 4.3711 | 4.3586 | 4.3611 | 7558124.0 |
| 2007-08-20 11:20:00 | AAPL | Stock | 4.3614 | 4.3707 | 4.3586 | 4.3625 | 5359424.0 |
| 2007-08-20 11:25:00 | AAPL | Stock | 4.3614 | 4.3811 | 4.3614 | 4.3764 | 7266868.0 |
| 2007-08-20 11:30:00 | AAPL | Stock | 4.3764 | 4.3882 | 4.3754 | 4.3829 | 10787952.0 |
| 2007-08-20 11:35:00 | AAPL | Stock | 4.3829 | 4.3889 | 4.3789 | 4.3818 | 6226920.0 |
| 2007-08-20 11:40:00 | AAPL | Stock | 4.3818 | 4.385 | 4.3732 | 4.3746 | 5184956.0 |
| 2007-08-20 11:45:00 | AAPL | Stock | 4.3737 | 4.3757 | 4.3632 | 4.3636 | 6220956.0 |
| 2007-08-20 11:50:00 | AAPL | Stock | 4.3639 | 4.3654 | 4.3471 | 4.3529 | 9489424.0 |
| 2007-08-20 11:55:00 | AAPL | Stock | 4.3539 | 4.3554 | 4.3364 | 4.3386 | 10505208.0 |
| 2007-08-20 12:00:00 | AAPL | Stock | 4.3382 | 4.3386 | 4.3261 | 4.3339 | 13794088.0 |
| 2007-08-20 12:05:00 | AAPL | Stock | 4.3338 | 4.3418 | 4.3286 | 4.3321 | 6495048.0 |
| 2007-08-20 12:10:00 | AAPL | Stock | 4.3321 | 4.3389 | 4.3214 | 4.3314 | 13137012.0 |
| 2007-08-20 12:15:00 | AAPL | Stock | 4.3307 | 4.3371 | 4.3271 | 4.3321 | 6876632.0 |
| 2007-08-20 12:20:00 | AAPL | Stock | 4.3321 | 4.3361 | 4.3268 | 4.335 | 5277944.0 |
| 2007-08-20 12:25:00 | AAPL | Stock | 4.335 | 4.345 | 4.3325 | 4.34 | 7306152.0 |
| 2007-08-20 12:30:00 | AAPL | Stock | 4.3404 | 4.3479 | 4.3357 | 4.3475 | 4460932.0 |
| 2007-08-20 12:35:00 | AAPL | Stock | 4.3479 | 4.3507 | 4.3432 | 4.3432 | 3829952.0 |
| 2007-08-20 12:40:00 | AAPL | Stock | 4.3432 | 4.3446 | 4.3329 | 4.3352 | 5910268.0 |
| 2007-08-20 12:45:00 | AAPL | Stock | 4.3357 | 4.3479 | 4.3357 | 4.34 | 4297608.0 |
| 2007-08-20 12:50:00 | AAPL | Stock | 4.3396 | 4.3414 | 4.3304 | 4.3336 | 4034968.0 |
| 2007-08-20 12:55:00 | AAPL | Stock | 4.3325 | 4.3371 | 4.3225 | 4.3268 | 5335288.0 |
| 2007-08-20 13:00:00 | AAPL | Stock | 4.3264 | 4.3293 | 4.3036 | 4.3171 | 12539912.0 |
| 2007-08-20 13:05:00 | AAPL | Stock | 4.3173 | 4.3214 | 4.31 | 4.3189 | 7149128.0 |
| 2007-08-20 13:10:00 | AAPL | Stock | 4.3189 | 4.3243 | 4.31 | 4.3243 | 7006384.0 |
| 2007-08-20 13:15:00 | AAPL | Stock | 4.3239 | 4.3275 | 4.3182 | 4.3211 | 6205724.0 |
| 2007-08-20 13:20:00 | AAPL | Stock | 4.3204 | 4.3214 | 4.3114 | 4.3196 | 5591152.0 |
| 2007-08-20 13:25:00 | AAPL | Stock | 4.32 | 4.3268 | 4.3164 | 4.32 | 4451048.0 |
| 2007-08-20 13:30:00 | AAPL | Stock | 4.3196 | 4.3275 | 4.3182 | 4.3232 | 4801748.0 |
> showing 50 of 302,910 rows — these rows as CSV