flipside

    Terraswap Volume
    adam10Terraswap Volume
    Updated 2021-08-31
    SELECT n.address_name as swap_pair, COUNT(*) as total_transactions, SUM(msg_value:execute_msg:send:amount::float / POW(10,6)) AS swap_volume
    FROM terra.msgs
    JOIN (
    SELECT address, address_name FROM terra.labels
    WHERE address_name ILIKE '%terraswap%lp'
    ) n
    ON msg_value:contract::string = n.address
    WHERE msg_value:contract::string IN (
    SELECT address FROM terra.labels
    WHERE address_name ILIKE '%terraswap%lp'
    )
    AND tx_status = 'SUCCEEDED'
    AND DATEDIFF('day', TO_DATE(block_timestamp), current_date()) <= 365
    GROUP BY n.address_name
    ORDER BY swap_volume DESC
    Run a query to Download Data