PREVIEW / stock_5min / 2010-12-03
file: by_date/stock_5min/2010/2010-12-03.parquet size: 4.8 MB rows: 327,836 symbols: 3,514
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-12-03 07:00:00 | AAPL | Stock | 11.3714 | 11.3714 | 11.3711 | 11.3714 | 197400.0 |
| 2010-12-03 07:15:00 | AAPL | Stock | 11.3786 | 11.3786 | 11.3786 | 11.3786 | 2800.0 |
| 2010-12-03 07:20:00 | AAPL | Stock | 11.3821 | 11.3821 | 11.3821 | 11.3821 | 8400.0 |
| 2010-12-03 07:25:00 | AAPL | Stock | 11.3839 | 11.3839 | 11.375 | 11.3821 | 58800.0 |
| 2010-12-03 07:30:00 | AAPL | Stock | 11.3886 | 11.3886 | 11.3886 | 11.3886 | 13720.0 |
| 2010-12-03 07:35:00 | AAPL | Stock | 11.3889 | 11.3889 | 11.3882 | 11.3882 | 19320.0 |
| 2010-12-03 07:40:00 | AAPL | Stock | 11.3807 | 11.3818 | 11.3807 | 11.3818 | 5600.0 |
| 2010-12-03 07:45:00 | AAPL | Stock | 11.3818 | 11.3818 | 11.3818 | 11.3818 | 2800.0 |
| 2010-12-03 07:50:00 | AAPL | Stock | 11.3811 | 11.3893 | 11.38 | 11.3893 | 19600.0 |
| 2010-12-03 07:55:00 | AAPL | Stock | 11.3921 | 11.3929 | 11.3921 | 11.3929 | 20860.0 |
| 2010-12-03 08:00:00 | AAPL | Stock | 11.3929 | 11.4018 | 11.3786 | 11.3882 | 403116.0 |
| 2010-12-03 08:05:00 | AAPL | Stock | 11.3843 | 11.3843 | 11.3804 | 11.3821 | 62692.0 |
| 2010-12-03 08:10:00 | AAPL | Stock | 11.3821 | 11.3946 | 11.3793 | 11.3893 | 229180.0 |
| 2010-12-03 08:15:00 | AAPL | Stock | 11.3929 | 11.4 | 11.3893 | 11.3971 | 251944.0 |
| 2010-12-03 08:20:00 | AAPL | Stock | 11.3993 | 11.3993 | 11.3875 | 11.3982 | 401576.0 |
| 2010-12-03 08:25:00 | AAPL | Stock | 11.3982 | 11.4014 | 11.3893 | 11.3979 | 357168.0 |
| 2010-12-03 08:30:00 | AAPL | Stock | 11.3939 | 11.3993 | 11.3071 | 11.3071 | 2498972.0 |
| 2010-12-03 08:35:00 | AAPL | Stock | 11.3096 | 11.3096 | 11.2714 | 11.2932 | 1988784.0 |
| 2010-12-03 08:40:00 | AAPL | Stock | 11.2932 | 11.2982 | 11.2843 | 11.2961 | 1411340.0 |
| 2010-12-03 08:45:00 | AAPL | Stock | 11.2964 | 11.3068 | 11.2607 | 11.2768 | 1632960.0 |
| 2010-12-03 08:50:00 | AAPL | Stock | 11.2786 | 11.2786 | 11.2589 | 11.2607 | 709408.0 |
| 2010-12-03 08:55:00 | AAPL | Stock | 11.2611 | 11.2714 | 11.2571 | 11.2686 | 1178324.0 |
| 2010-12-03 09:00:00 | AAPL | Stock | 11.2718 | 11.2764 | 11.2661 | 11.2732 | 1024324.0 |
| 2010-12-03 09:05:00 | AAPL | Stock | 11.2732 | 11.2914 | 11.2732 | 11.28 | 1107064.0 |
| 2010-12-03 09:10:00 | AAPL | Stock | 11.2857 | 11.2971 | 11.2832 | 11.295 | 777084.0 |
| 2010-12-03 09:15:00 | AAPL | Stock | 11.2936 | 11.2936 | 11.2857 | 11.2886 | 289212.0 |
| 2010-12-03 09:20:00 | AAPL | Stock | 11.2886 | 11.3029 | 11.2882 | 11.2982 | 395920.0 |
| 2010-12-03 09:25:00 | AAPL | Stock | 11.3004 | 11.3214 | 11.2975 | 11.3211 | 801416.0 |
| 2010-12-03 09:30:00 | AAPL | Stock | 11.3211 | 11.3482 | 11.2989 | 11.3397 | 19377876.0 |
| 2010-12-03 09:35:00 | AAPL | Stock | 11.3368 | 11.3432 | 11.3179 | 11.3293 | 15723932.0 |
| 2010-12-03 09:40:00 | AAPL | Stock | 11.3314 | 11.3518 | 11.3296 | 11.3454 | 9059008.0 |
| 2010-12-03 09:45:00 | AAPL | Stock | 11.3464 | 11.3518 | 11.3304 | 11.3511 | 9897496.0 |
| 2010-12-03 09:50:00 | AAPL | Stock | 11.3518 | 11.3564 | 11.3343 | 11.3368 | 8888740.0 |
| 2010-12-03 09:55:00 | AAPL | Stock | 11.3361 | 11.3475 | 11.3357 | 11.3461 | 3843588.0 |
| 2010-12-03 10:00:00 | AAPL | Stock | 11.3446 | 11.3804 | 11.344 | 11.3739 | 16574096.0 |
| 2010-12-03 10:05:00 | AAPL | Stock | 11.3743 | 11.3782 | 11.3482 | 11.355 | 6905836.0 |
| 2010-12-03 10:10:00 | AAPL | Stock | 11.355 | 11.3589 | 11.3436 | 11.3482 | 7102116.0 |
| 2010-12-03 10:15:00 | AAPL | Stock | 11.3475 | 11.3639 | 11.3468 | 11.3596 | 5592468.0 |
| 2010-12-03 10:20:00 | AAPL | Stock | 11.3614 | 11.3625 | 11.3446 | 11.3571 | 5271084.0 |
| 2010-12-03 10:25:00 | AAPL | Stock | 11.3579 | 11.3621 | 11.3486 | 11.3593 | 3606204.0 |
| 2010-12-03 10:30:00 | AAPL | Stock | 11.3607 | 11.3657 | 11.3475 | 11.3525 | 4935588.0 |
| 2010-12-03 10:35:00 | AAPL | Stock | 11.3514 | 11.3586 | 11.3489 | 11.3514 | 3323432.0 |
| 2010-12-03 10:40:00 | AAPL | Stock | 11.3522 | 11.3536 | 11.3264 | 11.3289 | 6098596.0 |
| 2010-12-03 10:45:00 | AAPL | Stock | 11.3311 | 11.3404 | 11.3292 | 11.33 | 4051488.0 |
| 2010-12-03 10:50:00 | AAPL | Stock | 11.3296 | 11.3479 | 11.3296 | 11.3439 | 3481604.0 |
| 2010-12-03 10:55:00 | AAPL | Stock | 11.3422 | 11.3507 | 11.3339 | 11.3502 | 3027024.0 |
| 2010-12-03 11:00:00 | AAPL | Stock | 11.3504 | 11.3536 | 11.3386 | 11.3439 | 3435740.0 |
| 2010-12-03 11:05:00 | AAPL | Stock | 11.3439 | 11.3523 | 11.3411 | 11.3511 | 1857296.0 |
| 2010-12-03 11:10:00 | AAPL | Stock | 11.3489 | 11.3507 | 11.3325 | 11.3336 | 3029124.0 |
| 2010-12-03 11:15:00 | AAPL | Stock | 11.3336 | 11.3404 | 11.3329 | 11.334 | 2096388.0 |
> showing 50 of 327,836 rows — these rows as CSV