MahrooUntitled Query
Updated 2022-09-14
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
›
⌄
WITH bridge_to_near_or_aurora as (
SELECT
*
FROM (
SELECT
*
from ethereum.core.fact_transactions as transactions
INNER JOIN
(SELECT
tx_hash as tx_hash_t,
contract_address,
amount_usd,
raw_amount
FROM ethereum.core.ez_token_transfers
) as transfers
ON transactions.tx_hash=transfers.tx_hash_t
WHERE (from_address = '0x23ddd3e3692d1861ed57ede224608875809e127f'
OR to_address = '0x23ddd3e3692d1861ed57ede224608875809e127f')
AND SUBSTRING(INPUT_DATA,0,10) = '0x4a00c629'
)
)
select
COUNT(DISTINCT TX_HASH) as number_transactions,
COUNT(DISTINCT from_address) as unique_users,
SUM(amount_usd) as usd_volume
FROM bridge_to_near_or_aurora
-- SELECT * FROM ethereum.core.ez_token_transfers WHERE tx_hash = '0xf4c0682856c2088a3765d9ae5f0f5919a4544d09bf39eb2f062fc25ce325304e'
Run a query to Download Data