PREVIEW / stock_5min / 2008-11-11
file: by_date/stock_5min/2008/2008-11-11.parquet size: 4.2 MB rows: 306,874 symbols: 3,284
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 |
|---|---|---|---|---|---|---|---|
| 2008-11-11 07:15:00 | AAPL | Stock | 3.3646 | 3.3646 | 3.3643 | 3.3643 | 11592.0 |
| 2008-11-11 07:30:00 | AAPL | Stock | 3.3811 | 3.3811 | 3.3811 | 3.3811 | 2800.0 |
| 2008-11-11 07:35:00 | AAPL | Stock | 3.3814 | 3.3814 | 3.3814 | 3.3814 | 8680.0 |
| 2008-11-11 07:40:00 | AAPL | Stock | 3.3818 | 3.3818 | 3.3818 | 3.3818 | 25200.0 |
| 2008-11-11 07:45:00 | AAPL | Stock | 3.3679 | 3.3679 | 3.3679 | 3.3679 | 2800.0 |
| 2008-11-11 07:50:00 | AAPL | Stock | 3.3818 | 3.3818 | 3.3818 | 3.3818 | 5600.0 |
| 2008-11-11 07:55:00 | AAPL | Stock | 3.3732 | 3.3732 | 3.3732 | 3.3732 | 2800.0 |
| 2008-11-11 08:00:00 | AAPL | Stock | 3.375 | 3.3814 | 3.3711 | 3.3739 | 108724.0 |
| 2008-11-11 08:05:00 | AAPL | Stock | 3.3743 | 3.3811 | 3.3743 | 3.375 | 231364.0 |
| 2008-11-11 08:10:00 | AAPL | Stock | 3.375 | 3.3818 | 3.375 | 3.3786 | 61880.0 |
| 2008-11-11 08:15:00 | AAPL | Stock | 3.3757 | 3.3757 | 3.3632 | 3.3643 | 163856.0 |
| 2008-11-11 08:20:00 | AAPL | Stock | 3.3643 | 3.3704 | 3.3643 | 3.3693 | 65464.0 |
| 2008-11-11 08:25:00 | AAPL | Stock | 3.3711 | 3.3714 | 3.3696 | 3.3696 | 54880.0 |
| 2008-11-11 08:30:00 | AAPL | Stock | 3.3679 | 3.37 | 3.3643 | 3.3643 | 165564.0 |
| 2008-11-11 08:35:00 | AAPL | Stock | 3.3643 | 3.3686 | 3.3643 | 3.3661 | 103572.0 |
| 2008-11-11 08:40:00 | AAPL | Stock | 3.3661 | 3.37 | 3.3661 | 3.37 | 82600.0 |
| 2008-11-11 08:45:00 | AAPL | Stock | 3.3696 | 3.3739 | 3.3682 | 3.3739 | 141568.0 |
| 2008-11-11 08:50:00 | AAPL | Stock | 3.3721 | 3.3782 | 3.37 | 3.3729 | 269696.0 |
| 2008-11-11 08:55:00 | AAPL | Stock | 3.3729 | 3.3754 | 3.3661 | 3.3714 | 355404.0 |
| 2008-11-11 09:00:00 | AAPL | Stock | 3.3689 | 3.3732 | 3.3686 | 3.3732 | 124600.0 |
| 2008-11-11 09:05:00 | AAPL | Stock | 3.3725 | 3.375 | 3.3725 | 3.3725 | 40712.0 |
| 2008-11-11 09:10:00 | AAPL | Stock | 3.3746 | 3.3789 | 3.3714 | 3.3789 | 137144.0 |
| 2008-11-11 09:15:00 | AAPL | Stock | 3.3775 | 3.3775 | 3.37 | 3.3704 | 215600.0 |
| 2008-11-11 09:20:00 | AAPL | Stock | 3.3732 | 3.3757 | 3.37 | 3.3707 | 53900.0 |
| 2008-11-11 09:25:00 | AAPL | Stock | 3.3732 | 3.3929 | 3.3725 | 3.3818 | 852124.0 |
| 2008-11-11 09:30:00 | AAPL | Stock | 3.3839 | 3.4121 | 3.3618 | 3.3736 | 26625984.0 |
| 2008-11-11 09:35:00 | AAPL | Stock | 3.3743 | 3.3961 | 3.37 | 3.3843 | 23490432.0 |
| 2008-11-11 09:40:00 | AAPL | Stock | 3.3839 | 3.3875 | 3.3304 | 3.3525 | 32014304.0 |
| 2008-11-11 09:45:00 | AAPL | Stock | 3.3525 | 3.3554 | 3.3221 | 3.3279 | 21376684.0 |
| 2008-11-11 09:50:00 | AAPL | Stock | 3.3275 | 3.3329 | 3.3107 | 3.3211 | 28850864.0 |
| 2008-11-11 09:55:00 | AAPL | Stock | 3.3211 | 3.3246 | 3.295 | 3.3079 | 21139076.0 |
| 2008-11-11 10:00:00 | AAPL | Stock | 3.3071 | 3.3311 | 3.2982 | 3.3304 | 19109440.0 |
| 2008-11-11 10:05:00 | AAPL | Stock | 3.33 | 3.3325 | 3.3157 | 3.33 | 17579912.0 |
| 2008-11-11 10:10:00 | AAPL | Stock | 3.3293 | 3.3375 | 3.3175 | 3.3261 | 17667916.0 |
| 2008-11-11 10:15:00 | AAPL | Stock | 3.3261 | 3.3364 | 3.3096 | 3.3314 | 16412172.0 |
| 2008-11-11 10:20:00 | AAPL | Stock | 3.3311 | 3.3393 | 3.3193 | 3.3379 | 16435524.0 |
| 2008-11-11 10:25:00 | AAPL | Stock | 3.3386 | 3.3439 | 3.325 | 3.3289 | 15338764.0 |
| 2008-11-11 10:30:00 | AAPL | Stock | 3.3275 | 3.3368 | 3.3214 | 3.3332 | 13098456.0 |
| 2008-11-11 10:35:00 | AAPL | Stock | 3.3329 | 3.3339 | 3.3146 | 3.315 | 14300664.0 |
| 2008-11-11 10:40:00 | AAPL | Stock | 3.3146 | 3.3168 | 3.3004 | 3.3011 | 17811836.0 |
| 2008-11-11 10:45:00 | AAPL | Stock | 3.3007 | 3.3132 | 3.2979 | 3.3114 | 17339224.0 |
| 2008-11-11 10:50:00 | AAPL | Stock | 3.3107 | 3.3275 | 3.3086 | 3.3243 | 11946256.0 |
| 2008-11-11 10:55:00 | AAPL | Stock | 3.3243 | 3.3254 | 3.3104 | 3.3129 | 13387052.0 |
| 2008-11-11 11:00:00 | AAPL | Stock | 3.3125 | 3.3214 | 3.3079 | 3.3132 | 13094620.0 |
| 2008-11-11 11:05:00 | AAPL | Stock | 3.3136 | 3.3254 | 3.3054 | 3.3229 | 12552064.0 |
| 2008-11-11 11:10:00 | AAPL | Stock | 3.3221 | 3.3254 | 3.3168 | 3.3211 | 10367168.0 |
| 2008-11-11 11:15:00 | AAPL | Stock | 3.3207 | 3.3246 | 3.3118 | 3.314 | 9183692.0 |
| 2008-11-11 11:20:00 | AAPL | Stock | 3.3139 | 3.3321 | 3.3132 | 3.3229 | 11391044.0 |
| 2008-11-11 11:25:00 | AAPL | Stock | 3.3225 | 3.3254 | 3.3161 | 3.3171 | 9129512.0 |
| 2008-11-11 11:30:00 | AAPL | Stock | 3.3168 | 3.3196 | 3.3036 | 3.3079 | 11835992.0 |
> showing 50 of 306,874 rows — these rows as CSV