maybeyonaskashi_contracts
    Updated 2022-06-12
    with
    token_data as (
    select distinct
    token_address,
    symbol,
    decimals
    -- median(price) as price
    from ethereum_core.fact_hourly_token_prices
    -- where hour >= current_date - interval '1 day'
    -- and decimals is not null
    -- group by 1,2,3
    ),
    kashi_deployments as (
    select
    block_timestamp as deployed_time,
    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
    )

    select
    deployed_time,
    pair_address,
    collateral,
    cc.symbol as collateral_symbol,
    cc.decimals as collateral_decimal,
    asset,
    ca.symbol as asset_symbol,
    ca.decimals as asset_decimal
    from kashi_deployments k
    Run a query to Download Data