PREVIEW / stock_5min / 2004-02-03
file: by_date/stock_5min/2004/2004-02-03.parquet size: 2.4 MB rows: 172,447 symbols: 1,721
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-02-03 08:40:00 | AAPL | Stock | 0.3964 | 0.3964 | 0.3964 | 0.3964 | 56000.0 |
| 2004-02-03 09:20:00 | AAPL | Stock | 0.3964 | 0.3964 | 0.3964 | 0.3964 | 5600.0 |
| 2004-02-03 09:25:00 | AAPL | Stock | 0.3964 | 0.3977 | 0.3948 | 0.3977 | 117600.0 |
| 2004-02-03 09:30:00 | AAPL | Stock | 0.3982 | 0.3986 | 0.3946 | 0.3984 | 3856608.0 |
| 2004-02-03 09:35:00 | AAPL | Stock | 0.3986 | 0.4 | 0.3964 | 0.3966 | 3534272.0 |
| 2004-02-03 09:40:00 | AAPL | Stock | 0.3966 | 0.3973 | 0.395 | 0.395 | 3341240.0 |
| 2004-02-03 09:45:00 | AAPL | Stock | 0.395 | 0.3966 | 0.3948 | 0.3961 | 2648240.0 |
| 2004-02-03 09:50:00 | AAPL | Stock | 0.3964 | 0.3964 | 0.3961 | 0.3964 | 2986480.0 |
| 2004-02-03 09:55:00 | AAPL | Stock | 0.3964 | 0.3968 | 0.3959 | 0.3961 | 3209920.0 |
| 2004-02-03 10:00:00 | AAPL | Stock | 0.3961 | 0.398 | 0.3954 | 0.398 | 3524024.0 |
| 2004-02-03 10:05:00 | AAPL | Stock | 0.398 | 0.3982 | 0.3973 | 0.3979 | 3151904.0 |
| 2004-02-03 10:10:00 | AAPL | Stock | 0.3979 | 0.3979 | 0.3964 | 0.3975 | 4953592.0 |
| 2004-02-03 10:15:00 | AAPL | Stock | 0.3975 | 0.3979 | 0.397 | 0.3971 | 999544.0 |
| 2004-02-03 10:20:00 | AAPL | Stock | 0.397 | 0.397 | 0.3959 | 0.3966 | 2482032.0 |
| 2004-02-03 10:25:00 | AAPL | Stock | 0.3966 | 0.3968 | 0.3957 | 0.3957 | 1280944.0 |
| 2004-02-03 10:30:00 | AAPL | Stock | 0.3959 | 0.3961 | 0.3943 | 0.3945 | 3836112.0 |
| 2004-02-03 10:35:00 | AAPL | Stock | 0.3941 | 0.3946 | 0.393 | 0.3941 | 8621648.0 |
| 2004-02-03 10:40:00 | AAPL | Stock | 0.3939 | 0.3941 | 0.3929 | 0.3938 | 5589696.0 |
| 2004-02-03 10:45:00 | AAPL | Stock | 0.3936 | 0.3939 | 0.3934 | 0.3938 | 2043496.0 |
| 2004-02-03 10:50:00 | AAPL | Stock | 0.3938 | 0.3941 | 0.3934 | 0.3939 | 2206400.0 |
| 2004-02-03 10:55:00 | AAPL | Stock | 0.3939 | 0.3955 | 0.3939 | 0.3946 | 4226376.0 |
| 2004-02-03 11:00:00 | AAPL | Stock | 0.3948 | 0.3952 | 0.3943 | 0.395 | 2717456.0 |
| 2004-02-03 11:05:00 | AAPL | Stock | 0.395 | 0.3952 | 0.3948 | 0.395 | 1458352.0 |
| 2004-02-03 11:10:00 | AAPL | Stock | 0.395 | 0.3959 | 0.3946 | 0.3952 | 2531256.0 |
| 2004-02-03 11:15:00 | AAPL | Stock | 0.3952 | 0.3961 | 0.3948 | 0.3955 | 1546496.0 |
| 2004-02-03 11:20:00 | AAPL | Stock | 0.3955 | 0.3959 | 0.3954 | 0.3959 | 1312136.0 |
| 2004-02-03 11:25:00 | AAPL | Stock | 0.3961 | 0.3963 | 0.3954 | 0.3959 | 1279264.0 |
| 2004-02-03 11:30:00 | AAPL | Stock | 0.3961 | 0.3963 | 0.3959 | 0.3959 | 772072.0 |
| 2004-02-03 11:35:00 | AAPL | Stock | 0.3961 | 0.3964 | 0.3959 | 0.3959 | 1055600.0 |
| 2004-02-03 11:40:00 | AAPL | Stock | 0.3959 | 0.3963 | 0.3954 | 0.3959 | 1225056.0 |
| 2004-02-03 11:45:00 | AAPL | Stock | 0.3959 | 0.3963 | 0.3948 | 0.3955 | 3127824.0 |
| 2004-02-03 11:50:00 | AAPL | Stock | 0.3957 | 0.3959 | 0.3948 | 0.3955 | 2544024.0 |
| 2004-02-03 11:55:00 | AAPL | Stock | 0.3955 | 0.3964 | 0.3954 | 0.3957 | 1486128.0 |
| 2004-02-03 12:00:00 | AAPL | Stock | 0.3959 | 0.3961 | 0.3955 | 0.3957 | 551824.0 |
| 2004-02-03 12:05:00 | AAPL | Stock | 0.3957 | 0.3963 | 0.3955 | 0.3959 | 722400.0 |
| 2004-02-03 12:10:00 | AAPL | Stock | 0.3959 | 0.3963 | 0.3952 | 0.3959 | 1374744.0 |
| 2004-02-03 12:15:00 | AAPL | Stock | 0.3961 | 0.3964 | 0.3957 | 0.3959 | 692272.0 |
| 2004-02-03 12:20:00 | AAPL | Stock | 0.3963 | 0.3966 | 0.3963 | 0.3964 | 810152.0 |
| 2004-02-03 12:25:00 | AAPL | Stock | 0.3964 | 0.3966 | 0.3959 | 0.3961 | 1057448.0 |
| 2004-02-03 12:30:00 | AAPL | Stock | 0.3959 | 0.3966 | 0.3959 | 0.3964 | 1914472.0 |
| 2004-02-03 12:35:00 | AAPL | Stock | 0.3963 | 0.397 | 0.3963 | 0.3964 | 1485288.0 |
| 2004-02-03 12:40:00 | AAPL | Stock | 0.3964 | 0.3973 | 0.3964 | 0.3973 | 5892040.0 |
| 2004-02-03 12:45:00 | AAPL | Stock | 0.3973 | 0.3975 | 0.3968 | 0.397 | 1130528.0 |
| 2004-02-03 12:50:00 | AAPL | Stock | 0.397 | 0.3971 | 0.3966 | 0.3968 | 361536.0 |
| 2004-02-03 12:55:00 | AAPL | Stock | 0.3968 | 0.3982 | 0.3968 | 0.3982 | 3968160.0 |
| 2004-02-03 13:00:00 | AAPL | Stock | 0.3982 | 0.3988 | 0.3977 | 0.3986 | 5354272.0 |
| 2004-02-03 13:05:00 | AAPL | Stock | 0.3982 | 0.3986 | 0.3982 | 0.3984 | 492912.0 |
| 2004-02-03 13:10:00 | AAPL | Stock | 0.3982 | 0.3986 | 0.3977 | 0.3977 | 898464.0 |
| 2004-02-03 13:15:00 | AAPL | Stock | 0.3977 | 0.3977 | 0.3966 | 0.3975 | 1477168.0 |
| 2004-02-03 13:20:00 | AAPL | Stock | 0.3977 | 0.3977 | 0.3961 | 0.3962 | 629496.0 |
> showing 50 of 172,447 rows — these rows as CSV