KaskoazulLUNA whales on crc
    Updated 2022-03-15
    --Create a dashboard to track the outflows of LUNA and UST to Osmosis, Secret, Axelar, and Injective. What conclusions can you draw from the outflows thus far?


    select me.block_timestamp::date as fecha,
    te.amount,
    te.currency,
    te.amount_usd,
    me.event_attributes:receiver,
    te.recipient,
    me.tx_id
    from terra.msg_events me
    inner join terra.transfer_events te
    on me.tx_id = te.tx_id
    where fecha = '2022-02-25'
    and event_type = 'ibc_transfer'
    --and event_attributes:receiver not like 'osmo%'
    --and event_attributes:receiver not like 'axelar%'
    --and event_attributes:receiver not like 'secret%'
    --and event_attributes:receiver not like 'inj%'
    --and event_attributes:receiver not like 'juno%'
    --and event_attributes:receiver not like 'kava%'
    --and event_attributes:receiver not like 'cosmos%'
    and event_attributes:receiver like 'crc%'
    --and event_attributes:recevier not like 'terra%'
    --group by fecha, 3
    --and msg_type = 'applications/transfer.v1.MsgTransfer'
    -- and tx_id = '7EFCA831C6567EEB7C4FE8D073C32E3BD56367574D1DBBBEC98E838037BFC7A9'
    --or tx_id = '5B9F30C78698FEDBB0FD1B75D265EB930D120C06D2D18CA95322E41AEDDAD1A2'
    and te.currency like 'LUNA'
    and te.amount > 49000
    -- and event_from_address_name IN ('osmosis bridge', 'secret bridge', 'axelar bridge', 'injective bridge')--, 'ethereum bridge', 'binance bridge')
    --and event_to = 'terra1kq2rzz6fq2q7fsu75a9g7cpzjeanmk68wplle5'
    --GROUP by fecha, bridge, currency
    --ORDER BY total_outflow


    Run a query to Download Data