flipside

    azuro test
    SocioAnalyticaazuro test
    Updated 2023-12-24
    -- contract : 0x7043E4e1c4045424858ECBCED80989FeAfC11B36 --polygon usdt
    -- : 0x2a838ab9b037db117576db8d0dcc3b686748ef7c usdc

    -- Token AzuroBet-NFT (BET) : 0x351c8BACF9C75f54F50F7c601B80CD7a3B73070C
    --ORIGIN_FUNCTION_SIGNATURE = '0x613db23b' addliquidity
    --ORIGIN_FUNCTION_SIGNATURE = '0xe408d788' removeliquidity
    --

    -- min block_timestamp : 2023-04-16 10:45:09.000
    -- min block_number : 41594860


    --event_name:
    -- LiquidityAdded

    --LiquidityRemoved

    -- AffiliateRewarded

    -- NewGame

    -- BettorWin

    with azuro_txns as (
    SELECT
    *
    FROM polygon.core.ez_decoded_event_logs
    WHERE
    contract_address = '0x7043e4e1c4045424858ecbced80989feafc11b36'
    )


    SELECT
    'deposit' as type,
    sum(amount) as value
    FROM polygon.core.ez_token_transfers a
    QueryRunArchived: QueryRun has been archived