PREVIEW / stock_5min / 2008-08-14
file: by_date/stock_5min/2008/2008-08-14.parquet size: 4.4 MB rows: 312,679 symbols: 3,329
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 |
|---|---|---|---|---|---|---|---|
| 2008-08-14 07:05:00 | AAPL | Stock | 6.4107 | 6.4107 | 6.4107 | 6.4107 | 11200.0 |
| 2008-08-14 07:10:00 | AAPL | Stock | 6.4214 | 6.4214 | 6.4214 | 6.4214 | 5600.0 |
| 2008-08-14 07:20:00 | AAPL | Stock | 6.4107 | 6.4107 | 6.4107 | 6.4107 | 7000.0 |
| 2008-08-14 07:25:00 | AAPL | Stock | 6.4211 | 6.4214 | 6.4211 | 6.4214 | 20860.0 |
| 2008-08-14 07:45:00 | AAPL | Stock | 6.4214 | 6.4214 | 6.4214 | 6.4214 | 7560.0 |
| 2008-08-14 07:50:00 | AAPL | Stock | 6.4179 | 6.4211 | 6.4107 | 6.4107 | 94500.0 |
| 2008-08-14 07:55:00 | AAPL | Stock | 6.4211 | 6.4211 | 6.4211 | 6.4211 | 5600.0 |
| 2008-08-14 08:00:00 | AAPL | Stock | 6.4196 | 6.4207 | 6.4107 | 6.4107 | 188440.0 |
| 2008-08-14 08:05:00 | AAPL | Stock | 6.4129 | 6.4161 | 6.4107 | 6.4107 | 235228.0 |
| 2008-08-14 08:10:00 | AAPL | Stock | 6.4107 | 6.4143 | 6.4107 | 6.4143 | 36400.0 |
| 2008-08-14 08:15:00 | AAPL | Stock | 6.4114 | 6.4118 | 6.4114 | 6.4118 | 29624.0 |
| 2008-08-14 08:20:00 | AAPL | Stock | 6.4143 | 6.4157 | 6.4121 | 6.4157 | 58800.0 |
| 2008-08-14 08:25:00 | AAPL | Stock | 6.4175 | 6.4268 | 6.4114 | 6.4211 | 343112.0 |
| 2008-08-14 08:30:00 | AAPL | Stock | 6.4157 | 6.4157 | 6.375 | 6.375 | 946288.0 |
| 2008-08-14 08:35:00 | AAPL | Stock | 6.375 | 6.3821 | 6.3661 | 6.3804 | 312032.0 |
| 2008-08-14 08:40:00 | AAPL | Stock | 6.3818 | 6.3882 | 6.375 | 6.3754 | 102900.0 |
| 2008-08-14 08:45:00 | AAPL | Stock | 6.3757 | 6.3779 | 6.3714 | 6.3729 | 67592.0 |
| 2008-08-14 08:50:00 | AAPL | Stock | 6.3771 | 6.3836 | 6.375 | 6.3796 | 62020.0 |
| 2008-08-14 08:55:00 | AAPL | Stock | 6.3839 | 6.3861 | 6.3825 | 6.3839 | 57400.0 |
| 2008-08-14 09:00:00 | AAPL | Stock | 6.3804 | 6.3875 | 6.3804 | 6.3857 | 170464.0 |
| 2008-08-14 09:05:00 | AAPL | Stock | 6.3857 | 6.3864 | 6.3839 | 6.3857 | 20384.0 |
| 2008-08-14 09:10:00 | AAPL | Stock | 6.3846 | 6.3846 | 6.3821 | 6.3821 | 39200.0 |
| 2008-08-14 09:15:00 | AAPL | Stock | 6.3839 | 6.3843 | 6.3821 | 6.3839 | 50120.0 |
| 2008-08-14 09:20:00 | AAPL | Stock | 6.3821 | 6.3825 | 6.3821 | 6.3821 | 71120.0 |
| 2008-08-14 09:25:00 | AAPL | Stock | 6.3821 | 6.3843 | 6.3579 | 6.3689 | 939120.0 |
| 2008-08-14 09:30:00 | AAPL | Stock | 6.3682 | 6.3814 | 6.3514 | 6.3707 | 18034156.0 |
| 2008-08-14 09:35:00 | AAPL | Stock | 6.3714 | 6.4071 | 6.3711 | 6.3971 | 19744704.0 |
| 2008-08-14 09:40:00 | AAPL | Stock | 6.3971 | 6.4336 | 6.3929 | 6.4314 | 32618880.0 |
| 2008-08-14 09:45:00 | AAPL | Stock | 6.4311 | 6.4446 | 6.3846 | 6.3929 | 24891664.0 |
| 2008-08-14 09:50:00 | AAPL | Stock | 6.3921 | 6.4204 | 6.3907 | 6.4171 | 15390676.0 |
| 2008-08-14 09:55:00 | AAPL | Stock | 6.4161 | 6.4304 | 6.3839 | 6.4304 | 15775536.0 |
| 2008-08-14 10:00:00 | AAPL | Stock | 6.4304 | 6.4375 | 6.4086 | 6.4114 | 17466820.0 |
| 2008-08-14 10:05:00 | AAPL | Stock | 6.4087 | 6.4125 | 6.3857 | 6.3936 | 17173940.0 |
| 2008-08-14 10:10:00 | AAPL | Stock | 6.3932 | 6.4032 | 6.3679 | 6.3782 | 16887360.0 |
| 2008-08-14 10:15:00 | AAPL | Stock | 6.3782 | 6.4143 | 6.3782 | 6.4111 | 12067104.0 |
| 2008-08-14 10:20:00 | AAPL | Stock | 6.4111 | 6.4111 | 6.3929 | 6.3971 | 10099320.0 |
| 2008-08-14 10:25:00 | AAPL | Stock | 6.3971 | 6.4107 | 6.3896 | 6.4086 | 8857268.0 |
| 2008-08-14 10:30:00 | AAPL | Stock | 6.4075 | 6.4096 | 6.395 | 6.3986 | 7078176.0 |
| 2008-08-14 10:35:00 | AAPL | Stock | 6.3985 | 6.4214 | 6.3964 | 6.4146 | 10761212.0 |
| 2008-08-14 10:40:00 | AAPL | Stock | 6.4154 | 6.4261 | 6.4089 | 6.4254 | 12671764.0 |
| 2008-08-14 10:45:00 | AAPL | Stock | 6.4254 | 6.4271 | 6.4143 | 6.4164 | 8027404.0 |
| 2008-08-14 10:50:00 | AAPL | Stock | 6.4157 | 6.4282 | 6.4114 | 6.4268 | 10147228.0 |
| 2008-08-14 10:55:00 | AAPL | Stock | 6.4261 | 6.4271 | 6.4036 | 6.4157 | 8804124.0 |
| 2008-08-14 11:00:00 | AAPL | Stock | 6.4161 | 6.4232 | 6.4086 | 6.4189 | 7259756.0 |
| 2008-08-14 11:05:00 | AAPL | Stock | 6.4189 | 6.4282 | 6.4114 | 6.4271 | 7840196.0 |
| 2008-08-14 11:10:00 | AAPL | Stock | 6.4266 | 6.4282 | 6.4143 | 6.4143 | 7873908.0 |
| 2008-08-14 11:15:00 | AAPL | Stock | 6.415 | 6.4214 | 6.4125 | 6.4171 | 6022268.0 |
| 2008-08-14 11:20:00 | AAPL | Stock | 6.4182 | 6.4204 | 6.4107 | 6.4138 | 6469988.0 |
| 2008-08-14 11:25:00 | AAPL | Stock | 6.4136 | 6.4229 | 6.4129 | 6.4194 | 5560604.0 |
| 2008-08-14 11:30:00 | AAPL | Stock | 6.4193 | 6.4286 | 6.4164 | 6.4282 | 8394624.0 |
> showing 50 of 312,679 rows — these rows as CSV