adambalaTop 10 profitable Tokens With Most Earned ETH for theirs traders
Updated 2022-09-04
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
35
36
›
⌄
WITH
a as
(select
bb.BLOCK_TIMESTAMP,
bb.TX_HASH,
bb.ORIGIN_FROM_ADDRESS as buyer , bb.EVENT_INPUTS:from as seller ,
bb.EVENT_INPUTS:tokenId as token_id,
bb.CONTRACT_ADDRESS ,
aa.RAW_AMOUNT / pow(10,18) as volume
from
arbitrum.core.fact_event_logs as bb inner join arbitrum.core.fact_token_transfers as aa
on bb.ORIGIN_TO_ADDRESS = aa.TO_ADDRESS and aa.tx_hash=bb.tx_hash
where aa.FROM_ADDRESS='0x0000000000000000000000000000000000000000'
and EVENT_NAME ='Transfer'
and TX_STATUS='SUCCESS'
and BUYER !=SELLER and bb.ORIGIN_TO_ADDRESS=lower('0x7bc8b1b5aba4df3be9f9a32dae501214dc0e4f3f') and TOKEN_ID is not null
order by 1 desc ),
b as
(select
bb.BLOCK_TIMESTAMP,
bb.TX_HASH,
bb.EVENT_INPUTS:from as seller , bb.ORIGIN_FROM_ADDRESS as buyer ,
bb.EVENT_INPUTS:tokenId as token_id,
bb.CONTRACT_ADDRESS ,
aa.RAW_AMOUNT / pow(10,18) as volume
from
arbitrum.core.fact_event_logs as bb inner join arbitrum.core.fact_token_transfers as aa
on bb.ORIGIN_TO_ADDRESS = aa.TO_ADDRESS and aa.tx_hash=bb.tx_hash
where aa.FROM_ADDRESS='0x0000000000000000000000000000000000000000'
and EVENT_NAME ='Transfer'
Run a query to Download Data