flipside
GROWTH MCP
IDG PLAYBOOK
JOURNEYS
INSIGHTS
About
Log in
BECOME A PARTNER
flipside
Gogo - Distinct contract signatures
Kurama
Gogo - Distinct contract signatures
Updated 2022-11-21
Copy Reference
Fork
99
1
2
3
4
5
6
7
8
9
10
11
12
›
⌄
-- signatures 0x7edbceb1 and 0x2f93b839 are not on the signatures table for some reason, but looking at two example transactions and going on polygonscan we can confirm that they are
-- withdraw pending and stable reward respectively
select
distinct
origin_function_signature
,
case
when
origin_function_signature
=
'0x7edbceb1'
then
'withdraw pending'
when
origin_function_signature
=
'0x2f93b839'
then
'stable reward'
else
b
.
text_signature
end
as
signature
from
polygon
.
core
.
fact_token_transfers
a
left
join
ethereum
.
core
.
dim_function_signatures
b
on
a
.
origin_function_signature
=
b
.
bytes_signature
where
origin_to_address
=
'0x7fcf0f2dcec385fcced98240a8a4bec8e91da7d1'
Results
Run a query to Download Data