Sbhn_NPPolygon Total Origination
    Updated 2022-08-10
    SELECT
    CASE WHEN address_name is null THEN a.symbol ELSE address_name END as token,
    avg(borrowed_tokens+flashloan_amount) as total,
    count(*) as events
    FROM flipside_prod_db.aave.borrows a
    left outer JOIN polygon.core.dim_labels b
    ON b.address = a.symbol
    left outer join flipside_prod_db.aave.flashloans c
    on a.borrower_address = c.initiator_address
    WHERE borrower_address LIKE lower('{{User}}')
    and token is not null
    GROUP BY 1
    ORDER BY 2 DESC
    LIMIT 10
    Run a query to Download Data