nickpayiatis_Untitled Query
9
1
2
3
4
5
6
7
8
›
⌄
with reward as (select tx_id, date(block_timestamp) as rdate,event_attributes:rewards::float/1e6 as rewards, event_attributes:holder_address::string as holder
from terra.msg_events where -- tx_id='88B25A019CF28363A930C6C136DD76DC3396E65CE02D3E8C8C09DC1EB808B793' and
event_attributes:contract_address='terra17yap3mhph35pcwvhza38c2lkj7gzywzy05h7l0'
and event_attributes:action::string = 'claim_reward' and event_type = 'wasm')
select *
from terra.msg_events, reward
where event_attributes:sender::string = holder
and holder = 'terra19z8s5p35pyzzdvex8dfqce44du3p9eryylnul2'
Run a query to Download Data