flipside

    Old contract address (total)
    kiacryptoOld contract address (total)
    Updated 2022-09-12
    -- 0xae1fc3947ee83aeb3b7fec237bcc1d194c88bc24 old contract
    -- 0xef0881ec094552b2e128cf945ef17a6752b4ec5d, 0x3d3f13f2529ec3c84b2940155effbf9b39a8f3ec new contract

    select count(tx_hash) as tx_count, count(distinct origin_from_address) as unique_user, sum(iff(origin_function_signature = '0x8dbdbe6d', amount, -amount)) as liquidity
    from ethereum.core.ez_token_transfers
    where --tx_hash = '0x010d855a5389edeb843ebe2a537b2f88710593529f913293b0a157be51e62f0c' and
    origin_to_address = '0xae1fc3947ee83aeb3b7fec237bcc1d194c88bc24' and origin_function_signature in ('0x8dbdbe6d', '0xd1abb907') and contract_address = '0x3d3f13f2529ec3c84b2940155effbf9b39a8f3ec'
    Run a query to Download Data