zyroqexperienced-red
Updated 2024-12-27
999
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
›
⌄
with inflows as
(select
BLOCK_TIMESTAMP,
TX_HASH,
DECODED_LOG:redeemer,
CONTRACT_ADDRESS,
(case
when contract_address ='0x334ad834cd4481bb02d09615e7c11a00579a7909'then'WETH.E',
when contract_address ='0x35bd6aeda81a7e5fc7a7832490e71f757b0cd9ce'then'QI',
when contract_address '0x4e9f683a27a6bdad3fc2764003759277e93696e6'then'LINK.E',
when contract_address '0x5c0401e81bc07ca70fad469b451682c0d747ef1c'then'WAVAX',
when contract_address '0xbeb5d47a3f720ec0a390d04b4d41ed7d9688bc7f'then'USDC.E',
when contract_address '0x835866d37afb8cb8f8334dccdaf66cf01832ff5d'then'DAI.E',
when contract_address '0xc9e5999b8e75c3feb117f6f73e664b9f3c8ca65c'then'USDT.E',
when contract_address'0xe194c4c5ac32a3c9ffdb358d9bfd523a0b6d1568'then'WBTC.E',
when contract_address '0x89a415b3d20098e6a6c8f7a59001c67bd3129821'then'BTC.B',
when contract_address '0x872670ccae8c19557cc9443eff587d7086b8043a'then'BUSD',
when contract_address '0xf362fea9659cf036792c9cb02f8ff8198e21b4cb'then'SAVAX',
when contract_address '0xb715808a78f6041e46d61cb123c9b4a27056ae9c'then'USDC',
when contract_address '0xd8fcda6ec4bdc547c0827b8804e89acd817d56ef'then'USDT'else 'NULL' end) as Token
, (case
when contract_address ='0x334ad834cd4481bb02d09615e7c11a00579a7909'then DECODED_LOG:redeemAmount/le18,
when contract_address ='0x35bd6aeda81a7e5fc7a7832490e71f757b0cd9ce'then DECODED_LOG:redeemAmount/le18,
when contract_address '0x4e9f683a27a6bdad3fc2764003759277e93696e6'then DECODED_LOG:redeemAmount/le18,
when contract_address '0x5c0401e81bc07ca70fad469b451682c0d747ef1c'then DECODED_LOG:redeemAmount/le18,
when contract_address '0xbeb5d47a3f720ec0a390d04b4d41ed7d9688bc7f'then DECODED_LOG:redeemAmount/le18,
when contract_address '0x835866d37afb8cb8f8334dccdaf66cf01832ff5d'then DECODED_LOG:redeemAmount/le18,
when contract_address '0xc9e5999b8e75c3feb117f6f73e664b9f3c8ca65c'then DECODED_LOG:redeemAmount/le18,
when contract_address'0xe194c4c5ac32a3c9ffdb358d9bfd523a0b6d1568'then DECODED_LOG:redeemAmount/le18,
when contract_address '0x89a415b3d20098e6a6c8f7a59001c67bd3129821'then DECODED_LOG:redeemAmount/le18,
when contract_address '0x872670ccae8c19557cc9443eff587d7086b8043a'then DECODED_LOG:redeemAmount/le18,
when contract_address '0xf362fea9659cf036792c9cb02f8ff8198e21b4cb'then DECODED_LOG:redeemAmount/le18,
when contract_address '0xb715808a78f6041e46d61cb123c9b4a27056ae9c'then DECODED_LOG:redeemAmount/le18,
when contract_address '0xd8fcda6ec4bdc547c0827b8804e89acd817d56ef'thenDECODED_LOG:redeemAmount/le18
else 0 end) as Tokens_Deposited
QueryRunArchived: QueryRun has been archived