Mojtaba-BanaeiGNO Playground
Updated 2022-07-30
99
1
2
3
4
5
6
7
8
9
10
11
12
13
›
⌄
select
distinct origin_function_signature
, count (distinct tx_hash) over(partition by origin_function_signature ) as tx_count
, first_value (tx_hash) over(partition by origin_function_signature order by block_timestamp) as first_tx
, last_value (tx_hash) over(partition by origin_function_signature order by block_timestamp) as last_tx
FROM
gnosis.core.fact_token_transfers
where
-- tx_hash = '0x26551e53b17848409391ecbf88dc5b921afd8455b82ca56701591c8b549a3279' and
-- origin_function_signature = '0x382d5243' -- claimIncentive
contract_address = '0xa4ef9da5ba71cc0d2e5e877a910a37ec43420445' -- sGNO '0x722fc4daabfeaff81b97894fc623f91814a1bf68' -- mGNO
order by 2 desc
Run a query to Download Data