dannerBadger Creators
Updated 2023-01-15
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
›
⌄
with creators as
(
select
distinct origin_from_address as user,
count(tx_hash) as amount
from
polygon.core.fact_event_logs
where block_timestamp::date > '2022-10-16'::date
and contract_Address = lower('0x218b3c623ffb9c5e4dbb9142e6ca6f6559f1c2d6')
and origin_function_signature = '0x7b366213'
group by 1
)
-- , operator_balances as
-- (
-- select
-- )
select
*
from
creators
Run a query to Download Data