PREVIEW / stock_5min / 2008-04-03
file: by_date/stock_5min/2008/2008-04-03.parquet size: 4.4 MB rows: 320,564 symbols: 3,250
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-04-03 06:10:00 | AAPL | Stock | 5.3071 | 5.3071 | 5.3071 | 5.3071 | 28000.0 |
| 2008-04-03 06:30:00 | AAPL | Stock | 5.2996 | 5.2996 | 5.2996 | 5.2996 | 2800.0 |
| 2008-04-03 07:05:00 | AAPL | Stock | 5.3 | 5.3 | 5.2875 | 5.2875 | 28000.0 |
| 2008-04-03 07:10:00 | AAPL | Stock | 5.2861 | 5.2861 | 5.2857 | 5.2857 | 16800.0 |
| 2008-04-03 07:25:00 | AAPL | Stock | 5.3036 | 5.3114 | 5.3036 | 5.3114 | 33600.0 |
| 2008-04-03 07:30:00 | AAPL | Stock | 5.29 | 5.3089 | 5.2893 | 5.3089 | 42000.0 |
| 2008-04-03 07:35:00 | AAPL | Stock | 5.3129 | 5.3154 | 5.3068 | 5.3068 | 29092.0 |
| 2008-04-03 07:40:00 | AAPL | Stock | 5.3111 | 5.315 | 5.3071 | 5.315 | 22400.0 |
| 2008-04-03 07:50:00 | AAPL | Stock | 5.3175 | 5.3175 | 5.3175 | 5.3175 | 30800.0 |
| 2008-04-03 07:55:00 | AAPL | Stock | 5.3125 | 5.3125 | 5.3125 | 5.3125 | 2800.0 |
| 2008-04-03 08:00:00 | AAPL | Stock | 5.3093 | 5.3125 | 5.3054 | 5.3086 | 270508.0 |
| 2008-04-03 08:05:00 | AAPL | Stock | 5.3071 | 5.3071 | 5.2961 | 5.3036 | 300328.0 |
| 2008-04-03 08:10:00 | AAPL | Stock | 5.3021 | 5.3036 | 5.2893 | 5.2929 | 254268.0 |
| 2008-04-03 08:15:00 | AAPL | Stock | 5.2929 | 5.3043 | 5.2929 | 5.3043 | 73164.0 |
| 2008-04-03 08:20:00 | AAPL | Stock | 5.3032 | 5.3043 | 5.2821 | 5.2839 | 392812.0 |
| 2008-04-03 08:25:00 | AAPL | Stock | 5.285 | 5.2929 | 5.2836 | 5.2925 | 131320.0 |
| 2008-04-03 08:30:00 | AAPL | Stock | 5.2882 | 5.2886 | 5.2554 | 5.2732 | 1008784.0 |
| 2008-04-03 08:35:00 | AAPL | Stock | 5.2679 | 5.2679 | 5.235 | 5.2432 | 813176.0 |
| 2008-04-03 08:40:00 | AAPL | Stock | 5.2461 | 5.2632 | 5.2429 | 5.2579 | 172732.0 |
| 2008-04-03 08:45:00 | AAPL | Stock | 5.2586 | 5.2725 | 5.2586 | 5.2679 | 194180.0 |
| 2008-04-03 08:50:00 | AAPL | Stock | 5.2696 | 5.2811 | 5.2636 | 5.2646 | 206220.0 |
| 2008-04-03 08:55:00 | AAPL | Stock | 5.2636 | 5.2661 | 5.2443 | 5.2496 | 435708.0 |
| 2008-04-03 09:00:00 | AAPL | Stock | 5.2493 | 5.25 | 5.2371 | 5.2371 | 567364.0 |
| 2008-04-03 09:05:00 | AAPL | Stock | 5.2382 | 5.2404 | 5.2343 | 5.2343 | 293860.0 |
| 2008-04-03 09:10:00 | AAPL | Stock | 5.2339 | 5.2382 | 5.2271 | 5.2339 | 477092.0 |
| 2008-04-03 09:15:00 | AAPL | Stock | 5.2339 | 5.2339 | 5.2232 | 5.2268 | 111580.0 |
| 2008-04-03 09:20:00 | AAPL | Stock | 5.2307 | 5.2393 | 5.2275 | 5.2321 | 254940.0 |
| 2008-04-03 09:25:00 | AAPL | Stock | 5.2357 | 5.2586 | 5.2357 | 5.2554 | 1041012.0 |
| 2008-04-03 09:30:00 | AAPL | Stock | 5.2518 | 5.2839 | 5.25 | 5.2825 | 46025224.0 |
| 2008-04-03 09:35:00 | AAPL | Stock | 5.2836 | 5.3032 | 5.2711 | 5.2821 | 24102624.0 |
| 2008-04-03 09:40:00 | AAPL | Stock | 5.2818 | 5.2993 | 5.2714 | 5.2782 | 22057140.0 |
| 2008-04-03 09:45:00 | AAPL | Stock | 5.2782 | 5.3152 | 5.2743 | 5.3096 | 42412104.0 |
| 2008-04-03 09:50:00 | AAPL | Stock | 5.3096 | 5.3332 | 5.3029 | 5.3189 | 17784060.0 |
| 2008-04-03 09:55:00 | AAPL | Stock | 5.3196 | 5.3332 | 5.3189 | 5.3311 | 14960092.0 |
| 2008-04-03 10:00:00 | AAPL | Stock | 5.3307 | 5.3468 | 5.3164 | 5.3436 | 25848788.0 |
| 2008-04-03 10:05:00 | AAPL | Stock | 5.3436 | 5.3629 | 5.3361 | 5.3511 | 25583684.0 |
| 2008-04-03 10:10:00 | AAPL | Stock | 5.3514 | 5.3593 | 5.345 | 5.3482 | 18562488.0 |
| 2008-04-03 10:15:00 | AAPL | Stock | 5.3482 | 5.3531 | 5.3371 | 5.34 | 16480800.0 |
| 2008-04-03 10:20:00 | AAPL | Stock | 5.3399 | 5.3546 | 5.3371 | 5.3413 | 11670456.0 |
| 2008-04-03 10:25:00 | AAPL | Stock | 5.3411 | 5.3518 | 5.3357 | 5.3429 | 10426472.0 |
| 2008-04-03 10:30:00 | AAPL | Stock | 5.3432 | 5.3493 | 5.3321 | 5.3475 | 10465140.0 |
| 2008-04-03 10:35:00 | AAPL | Stock | 5.3471 | 5.3532 | 5.3343 | 5.3371 | 10531808.0 |
| 2008-04-03 10:40:00 | AAPL | Stock | 5.34 | 5.3611 | 5.3382 | 5.3464 | 14255220.0 |
| 2008-04-03 10:45:00 | AAPL | Stock | 5.3464 | 5.3486 | 5.3375 | 5.3421 | 10329928.0 |
| 2008-04-03 10:50:00 | AAPL | Stock | 5.3425 | 5.3464 | 5.3229 | 5.3271 | 13776224.0 |
| 2008-04-03 10:55:00 | AAPL | Stock | 5.3271 | 5.3337 | 5.3236 | 5.3282 | 6180608.0 |
| 2008-04-03 11:00:00 | AAPL | Stock | 5.3275 | 5.3421 | 5.3221 | 5.3362 | 7641788.0 |
| 2008-04-03 11:05:00 | AAPL | Stock | 5.3361 | 5.3611 | 5.3361 | 5.3554 | 13144236.0 |
| 2008-04-03 11:10:00 | AAPL | Stock | 5.3568 | 5.3654 | 5.3486 | 5.3618 | 13578404.0 |
| 2008-04-03 11:15:00 | AAPL | Stock | 5.3646 | 5.3657 | 5.345 | 5.345 | 10335248.0 |
> showing 50 of 320,564 rows — these rows as CSV