PREVIEW / stock_5min / 2002-01-18
file: by_date/stock_5min/2002/2002-01-18.parquet size: 1.6 MB rows: 113,221 symbols: 1,350
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 |
|---|---|---|---|---|---|---|---|
| 2002-01-18 08:00:00 | AAPL | Stock | 0.392 | 0.393 | 0.3911 | 0.393 | 61600.0 |
| 2002-01-18 08:20:00 | AAPL | Stock | 0.3911 | 0.3911 | 0.3911 | 0.3911 | 56000.0 |
| 2002-01-18 08:25:00 | AAPL | Stock | 0.3884 | 0.3884 | 0.3884 | 0.3884 | 28000.0 |
| 2002-01-18 08:30:00 | AAPL | Stock | 0.3914 | 0.3914 | 0.3911 | 0.3911 | 112000.0 |
| 2002-01-18 08:35:00 | AAPL | Stock | 0.3927 | 0.3929 | 0.3927 | 0.3927 | 39200.0 |
| 2002-01-18 08:45:00 | AAPL | Stock | 0.3929 | 0.3929 | 0.3925 | 0.3925 | 56000.0 |
| 2002-01-18 08:55:00 | AAPL | Stock | 0.3929 | 0.3929 | 0.3929 | 0.3929 | 39200.0 |
| 2002-01-18 09:00:00 | AAPL | Stock | 0.3929 | 0.3929 | 0.3929 | 0.3929 | 560000.0 |
| 2002-01-18 09:15:00 | AAPL | Stock | 0.3923 | 0.3923 | 0.3923 | 0.3923 | 5600.0 |
| 2002-01-18 09:20:00 | AAPL | Stock | 0.3929 | 0.3929 | 0.3927 | 0.3929 | 700000.0 |
| 2002-01-18 09:25:00 | AAPL | Stock | 0.392 | 0.3929 | 0.392 | 0.3929 | 1792000.0 |
| 2002-01-18 09:30:00 | AAPL | Stock | 0.3929 | 0.3984 | 0.3923 | 0.3984 | 16699200.0 |
| 2002-01-18 09:35:00 | AAPL | Stock | 0.3986 | 0.3998 | 0.3938 | 0.3954 | 10511200.0 |
| 2002-01-18 09:40:00 | AAPL | Stock | 0.3954 | 0.3959 | 0.3938 | 0.3948 | 6921600.0 |
| 2002-01-18 09:45:00 | AAPL | Stock | 0.3946 | 0.3964 | 0.3945 | 0.3964 | 8629600.0 |
| 2002-01-18 09:50:00 | AAPL | Stock | 0.3964 | 0.3991 | 0.3955 | 0.3955 | 6843200.0 |
| 2002-01-18 09:55:00 | AAPL | Stock | 0.3957 | 0.3961 | 0.3946 | 0.3948 | 3354400.0 |
| 2002-01-18 10:00:00 | AAPL | Stock | 0.3946 | 0.3957 | 0.3943 | 0.395 | 5230400.0 |
| 2002-01-18 10:05:00 | AAPL | Stock | 0.395 | 0.3954 | 0.3943 | 0.3954 | 5824000.0 |
| 2002-01-18 10:10:00 | AAPL | Stock | 0.3952 | 0.3955 | 0.3932 | 0.3936 | 6272000.0 |
| 2002-01-18 10:15:00 | AAPL | Stock | 0.3936 | 0.3946 | 0.3934 | 0.3943 | 1831200.0 |
| 2002-01-18 10:20:00 | AAPL | Stock | 0.3938 | 0.3957 | 0.3932 | 0.395 | 4704000.0 |
| 2002-01-18 10:25:00 | AAPL | Stock | 0.3957 | 0.3963 | 0.3945 | 0.3948 | 1999200.0 |
| 2002-01-18 10:30:00 | AAPL | Stock | 0.3954 | 0.3957 | 0.395 | 0.3955 | 3164000.0 |
| 2002-01-18 10:35:00 | AAPL | Stock | 0.3959 | 0.3961 | 0.395 | 0.3952 | 2682400.0 |
| 2002-01-18 10:40:00 | AAPL | Stock | 0.3952 | 0.3955 | 0.3943 | 0.3943 | 2268000.0 |
| 2002-01-18 10:45:00 | AAPL | Stock | 0.3943 | 0.4036 | 0.3943 | 0.4011 | 14341600.0 |
| 2002-01-18 10:50:00 | AAPL | Stock | 0.4011 | 0.4018 | 0.3977 | 0.3982 | 9531200.0 |
| 2002-01-18 10:55:00 | AAPL | Stock | 0.3977 | 0.3979 | 0.3952 | 0.3961 | 3858400.0 |
| 2002-01-18 11:00:00 | AAPL | Stock | 0.3961 | 0.3964 | 0.3943 | 0.3953 | 2307200.0 |
| 2002-01-18 11:05:00 | AAPL | Stock | 0.3952 | 0.3954 | 0.3921 | 0.3932 | 11172000.0 |
| 2002-01-18 11:10:00 | AAPL | Stock | 0.3932 | 0.3948 | 0.3923 | 0.3945 | 3690400.0 |
| 2002-01-18 11:15:00 | AAPL | Stock | 0.3944 | 0.3944 | 0.3932 | 0.3932 | 1663200.0 |
| 2002-01-18 11:20:00 | AAPL | Stock | 0.393 | 0.3938 | 0.3929 | 0.393 | 3231200.0 |
| 2002-01-18 11:25:00 | AAPL | Stock | 0.393 | 0.3936 | 0.3927 | 0.3936 | 2626400.0 |
| 2002-01-18 11:30:00 | AAPL | Stock | 0.3932 | 0.3941 | 0.3929 | 0.393 | 1584800.0 |
| 2002-01-18 11:35:00 | AAPL | Stock | 0.393 | 0.3937 | 0.3927 | 0.3936 | 924000.0 |
| 2002-01-18 11:40:00 | AAPL | Stock | 0.3936 | 0.3938 | 0.3932 | 0.3934 | 812000.0 |
| 2002-01-18 11:45:00 | AAPL | Stock | 0.3939 | 0.3939 | 0.3927 | 0.3929 | 1954400.0 |
| 2002-01-18 11:50:00 | AAPL | Stock | 0.3929 | 0.3938 | 0.3923 | 0.3923 | 2900800.0 |
| 2002-01-18 11:55:00 | AAPL | Stock | 0.3932 | 0.3932 | 0.3927 | 0.3929 | 2335200.0 |
| 2002-01-18 12:00:00 | AAPL | Stock | 0.3929 | 0.3938 | 0.3929 | 0.3936 | 677600.0 |
| 2002-01-18 12:05:00 | AAPL | Stock | 0.3934 | 0.3934 | 0.3927 | 0.3929 | 1248800.0 |
| 2002-01-18 12:10:00 | AAPL | Stock | 0.393 | 0.3936 | 0.3929 | 0.393 | 711200.0 |
| 2002-01-18 12:15:00 | AAPL | Stock | 0.3934 | 0.3938 | 0.3929 | 0.3934 | 3539200.0 |
| 2002-01-18 12:20:00 | AAPL | Stock | 0.3934 | 0.3943 | 0.3929 | 0.3931 | 1058400.0 |
| 2002-01-18 12:25:00 | AAPL | Stock | 0.3938 | 0.3938 | 0.393 | 0.3938 | 1388800.0 |
| 2002-01-18 12:30:00 | AAPL | Stock | 0.3938 | 0.3941 | 0.3936 | 0.3939 | 1069600.0 |
| 2002-01-18 12:35:00 | AAPL | Stock | 0.3938 | 0.3941 | 0.3936 | 0.3939 | 868000.0 |
| 2002-01-18 12:40:00 | AAPL | Stock | 0.3941 | 0.3948 | 0.3939 | 0.3946 | 2279200.0 |
> showing 50 of 113,221 rows — these rows as CSV