PREVIEW / stock_5min / 2009-10-22
file: by_date/stock_5min/2009/2009-10-22.parquet size: 4.7 MB rows: 317,946 symbols: 3,390
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-10-22 04:20:00 | AAPL | Stock | 7.2893 | 7.2893 | 7.2679 | 7.2679 | 19600.0 |
| 2009-10-22 04:30:00 | AAPL | Stock | 7.2707 | 7.2707 | 7.2707 | 7.2707 | 2800.0 |
| 2009-10-22 04:40:00 | AAPL | Stock | 7.2696 | 7.2696 | 7.2693 | 7.2693 | 5600.0 |
| 2009-10-22 04:45:00 | AAPL | Stock | 7.2689 | 7.2689 | 7.2689 | 7.2689 | 2800.0 |
| 2009-10-22 05:05:00 | AAPL | Stock | 7.2507 | 7.2507 | 7.2507 | 7.2507 | 6916.0 |
| 2009-10-22 05:10:00 | AAPL | Stock | 7.2511 | 7.2511 | 7.2511 | 7.2511 | 2800.0 |
| 2009-10-22 05:20:00 | AAPL | Stock | 7.2504 | 7.2504 | 7.2504 | 7.2504 | 2800.0 |
| 2009-10-22 05:25:00 | AAPL | Stock | 7.2504 | 7.2504 | 7.2504 | 7.2504 | 2800.0 |
| 2009-10-22 05:40:00 | AAPL | Stock | 7.2589 | 7.2589 | 7.2589 | 7.2589 | 2800.0 |
| 2009-10-22 05:45:00 | AAPL | Stock | 7.2589 | 7.2589 | 7.25 | 7.25 | 5600.0 |
| 2009-10-22 06:45:00 | AAPL | Stock | 7.2746 | 7.2821 | 7.2746 | 7.2821 | 9240.0 |
| 2009-10-22 06:50:00 | AAPL | Stock | 7.2839 | 7.2861 | 7.2839 | 7.2861 | 8400.0 |
| 2009-10-22 06:55:00 | AAPL | Stock | 7.2875 | 7.2875 | 7.2875 | 7.2875 | 2800.0 |
| 2009-10-22 07:00:00 | AAPL | Stock | 7.3057 | 7.3214 | 7.3057 | 7.3071 | 13048.0 |
| 2009-10-22 07:05:00 | AAPL | Stock | 7.3036 | 7.3157 | 7.2929 | 7.3157 | 22092.0 |
| 2009-10-22 07:25:00 | AAPL | Stock | 7.2954 | 7.2968 | 7.295 | 7.2968 | 60396.0 |
| 2009-10-22 07:30:00 | AAPL | Stock | 7.3 | 7.3 | 7.3 | 7.3 | 8512.0 |
| 2009-10-22 07:40:00 | AAPL | Stock | 7.3036 | 7.3036 | 7.3032 | 7.3032 | 33320.0 |
| 2009-10-22 07:55:00 | AAPL | Stock | 7.3018 | 7.3018 | 7.2964 | 7.2964 | 43148.0 |
| 2009-10-22 08:00:00 | AAPL | Stock | 7.3 | 7.3371 | 7.3 | 7.3339 | 616448.0 |
| 2009-10-22 08:05:00 | AAPL | Stock | 7.3368 | 7.3568 | 7.3357 | 7.3493 | 734384.0 |
| 2009-10-22 08:10:00 | AAPL | Stock | 7.3464 | 7.3675 | 7.3429 | 7.3675 | 858424.0 |
| 2009-10-22 08:15:00 | AAPL | Stock | 7.3671 | 7.3764 | 7.3671 | 7.3732 | 992908.0 |
| 2009-10-22 08:20:00 | AAPL | Stock | 7.3714 | 7.3796 | 7.3632 | 7.3796 | 881020.0 |
| 2009-10-22 08:25:00 | AAPL | Stock | 7.3796 | 7.3861 | 7.3732 | 7.3757 | 722988.0 |
| 2009-10-22 08:30:00 | AAPL | Stock | 7.3757 | 7.3814 | 7.3671 | 7.3671 | 785540.0 |
| 2009-10-22 08:35:00 | AAPL | Stock | 7.3668 | 7.3746 | 7.3186 | 7.3732 | 1671124.0 |
| 2009-10-22 08:40:00 | AAPL | Stock | 7.3732 | 7.3736 | 7.3643 | 7.3646 | 210840.0 |
| 2009-10-22 08:45:00 | AAPL | Stock | 7.3646 | 7.3711 | 7.3571 | 7.3711 | 525532.0 |
| 2009-10-22 08:50:00 | AAPL | Stock | 7.3639 | 7.3679 | 7.3632 | 7.3632 | 131824.0 |
| 2009-10-22 08:55:00 | AAPL | Stock | 7.3657 | 7.3661 | 7.3589 | 7.3607 | 221928.0 |
| 2009-10-22 09:00:00 | AAPL | Stock | 7.3607 | 7.3639 | 7.35 | 7.35 | 419720.0 |
| 2009-10-22 09:05:00 | AAPL | Stock | 7.3521 | 7.3561 | 7.3486 | 7.3561 | 354844.0 |
| 2009-10-22 09:10:00 | AAPL | Stock | 7.3568 | 7.3571 | 7.3536 | 7.3536 | 186704.0 |
| 2009-10-22 09:15:00 | AAPL | Stock | 7.3536 | 7.3539 | 7.3521 | 7.3536 | 89572.0 |
| 2009-10-22 09:20:00 | AAPL | Stock | 7.3532 | 7.3536 | 7.3482 | 7.35 | 236740.0 |
| 2009-10-22 09:25:00 | AAPL | Stock | 7.3486 | 7.3486 | 7.3036 | 7.3036 | 1554924.0 |
| 2009-10-22 09:30:00 | AAPL | Stock | 7.3111 | 7.3696 | 7.3 | 7.3675 | 37224908.0 |
| 2009-10-22 09:35:00 | AAPL | Stock | 7.3682 | 7.4107 | 7.3643 | 7.3996 | 32883228.0 |
| 2009-10-22 09:40:00 | AAPL | Stock | 7.3993 | 7.4232 | 7.3982 | 7.4025 | 28562436.0 |
| 2009-10-22 09:45:00 | AAPL | Stock | 7.4007 | 7.4021 | 7.3482 | 7.362 | 27576052.0 |
| 2009-10-22 09:50:00 | AAPL | Stock | 7.3607 | 7.3907 | 7.3589 | 7.3879 | 16185568.0 |
| 2009-10-22 09:55:00 | AAPL | Stock | 7.3882 | 7.3907 | 7.3571 | 7.3611 | 14578592.0 |
| 2009-10-22 10:00:00 | AAPL | Stock | 7.3617 | 7.3821 | 7.3507 | 7.3821 | 13737584.0 |
| 2009-10-22 10:05:00 | AAPL | Stock | 7.3821 | 7.3968 | 7.375 | 7.3855 | 15972768.0 |
| 2009-10-22 10:10:00 | AAPL | Stock | 7.3857 | 7.3893 | 7.3604 | 7.3832 | 12967388.0 |
| 2009-10-22 10:15:00 | AAPL | Stock | 7.3832 | 7.3875 | 7.3571 | 7.3639 | 11260984.0 |
| 2009-10-22 10:20:00 | AAPL | Stock | 7.3643 | 7.3918 | 7.3621 | 7.3893 | 12280856.0 |
| 2009-10-22 10:25:00 | AAPL | Stock | 7.39 | 7.3921 | 7.3482 | 7.3599 | 19965596.0 |
| 2009-10-22 10:30:00 | AAPL | Stock | 7.3593 | 7.375 | 7.3168 | 7.3182 | 23436560.0 |
> showing 50 of 317,946 rows — these rows as CSV