PREVIEW / stock_5min / 2008-09-12
file: by_date/stock_5min/2008/2008-09-12.parquet size: 4.4 MB rows: 314,368 symbols: 3,313
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-09-12 07:05:00 | AAPL | Stock | 5.4711 | 5.4711 | 5.4711 | 5.4711 | 2800.0 |
| 2008-09-12 07:10:00 | AAPL | Stock | 5.4182 | 5.4182 | 5.4182 | 5.4182 | 2800.0 |
| 2008-09-12 07:50:00 | AAPL | Stock | 5.4464 | 5.4464 | 5.4464 | 5.4464 | 2800.0 |
| 2008-09-12 07:55:00 | AAPL | Stock | 5.4289 | 5.4289 | 5.4289 | 5.4289 | 2800.0 |
| 2008-09-12 08:00:00 | AAPL | Stock | 5.4289 | 5.4464 | 5.4289 | 5.4332 | 96516.0 |
| 2008-09-12 08:05:00 | AAPL | Stock | 5.4325 | 5.455 | 5.4321 | 5.4443 | 151060.0 |
| 2008-09-12 08:10:00 | AAPL | Stock | 5.4518 | 5.4518 | 5.4446 | 5.4464 | 138656.0 |
| 2008-09-12 08:15:00 | AAPL | Stock | 5.45 | 5.45 | 5.4429 | 5.4429 | 116144.0 |
| 2008-09-12 08:20:00 | AAPL | Stock | 5.44 | 5.4407 | 5.4375 | 5.4375 | 11200.0 |
| 2008-09-12 08:25:00 | AAPL | Stock | 5.4425 | 5.4425 | 5.4425 | 5.4425 | 2800.0 |
| 2008-09-12 08:30:00 | AAPL | Stock | 5.4389 | 5.4389 | 5.4121 | 5.4121 | 282856.0 |
| 2008-09-12 08:35:00 | AAPL | Stock | 5.4143 | 5.4193 | 5.4075 | 5.4075 | 231000.0 |
| 2008-09-12 08:40:00 | AAPL | Stock | 5.4075 | 5.4179 | 5.4071 | 5.4179 | 176652.0 |
| 2008-09-12 08:45:00 | AAPL | Stock | 5.4179 | 5.4179 | 5.4068 | 5.4068 | 123704.0 |
| 2008-09-12 08:50:00 | AAPL | Stock | 5.4064 | 5.4107 | 5.4064 | 5.41 | 66108.0 |
| 2008-09-12 08:55:00 | AAPL | Stock | 5.4046 | 5.4046 | 5.3946 | 5.3982 | 121156.0 |
| 2008-09-12 09:00:00 | AAPL | Stock | 5.3986 | 5.4036 | 5.3982 | 5.3982 | 69664.0 |
| 2008-09-12 09:05:00 | AAPL | Stock | 5.3989 | 5.3989 | 5.385 | 5.3921 | 132412.0 |
| 2008-09-12 09:10:00 | AAPL | Stock | 5.3929 | 5.3957 | 5.3864 | 5.3929 | 180012.0 |
| 2008-09-12 09:15:00 | AAPL | Stock | 5.3929 | 5.3929 | 5.3857 | 5.3875 | 217504.0 |
| 2008-09-12 09:20:00 | AAPL | Stock | 5.3875 | 5.3875 | 5.3857 | 5.3875 | 97720.0 |
| 2008-09-12 09:25:00 | AAPL | Stock | 5.3871 | 5.3911 | 5.3825 | 5.3864 | 498428.0 |
| 2008-09-12 09:30:00 | AAPL | Stock | 5.3861 | 5.3896 | 5.3407 | 5.3411 | 18912068.0 |
| 2008-09-12 09:35:00 | AAPL | Stock | 5.3393 | 5.3543 | 5.3214 | 5.3268 | 18110288.0 |
| 2008-09-12 09:40:00 | AAPL | Stock | 5.3271 | 5.3354 | 5.29 | 5.3219 | 22233680.0 |
| 2008-09-12 09:45:00 | AAPL | Stock | 5.3239 | 5.3268 | 5.2957 | 5.3036 | 15620220.0 |
| 2008-09-12 09:50:00 | AAPL | Stock | 5.3032 | 5.3293 | 5.29 | 5.3214 | 15099616.0 |
| 2008-09-12 09:55:00 | AAPL | Stock | 5.3211 | 5.3439 | 5.2968 | 5.2979 | 15893612.0 |
| 2008-09-12 10:00:00 | AAPL | Stock | 5.2982 | 5.3061 | 5.2679 | 5.2821 | 21290108.0 |
| 2008-09-12 10:05:00 | AAPL | Stock | 5.2821 | 5.305 | 5.2768 | 5.2943 | 15715308.0 |
| 2008-09-12 10:10:00 | AAPL | Stock | 5.2943 | 5.2968 | 5.2729 | 5.2843 | 10791088.0 |
| 2008-09-12 10:15:00 | AAPL | Stock | 5.2846 | 5.3075 | 5.2796 | 5.29 | 12288472.0 |
| 2008-09-12 10:20:00 | AAPL | Stock | 5.29 | 5.3118 | 5.2786 | 5.3061 | 11690420.0 |
| 2008-09-12 10:25:00 | AAPL | Stock | 5.3057 | 5.3193 | 5.2864 | 5.2871 | 10887772.0 |
| 2008-09-12 10:30:00 | AAPL | Stock | 5.2882 | 5.2932 | 5.2579 | 5.2657 | 14606340.0 |
| 2008-09-12 10:35:00 | AAPL | Stock | 5.2657 | 5.2746 | 5.2321 | 5.2556 | 22609020.0 |
| 2008-09-12 10:40:00 | AAPL | Stock | 5.2549 | 5.2657 | 5.2429 | 5.2625 | 13517784.0 |
| 2008-09-12 10:45:00 | AAPL | Stock | 5.2625 | 5.2639 | 5.2429 | 5.2457 | 11701620.0 |
| 2008-09-12 10:50:00 | AAPL | Stock | 5.2461 | 5.2573 | 5.245 | 5.2532 | 11217192.0 |
| 2008-09-12 10:55:00 | AAPL | Stock | 5.2546 | 5.2571 | 5.25 | 5.2561 | 12107676.0 |
| 2008-09-12 11:00:00 | AAPL | Stock | 5.2564 | 5.2907 | 5.255 | 5.2811 | 18475128.0 |
| 2008-09-12 11:05:00 | AAPL | Stock | 5.2811 | 5.3007 | 5.2671 | 5.2979 | 11222568.0 |
| 2008-09-12 11:10:00 | AAPL | Stock | 5.2975 | 5.3321 | 5.2914 | 5.3318 | 14757792.0 |
| 2008-09-12 11:15:00 | AAPL | Stock | 5.3282 | 5.3543 | 5.3271 | 5.3461 | 20864900.0 |
| 2008-09-12 11:20:00 | AAPL | Stock | 5.3454 | 5.3571 | 5.2857 | 5.3504 | 18081056.0 |
| 2008-09-12 11:25:00 | AAPL | Stock | 5.3514 | 5.3643 | 5.3286 | 5.3382 | 13764520.0 |
| 2008-09-12 11:30:00 | AAPL | Stock | 5.3386 | 5.34 | 5.3236 | 5.325 | 7914060.0 |
| 2008-09-12 11:35:00 | AAPL | Stock | 5.325 | 5.3321 | 5.3161 | 5.3193 | 7044408.0 |
| 2008-09-12 11:40:00 | AAPL | Stock | 5.3189 | 5.3332 | 5.3143 | 5.3257 | 7993076.0 |
| 2008-09-12 11:45:00 | AAPL | Stock | 5.3257 | 5.3325 | 5.3139 | 5.3218 | 8164044.0 |
> showing 50 of 314,368 rows — these rows as CSV