binhachon1. Daily bETH Volume: Volume bridge from Terra to Ethereum
Updated 2021-10-07
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 BRIDGE_FROM_LIDO AS(
SELECT BLOCK_TIMESTAMP, TX_ID, ORIGIN_ADDRESS AS ADDRESS, AMOUNT FROM ethereum.udm_events
WHERE ORIGIN_FUNCTION_SIGNATURE = '0x9e63798d' -- Send from LIDO using submit function
AND TO_ADDRESS = '0xf9dcf31ee6eb94ab732a43c2fba1dc6179c98965' -- bETH Shuttle Vault
AND CONTRACT_ADDRESS = '0x707f9118e33a9b8998bea41dd0d46f38bb963fc8' -- bETH contract
),
BRIDGE_FROM_TERRA_BRIDGE AS (
SELECT BLOCK_TIMESTAMP, TX_ID, ORIGIN_ADDRESS AS ADDRESS, AMOUNT FROM ethereum.udm_events
WHERE ORIGIN_FUNCTION_SIGNATURE = '0xbcf64e05' -- Burn function
AND TO_ADDRESS = '0xf9dcf31ee6eb94ab732a43c2fba1dc6179c98965' -- bETH Shuttle Vault
AND CONTRACT_ADDRESS = '0x707f9118e33a9b8998bea41dd0d46f38bb963fc8' -- bETH contract
),
BRIDGE_FROM_TERRA_SIDE AS (
SELECT BLOCK_TIMESTAMP, TX_ID, TO_ADDRESS AS ADDRESS, AMOUNT FROM ethereum.udm_events
WHERE ORIGIN_FUNCTION_SIGNATURE = '0xedeb09c7' -- Mint function
AND FROM_ADDRESS = '0xf9dcf31ee6eb94ab732a43c2fba1dc6179c98965' -- bETH Shuttle Vault
AND CONTRACT_ADDRESS = '0x707f9118e33a9b8998bea41dd0d46f38bb963fc8' -- bETH contract
),
TOTAL_BRIDGE_TO_TERRA AS(
SELECT 'LIDO_TO_TERRA' AS SYMBOL, DATE_TRUNC('Day', BLOCK_TIMESTAMP) AS BLOCKTIME, ADDRESS, AMOUNT FROM BRIDGE_FROM_LIDO
UNION ALL
SELECT 'TERRA_BRIDGE_TO_TERRA' AS SYMBOL, DATE_TRUNC('Day', BLOCK_TIMESTAMP) AS BLOCKTIME, ADDRESS, AMOUNT FROM BRIDGE_FROM_TERRA_BRIDGE
),
TOTAL_BRIDGE_TO_ETH AS(
SELECT 'TO_ETHEREUM' AS SYMBOL, DATE_TRUNC('Day', BLOCK_TIMESTAMP) AS BLOCKTIME, ADDRESS, AMOUNT FROM BRIDGE_FROM_TERRA_SIDE
),
TOTAL_BRIDGE AS(
SELECT SYMBOL, BLOCKTIME, SUM(AMOUNT) AS AMOUNT FROM TOTAL_BRIDGE_TO_TERRA
GROUP BY SYMBOL, BLOCKTIME
UNION ALL SELECT SYMBOL, BLOCKTIME, SUM(AMOUNT) AS AMOUNT FROM TOTAL_BRIDGE_TO_ETH
GROUP BY SYMBOL, BLOCKTIME
ORDER BY BLOCKTIME DESC, AMOUNT -- Final table
Run a query to Download Data