No Data to Display
SniperMoM Transactions by Project Type copy
Updated 2025-04-05
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 defi as (select
'defi' as type,
date_trunc('month', block_timestamp) as date,
count (DISTINCT TX_HASH) as tx_defi,
count (DISTINCT FROM_ADDRESS) as user,
from swell.core.fact_transactions x
join swell.core.dim_labels y on x.to_address=y.address
where block_timestamp :: Date >= '2024-09-01'
and label_type = 'defi'
and TX_SUCCEEDED = 'TRUE'
group by 1,2
),
dapp as (select
'dapp' as type,
date_trunc('month', block_timestamp) as date,
count (DISTINCT TX_HASH) as tx_dapp,
count (DISTINCT FROM_ADDRESS) as user,
from swell.core.fact_transactions x
join swell.core.dim_labels y on x.to_address=y.address
where block_timestamp :: Date >= '2024-09-01'
and label_type = 'dapp'
and TX_SUCCEEDED = 'TRUE'
group by 1,2
),
bridge as (select
'bridge' as type,
date_trunc('month', block_timestamp) as date,
count (DISTINCT TX_HASH) as tx_bridge,
count (DISTINCT FROM_ADDRESS) as user,
from swell.core.fact_transactions x
join swell.core.dim_labels y on x.to_address=y.address
where block_timestamp :: Date >= '2024-09-01'
and label_type = 'bridge'
and TX_SUCCEEDED = 'TRUE'
group by 1,2
),
Last run: 13 days ago
0
2B
32s