sepehrmhz8Untitled Query
Updated 2022-09-03
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
›
⌄
with stakewise as (
select 'Stakewise' as platform,
origin_from_address,
count (distinct tx_hash) TX_Count
from ethereum.core.fact_event_logs
where origin_to_address = lower('0xC874b064f465bdD6411D45734b56fac750Cda29A')
group by 2),
stkr as (
select 'stkr' as platform,
origin_from_address,
count (distinct tx_hash) TX_Count
from ethereum.core.fact_event_logs
where origin_to_address = lower('0x84db6eE82b7Cf3b47E8F19270abdE5718B936670')
group by 2),
Cream as (
select 'Cream' as platform,
origin_from_address,
count (distinct tx_hash) TX_Count
from ethereum.core.fact_event_logs
where origin_to_address in ('0xcbc1065255cbc3ab41a6868c22d1f1c573ab89fd')
group by 2),
Rocketpool as (
select 'RocketPool' as platform,
origin_from_address,
count (distinct tx_hash) TX_Count
from ethereum.core.fact_event_logs
where origin_to_address = lower('0x4D05E3d48a938db4b7a9A59A802D5b45011BDe58')
and event_name = 'Transfer'
group by 2),
lido as (
select 'Lido' as platform,
origin_from_address,
Run a query to Download Data