MLDZMNsudootc3
Updated 2024-05-21
99
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
›
⌄
-- forked from sudootc1 @ https://flipsidecrypto.xyz/edit/queries/0f87a448-b13b-4607-ad90-a9d84be46ba6
with tb1 as (
select
s.BLOCK_TIMESTAMP AS day,
e.tx_hash,
e.amount AS weth,
NFT_ADDRESS AS address
from
ethereum.core.ez_decoded_event_logs s
JOIN ethereum.core.ez_token_transfers AS e ON e.tx_hash = s.tx_hash
JOIN ethereum.nft.ez_nft_transfers AS t ON t.tx_hash = s.tx_hash
where
s.CONTRACT_ADDRESS = '0x080bf510fcbf18b91105470639e9561022937712'
and s.EVENT_NAME = 'Fill'
and s.DECODED_LOG:feeRecipientAddress = lower('0x4e2f98c96e2d595a83AFa35888C4af58Ac343E44')
AND NFT_ADDRESS IN (
'0xf17bb82b6e9cc0075ae308e406e5198ba7320545',
'0x2c889a24af0d0ec6337db8feb589fa6368491146',
'0x9e629d779be89783263d4c4a765c38eb3f18671c',
'0xb4e570232d3e55d2ee850047639dc74da83c7067',
'0x32bb5a147b5371fd901aa4a72b7f82c58a87e36d'
)
),
tb2 as (
select
s.tx_hash,
COUNT(e.tx_hash) AS no_txn
from
ethereum.core.ez_decoded_event_logs s
JOIN ethereum.core.ez_token_transfers AS e ON e.tx_hash = s.tx_hash
JOIN ethereum.nft.ez_nft_transfers AS t ON t.tx_hash = s.tx_hash
where
s.CONTRACT_ADDRESS = '0x080bf510fcbf18b91105470639e9561022937712'
and s.EVENT_NAME = 'Fill'
and s.DECODED_LOG:feeRecipientAddress = lower('0x4e2f98c96e2d595a83AFa35888C4af58Ac343E44')
AND e.contract_address = '0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2'
QueryRunArchived: QueryRun has been archived