bertaBot Swappers
Updated 2022-05-04
99
1
2
3
4
5
6
7
8
9
10
›
⌄
with all_swapper as (select date(block_timestamp) as day, trader, count(tx_id) as number_of_transaction,
iff( number_of_transaction > 400, 'bot_swapper', 'normal_swapper') as type_of_swapper
from terra.swaps
where block_timestamp >= '2022-03-26' and block_timestamp <= '2022-04-26'
group by 1,2)
select date(block_timestamp) as day, trader as bot_swapper, count(tx_id) as number_of_transaction_by_bot
from terra.swaps where block_timestamp >= '2022-03-26' and block_timestamp <= '2022-04-26' and
bot_swapper in (select trader from all_swapper where type_of_swapper = 'bot_swapper')
group by 1,2
Run a query to Download Data