PREVIEW / stock_5min / 2007-04-04
file: by_date/stock_5min/2007/2007-04-04.parquet size: 3.5 MB rows: 252,403 symbols: 2,551
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 |
|---|---|---|---|---|---|---|---|
| 2007-04-04 07:20:00 | AAPL | Stock | 3.3854 | 3.3929 | 3.3839 | 3.3893 | 215600.0 |
| 2007-04-04 07:25:00 | AAPL | Stock | 3.3961 | 3.3961 | 3.3961 | 3.3961 | 18200.0 |
| 2007-04-04 07:30:00 | AAPL | Stock | 3.4014 | 3.4014 | 3.3961 | 3.3961 | 107800.0 |
| 2007-04-04 07:55:00 | AAPL | Stock | 3.3907 | 3.3907 | 3.3893 | 3.3893 | 144200.0 |
| 2007-04-04 08:00:00 | AAPL | Stock | 3.3893 | 3.3964 | 3.3861 | 3.3929 | 394072.0 |
| 2007-04-04 08:05:00 | AAPL | Stock | 3.3929 | 3.3964 | 3.3882 | 3.3893 | 284564.0 |
| 2007-04-04 08:10:00 | AAPL | Stock | 3.3896 | 3.39 | 3.3893 | 3.3893 | 202552.0 |
| 2007-04-04 08:15:00 | AAPL | Stock | 3.3889 | 3.3889 | 3.3868 | 3.3875 | 39200.0 |
| 2007-04-04 08:20:00 | AAPL | Stock | 3.3893 | 3.3893 | 3.3857 | 3.3879 | 135940.0 |
| 2007-04-04 08:25:00 | AAPL | Stock | 3.3879 | 3.3879 | 3.3857 | 3.3857 | 186424.0 |
| 2007-04-04 08:30:00 | AAPL | Stock | 3.3871 | 3.3875 | 3.3857 | 3.3875 | 77448.0 |
| 2007-04-04 08:35:00 | AAPL | Stock | 3.3875 | 3.3875 | 3.3875 | 3.3875 | 18200.0 |
| 2007-04-04 08:40:00 | AAPL | Stock | 3.3875 | 3.3875 | 3.385 | 3.385 | 14000.0 |
| 2007-04-04 08:45:00 | AAPL | Stock | 3.3857 | 3.3857 | 3.385 | 3.385 | 16800.0 |
| 2007-04-04 08:50:00 | AAPL | Stock | 3.3846 | 3.3846 | 3.3839 | 3.3843 | 123676.0 |
| 2007-04-04 08:55:00 | AAPL | Stock | 3.3843 | 3.3846 | 3.3839 | 3.3846 | 70588.0 |
| 2007-04-04 09:00:00 | AAPL | Stock | 3.3846 | 3.3857 | 3.3821 | 3.3839 | 103628.0 |
| 2007-04-04 09:05:00 | AAPL | Stock | 3.385 | 3.385 | 3.375 | 3.3839 | 4316116.0 |
| 2007-04-04 09:10:00 | AAPL | Stock | 3.3857 | 3.3929 | 3.3857 | 3.3896 | 351764.0 |
| 2007-04-04 09:15:00 | AAPL | Stock | 3.3893 | 3.3893 | 3.3893 | 3.3893 | 44800.0 |
| 2007-04-04 09:20:00 | AAPL | Stock | 3.3871 | 3.3871 | 3.3871 | 3.3871 | 2800.0 |
| 2007-04-04 09:25:00 | AAPL | Stock | 3.3871 | 3.3914 | 3.3871 | 3.3911 | 226800.0 |
| 2007-04-04 09:30:00 | AAPL | Stock | 3.3904 | 3.3914 | 3.3761 | 3.38 | 13673436.0 |
| 2007-04-04 09:35:00 | AAPL | Stock | 3.3807 | 3.3875 | 3.375 | 3.3793 | 14020020.0 |
| 2007-04-04 09:40:00 | AAPL | Stock | 3.3796 | 3.3818 | 3.3754 | 3.3761 | 8969772.0 |
| 2007-04-04 09:45:00 | AAPL | Stock | 3.3764 | 3.3786 | 3.3696 | 3.3757 | 12293232.0 |
| 2007-04-04 09:50:00 | AAPL | Stock | 3.375 | 3.3779 | 3.3725 | 3.3776 | 4723628.0 |
| 2007-04-04 09:55:00 | AAPL | Stock | 3.3779 | 3.3804 | 3.3739 | 3.3757 | 5497492.0 |
| 2007-04-04 10:00:00 | AAPL | Stock | 3.3754 | 3.3754 | 3.3707 | 3.3736 | 12379780.0 |
| 2007-04-04 10:05:00 | AAPL | Stock | 3.3732 | 3.375 | 3.3661 | 3.3686 | 14946232.0 |
| 2007-04-04 10:10:00 | AAPL | Stock | 3.3686 | 3.3732 | 3.3679 | 3.3707 | 5590312.0 |
| 2007-04-04 10:15:00 | AAPL | Stock | 3.3711 | 3.3871 | 3.3707 | 3.3846 | 16478616.0 |
| 2007-04-04 10:20:00 | AAPL | Stock | 3.3843 | 3.3893 | 3.3818 | 3.3893 | 13365436.0 |
| 2007-04-04 10:25:00 | AAPL | Stock | 3.3889 | 3.3979 | 3.3886 | 3.3932 | 21566132.0 |
| 2007-04-04 10:30:00 | AAPL | Stock | 3.3929 | 3.3954 | 3.3861 | 3.3886 | 12533360.0 |
| 2007-04-04 10:35:00 | AAPL | Stock | 3.3882 | 3.3921 | 3.3864 | 3.3875 | 7436940.0 |
| 2007-04-04 10:40:00 | AAPL | Stock | 3.3875 | 3.3886 | 3.3846 | 3.3885 | 5889044.0 |
| 2007-04-04 10:45:00 | AAPL | Stock | 3.3886 | 3.3886 | 3.3796 | 3.3804 | 8890644.0 |
| 2007-04-04 10:50:00 | AAPL | Stock | 3.3804 | 3.3807 | 3.3761 | 3.38 | 8353324.0 |
| 2007-04-04 10:55:00 | AAPL | Stock | 3.38 | 3.3846 | 3.3796 | 3.3836 | 6152636.0 |
| 2007-04-04 11:00:00 | AAPL | Stock | 3.3832 | 3.3875 | 3.3825 | 3.385 | 3766756.0 |
| 2007-04-04 11:05:00 | AAPL | Stock | 3.3846 | 3.3879 | 3.3836 | 3.3861 | 3710728.0 |
| 2007-04-04 11:10:00 | AAPL | Stock | 3.3861 | 3.3911 | 3.3861 | 3.3889 | 6593384.0 |
| 2007-04-04 11:15:00 | AAPL | Stock | 3.3889 | 3.3893 | 3.3861 | 3.3868 | 4773132.0 |
| 2007-04-04 11:20:00 | AAPL | Stock | 3.3864 | 3.3907 | 3.3854 | 3.3861 | 5410944.0 |
| 2007-04-04 11:25:00 | AAPL | Stock | 3.3861 | 3.3875 | 3.3843 | 3.3843 | 2458820.0 |
| 2007-04-04 11:30:00 | AAPL | Stock | 3.3843 | 3.3857 | 3.3811 | 3.3839 | 5685848.0 |
| 2007-04-04 11:35:00 | AAPL | Stock | 3.3843 | 3.3846 | 3.3796 | 3.3807 | 5075028.0 |
| 2007-04-04 11:40:00 | AAPL | Stock | 3.38 | 3.3804 | 3.3725 | 3.3736 | 9128812.0 |
| 2007-04-04 11:45:00 | AAPL | Stock | 3.3736 | 3.3771 | 3.3736 | 3.3736 | 2837604.0 |
> showing 50 of 252,403 rows — these rows as CSV