PREVIEW / stock_5min / 2003-11-12
file: by_date/stock_5min/2003/2003-11-12.parquet size: 2.3 MB rows: 165,612 symbols: 1,665
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 |
|---|---|---|---|---|---|---|---|
| 2003-11-12 08:00:00 | AAPL | Stock | 0.3846 | 0.3846 | 0.3846 | 0.3846 | 1220800.0 |
| 2003-11-12 08:40:00 | AAPL | Stock | 0.3854 | 0.3854 | 0.3854 | 0.3854 | 28000.0 |
| 2003-11-12 09:00:00 | AAPL | Stock | 0.3848 | 0.3848 | 0.3848 | 0.3848 | 89600.0 |
| 2003-11-12 09:10:00 | AAPL | Stock | 0.3854 | 0.3854 | 0.3841 | 0.3841 | 95200.0 |
| 2003-11-12 09:15:00 | AAPL | Stock | 0.3848 | 0.3848 | 0.3843 | 0.3848 | 173600.0 |
| 2003-11-12 09:20:00 | AAPL | Stock | 0.3854 | 0.3855 | 0.3854 | 0.3855 | 140000.0 |
| 2003-11-12 09:25:00 | AAPL | Stock | 0.3854 | 0.3854 | 0.3845 | 0.3845 | 114800.0 |
| 2003-11-12 09:30:00 | AAPL | Stock | 0.3838 | 0.3882 | 0.3836 | 0.3871 | 7262472.0 |
| 2003-11-12 09:35:00 | AAPL | Stock | 0.3873 | 0.3896 | 0.387 | 0.3886 | 3649856.0 |
| 2003-11-12 09:40:00 | AAPL | Stock | 0.3884 | 0.3904 | 0.3879 | 0.3904 | 10275720.0 |
| 2003-11-12 09:45:00 | AAPL | Stock | 0.3904 | 0.3909 | 0.3895 | 0.3895 | 3055752.0 |
| 2003-11-12 09:50:00 | AAPL | Stock | 0.3893 | 0.3905 | 0.3891 | 0.3905 | 2253608.0 |
| 2003-11-12 09:55:00 | AAPL | Stock | 0.3905 | 0.392 | 0.3905 | 0.3905 | 1984416.0 |
| 2003-11-12 10:00:00 | AAPL | Stock | 0.3907 | 0.3927 | 0.3905 | 0.3927 | 2559480.0 |
| 2003-11-12 10:05:00 | AAPL | Stock | 0.3925 | 0.3936 | 0.3913 | 0.3918 | 8104152.0 |
| 2003-11-12 10:10:00 | AAPL | Stock | 0.392 | 0.3929 | 0.3913 | 0.3929 | 1308608.0 |
| 2003-11-12 10:15:00 | AAPL | Stock | 0.3929 | 0.3932 | 0.3925 | 0.3929 | 9483992.0 |
| 2003-11-12 10:20:00 | AAPL | Stock | 0.3932 | 0.3961 | 0.3932 | 0.3954 | 6454056.0 |
| 2003-11-12 10:25:00 | AAPL | Stock | 0.3952 | 0.3955 | 0.3952 | 0.3955 | 1063888.0 |
| 2003-11-12 10:30:00 | AAPL | Stock | 0.3955 | 0.3955 | 0.3948 | 0.395 | 3369800.0 |
| 2003-11-12 10:35:00 | AAPL | Stock | 0.3948 | 0.3948 | 0.3938 | 0.3938 | 1204448.0 |
| 2003-11-12 10:40:00 | AAPL | Stock | 0.3938 | 0.3943 | 0.3936 | 0.3943 | 1558592.0 |
| 2003-11-12 10:45:00 | AAPL | Stock | 0.3943 | 0.395 | 0.3934 | 0.3943 | 2065056.0 |
| 2003-11-12 10:50:00 | AAPL | Stock | 0.3945 | 0.3945 | 0.3938 | 0.3941 | 3949792.0 |
| 2003-11-12 10:55:00 | AAPL | Stock | 0.3939 | 0.3941 | 0.3932 | 0.3934 | 570248.0 |
| 2003-11-12 11:00:00 | AAPL | Stock | 0.3932 | 0.3938 | 0.3929 | 0.3929 | 1430464.0 |
| 2003-11-12 11:05:00 | AAPL | Stock | 0.393 | 0.3941 | 0.393 | 0.3941 | 2175544.0 |
| 2003-11-12 11:10:00 | AAPL | Stock | 0.3939 | 0.3941 | 0.3939 | 0.3939 | 373240.0 |
| 2003-11-12 11:15:00 | AAPL | Stock | 0.3941 | 0.3946 | 0.3939 | 0.3946 | 1406776.0 |
| 2003-11-12 11:20:00 | AAPL | Stock | 0.3945 | 0.395 | 0.3945 | 0.3948 | 1605912.0 |
| 2003-11-12 11:25:00 | AAPL | Stock | 0.3948 | 0.395 | 0.3938 | 0.3938 | 4059720.0 |
| 2003-11-12 11:30:00 | AAPL | Stock | 0.3938 | 0.3939 | 0.3929 | 0.3932 | 967904.0 |
| 2003-11-12 11:35:00 | AAPL | Stock | 0.393 | 0.3939 | 0.393 | 0.3938 | 254744.0 |
| 2003-11-12 11:40:00 | AAPL | Stock | 0.3941 | 0.3955 | 0.3934 | 0.3955 | 1397312.0 |
| 2003-11-12 11:45:00 | AAPL | Stock | 0.3952 | 0.3963 | 0.3951 | 0.3963 | 3318672.0 |
| 2003-11-12 11:50:00 | AAPL | Stock | 0.3963 | 0.3964 | 0.3957 | 0.3957 | 2407216.0 |
| 2003-11-12 11:55:00 | AAPL | Stock | 0.3957 | 0.3966 | 0.3957 | 0.3966 | 905576.0 |
| 2003-11-12 12:00:00 | AAPL | Stock | 0.3966 | 0.3973 | 0.3966 | 0.397 | 1929480.0 |
| 2003-11-12 12:05:00 | AAPL | Stock | 0.3971 | 0.3971 | 0.3963 | 0.397 | 1473528.0 |
| 2003-11-12 12:10:00 | AAPL | Stock | 0.397 | 0.3979 | 0.397 | 0.3973 | 1156904.0 |
| 2003-11-12 12:15:00 | AAPL | Stock | 0.3973 | 0.3973 | 0.397 | 0.397 | 1573600.0 |
| 2003-11-12 12:20:00 | AAPL | Stock | 0.3968 | 0.3971 | 0.3963 | 0.3968 | 828744.0 |
| 2003-11-12 12:25:00 | AAPL | Stock | 0.3969 | 0.3969 | 0.3963 | 0.3964 | 1780464.0 |
| 2003-11-12 12:30:00 | AAPL | Stock | 0.3964 | 0.3964 | 0.3957 | 0.3962 | 1967224.0 |
| 2003-11-12 12:35:00 | AAPL | Stock | 0.3961 | 0.3966 | 0.3961 | 0.3966 | 1296400.0 |
| 2003-11-12 12:40:00 | AAPL | Stock | 0.3966 | 0.3982 | 0.3966 | 0.398 | 4210528.0 |
| 2003-11-12 12:45:00 | AAPL | Stock | 0.3979 | 0.3989 | 0.3979 | 0.3986 | 4128488.0 |
| 2003-11-12 12:50:00 | AAPL | Stock | 0.3989 | 0.3991 | 0.398 | 0.3989 | 5420744.0 |
| 2003-11-12 12:55:00 | AAPL | Stock | 0.3988 | 0.3989 | 0.3986 | 0.3989 | 978600.0 |
| 2003-11-12 13:00:00 | AAPL | Stock | 0.3989 | 0.4 | 0.3988 | 0.4 | 8375024.0 |
> showing 50 of 165,612 rows — these rows as CSV