backtest_dummyBNKR Txs
Updated 2025-01-11
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
›
⌄
with buys as (select
*
from base.defi.ez_dex_swaps
-- where contract_address = lower('0x22aF33FE49fD1Fa80c7149773dDe5890D3c76F3b')
where token_in = lower('0x22aF33FE49fD1Fa80c7149773dDe5890D3c76F3b')
-- or token_out = lower('0x22aF33FE49fD1Fa80c7149773dDe5890D3c76F3b')
)
select
origin_to_address
, sum(amount_in) as tokens_bought
, sum(amount_in_usd) as bought_in_usd
, count(origin_to_address) as no_txs
from buys
group by origin_to_address
-- having no_txs < 50
order by tokens_bought desc
QueryRunArchived: QueryRun has been archived