PREVIEW / stock_5min / 2003-09-17
file: by_date/stock_5min/2003/2003-09-17.parquet size: 2.1 MB rows: 150,360 symbols: 1,609
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-09-17 08:00:00 | AAPL | Stock | 0.4164 | 0.4164 | 0.4164 | 0.4164 | 5600.0 |
| 2003-09-17 08:25:00 | AAPL | Stock | 0.4036 | 0.4036 | 0.4036 | 0.4036 | 5600.0 |
| 2003-09-17 08:30:00 | AAPL | Stock | 0.4018 | 0.4018 | 0.4018 | 0.4018 | 5600.0 |
| 2003-09-17 09:25:00 | AAPL | Stock | 0.3996 | 0.3996 | 0.3995 | 0.3995 | 61600.0 |
| 2003-09-17 09:30:00 | AAPL | Stock | 0.3995 | 0.3996 | 0.3966 | 0.3968 | 4069352.0 |
| 2003-09-17 09:35:00 | AAPL | Stock | 0.3968 | 0.3971 | 0.3955 | 0.3963 | 3877552.0 |
| 2003-09-17 09:40:00 | AAPL | Stock | 0.3961 | 0.3968 | 0.3959 | 0.3964 | 2810360.0 |
| 2003-09-17 09:45:00 | AAPL | Stock | 0.3964 | 0.3971 | 0.3941 | 0.3946 | 9814000.0 |
| 2003-09-17 09:50:00 | AAPL | Stock | 0.3946 | 0.395 | 0.3939 | 0.3943 | 4692800.0 |
| 2003-09-17 09:55:00 | AAPL | Stock | 0.3939 | 0.3945 | 0.3923 | 0.393 | 8148672.0 |
| 2003-09-17 10:00:00 | AAPL | Stock | 0.393 | 0.3941 | 0.3929 | 0.3938 | 5708304.0 |
| 2003-09-17 10:05:00 | AAPL | Stock | 0.3936 | 0.3955 | 0.3936 | 0.3952 | 4233376.0 |
| 2003-09-17 10:10:00 | AAPL | Stock | 0.3952 | 0.3952 | 0.393 | 0.3946 | 2659216.0 |
| 2003-09-17 10:15:00 | AAPL | Stock | 0.3946 | 0.3946 | 0.3936 | 0.3941 | 4832800.0 |
| 2003-09-17 10:20:00 | AAPL | Stock | 0.3941 | 0.3943 | 0.393 | 0.3934 | 3641792.0 |
| 2003-09-17 10:25:00 | AAPL | Stock | 0.3936 | 0.3939 | 0.3929 | 0.393 | 4762912.0 |
| 2003-09-17 10:30:00 | AAPL | Stock | 0.393 | 0.3934 | 0.3925 | 0.3929 | 4418064.0 |
| 2003-09-17 10:35:00 | AAPL | Stock | 0.3929 | 0.393 | 0.3925 | 0.3927 | 3034248.0 |
| 2003-09-17 10:40:00 | AAPL | Stock | 0.3927 | 0.393 | 0.3921 | 0.3929 | 2862552.0 |
| 2003-09-17 10:45:00 | AAPL | Stock | 0.3929 | 0.3934 | 0.3921 | 0.3923 | 2249800.0 |
| 2003-09-17 10:50:00 | AAPL | Stock | 0.3923 | 0.3927 | 0.3916 | 0.3925 | 2862160.0 |
| 2003-09-17 10:55:00 | AAPL | Stock | 0.3925 | 0.3929 | 0.392 | 0.3927 | 1681848.0 |
| 2003-09-17 11:00:00 | AAPL | Stock | 0.3927 | 0.3939 | 0.3927 | 0.3934 | 2564800.0 |
| 2003-09-17 11:05:00 | AAPL | Stock | 0.393 | 0.3934 | 0.3927 | 0.3929 | 1433600.0 |
| 2003-09-17 11:10:00 | AAPL | Stock | 0.393 | 0.3934 | 0.3921 | 0.3923 | 2097200.0 |
| 2003-09-17 11:15:00 | AAPL | Stock | 0.3923 | 0.3936 | 0.3923 | 0.3927 | 1685600.0 |
| 2003-09-17 11:20:00 | AAPL | Stock | 0.3929 | 0.3929 | 0.3927 | 0.3929 | 916440.0 |
| 2003-09-17 11:25:00 | AAPL | Stock | 0.3929 | 0.3934 | 0.392 | 0.392 | 1739920.0 |
| 2003-09-17 11:30:00 | AAPL | Stock | 0.392 | 0.393 | 0.392 | 0.3927 | 950432.0 |
| 2003-09-17 11:35:00 | AAPL | Stock | 0.3929 | 0.3931 | 0.3923 | 0.3929 | 3889200.0 |
| 2003-09-17 11:40:00 | AAPL | Stock | 0.393 | 0.3938 | 0.3925 | 0.3932 | 8092280.0 |
| 2003-09-17 11:45:00 | AAPL | Stock | 0.3932 | 0.3932 | 0.3925 | 0.3929 | 1562624.0 |
| 2003-09-17 11:50:00 | AAPL | Stock | 0.3927 | 0.3929 | 0.3925 | 0.3927 | 1571416.0 |
| 2003-09-17 11:55:00 | AAPL | Stock | 0.3927 | 0.393 | 0.3927 | 0.3927 | 1222760.0 |
| 2003-09-17 12:00:00 | AAPL | Stock | 0.3929 | 0.3932 | 0.3921 | 0.3932 | 2728600.0 |
| 2003-09-17 12:05:00 | AAPL | Stock | 0.3932 | 0.3936 | 0.3929 | 0.3932 | 1199464.0 |
| 2003-09-17 12:10:00 | AAPL | Stock | 0.3932 | 0.3934 | 0.3929 | 0.393 | 1049384.0 |
| 2003-09-17 12:15:00 | AAPL | Stock | 0.393 | 0.3932 | 0.3929 | 0.3932 | 990192.0 |
| 2003-09-17 12:20:00 | AAPL | Stock | 0.393 | 0.3936 | 0.3925 | 0.3936 | 20168400.0 |
| 2003-09-17 12:25:00 | AAPL | Stock | 0.3936 | 0.3936 | 0.3925 | 0.3925 | 1315104.0 |
| 2003-09-17 12:30:00 | AAPL | Stock | 0.3925 | 0.3936 | 0.3925 | 0.3936 | 698208.0 |
| 2003-09-17 12:35:00 | AAPL | Stock | 0.3936 | 0.395 | 0.3932 | 0.3946 | 3100944.0 |
| 2003-09-17 12:40:00 | AAPL | Stock | 0.3939 | 0.3946 | 0.3939 | 0.3941 | 711984.0 |
| 2003-09-17 12:45:00 | AAPL | Stock | 0.3941 | 0.3941 | 0.3938 | 0.3939 | 761600.0 |
| 2003-09-17 12:50:00 | AAPL | Stock | 0.3939 | 0.3945 | 0.3936 | 0.3939 | 1400000.0 |
| 2003-09-17 12:55:00 | AAPL | Stock | 0.3938 | 0.3943 | 0.3938 | 0.3943 | 1275344.0 |
| 2003-09-17 13:00:00 | AAPL | Stock | 0.3943 | 0.3952 | 0.3941 | 0.3943 | 1982400.0 |
| 2003-09-17 13:05:00 | AAPL | Stock | 0.3945 | 0.3945 | 0.3925 | 0.3927 | 2796024.0 |
| 2003-09-17 13:10:00 | AAPL | Stock | 0.3927 | 0.3939 | 0.3927 | 0.3938 | 2276064.0 |
| 2003-09-17 13:15:00 | AAPL | Stock | 0.3936 | 0.3938 | 0.3925 | 0.3936 | 2620800.0 |
> showing 50 of 150,360 rows — these rows as CSV