PREVIEW / stock_5min / 2002-01-17
file: by_date/stock_5min/2002/2002-01-17.parquet size: 1.7 MB rows: 115,324 symbols: 1,348
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-17 08:00:00 | AAPL | Stock | 0.3955 | 0.3957 | 0.3804 | 0.3957 | 1377600.0 |
| 2002-01-17 08:05:00 | AAPL | Stock | 0.3964 | 0.3964 | 0.3964 | 0.3964 | 5600.0 |
| 2002-01-17 08:15:00 | AAPL | Stock | 0.3946 | 0.3946 | 0.3902 | 0.3909 | 1075200.0 |
| 2002-01-17 08:20:00 | AAPL | Stock | 0.3898 | 0.3929 | 0.3893 | 0.392 | 364000.0 |
| 2002-01-17 08:25:00 | AAPL | Stock | 0.392 | 0.392 | 0.392 | 0.392 | 56000.0 |
| 2002-01-17 08:30:00 | AAPL | Stock | 0.3921 | 0.3929 | 0.3916 | 0.3929 | 509600.0 |
| 2002-01-17 08:35:00 | AAPL | Stock | 0.3929 | 0.3931 | 0.3923 | 0.393 | 89600.0 |
| 2002-01-17 08:40:00 | AAPL | Stock | 0.392 | 0.3929 | 0.392 | 0.3929 | 1825600.0 |
| 2002-01-17 08:45:00 | AAPL | Stock | 0.392 | 0.3927 | 0.392 | 0.3927 | 84000.0 |
| 2002-01-17 08:50:00 | AAPL | Stock | 0.3929 | 0.3929 | 0.3927 | 0.3927 | 128800.0 |
| 2002-01-17 08:55:00 | AAPL | Stock | 0.392 | 0.3936 | 0.392 | 0.392 | 604800.0 |
| 2002-01-17 09:00:00 | AAPL | Stock | 0.3925 | 0.3925 | 0.3911 | 0.3918 | 840000.0 |
| 2002-01-17 09:05:00 | AAPL | Stock | 0.3916 | 0.392 | 0.3916 | 0.392 | 571200.0 |
| 2002-01-17 09:10:00 | AAPL | Stock | 0.392 | 0.3927 | 0.3914 | 0.3914 | 268800.0 |
| 2002-01-17 09:15:00 | AAPL | Stock | 0.392 | 0.3925 | 0.3893 | 0.3911 | 2436000.0 |
| 2002-01-17 09:20:00 | AAPL | Stock | 0.393 | 0.393 | 0.3893 | 0.3904 | 2346400.0 |
| 2002-01-17 09:25:00 | AAPL | Stock | 0.3902 | 0.3929 | 0.39 | 0.3929 | 4782400.0 |
| 2002-01-17 09:30:00 | AAPL | Stock | 0.3923 | 0.4002 | 0.3913 | 0.3954 | 39709600.0 |
| 2002-01-17 09:35:00 | AAPL | Stock | 0.3955 | 0.3973 | 0.3932 | 0.3938 | 20955200.0 |
| 2002-01-17 09:40:00 | AAPL | Stock | 0.3939 | 0.3939 | 0.392 | 0.3925 | 21879200.0 |
| 2002-01-17 09:45:00 | AAPL | Stock | 0.3927 | 0.3955 | 0.3918 | 0.3932 | 20804000.0 |
| 2002-01-17 09:50:00 | AAPL | Stock | 0.3934 | 0.3946 | 0.3932 | 0.3941 | 18799200.0 |
| 2002-01-17 09:55:00 | AAPL | Stock | 0.3941 | 0.3946 | 0.3922 | 0.3938 | 32614400.0 |
| 2002-01-17 10:00:00 | AAPL | Stock | 0.3938 | 0.3948 | 0.3938 | 0.3941 | 11793600.0 |
| 2002-01-17 10:05:00 | AAPL | Stock | 0.3943 | 0.3945 | 0.3929 | 0.393 | 21117600.0 |
| 2002-01-17 10:10:00 | AAPL | Stock | 0.393 | 0.3938 | 0.3921 | 0.3932 | 11692800.0 |
| 2002-01-17 10:15:00 | AAPL | Stock | 0.393 | 0.3932 | 0.3914 | 0.3927 | 10444000.0 |
| 2002-01-17 10:20:00 | AAPL | Stock | 0.3923 | 0.3929 | 0.3913 | 0.3914 | 15450400.0 |
| 2002-01-17 10:25:00 | AAPL | Stock | 0.3923 | 0.3929 | 0.3905 | 0.3925 | 9156000.0 |
| 2002-01-17 10:30:00 | AAPL | Stock | 0.3923 | 0.3927 | 0.3911 | 0.392 | 4508000.0 |
| 2002-01-17 10:35:00 | AAPL | Stock | 0.3918 | 0.3929 | 0.3914 | 0.3923 | 12919200.0 |
| 2002-01-17 10:40:00 | AAPL | Stock | 0.3923 | 0.3943 | 0.3923 | 0.3939 | 11183200.0 |
| 2002-01-17 10:45:00 | AAPL | Stock | 0.3939 | 0.3945 | 0.3932 | 0.3939 | 7240800.0 |
| 2002-01-17 10:50:00 | AAPL | Stock | 0.3939 | 0.3946 | 0.3929 | 0.3941 | 12891200.0 |
| 2002-01-17 10:55:00 | AAPL | Stock | 0.3941 | 0.3961 | 0.3938 | 0.3946 | 6529600.0 |
| 2002-01-17 11:00:00 | AAPL | Stock | 0.3946 | 0.3954 | 0.3943 | 0.3952 | 3746400.0 |
| 2002-01-17 11:05:00 | AAPL | Stock | 0.3948 | 0.3955 | 0.3938 | 0.3941 | 10567200.0 |
| 2002-01-17 11:10:00 | AAPL | Stock | 0.3939 | 0.3943 | 0.3932 | 0.3934 | 4480000.0 |
| 2002-01-17 11:15:00 | AAPL | Stock | 0.3932 | 0.3943 | 0.3932 | 0.3938 | 3119200.0 |
| 2002-01-17 11:20:00 | AAPL | Stock | 0.3938 | 0.3941 | 0.3929 | 0.3932 | 4071200.0 |
| 2002-01-17 11:25:00 | AAPL | Stock | 0.3934 | 0.3936 | 0.3925 | 0.393 | 2637600.0 |
| 2002-01-17 11:30:00 | AAPL | Stock | 0.3929 | 0.3932 | 0.3905 | 0.3929 | 9688000.0 |
| 2002-01-17 11:35:00 | AAPL | Stock | 0.3929 | 0.3929 | 0.3911 | 0.3925 | 1881600.0 |
| 2002-01-17 11:40:00 | AAPL | Stock | 0.3927 | 0.3936 | 0.3927 | 0.393 | 1932000.0 |
| 2002-01-17 11:45:00 | AAPL | Stock | 0.3934 | 0.3939 | 0.3923 | 0.3929 | 8747200.0 |
| 2002-01-17 11:50:00 | AAPL | Stock | 0.3927 | 0.3934 | 0.3925 | 0.3932 | 5544000.0 |
| 2002-01-17 11:55:00 | AAPL | Stock | 0.3932 | 0.3941 | 0.3923 | 0.3932 | 10180800.0 |
| 2002-01-17 12:00:00 | AAPL | Stock | 0.3934 | 0.3945 | 0.393 | 0.3941 | 7560000.0 |
| 2002-01-17 12:05:00 | AAPL | Stock | 0.3943 | 0.3961 | 0.3936 | 0.3959 | 7044800.0 |
| 2002-01-17 12:10:00 | AAPL | Stock | 0.3957 | 0.3959 | 0.3934 | 0.3941 | 5269600.0 |
> showing 50 of 115,324 rows — these rows as CSV