KaskoazulLUNA in main bridges
    Updated 2022-03-15
    WITH ETH_BRIDGE AS (
    select block_timestamp::date as fecha,
    sum(event_amount) as total_amount,
    event_currency as currency,
    sum(event_amount_usd) as total_amount_usd
    from terra.transfers
    where event_from_address_name IN ('ethereum bridge')
    and currency in ('LUNA')
    and fecha >= '2022-01-01'
    group by 1,3
    ),

    BNB_BRIDGE AS (
    select block_timestamp::date as fecha,
    sum(event_amount) as total_amount,
    event_currency as currency,
    sum(event_amount_usd) as total_amount_usd
    from terra.transfers
    where event_from_address_name IN ('binance bridge')
    and currency in ('LUNA')
    and fecha >= '2022-01-01'
    group by 1,3
    ),

    HARM_BRIDGE AS (
    select block_timestamp::date as fecha,
    sum(event_amount) as total_amount,
    event_currency as currency,
    sum(event_amount_usd) as total_amount_usd
    from terra.transfers
    where event_from_address_name IN ('harmony bridge')
    and currency in ('LUNA')
    and fecha >= '2022-01-01'
    group by 1,3
    ),

    Run a query to Download Data