amelia-leeUntitled Query
Updated 2022-08-01
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
›
⌄
with
transactions as
(
select
origin_from_address,
block_timestamp
from ethereum.core.fact_event_logs
where origin_to_address in ('0x401f6c983ea34274ec46f84d70b31c151321188b','0xa0c68c638235ee32657e8f720a23cec1bfc77c77')
and tx_status='SUCCESS'
)
select
address_name,
--project_name,
--label_type,
--label_subtype,
count(distinct tx_hash) as counts
from polygon.core.fact_event_logs x
join transactions y on x.origin_from_address=y.origin_from_address
join polygon.core.dim_labels z on x.contract_address=z.address
and trunc(x.block_timestamp,'day')=trunc(y.block_timestamp,'day') and x.block_timestamp > y.block_timestamp
group by 1
order by 2 desc
limit 10
--adriaparcerisas
Run a query to Download Data