PREVIEW / stock_5min / 2004-01-07
file: by_date/stock_5min/2004/2004-01-07.parquet size: 2.4 MB rows: 170,713 symbols: 1,717
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 |
|---|---|---|---|---|---|---|---|
| 2004-01-07 08:00:00 | AAPL | Stock | 0.3938 | 0.3938 | 0.393 | 0.3932 | 4001200.0 |
| 2004-01-07 08:10:00 | AAPL | Stock | 0.3927 | 0.3927 | 0.3893 | 0.3893 | 56000.0 |
| 2004-01-07 08:15:00 | AAPL | Stock | 0.3941 | 0.3941 | 0.3941 | 0.3941 | 11200.0 |
| 2004-01-07 08:20:00 | AAPL | Stock | 0.3945 | 0.3945 | 0.3945 | 0.3945 | 5600.0 |
| 2004-01-07 08:35:00 | AAPL | Stock | 0.3943 | 0.3943 | 0.3939 | 0.3939 | 56000.0 |
| 2004-01-07 08:40:00 | AAPL | Stock | 0.3943 | 0.3943 | 0.3943 | 0.3943 | 5600.0 |
| 2004-01-07 08:45:00 | AAPL | Stock | 0.3941 | 0.3941 | 0.3941 | 0.3941 | 112000.0 |
| 2004-01-07 08:55:00 | AAPL | Stock | 0.3939 | 0.3939 | 0.3939 | 0.3939 | 33600.0 |
| 2004-01-07 09:00:00 | AAPL | Stock | 0.3934 | 0.3964 | 0.393 | 0.3954 | 311080.0 |
| 2004-01-07 09:05:00 | AAPL | Stock | 0.3973 | 0.3973 | 0.3973 | 0.3973 | 777896.0 |
| 2004-01-07 09:10:00 | AAPL | Stock | 0.3973 | 0.3973 | 0.3973 | 0.3973 | 22400.0 |
| 2004-01-07 09:15:00 | AAPL | Stock | 0.3945 | 0.3946 | 0.3943 | 0.3946 | 179200.0 |
| 2004-01-07 09:20:00 | AAPL | Stock | 0.3946 | 0.3946 | 0.3946 | 0.3946 | 84000.0 |
| 2004-01-07 09:25:00 | AAPL | Stock | 0.3955 | 0.3964 | 0.3946 | 0.3946 | 859040.0 |
| 2004-01-07 09:30:00 | AAPL | Stock | 0.3946 | 0.3961 | 0.3946 | 0.3952 | 13107696.0 |
| 2004-01-07 09:35:00 | AAPL | Stock | 0.3955 | 0.3963 | 0.3946 | 0.3963 | 14206640.0 |
| 2004-01-07 09:40:00 | AAPL | Stock | 0.3961 | 0.3966 | 0.3959 | 0.3963 | 12823328.0 |
| 2004-01-07 09:45:00 | AAPL | Stock | 0.3963 | 0.3964 | 0.3955 | 0.3959 | 2132928.0 |
| 2004-01-07 09:50:00 | AAPL | Stock | 0.3959 | 0.3959 | 0.3955 | 0.3955 | 15246896.0 |
| 2004-01-07 09:55:00 | AAPL | Stock | 0.3955 | 0.3957 | 0.3948 | 0.3948 | 6173776.0 |
| 2004-01-07 10:00:00 | AAPL | Stock | 0.3948 | 0.3954 | 0.3939 | 0.3946 | 13142136.0 |
| 2004-01-07 10:05:00 | AAPL | Stock | 0.3946 | 0.3949 | 0.3916 | 0.3919 | 25669616.0 |
| 2004-01-07 10:10:00 | AAPL | Stock | 0.3919 | 0.3939 | 0.3916 | 0.3927 | 9214408.0 |
| 2004-01-07 10:15:00 | AAPL | Stock | 0.3929 | 0.3934 | 0.3923 | 0.3929 | 6023920.0 |
| 2004-01-07 10:20:00 | AAPL | Stock | 0.3932 | 0.3934 | 0.3925 | 0.3932 | 5228664.0 |
| 2004-01-07 10:25:00 | AAPL | Stock | 0.3934 | 0.3946 | 0.3932 | 0.3939 | 7387576.0 |
| 2004-01-07 10:30:00 | AAPL | Stock | 0.3939 | 0.3939 | 0.3925 | 0.3927 | 11319840.0 |
| 2004-01-07 10:35:00 | AAPL | Stock | 0.3923 | 0.3931 | 0.3923 | 0.3927 | 3939656.0 |
| 2004-01-07 10:40:00 | AAPL | Stock | 0.3927 | 0.3927 | 0.3921 | 0.3921 | 2804368.0 |
| 2004-01-07 10:45:00 | AAPL | Stock | 0.3923 | 0.3923 | 0.3916 | 0.3918 | 2130408.0 |
| 2004-01-07 10:50:00 | AAPL | Stock | 0.3918 | 0.3925 | 0.3918 | 0.3921 | 4353328.0 |
| 2004-01-07 10:55:00 | AAPL | Stock | 0.3921 | 0.3938 | 0.392 | 0.3934 | 6328224.0 |
| 2004-01-07 11:00:00 | AAPL | Stock | 0.3936 | 0.3938 | 0.3929 | 0.3932 | 2384368.0 |
| 2004-01-07 11:05:00 | AAPL | Stock | 0.3932 | 0.3936 | 0.3927 | 0.3932 | 2777320.0 |
| 2004-01-07 11:10:00 | AAPL | Stock | 0.3932 | 0.3932 | 0.3929 | 0.3932 | 1433208.0 |
| 2004-01-07 11:15:00 | AAPL | Stock | 0.3932 | 0.3946 | 0.393 | 0.3941 | 6226360.0 |
| 2004-01-07 11:20:00 | AAPL | Stock | 0.3938 | 0.3943 | 0.3938 | 0.3941 | 487760.0 |
| 2004-01-07 11:25:00 | AAPL | Stock | 0.3941 | 0.3941 | 0.3936 | 0.3939 | 883456.0 |
| 2004-01-07 11:30:00 | AAPL | Stock | 0.3939 | 0.3939 | 0.3925 | 0.3928 | 2797144.0 |
| 2004-01-07 11:35:00 | AAPL | Stock | 0.3925 | 0.3955 | 0.3925 | 0.3954 | 3063592.0 |
| 2004-01-07 11:40:00 | AAPL | Stock | 0.3954 | 0.3964 | 0.3946 | 0.3959 | 5386080.0 |
| 2004-01-07 11:45:00 | AAPL | Stock | 0.3963 | 0.3968 | 0.3959 | 0.3963 | 11138232.0 |
| 2004-01-07 11:50:00 | AAPL | Stock | 0.3964 | 0.3971 | 0.3955 | 0.397 | 7773304.0 |
| 2004-01-07 11:55:00 | AAPL | Stock | 0.3968 | 0.3971 | 0.3964 | 0.3964 | 4481176.0 |
| 2004-01-07 12:00:00 | AAPL | Stock | 0.3964 | 0.3988 | 0.3964 | 0.3988 | 14054432.0 |
| 2004-01-07 12:05:00 | AAPL | Stock | 0.3988 | 0.4 | 0.3982 | 0.3993 | 12981136.0 |
| 2004-01-07 12:10:00 | AAPL | Stock | 0.3993 | 0.4004 | 0.3993 | 0.4 | 6285552.0 |
| 2004-01-07 12:15:00 | AAPL | Stock | 0.4002 | 0.4004 | 0.4 | 0.4004 | 7321552.0 |
| 2004-01-07 12:20:00 | AAPL | Stock | 0.4004 | 0.4018 | 0.4 | 0.4014 | 23221856.0 |
| 2004-01-07 12:25:00 | AAPL | Stock | 0.4014 | 0.4018 | 0.3964 | 0.4011 | 32508504.0 |
> showing 50 of 170,713 rows — these rows as CSV