CONTRACT_TYPE | TRANSACTION | ADDRESS | |
|---|---|---|---|
1 | Token | 18923 | 669 |
2 | DEFI & DEX | 13319 | 331 |
3 | Unknown | 12395 | 659 |
4 | Bridge | 654 | 197 |
5 | NFT | 432 | 16 |
6 | Rewards | 353 | 30 |
hessTotal Transactions
Updated 2025-03-14
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 layer_base as (select block_timestamp::Date as date,
tx_hash,
contract_address as token_address,
'0x' || substr(TOPIC_1,27) as null_address,
'0x' || substr(TOPIC_2,27) as user_address,
case when contract_address = '0xf1815bd50389c46847f0bda824ec8da914045d14' then 'USDC'
when token_address = '0x2f6f07cdcf3588944bf4c42ac74ff24bf56e7590' then 'WETH'
when token_address = '0x2aabea2058b5ac2d339b163c6ab6f2b6d53aabed' then 'USDF'
when token_address = '0x674843c06ff83502ddb4d37c2e09c01cda38cbc8' then 'USDT'
when token_address = '0xfa0e06b54986ad96de87a8c56fea76fbd8d493f8' then 'USDF'
when token_address = '0xea3910f1c6e687b59835885904a2fd1944b51ec6' then 'TRUMP' end as token_name,
event_index,
TOPICS,
livequery.utils.udf_hex_to_int(DATA) as amount_raw,
case when contract_address = '0xf1815bd50389c46847f0bda824ec8da914045d14' then amount_raw/pow(10,6)
when token_address = '0x2f6f07cdcf3588944bf4c42ac74ff24bf56e7590' then amount_raw/pow(10,18)
when token_address = '0x2aabea2058b5ac2d339b163c6ab6f2b6d53aabed' then amount_raw/pow(10,6)
when token_address = '0x674843c06ff83502ddb4d37c2e09c01cda38cbc8' then amount_raw/pow(10,6)
when token_address = '0xfa0e06b54986ad96de87a8c56fea76fbd8d493f8' then amount_raw/pow(10,6)
when token_address = '0xea3910f1c6e687b59835885904a2fd1944b51ec6' then amount_raw/pow(10,18) end as amount
from flow.core_evm.fact_event_logs
where origin_to_address = '0xa20db4ffe74a31d17fc24bd32a7dd7555441058e'
and topic_0 = '0xddf252ad1be2c89b69c2b068fc378daa952ba7f163c4a11628f55a4df523b3ef'
having null_address = '0x0000000000000000000000000000000000000000')
,
price as ( select hour::Date as date,
case when symbol = 'WETH' then '0x2f6f07cdcf3588944bf4c42ac74ff24bf56e7590' else '0xea3910f1c6e687b59835885904a2fd1944b51ec6' end as tok_address,
avg(price) as avg_price
from crosschain.price.ez_prices_hourly
where token_address in ('0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2','6p6xgHyF7AeE6TZkSmFsko444wqoP15icUSqi2jfGiPN')
group by 1,2)
,
final as ( select a.date,
a.tx_hash,
user_address,
token_name,
Last run: about 2 months ago
6
121B
12s