maybeyonaskashi_stable_tvl_collat
    Updated 2022-07-09
    with
    kashi_deployments as (
    select
    event_inputs:cloneAddress::string as pair_address,
    '0x'||substring(event_inputs:data::string, 27, 40) as collateral,
    '0x'||substring(event_inputs:data::string, 91, 40) as asset
    from ethereum_core.fact_event_logs
    where event_removed = 'false'
    and contract_address = '0xf5bce5077908a1b7370b9ae04adc565ebd643966' --bentobox
    and event_name = 'LogDeploy'
    and collateral is not null
    and asset is not null
    ),
    tokenMovement as (
    select
    contract_address as pair_address,
    event_inputs:to::string as user,
    event_inputs:share as share,
    event_name
    from ethereum_core.fact_event_logs
    where event_removed = 'false'
    and contract_address in (select pair_address from kashi_deployments)
    and event_name in (
    'LogAddCollateral',
    'LogAddAsset',
    'LogRemoveCollateral',
    'LogRemoveAsset'
    )
    ),
    tvl_data as (
    select
    pair_address,
    sum(
    case event_name
    when 'LogAddAsset' then share
    when 'LogRemoveAsset' then -share
    Run a query to Download Data