select * from

values

(62158452, 60503935, 256245713, 36467181, 373630890, 398590295) --Not possible to come up with a formula due to the non linear nature of the vesting

, price as (

select

avg(price) as op_price

from optimism.price.ez_prices_hourly

where symbol = 'OP'

and date_trunc('day', hour) = current_date()

select

Governance_fund + Partner_fund + Airdrops + RPGF + Early_contributors + Sugar_xaddies as circulating_supply,

op_price,

circulating_supply * op_price as marketcap,

4294967296 as total_supply

from current_circulating_supply, price