PREVIEW / stock_5min / 2009-11-25
file: by_date/stock_5min/2009/2009-11-25.parquet size: 4.4 MB rows: 305,016 symbols: 3,416
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 |
|---|---|---|---|---|---|---|---|
| 2009-11-25 04:15:00 | AAPL | Stock | 7.2996 | 7.2996 | 7.2996 | 7.2996 | 2800.0 |
| 2009-11-25 04:55:00 | AAPL | Stock | 7.3546 | 7.3546 | 7.3546 | 7.3546 | 2800.0 |
| 2009-11-25 06:50:00 | AAPL | Stock | 7.3564 | 7.3564 | 7.3564 | 7.3564 | 2800.0 |
| 2009-11-25 07:00:00 | AAPL | Stock | 7.3375 | 7.3375 | 7.3375 | 7.3375 | 4060.0 |
| 2009-11-25 07:05:00 | AAPL | Stock | 7.3307 | 7.3307 | 7.3304 | 7.3304 | 19600.0 |
| 2009-11-25 07:10:00 | AAPL | Stock | 7.3304 | 7.3304 | 7.3214 | 7.3232 | 22400.0 |
| 2009-11-25 07:15:00 | AAPL | Stock | 7.3218 | 7.3232 | 7.3218 | 7.3232 | 5600.0 |
| 2009-11-25 07:20:00 | AAPL | Stock | 7.325 | 7.325 | 7.325 | 7.325 | 14000.0 |
| 2009-11-25 07:25:00 | AAPL | Stock | 7.325 | 7.3268 | 7.325 | 7.3268 | 39200.0 |
| 2009-11-25 07:30:00 | AAPL | Stock | 7.3286 | 7.3304 | 7.3286 | 7.3304 | 45892.0 |
| 2009-11-25 07:35:00 | AAPL | Stock | 7.3304 | 7.3321 | 7.325 | 7.325 | 22708.0 |
| 2009-11-25 07:45:00 | AAPL | Stock | 7.33 | 7.33 | 7.33 | 7.33 | 2800.0 |
| 2009-11-25 07:55:00 | AAPL | Stock | 7.3321 | 7.3321 | 7.3318 | 7.3321 | 21756.0 |
| 2009-11-25 08:00:00 | AAPL | Stock | 7.3321 | 7.3443 | 7.3304 | 7.3404 | 548268.0 |
| 2009-11-25 08:05:00 | AAPL | Stock | 7.3418 | 7.3418 | 7.3286 | 7.3304 | 241808.0 |
| 2009-11-25 08:10:00 | AAPL | Stock | 7.3321 | 7.335 | 7.3271 | 7.3318 | 224280.0 |
| 2009-11-25 08:15:00 | AAPL | Stock | 7.3275 | 7.3318 | 7.3271 | 7.3318 | 121688.0 |
| 2009-11-25 08:20:00 | AAPL | Stock | 7.3271 | 7.3286 | 7.325 | 7.3286 | 55720.0 |
| 2009-11-25 08:25:00 | AAPL | Stock | 7.3286 | 7.3304 | 7.3268 | 7.3268 | 60508.0 |
| 2009-11-25 08:30:00 | AAPL | Stock | 7.3321 | 7.3393 | 7.3268 | 7.3357 | 545160.0 |
| 2009-11-25 08:35:00 | AAPL | Stock | 7.3371 | 7.3425 | 7.3364 | 7.3418 | 242060.0 |
| 2009-11-25 08:40:00 | AAPL | Stock | 7.3393 | 7.3518 | 7.3393 | 7.3518 | 897652.0 |
| 2009-11-25 08:45:00 | AAPL | Stock | 7.3464 | 7.3518 | 7.3464 | 7.3482 | 300160.0 |
| 2009-11-25 08:50:00 | AAPL | Stock | 7.3495 | 7.3495 | 7.345 | 7.3454 | 93884.0 |
| 2009-11-25 08:55:00 | AAPL | Stock | 7.3454 | 7.3454 | 7.3393 | 7.3425 | 216580.0 |
| 2009-11-25 09:00:00 | AAPL | Stock | 7.3404 | 7.3425 | 7.3336 | 7.3404 | 504140.0 |
| 2009-11-25 09:05:00 | AAPL | Stock | 7.3393 | 7.3411 | 7.3357 | 7.3357 | 224000.0 |
| 2009-11-25 09:10:00 | AAPL | Stock | 7.3375 | 7.3375 | 7.3304 | 7.3314 | 202860.0 |
| 2009-11-25 09:15:00 | AAPL | Stock | 7.3325 | 7.3334 | 7.3279 | 7.3279 | 204344.0 |
| 2009-11-25 09:20:00 | AAPL | Stock | 7.3318 | 7.3339 | 7.3318 | 7.3321 | 59780.0 |
| 2009-11-25 09:25:00 | AAPL | Stock | 7.3318 | 7.3393 | 7.3318 | 7.3393 | 326620.0 |
| 2009-11-25 09:30:00 | AAPL | Stock | 7.3393 | 7.3446 | 7.3125 | 7.3179 | 12461232.0 |
| 2009-11-25 09:35:00 | AAPL | Stock | 7.3175 | 7.3368 | 7.3154 | 7.3293 | 12554752.0 |
| 2009-11-25 09:40:00 | AAPL | Stock | 7.3284 | 7.3307 | 7.3096 | 7.3161 | 7987868.0 |
| 2009-11-25 09:45:00 | AAPL | Stock | 7.3161 | 7.3179 | 7.3004 | 7.3025 | 5435164.0 |
| 2009-11-25 09:50:00 | AAPL | Stock | 7.3024 | 7.3061 | 7.2796 | 7.2961 | 7887432.0 |
| 2009-11-25 09:55:00 | AAPL | Stock | 7.2957 | 7.3143 | 7.2946 | 7.3139 | 7464604.0 |
| 2009-11-25 10:00:00 | AAPL | Stock | 7.3139 | 7.3207 | 7.2975 | 7.3171 | 7337176.0 |
| 2009-11-25 10:05:00 | AAPL | Stock | 7.315 | 7.3164 | 7.305 | 7.3061 | 3152408.0 |
| 2009-11-25 10:10:00 | AAPL | Stock | 7.3061 | 7.3089 | 7.2975 | 7.2996 | 2954504.0 |
| 2009-11-25 10:15:00 | AAPL | Stock | 7.2989 | 7.3114 | 7.2975 | 7.3096 | 4993884.0 |
| 2009-11-25 10:20:00 | AAPL | Stock | 7.3096 | 7.3125 | 7.3007 | 7.3075 | 3789660.0 |
| 2009-11-25 10:25:00 | AAPL | Stock | 7.3057 | 7.3064 | 7.2861 | 7.2936 | 5380704.0 |
| 2009-11-25 10:30:00 | AAPL | Stock | 7.2943 | 7.305 | 7.2918 | 7.3007 | 3627232.0 |
| 2009-11-25 10:35:00 | AAPL | Stock | 7.3007 | 7.3032 | 7.2979 | 7.2986 | 2831136.0 |
| 2009-11-25 10:40:00 | AAPL | Stock | 7.2982 | 7.3071 | 7.2971 | 7.3071 | 3344852.0 |
| 2009-11-25 10:45:00 | AAPL | Stock | 7.3071 | 7.3125 | 7.3061 | 7.3089 | 2965984.0 |
| 2009-11-25 10:50:00 | AAPL | Stock | 7.3082 | 7.3089 | 7.3 | 7.3032 | 2425836.0 |
| 2009-11-25 10:55:00 | AAPL | Stock | 7.3032 | 7.3043 | 7.3 | 7.3025 | 1684956.0 |
| 2009-11-25 11:00:00 | AAPL | Stock | 7.3032 | 7.305 | 7.3004 | 7.3014 | 1562316.0 |
> showing 50 of 305,016 rows — these rows as CSV