maybeyonasrari_usdc_today
Updated 2022-05-21
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
›
⌄
with
rari_fuse_pools as (
select
distinct contract_address
from ethereum.events_emitted
where event_name = 'NewFuseFee'
)
select
user_address,
balance
from ethereum.erc20_balances
where user_address in (select contract_address from rari_fuse_pools)
and balance_date = current_date
and symbol = 'USDC'
-- select
-- contract_address,
-- count(distinct tx_id) as txs
-- from ethereum.events_emitted
-- -- where tx_id = '0xf2b98cfb0f0457cd7a6d2aa46652fc69ba804628b619fc211e13df78bd9b9b05'
-- where event_name = 'NewFuseFee'
-- -- and contract_address = '0x53de5a7b03dc24ff5d25ccf7ad337a0425dfd8d1'
-- group by 1
-- order by txs desc
-- limit 100
Run a query to Download Data