SyndicaAvalanche Non Bot Wallet Activities
Updated 2024-12-02
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
›
⌄
-- forked from Arbitrum Non Bot Wallet Activities @ https://flipsidecrypto.xyz/studio/queries/11c23d85-5274-4e66-8048-e2de8195129a
-- forked from Ethereum Non Bot Wallet Activities @ https://flipsidecrypto.xyz/studio/queries/e7fbb21e-e389-47cb-8b54-4414b7c41ab0
-- forked from Solana Non Bot Wallet Activities @ https://flipsidecrypto.xyz/studio/queries/d9db06f9-218c-49f0-8443-62adca8447d5
-- forked from Solana Wallets Transactions Count Grouped @ https://flipsidecrypto.xyz/studio/queries/b5a767b9-f07f-4a7a-b2b5-69ca0249472a
with
bots as (
SELECT
value:SIGNER as signer
from (
select live.udf_api('https://flipsidecrypto.xyz/api/v1/queries/a2cfc023-6d75-49a7-a02c-4258855b780c/data/latest'):data AS response
) , lateral flatten(input => response)
)
, contracts as (
select
b.address
, c.label_type
from avalanche.core.dim_contracts b inner join avalanche.core.dim_labels c
on b.address = c.address
where
label_type in (
'dapp'
, 'games'
, 'dex'
, 'bridge'
, 'defi'
, 'nft'
, 'token'
)
group by 1,2
)
QueryRunArchived: QueryRun has been archived