amelia-leeUntitled Query
Updated 2022-07-29
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 last_30d_eth_blocks AS
(
SELECT
block_id
FROM
ethereum.transactions
where datediff(day, block_timestamp, current_date())<30
),
T1 AS(
select
BLOCK_TIMESTAMP,
TX_ID,
FROM_ADDRESS,
TO_ADDRESS,
TO_LABEL_TYPE,
TO_LABEL_SUBTYPE,
TO_LABEL,
TO_ADDRESS_NAME,
FUNCTION_NAME,
FUNCTION_SIGNATURE
FROM
ethereum.transactions
WHERE to_label = 'polygon'
AND to_label_subtype = 'bridge'
--AND block_id IN (select block_id from last_30d_eth_blocks)
),
T2 as (
select
BLOCK_TIMESTAMP,
FROM_ADDRESS
from T1
where
FUNCTION_SIGNATURE='0x4faa8a26'
or FUNCTION_SIGNATURE='0xe3dec8fb'
Run a query to Download Data