Hessishfdn_stark - dau -avnu
Updated 2023-12-12
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
›
⌄
-- forked from fdn_stark - dau -firous @ https://flipsidecrypto.xyz/edit/queries/d0749bef-eec8-481d-a41b-28d3d763c17f
with avnu_all as (sELECT DISTINCT tx_hash as hash0
from external.tokenflow_starknet.decoded_traces
where-- tx_hash = '0x009184d8ab6f7a9a407df6e3bd459a589dab3cc9b2e68cc2a66e4f864e967ee7'--and
--tx_hash in ('0x009184d8ab6f7a9a407df6e3bd459a589dab3cc9b2e68cc2a66e4f864e967ee7' ,'0x071059bd9659a95d454e74d09efdf9ad6a84dc0ba840d2f855178c1bae60c627','0x001b57e30f56d92d54476d4afbc237db3bafa60c84cc879d137557b142c30bbd') and
caller = '0x04270219d365d6b017231b52e92b3fb5d7c8378b05e9abc97724537a80e93b0f' and
FUNCTION = '__default__'
and chain_id = 'mainnet')
SELECT timestamp::date as date, count(DISTINCT contract) as users, 'Avnu' as protocol
from external.tokenflow_starknet.decoded_transactions join avnu_all on tx_hash =hash0
where chain_id = 'mainnet'
GROUP by all
Run a query to Download Data