SYMBOL | TXS | TRADERS | VOLUME_USD | SUPPLY | HOLDERS | MC | TOKEN_ADDRESS | SWAPS_7D | SWAPS_24H | VOLUME_7D | VOLUME_24H | TRADERS_7D | |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | OGC | 20747 | 474 | 29404.70018161 | 100000000 | 110 | 54166.741794393 | 0xccf37622e6b72352e7b410481dd4913563038b7c | 0 | 0 | 0 | 0 | 0 |
2 | DDD | 17417 | 695 | 40674.987458546 | 100000000 | 870 | 62319.496567782 | 0x4bf82cf0d6b2afc87367052b793097153c859d38 | 0 | 0 | 0 | 0 | 0 |
3 | DHG | 11548 | 496 | 16644.579333227 | 100000000 | 141 | 28299.336467703 | 0x75c0a194cd8b4f01d5ed58be5b7c5b61a9c69d0a | 0 | 0 | 0 | 0 | 0 |
4 | LGP | 9910 | 401 | 11098.450365529 | 100000000 | 110 | 27315.277684964 | 0xddc330761761751e005333208889bfe36c6e6760 | 0 | 0 | 0 | 0 | 0 |
5 | BTN | 9907 | 330 | 11086.99112888 | 100000000 | 2603 | 40137.097837959 | 0xd7c584d40216576f1d8651eab8bef9de69497666 | 0 | 0 | 0 | 0 | 0 |
6 | EGP | 8092 | 371 | 14390.674114116 | 100000000 | 839 | 23046.166268165 | 0x64f6f111e9fdb753877f17f399b759de97379170 | 0 | 0 | 0 | 0 | 0 |
7 | PKT | 7469 | 297 | 10458.598578438 | 100000000 | 131 | 46626.392379043 | 0x8a088dceecbcf457762eb7c66f78fff27dc0c04a | 0 | 0 | 0 | 0 | 0 |
8 | IGS | 6744 | 253 | 9692.744162493 | 100000000 | 224 | 32556.63755895 | 0xe302672798d12e7f68c783db2c2d5e6b48ccf3ce | 0 | 0 | 0 | 0 | 0 |
9 | LANTERN | 5201 | 217 | 3289.08438414 | 365 | 75 | 35764.048208206 | 0x8e87497ec9fd80fc102b33837035f76cf17c3020 | 0 | 0 | 0 | 0 | 0 |
10 | PEAR | 3671 | 447 | 35294.285511041 | 1000000000 | 598 | 33035.068949932 | 0xc760a77356563560260c9e571af6dbbab396be38 | 0 | 0 | 0 | 0 | 0 |
11 | SOLAR | 2324 | 181 | 1633.005538214 | 100000000 | 169 | 62559.829000556 | 0x1772a283501b108c0f0016224518ff38db72de2f | 0 | 0 | 0 | 0 | 0 |
12 | STONEY | 1671 | 377 | 13880.501736884 | 1000000000 | 208 | 4711.407002365 | 0x1917f5c4d5ed06383b43e47f1e59ed1f3cb57074 | 0 | 0 | 0 | 0 | 0 |
13 | GONE | 1274 | 365 | 15730.531407658 | 69342069410 | 22790 | 229534.168090454 | 0x162539172b53e9a93b7d98fb6c41682de558a320 | 0 | 0 | 0 | 0 | 0 |
14 | EARTH | 1051 | 116 | 487.152368394 | 3046.294 | 176 | 0x9f9f149a02cddc9a8251207cefd3ff774daf56f6 | 0 | 0 | 0 | 0 | 0 | |
15 | KC | 1006 | 86 | 4454.087291087 | 982226226.877759 | 5830 | 71463.753124922 | 0x784665471bb8b945b57a76a9200b109ee214e789 | 0 | 0 | 0 | 0 | 0 |
16 | NEUS | 495 | 79 | 3751.512494912 | 1000000000 | 84 | 3812.261009259 | 0x1d9ccbe51cc6b4deeeca686d409561cf9f801fbc | 0 | 0 | 0 | 0 | 0 |
17 | VOCATE | 405 | 72 | 3637.7304912 | 1000000000 | 89 | 6273.06607113 | 0x560d5b84d081b3a91e1cea3a9713473303124730 | 0 | 0 | 0 | 0 | 0 |
18 | WORDS | 396 | 70 | 2645.42018584 | 1000000000 | 74 | 9098.684330246 | 0xa76164b3d0a2f35b140ec57f1552f7d6987e06db | 0 | 0 | 0 | 0 | 0 |
19 | KIRANA | 377 | 59 | 991.050343284 | 1000000000 | 84 | 3413.776432092 | 0xfec68cbf04f7c069628cf9e9c609abc95f9a476b | 0 | 0 | 0 | 0 | 0 |
20 | NOMAD | 282 | 57 | 1151.011087275 | 1000000000 | 72 | 0 | 0xd7b0c417365b63f098c1c4ad2ced35982d648876 | 0 | 0 | 0 | 0 | 0 |
MoDeFiGPC - tokens trades
Updated 2 hours ago
999
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
35
36
›
⌄
with tokens_data as (
select *
from $query('75f58bb3-b2cd-4208-85e9-e3d75d901a1c')
),
tokens_supply as (
select *
from $query('d113b02b-ad6c-4fc4-8bfb-df28c696d7da')
),
polygon_txs as (
select BLOCK_TIMESTAMP, TX_HASH, ORIGIN_FUNCTION_SIGNATURE, ORIGIN_FROM_ADDRESS, ORIGIN_TO_ADDRESS, CONTRACT_ADDRESS , FROM_ADDRESS, TO_ADDRESS,
RAW_AMOUNT_PRECISE, AMOUNT, AMOUNT_USD, b.*
from polygon.core.ez_token_transfers a
left join tokens_data b
on contract=CONTRACT_ADDRESS
where BLOCK_TIMESTAMP::date>='2025-01-27'
union all
select BLOCK_TIMESTAMP, TX_HASH, ORIGIN_FUNCTION_SIGNATURE, ORIGIN_FROM_ADDRESS, ORIGIN_TO_ADDRESS, '' as CONTRACT_ADDRESS , FROM_ADDRESS, TO_ADDRESS,
AMOUNT_PRECISE_RAW, AMOUNT, AMOUNT_USD, '', 'POL', 0, '', ''
from polygon.core.ez_native_transfers
where BLOCK_TIMESTAMP::date>='2025-01-27'),
polygon_undetected_swaps_raw as
(select a.BLOCK_TIMESTAMP, a.TX_HASH, a.ORIGIN_FUNCTION_SIGNATURE, a.ORIGIN_FROM_ADDRESS, a.ORIGIN_TO_ADDRESS,
b.RAW_AMOUNT_PRECISE as AMOUNT_IN_UNADJ, b.AMOUNT as AMOUNT_IN, b.AMOUNT_USD as AMOUNT_IN_USD,
a.RAW_AMOUNT_PRECISE as AMOUNT_OUT_UNADJ, a.AMOUNT as AMOUNT_OUT, a.AMOUNT_USD as AMOUNT_OUT_USD, 'Other' as PLATFORM,
b.CONTRACT_ADDRESS as TOKEN_IN, a.CONTRACT_ADDRESS as TOKEN_OUT, b.SYMBOL as SYMBOL_IN, a.SYMBOL as SYMBOL_OUT
from polygon_txs a
join polygon_txs b
on a.TX_HASH=b.TX_HASH and a.ORIGIN_FROM_ADDRESS=a.FROM_ADDRESS and a.ORIGIN_FROM_ADDRESS=b.TO_ADDRESS
where TOKEN_OUT!=TOKEN_IN
and (TOKEN_IN in (select contract from tokens_data) or TOKEN_OUT in (select contract from tokens_data))
and a.tx_hash not in (select tx_hash from polygon.defi.ez_dex_swaps)),
polygon_dexs_swaps as (
Last run: about 2 hours agoAuto-refreshes every 1 hour
39
4KB
114s