DAY | SYMBOL | VOLUME | |
|---|---|---|---|
1 | 2024-01-29 00:00:00.000 | DCK | 2750.97 |
2 | 2024-01-29 00:00:00.000 | WAGIEBOT | 3355.45 |
3 | 2024-01-29 00:00:00.000 | AIMBOT | 27764.11 |
4 | 2024-01-29 00:00:00.000 | LOOT | 45438.09 |
5 | 2024-01-29 00:00:00.000 | PAAL | 176648.25 |
6 | 2024-01-29 00:00:00.000 | BANANA | 348612.16 |
7 | 2024-01-29 00:00:00.000 | UNIBOT | 865995.15 |
8 | 2024-01-22 00:00:00.000 | WAGIEBOT | 28904.77 |
9 | 2024-01-22 00:00:00.000 | AIMBOT | 279190.52 |
10 | 2024-01-22 00:00:00.000 | LOOT | 311839.87 |
11 | 2024-01-22 00:00:00.000 | DCK | 1466749.3 |
12 | 2024-01-22 00:00:00.000 | PAAL | 2819142.13 |
13 | 2024-01-22 00:00:00.000 | BANANA | 5993623.13 |
14 | 2024-01-22 00:00:00.000 | UNIBOT | 10572144.95 |
15 | 2024-01-15 00:00:00.000 | WAGIEBOT | 17690.18 |
16 | 2024-01-15 00:00:00.000 | LOOT | 126762.11 |
17 | 2024-01-15 00:00:00.000 | AIMBOT | 541668.38 |
18 | 2024-01-15 00:00:00.000 | DCK | 834691.61 |
19 | 2024-01-15 00:00:00.000 | PAAL | 3032048.19 |
20 | 2024-01-15 00:00:00.000 | BANANA | 5810716.21 |
tkvresearchTelegram Bots I Dex
Updated 2024-01-29
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
28
29
30
31
32
33
34
›
⌄
with
L AS ( select * from (VALUES
( '🤖 Trading bot' , 'UniBot' , 'UNIBOT' , '0xf819d9cb1c2a819fd991781a822de3ca8607c3c9'),
( '🤖 Trading bot' , 'Banana Gun' , 'BANANA' , '0x38e68a37e401f7271568cecaac63c6b1e19130b4'),
( '🤖 Trading bot' , 'DexCheck' , 'DCK' , '0x16faf9daa401aa42506af503aa3d80b871c467a3'),
( '🤖 Trading bot' , 'LootBot' , 'LOOT' , '0xb478c6245e3d85d6ec3486b62ea872128d562541'),
( '🤖 Trading bot' , 'WagieBot' , 'WAGIEBOT' , '0xd2c869382c7ac9f87ff73548d029d67c0f9dee31'),
( '🤖 Trading bot' , 'AimBot' , 'AIMBOT' , '0x0c48250eb1f29491f1efbeec0261eb556f0973c7'),
( '🤖 Trading bot' , 'PAAL AI' , 'PAAL' , '0x14fee680690900ba0cccfc76ad70fd1b95d10e16')
) as l1(tag, name, symbol, contract) ),
-- DEX
A as( select AMOUNT_IN_USD as value, TOKEN_IN as contract, BLOCK_TIMESTAMP from ethereum.defi.ez_dex_swaps union all
select AMOUNT_OUT_USD as value, TOKEN_OUT as contract, BLOCK_TIMESTAMP from ethereum.defi.ez_dex_swaps union all
select AMOUNT_IN_USD as value, TOKEN_IN as contract, BLOCK_TIMESTAMP from bsc.defi.ez_dex_swaps union all
select AMOUNT_OUT_USD as value, TOKEN_OUT as contract, BLOCK_TIMESTAMP from bsc.defi.ez_dex_swaps ),
B as( select date_trunc('week',BLOCK_TIMESTAMP) as day, d.symbol, sum(value) as volume
from A as a
join L as d on a.contract = d.contract
group by 1,2)
-- all
select *
from B
order by day desc, volume
Last run: about 1 year agoAuto-refreshes every 24 hours
...
199
9KB
22s