Sniperyouthful-sapphire
    Updated 9 days ago
    -- select
    -- a.tx_hash
    -- -- b.EVENT_NAME
    -- --sum(DECODED_LOG:amount1Out/pow(10,18))as a
    -- -- count (DISTINCT tx_hash) as a
    -- from ink.core.fact_event_logs a left join ink.core.ez_decoded_event_logs b on a.tx_hash = b.tx_hash
    -- --where a.CONTRACT_ADDRESS = '0x38d9ecc404d8d21b1e251c0397f63d0429488345'
    -- where a.CONTRACT_ADDRESS = '0x7e16bb931c222e47597fa745abcc03098e1ebcf6'

    -- -- tx_hash = '0x659b843f87042521f8c587a3bb4a5dbc3f7d0b9d70501f64fc7c2a4ec6e32ba1'
    -- -- group by 1
    -- -- -- and

    -- and b.EVENT_NAME = 'Deposit'
    -- GROUP by 1
    -- limit 10
    --Withdrawal
    -- 0x8242119a ->swap
    --0x7ff36ab5 ->deposit --Deposit
    -- 0x791ac947

    select * from ink.core.ez_decoded_event_logs where tx_hash = '0xc01d2924a4c2a58328bb068c3ead054db0e44f7f45cb5403d60878f31fb296de'
    -- select sum (DECODED_LOG:wad)/pow(10,18) as amount from ink.core.ez_decoded_event_logs
    -- where
    -- --tx_hash = '0x079fea9ba82becbc78688054b4263d49d4ed7c59a7c4159eeda103b47410ddb8'
    -- --and
    -- EVENT_NAME = 'Withdrawal'
    -- --Withdrawal
    -- and DECODED_LOG:src = '0x9b17690de96fcfa80a3acaefe11d936629cd7a77'

    -- select * from ink.core.dim_contract_abis where
    -- -- NAME = 'DYOR LPs'
    -- CONTRACT_ADDRESS = '0x7e16bb931c222e47597fa745abcc03098e1ebcf6'

    -- and
    -- CONTRACT_ADDRESS = '0x38d9ecc404d8d21b1e251c0397f63d0429488345'