elvisHop 6/19 Q1: Bridge Users.1.4.3 : ETH&Poly Cumulative User growth
Updated 2022-06-21
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
›
⌄
--How many unique users have bridged to L2s using Hop?
WITH USDT_L2_sends_from_ETH AS (
SELECT block_timestamp, origin_from_address AS user_address, event_inputs:amount/1e6 AS amount, 'USDT' as currency, event_inputs:chainId AS dest_chainId, event_inputs:recipient AS dest_address,
'ETH' AS origin_chain, origin_function_signature, tx_hash
FROM ethereum.core.fact_event_logs
WHERE contract_address = lower('0x3E4a3a4796d16c0Cd582C382691998f7c06420B6')
AND event_name = 'TransferSentToL2'
AND tx_status = 'SUCCESS'
),
USDC_L2_sends_from_ETH AS (
SELECT block_timestamp, origin_from_address AS user_address, event_inputs:amount/1e6 AS amount, 'USDC' as currency, event_inputs:chainId AS dest_chainId, event_inputs:recipient AS dest_address,
'ETH' AS origin_chain, origin_function_signature, tx_hash
FROM ethereum.core.fact_event_logs
WHERE contract_address = lower('0x3666f603Cc164936C1b87e207F36BEBa4AC5f18a')
AND event_name = 'TransferSentToL2'
AND tx_status = 'SUCCESS'
),
MATIC_L2_sends_from_ETH AS (
SELECT block_timestamp, origin_from_address AS user_address, event_inputs:amount/1e18 AS amount, 'MATIC' as currency, event_inputs:chainId AS dest_chainId, event_inputs:recipient AS dest_address,
'ETH' AS origin_chain, origin_function_signature, tx_hash
FROM ethereum.core.fact_event_logs
WHERE contract_address = lower('0x22B1Cbb8D98a01a3B71D034BB899775A76Eb1cc2')
AND event_name = 'TransferSentToL2'
AND tx_status = 'SUCCESS'
),
DAI_L2_sends_from_ETH AS (
SELECT block_timestamp, origin_from_address AS user_address, event_inputs:amount/1e18 AS amount, 'DAI' as currency, event_inputs:chainId AS dest_chainId, event_inputs:recipient AS dest_address,
'ETH' AS origin_chain, origin_function_signature, tx_hash
FROM ethereum.core.fact_event_logs
WHERE contract_address = lower('0x3d4Cc8A61c7528Fd86C55cfe061a78dCBA48EDd1')
AND event_name = 'TransferSentToL2'
AND tx_status = 'SUCCESS'
),
ETH_L2_sends_from_ETH AS (
SELECT block_timestamp, origin_from_address AS user_address, event_inputs:amount/1e18 AS amount, 'WETH' as currency, event_inputs:chainId AS dest_chainId, event_inputs:recipient AS dest_address,
'ETH' AS origin_chain, origin_function_signature, tx_hash
Run a query to Download Data