ArashhNEAR 15 maga
Updated 2023-01-03
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
›
⌄
--SQL credits to abbasian34-8158 GP winner NEAR meta analysis
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,
symbol
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'
AND block_timestamp::date >= CURRENT_DATE - 30
)
)
select
DATE_TRUNC('day',block_timestamp) as date,
COUNT(DISTINCT TX_HASH) as number_transactions,
COUNT(DISTINCT FROM_ADDRESS) as unique_users,
SUM(amount_usd) as usd_volume,
symbol,
CASE WHEN date >= '2022-11-07' THEN 'After'
WHEN date < '2022-11-07' THEN 'Before' END AS range
FROM bridge_to_near_or_aurora
WHERE block_timestamp::date >= CURRENT_DATE - 30
GROUP BY date, symbol
Run a query to Download Data