flipside

    avax sushi
    bachiavax sushi
    Updated 2022-08-08
    select count(1),CONTRACT_ADDRESS from avalanche.core.fact_event_logs where
    EVENT_NAME like '%Swap%' --and EVENT_INPUTS:sender = '0x1b02da8cb0d097eb8d57a175b88c7d8b47997506'
    and TX_STATUS like '%SUCCESS%'
    group by CONTRACT_ADDRESS

    select
    * from avalanche.core.fact_event_logs where
    EVENT_NAME like '%Swap%' --and EVENT_INPUTS:sender = '0x1b02da8cb0d097eb8d57a175b88c7d8b47997506'
    and TX_STATUS like '%SUCCESS%'
    Run a query to Download Data