maybeyonasAAVE Flash Loans - Farming - Weekly
    Updated 2021-08-26
    with flashloans as(
    select
    tx_id,
    block_timestamp,
    initiator_address,
    flashloan_amount,
    flashloan_amount_usd,
    premium_amount,
    premium_amount_usd,
    aave_token,
    symbol,
    token_price
    from aave.flashloans
    where aave_version = 'Aave V2'
    ),
    total_flashes as(
    select
    count(distinct tx_id) as total_flashloans,
    sum(flashloan_amount_usd) as all_usd_val
    from flashloans
    ),

    props as(
    select
    f.tx_id,
    f.block_timestamp,
    initiator_address,
    flashloan_amount,
    flashloan_amount_usd,
    premium_amount,
    premium_amount_usd,
    aave_token,
    f.symbol,
    token_price,
    from_label,
    to_label,
    Run a query to Download Data