PREVIEW / stock_5min / 2005-02-04
file: by_date/stock_5min/2005/2005-02-04.parquet size: 2.6 MB rows: 191,777 symbols: 1,928
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 |
|---|---|---|---|---|---|---|---|
| 2005-02-04 08:00:00 | AAPL | Stock | 1.3889 | 1.3889 | 1.3889 | 1.3889 | 28000.0 |
| 2005-02-04 08:05:00 | AAPL | Stock | 1.3889 | 1.3889 | 1.3889 | 1.3889 | 5600.0 |
| 2005-02-04 08:10:00 | AAPL | Stock | 1.3893 | 1.3893 | 1.3893 | 1.3893 | 19600.0 |
| 2005-02-04 08:15:00 | AAPL | Stock | 1.3973 | 1.3973 | 1.3973 | 1.3973 | 98000.0 |
| 2005-02-04 08:30:00 | AAPL | Stock | 1.3929 | 1.3929 | 1.3889 | 1.3927 | 323064.0 |
| 2005-02-04 08:35:00 | AAPL | Stock | 1.3929 | 1.3929 | 1.3893 | 1.3929 | 128240.0 |
| 2005-02-04 08:40:00 | AAPL | Stock | 1.3955 | 1.3955 | 1.3955 | 1.3955 | 52640.0 |
| 2005-02-04 08:45:00 | AAPL | Stock | 1.3929 | 1.3929 | 1.3902 | 1.3929 | 305200.0 |
| 2005-02-04 08:50:00 | AAPL | Stock | 1.3902 | 1.3911 | 1.3902 | 1.3911 | 112000.0 |
| 2005-02-04 09:00:00 | AAPL | Stock | 1.3905 | 1.3905 | 1.3905 | 1.3905 | 5600.0 |
| 2005-02-04 09:05:00 | AAPL | Stock | 1.3902 | 1.3909 | 1.3893 | 1.3902 | 59920.0 |
| 2005-02-04 09:10:00 | AAPL | Stock | 1.3902 | 1.3902 | 1.3902 | 1.3902 | 11200.0 |
| 2005-02-04 09:15:00 | AAPL | Stock | 1.3902 | 1.3902 | 1.3902 | 1.3902 | 61040.0 |
| 2005-02-04 09:20:00 | AAPL | Stock | 1.3911 | 1.3911 | 1.3909 | 1.3909 | 33600.0 |
| 2005-02-04 09:25:00 | AAPL | Stock | 1.3902 | 1.3959 | 1.3902 | 1.3936 | 812784.0 |
| 2005-02-04 09:30:00 | AAPL | Stock | 1.3905 | 1.3946 | 1.3845 | 1.39 | 22820896.0 |
| 2005-02-04 09:35:00 | AAPL | Stock | 1.3896 | 1.3991 | 1.3893 | 1.3966 | 20005440.0 |
| 2005-02-04 09:40:00 | AAPL | Stock | 1.3973 | 1.4004 | 1.397 | 1.3979 | 15398264.0 |
| 2005-02-04 09:45:00 | AAPL | Stock | 1.3982 | 1.4005 | 1.3973 | 1.3982 | 14865088.0 |
| 2005-02-04 09:50:00 | AAPL | Stock | 1.3982 | 1.402 | 1.3982 | 1.4 | 12038096.0 |
| 2005-02-04 09:55:00 | AAPL | Stock | 1.3998 | 1.4045 | 1.3996 | 1.4027 | 17712296.0 |
| 2005-02-04 10:00:00 | AAPL | Stock | 1.4027 | 1.4041 | 1.3988 | 1.4 | 17934448.0 |
| 2005-02-04 10:05:00 | AAPL | Stock | 1.3998 | 1.4009 | 1.395 | 1.3955 | 12535880.0 |
| 2005-02-04 10:10:00 | AAPL | Stock | 1.3955 | 1.3964 | 1.3902 | 1.3941 | 20424768.0 |
| 2005-02-04 10:15:00 | AAPL | Stock | 1.3941 | 1.395 | 1.3898 | 1.3932 | 11280416.0 |
| 2005-02-04 10:20:00 | AAPL | Stock | 1.3929 | 1.3948 | 1.3911 | 1.3911 | 11735304.0 |
| 2005-02-04 10:25:00 | AAPL | Stock | 1.3911 | 1.3925 | 1.3861 | 1.3879 | 16895536.0 |
| 2005-02-04 10:30:00 | AAPL | Stock | 1.388 | 1.3891 | 1.3863 | 1.388 | 12586672.0 |
| 2005-02-04 10:35:00 | AAPL | Stock | 1.3882 | 1.3973 | 1.3875 | 1.3941 | 16333968.0 |
| 2005-02-04 10:40:00 | AAPL | Stock | 1.3941 | 1.3996 | 1.3936 | 1.398 | 13662656.0 |
| 2005-02-04 10:45:00 | AAPL | Stock | 1.3982 | 1.3982 | 1.3955 | 1.3973 | 7147168.0 |
| 2005-02-04 10:50:00 | AAPL | Stock | 1.3973 | 1.3996 | 1.3957 | 1.3971 | 7744744.0 |
| 2005-02-04 10:55:00 | AAPL | Stock | 1.3973 | 1.3988 | 1.397 | 1.3986 | 6683544.0 |
| 2005-02-04 11:00:00 | AAPL | Stock | 1.3986 | 1.4009 | 1.3982 | 1.3996 | 10015824.0 |
| 2005-02-04 11:05:00 | AAPL | Stock | 1.3996 | 1.4014 | 1.3963 | 1.3973 | 11058432.0 |
| 2005-02-04 11:10:00 | AAPL | Stock | 1.3975 | 1.3989 | 1.3946 | 1.3952 | 10191104.0 |
| 2005-02-04 11:15:00 | AAPL | Stock | 1.3961 | 1.3964 | 1.3946 | 1.3963 | 7487592.0 |
| 2005-02-04 11:20:00 | AAPL | Stock | 1.3964 | 1.3964 | 1.3952 | 1.3957 | 3719072.0 |
| 2005-02-04 11:25:00 | AAPL | Stock | 1.3957 | 1.397 | 1.3957 | 1.3964 | 4492152.0 |
| 2005-02-04 11:30:00 | AAPL | Stock | 1.3966 | 1.3984 | 1.3952 | 1.397 | 5903744.0 |
| 2005-02-04 11:35:00 | AAPL | Stock | 1.3971 | 1.3979 | 1.3961 | 1.3979 | 3766504.0 |
| 2005-02-04 11:40:00 | AAPL | Stock | 1.3979 | 1.3979 | 1.3954 | 1.3959 | 4698120.0 |
| 2005-02-04 11:45:00 | AAPL | Stock | 1.3955 | 1.397 | 1.3952 | 1.3957 | 2631104.0 |
| 2005-02-04 11:50:00 | AAPL | Stock | 1.3957 | 1.3966 | 1.3954 | 1.3954 | 4292680.0 |
| 2005-02-04 11:55:00 | AAPL | Stock | 1.3952 | 1.3954 | 1.393 | 1.3938 | 6274072.0 |
| 2005-02-04 12:00:00 | AAPL | Stock | 1.3939 | 1.3952 | 1.393 | 1.3934 | 3923472.0 |
| 2005-02-04 12:05:00 | AAPL | Stock | 1.3934 | 1.3955 | 1.392 | 1.3945 | 5691448.0 |
| 2005-02-04 12:10:00 | AAPL | Stock | 1.3941 | 1.3943 | 1.3918 | 1.392 | 3245424.0 |
| 2005-02-04 12:15:00 | AAPL | Stock | 1.392 | 1.3936 | 1.392 | 1.3936 | 2323104.0 |
| 2005-02-04 12:20:00 | AAPL | Stock | 1.3932 | 1.3945 | 1.3929 | 1.3941 | 1963976.0 |
> showing 50 of 191,777 rows — these rows as CSV