PREVIEW / stock_5min / 2001-12-07
file: by_date/stock_5min/2001/2001-12-07.parquet size: 1.7 MB rows: 118,108 symbols: 1,360
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 |
|---|---|---|---|---|---|---|---|
| 2001-12-07 08:00:00 | AAPL | Stock | 0.4152 | 0.4154 | 0.4069 | 0.4154 | 464800.0 |
| 2001-12-07 08:05:00 | AAPL | Stock | 0.4125 | 0.4125 | 0.4125 | 0.4125 | 11200.0 |
| 2001-12-07 08:10:00 | AAPL | Stock | 0.4132 | 0.4132 | 0.4121 | 0.4121 | 28000.0 |
| 2001-12-07 08:15:00 | AAPL | Stock | 0.4116 | 0.4125 | 0.4116 | 0.4121 | 39200.0 |
| 2001-12-07 08:25:00 | AAPL | Stock | 0.4125 | 0.4125 | 0.4125 | 0.4125 | 11200.0 |
| 2001-12-07 08:30:00 | AAPL | Stock | 0.412 | 0.412 | 0.407 | 0.4086 | 291200.0 |
| 2001-12-07 08:35:00 | AAPL | Stock | 0.4107 | 0.4107 | 0.4061 | 0.4107 | 67200.0 |
| 2001-12-07 08:40:00 | AAPL | Stock | 0.4061 | 0.4061 | 0.4061 | 0.4061 | 28000.0 |
| 2001-12-07 08:55:00 | AAPL | Stock | 0.4068 | 0.4077 | 0.4059 | 0.4059 | 162400.0 |
| 2001-12-07 09:00:00 | AAPL | Stock | 0.4061 | 0.4061 | 0.4061 | 0.4061 | 39200.0 |
| 2001-12-07 09:10:00 | AAPL | Stock | 0.4052 | 0.4052 | 0.4052 | 0.4052 | 22400.0 |
| 2001-12-07 09:25:00 | AAPL | Stock | 0.4029 | 0.4029 | 0.4011 | 0.4011 | 425600.0 |
| 2001-12-07 09:30:00 | AAPL | Stock | 0.4011 | 0.4038 | 0.4009 | 0.403 | 6440000.0 |
| 2001-12-07 09:35:00 | AAPL | Stock | 0.403 | 0.4039 | 0.402 | 0.4036 | 6860000.0 |
| 2001-12-07 09:40:00 | AAPL | Stock | 0.4034 | 0.4039 | 0.4018 | 0.4027 | 2072000.0 |
| 2001-12-07 09:45:00 | AAPL | Stock | 0.4027 | 0.403 | 0.3988 | 0.4 | 12594400.0 |
| 2001-12-07 09:50:00 | AAPL | Stock | 0.3998 | 0.4012 | 0.3982 | 0.3982 | 5437600.0 |
| 2001-12-07 09:55:00 | AAPL | Stock | 0.3986 | 0.4 | 0.3982 | 0.3991 | 5633600.0 |
| 2001-12-07 10:00:00 | AAPL | Stock | 0.3998 | 0.4007 | 0.3968 | 0.3973 | 6137600.0 |
| 2001-12-07 10:05:00 | AAPL | Stock | 0.3971 | 0.3977 | 0.3952 | 0.3963 | 3768800.0 |
| 2001-12-07 10:10:00 | AAPL | Stock | 0.3964 | 0.3995 | 0.3961 | 0.3982 | 3113600.0 |
| 2001-12-07 10:15:00 | AAPL | Stock | 0.3982 | 0.4005 | 0.3977 | 0.3998 | 2833600.0 |
| 2001-12-07 10:20:00 | AAPL | Stock | 0.4004 | 0.4009 | 0.3991 | 0.3996 | 1898400.0 |
| 2001-12-07 10:25:00 | AAPL | Stock | 0.3993 | 0.3998 | 0.3982 | 0.3991 | 1803200.0 |
| 2001-12-07 10:30:00 | AAPL | Stock | 0.3986 | 0.4005 | 0.3982 | 0.4002 | 1607200.0 |
| 2001-12-07 10:35:00 | AAPL | Stock | 0.4002 | 0.4014 | 0.3991 | 0.4011 | 1428000.0 |
| 2001-12-07 10:40:00 | AAPL | Stock | 0.4009 | 0.4011 | 0.3991 | 0.3991 | 9027200.0 |
| 2001-12-07 10:45:00 | AAPL | Stock | 0.3989 | 0.4004 | 0.3989 | 0.3995 | 1243200.0 |
| 2001-12-07 10:50:00 | AAPL | Stock | 0.3998 | 0.4004 | 0.3995 | 0.3998 | 2514400.0 |
| 2001-12-07 10:55:00 | AAPL | Stock | 0.3998 | 0.3998 | 0.3975 | 0.3982 | 1999200.0 |
| 2001-12-07 11:00:00 | AAPL | Stock | 0.3979 | 0.3989 | 0.3973 | 0.3977 | 1926400.0 |
| 2001-12-07 11:05:00 | AAPL | Stock | 0.3977 | 0.398 | 0.3955 | 0.3957 | 4513600.0 |
| 2001-12-07 11:10:00 | AAPL | Stock | 0.3959 | 0.3966 | 0.3957 | 0.3964 | 828800.0 |
| 2001-12-07 11:15:00 | AAPL | Stock | 0.3966 | 0.3986 | 0.3963 | 0.397 | 1416800.0 |
| 2001-12-07 11:20:00 | AAPL | Stock | 0.3973 | 0.3973 | 0.3955 | 0.3966 | 1041600.0 |
| 2001-12-07 11:25:00 | AAPL | Stock | 0.3964 | 0.3984 | 0.3964 | 0.3982 | 2940000.0 |
| 2001-12-07 11:30:00 | AAPL | Stock | 0.3984 | 0.3984 | 0.3964 | 0.3966 | 1657600.0 |
| 2001-12-07 11:35:00 | AAPL | Stock | 0.3968 | 0.3968 | 0.3955 | 0.3955 | 3108000.0 |
| 2001-12-07 11:40:00 | AAPL | Stock | 0.3957 | 0.3961 | 0.3946 | 0.3955 | 2755200.0 |
| 2001-12-07 11:45:00 | AAPL | Stock | 0.3955 | 0.3961 | 0.3946 | 0.3954 | 2704800.0 |
| 2001-12-07 11:50:00 | AAPL | Stock | 0.3948 | 0.397 | 0.3945 | 0.3966 | 1517600.0 |
| 2001-12-07 11:55:00 | AAPL | Stock | 0.3966 | 0.3968 | 0.3955 | 0.3955 | 1024800.0 |
| 2001-12-07 12:00:00 | AAPL | Stock | 0.3955 | 0.3964 | 0.3939 | 0.3955 | 2447200.0 |
| 2001-12-07 12:05:00 | AAPL | Stock | 0.3953 | 0.3964 | 0.3948 | 0.3948 | 1120000.0 |
| 2001-12-07 12:10:00 | AAPL | Stock | 0.395 | 0.3956 | 0.3948 | 0.3955 | 341600.0 |
| 2001-12-07 12:15:00 | AAPL | Stock | 0.3957 | 0.3959 | 0.3955 | 0.3955 | 218400.0 |
| 2001-12-07 12:20:00 | AAPL | Stock | 0.3955 | 0.3955 | 0.3943 | 0.3943 | 1176000.0 |
| 2001-12-07 12:25:00 | AAPL | Stock | 0.3943 | 0.3952 | 0.3939 | 0.3946 | 991200.0 |
| 2001-12-07 12:30:00 | AAPL | Stock | 0.3946 | 0.3964 | 0.3946 | 0.3957 | 3309600.0 |
| 2001-12-07 12:35:00 | AAPL | Stock | 0.3962 | 0.3963 | 0.3946 | 0.3952 | 599200.0 |
> showing 50 of 118,108 rows — these rows as CSV