Benqi DAU WAU

Updated 2 days ago

with benqi_tokens as (

select

address, address_name, label_subtype,

case when address='0x334ad834cd4481bb02d09615e7c11a00579a7909' then 'WETH.E'

when address='0x35bd6aeda81a7e5fc7a7832490e71f757b0cd9ce' then 'QI'

when address='0x4e9f683a27a6bdad3fc2764003759277e93696e6' then 'LINK.E'

when address='0x5c0401e81bc07ca70fad469b451682c0d747ef1c' then 'WAVAX'

when address='0xbeb5d47a3f720ec0a390d04b4d41ed7d9688bc7f' then 'USDC.E'

when address='0x835866d37afb8cb8f8334dccdaf66cf01832ff5d' then 'DAI.E'

when address='0xc9e5999b8e75c3feb117f6f73e664b9f3c8ca65c' then 'USDT.E'

when address='0xe194c4c5ac32a3c9ffdb358d9bfd523a0b6d1568' then 'WBTC.E'

when address='0x89a415b3d20098e6a6c8f7a59001c67bd3129821' then 'BTC.B'

when address='0x872670ccae8c19557cc9443eff587d7086b8043a' then 'BUSD'

when address='0xf362fea9659cf036792c9cb02f8ff8198e21b4cb' then 'SAVAX'

when address='0xb715808a78f6041e46d61cb123c9b4a27056ae9c' then 'USDC'

when address='0xd8fcda6ec4bdc547c0827b8804e89acd817d56ef' then 'USDT'

else null

end as token

from avalanche.core.dim_labels

where

project_name='benqi finance'

and label_subtype='token_contract'

and address!='0x8729438eb15e2c8b576fcc6aecda6a148776c0f5'

and token is not null

benqi_tx as (

select

block_timestamp,

origin_from_address

from

avalanche.core.ez_decoded_event_logs

left join

benqi_tokens on contract_address=address

Last run: 2 days ago

...

315

11KB

12s

flipside