select msg_value:contract::string as contract,

'MIR airdrop' as mir,

msg_value:execute_msg:claim:amount/1e6 as amount_claim,

msg_value:sender::string as user_address,

date_trunc('day', block_timestamp) as dt

from terra.msgs

where msg_type = 'wasm/MsgExecuteContract'

and msg_value like '%terra1kalp2knjm4cs3f59ukr4hdhuuncp648eqrgshw%'

and msg_value:execute_msg:claim:stage = 1

),

claim_on_eth as (

select event_inputs:account::string as users_address,

event_inputs:amount/1e18 as amount_claim,

date_trunc('day', block_timestamp) as dt1

from ethereum.events_emitted

where tx_succeeded = 'TRUE'

and event_name = 'Claimed'

and tx_to_address = '0x2a398bba1236890fb6e9698a698a393bb8ee8674'

and event_inputs:amount = '220036552520200076952'

),

uni_holding as (

select amount_usd, balance, symbol ,user_address, balance_date

from ethereum.erc20_balances

where contract_address = lower('0x1f9840a85d5af5bf1d1762f925bdaddc4201f984')

and user_address in (select users_address from claim_on_eth)

and balance_date = '2020-11-23'

),

cum_terra_user as (

select count(distinct user_address) as num_user,

dt ,

SUM(num_user) OVER(ORDER BY dt ROWS BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW) AS cumulative_terra_user_claim

from claim_on_terra