cnallenzhaodelightful-silver
Updated 2025-02-20
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
›
⌄
WITH POOLS AS (
SELECT
*
FROM
ethereum.uniswapv3.ez_pools
WHERE
pool_address IN (
'0x11b815efb8f581194ae79006d24e0d814b7697f6',
'0x4e68ccd3e89f51c3074ca5072bbac773960dfa36',
'0x69d91b94f0aaf8e8a2586909fa77a5c2c89818d5',
'0x84383fb05f610222430f69727aa638f8fdbf5cc1',
'0x99ac8ca7087fa4a2a1fb6357269965a2014abc35',
'0x88e6a0c2ddd26feeb64f039a2c41296fcb3f5640',
'0x8ad599c3a0ff1de082011efddc58f1908eb6e6d8',
'0xc2e9f25be6257c210d7adf0d4cd6e3e881ba25f8'
)
),
burn AS (
SELECT
*
FROM
ethereum.core.ez_decoded_event_logs
WHERE
1 = 1
AND BLOCK_NUMBER >= 12369854
AND BLOCK_NUMBER <= 16308144
AND CONTRACT_ADDRESS IN (
'0x11b815efb8f581194ae79006d24e0d814b7697f6',
'0x4e68ccd3e89f51c3074ca5072bbac773960dfa36',
'0x69d91b94f0aaf8e8a2586909fa77a5c2c89818d5',
'0x84383fb05f610222430f69727aa638f8fdbf5cc1',
'0x99ac8ca7087fa4a2a1fb6357269965a2014abc35',
'0x88e6a0c2ddd26feeb64f039a2c41296fcb3f5640',
'0x8ad599c3a0ff1de082011efddc58f1908eb6e6d8',
'0xc2e9f25be6257c210d7adf0d4cd6e3e881ba25f8'
)
QueryRunArchived: QueryRun has been archived