PREVIEW / stock_5min / 2010-10-07
file: by_date/stock_5min/2010/2010-10-07.parquet size: 4.8 MB rows: 330,728 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-10-07 07:05:00 | AAPL | Stock | 10.3675 | 10.3714 | 10.3675 | 10.3714 | 10500.0 |
| 2010-10-07 07:10:00 | AAPL | Stock | 10.3686 | 10.3686 | 10.3686 | 10.3686 | 5600.0 |
| 2010-10-07 07:15:00 | AAPL | Stock | 10.3657 | 10.3657 | 10.3657 | 10.3657 | 2800.0 |
| 2010-10-07 07:20:00 | AAPL | Stock | 10.365 | 10.3654 | 10.3589 | 10.3654 | 39620.0 |
| 2010-10-07 07:25:00 | AAPL | Stock | 10.3571 | 10.3571 | 10.3571 | 10.3571 | 11200.0 |
| 2010-10-07 07:30:00 | AAPL | Stock | 10.3568 | 10.3568 | 10.3568 | 10.3568 | 5404.0 |
| 2010-10-07 07:35:00 | AAPL | Stock | 10.3525 | 10.3568 | 10.3496 | 10.3518 | 42504.0 |
| 2010-10-07 07:40:00 | AAPL | Stock | 10.35 | 10.3611 | 10.35 | 10.3611 | 8400.0 |
| 2010-10-07 07:45:00 | AAPL | Stock | 10.3571 | 10.3571 | 10.35 | 10.3557 | 47404.0 |
| 2010-10-07 07:50:00 | AAPL | Stock | 10.355 | 10.3568 | 10.3514 | 10.3532 | 22400.0 |
| 2010-10-07 07:55:00 | AAPL | Stock | 10.3546 | 10.3546 | 10.3446 | 10.3464 | 30800.0 |
| 2010-10-07 08:00:00 | AAPL | Stock | 10.3432 | 10.3432 | 10.3121 | 10.3121 | 200312.0 |
| 2010-10-07 08:05:00 | AAPL | Stock | 10.3175 | 10.3236 | 10.3175 | 10.3179 | 116760.0 |
| 2010-10-07 08:10:00 | AAPL | Stock | 10.3125 | 10.3143 | 10.2854 | 10.2854 | 114044.0 |
| 2010-10-07 08:15:00 | AAPL | Stock | 10.2839 | 10.2943 | 10.2768 | 10.2786 | 395276.0 |
| 2010-10-07 08:20:00 | AAPL | Stock | 10.2832 | 10.3139 | 10.2721 | 10.3036 | 548212.0 |
| 2010-10-07 08:25:00 | AAPL | Stock | 10.3096 | 10.3211 | 10.3036 | 10.3211 | 250124.0 |
| 2010-10-07 08:30:00 | AAPL | Stock | 10.3211 | 10.3329 | 10.3039 | 10.3089 | 829220.0 |
| 2010-10-07 08:35:00 | AAPL | Stock | 10.3096 | 10.3179 | 10.3075 | 10.3179 | 340200.0 |
| 2010-10-07 08:40:00 | AAPL | Stock | 10.3196 | 10.3393 | 10.3196 | 10.3389 | 391580.0 |
| 2010-10-07 08:45:00 | AAPL | Stock | 10.3371 | 10.3511 | 10.3361 | 10.3511 | 445732.0 |
| 2010-10-07 08:50:00 | AAPL | Stock | 10.3511 | 10.3711 | 10.3464 | 10.3668 | 865732.0 |
| 2010-10-07 08:55:00 | AAPL | Stock | 10.3668 | 10.3929 | 10.3668 | 10.3825 | 902776.0 |
| 2010-10-07 09:00:00 | AAPL | Stock | 10.3821 | 10.3886 | 10.3818 | 10.3832 | 580636.0 |
| 2010-10-07 09:05:00 | AAPL | Stock | 10.3868 | 10.3893 | 10.3675 | 10.3814 | 723660.0 |
| 2010-10-07 09:10:00 | AAPL | Stock | 10.3839 | 10.3879 | 10.3829 | 10.3846 | 216160.0 |
| 2010-10-07 09:15:00 | AAPL | Stock | 10.3854 | 10.3864 | 10.3754 | 10.3768 | 155400.0 |
| 2010-10-07 09:20:00 | AAPL | Stock | 10.3796 | 10.3839 | 10.3732 | 10.3786 | 555212.0 |
| 2010-10-07 09:25:00 | AAPL | Stock | 10.3768 | 10.3768 | 10.365 | 10.365 | 291564.0 |
| 2010-10-07 09:30:00 | AAPL | Stock | 10.3664 | 10.3743 | 10.3218 | 10.3243 | 17838828.0 |
| 2010-10-07 09:35:00 | AAPL | Stock | 10.3236 | 10.3429 | 10.3036 | 10.3057 | 12756800.0 |
| 2010-10-07 09:40:00 | AAPL | Stock | 10.3036 | 10.3143 | 10.2786 | 10.3118 | 13959232.0 |
| 2010-10-07 09:45:00 | AAPL | Stock | 10.3079 | 10.3096 | 10.2589 | 10.2739 | 12370904.0 |
| 2010-10-07 09:50:00 | AAPL | Stock | 10.2721 | 10.2893 | 10.2468 | 10.2766 | 11564056.0 |
| 2010-10-07 09:55:00 | AAPL | Stock | 10.2787 | 10.2929 | 10.2643 | 10.2711 | 8824312.0 |
| 2010-10-07 10:00:00 | AAPL | Stock | 10.2686 | 10.2817 | 10.2589 | 10.2739 | 9681112.0 |
| 2010-10-07 10:05:00 | AAPL | Stock | 10.274 | 10.2975 | 10.274 | 10.2913 | 6976256.0 |
| 2010-10-07 10:10:00 | AAPL | Stock | 10.2929 | 10.3211 | 10.2911 | 10.3086 | 9008132.0 |
| 2010-10-07 10:15:00 | AAPL | Stock | 10.3104 | 10.3143 | 10.2857 | 10.3125 | 6066396.0 |
| 2010-10-07 10:20:00 | AAPL | Stock | 10.3118 | 10.3518 | 10.31 | 10.3436 | 11757480.0 |
| 2010-10-07 10:25:00 | AAPL | Stock | 10.344 | 10.3532 | 10.3307 | 10.3479 | 7705292.0 |
| 2010-10-07 10:30:00 | AAPL | Stock | 10.3501 | 10.3504 | 10.3357 | 10.3357 | 4196640.0 |
| 2010-10-07 10:35:00 | AAPL | Stock | 10.3361 | 10.3489 | 10.3225 | 10.3244 | 5564720.0 |
| 2010-10-07 10:40:00 | AAPL | Stock | 10.3254 | 10.3289 | 10.3071 | 10.3254 | 7089544.0 |
| 2010-10-07 10:45:00 | AAPL | Stock | 10.3254 | 10.3304 | 10.3157 | 10.3301 | 3492636.0 |
| 2010-10-07 10:50:00 | AAPL | Stock | 10.329 | 10.3403 | 10.3239 | 10.3282 | 4569992.0 |
| 2010-10-07 10:55:00 | AAPL | Stock | 10.3289 | 10.3361 | 10.3143 | 10.3143 | 3238956.0 |
| 2010-10-07 11:00:00 | AAPL | Stock | 10.3143 | 10.3168 | 10.2964 | 10.2964 | 7685132.0 |
| 2010-10-07 11:05:00 | AAPL | Stock | 10.2964 | 10.3046 | 10.2957 | 10.3025 | 2601284.0 |
| 2010-10-07 11:10:00 | AAPL | Stock | 10.3018 | 10.3036 | 10.2868 | 10.2996 | 4107852.0 |
> showing 50 of 330,728 rows — these rows as CSV