Supply | Sniper | Flipside

Updated 8 days ago

with tbl as(

select

a.BLOCK_TIMESTAMP::date as date_,

'Deposit' as type,

case

when c.contract_address = '0x10d0d11a8b693f4e3e33d09bbab7d4afc3c03ef3' then 'WEETH'

when c.contract_address = '0x49c077b74292aa8f589d39034bf9c1ed1825a608' then 'WETH'

when c.contract_address = '0x29c85c752e854b0cf2372e6b6c56f260755f5120' then 'PZETH'

when c.contract_address = '0x4a5c95a0e3fca4148f91ceb637fba0e1080be40e' then 'EZETH'

when c.contract_address = '0x3c12aa52b014acf7957308808362909b5757cca8' then 'WSTETH'

when c.contract_address = '0x1773002742a2bcc7666e38454f761ce8fe613de5' then 'RSWETH'

when c.contract_address = '0xf34253ec3dd0cb39c29cf5eeb62161fb350a9d14' then 'SWETH'

when c.contract_address = '0x46e3c018798d6de4517a3c98358e4bd8d334b79c' then 'RSETH'

when c.contract_address = '0xf18de8d3bcf95da46bb667c8a222956199b94e6c' then 'WETH'

when c.contract_address = '0x522d58aefb7b4f54fc1bd31b5063e55c7984badd' then 'SWELL'

end as symbol,

DECODED_LOG:assets/pow(10,18) as volume

from

swell.core.fact_transactions a

left join

swell.core.fact_event_logs b

on a.tx_hash = b.tx_hash

join

swell.core.ez_decoded_event_logs c

on b.contract_address = c.contract_address and a.tx_hash = c.tx_hash

where

-- a.TO_ADDRESS = '0x08739cbede6e28e387685ba20e6409bd16969cde'

--and

c.EVENT_NAME = 'Deposit'

and b.topics[0] = '0x80b61abbfc5f73cfe5cf93cec97a69ed20643dc6c6f1833b05a1560aa164e24c'

and c.topics[0] = '0xdcbc1c05240f31ff3ad067ef1ee35ce4997762752e3a095284754544f4c709d7'

-- and c.contract_address = '0x10d0d11a8b693f4e3e33d09bbab7d4afc3c03ef3'

--and c.contract_address = '0x49c077b74292aa8f589d39034bf9c1ed1825a608'

and c.TX_SUCCEEDED = 'TRUE'

-- GROUP by 1,2

Last run: 8 days ago

5KB

19s

flipside