campin and out 5
Updated 2022-11-01Copy Reference Fork
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
›
⌄
-- -- Inflows and Outflows
-- Pay by Quality Your score determines your final payout.
-- Grand Prize 75 USDC (A score of 11 or 12 earns you a Grand Prize title)
-- Payout 50 USDC
-- Score Multiplier 0-7 : 0% 8 : 50% 9 : 75% 10 : 100% 11 : 125% 12 : 150%
-- Payout Network Ethereum
-- Level Beginner
-- Difficulty Medium
-- What is the volume of ETH and three stablecoins of your choice that's moved between the Optimism
-- network and the Ethereum network across the bridge?
-- How has that changed over time? Note any interesting trends or outliers that you see.
-- BONUS: Post your dashboard on Twitter and tag @flipsidecrypto and any relevant accounts!
with txns as (
select
iff(origin_to_address = '0x25ace71c97b33cc4729cf772ae268934f7ab5fa1', 'OP-->ETH', 'ETH-->OP') as flow,
symbol,
concat(flow,' (',symbol, ')') as type,
block_timestamp,
tx_hash,
amount_usd,
origin_from_address
from ethereum.core.ez_token_transfers
where origin_to_address in (
'0x25ace71c97b33cc4729cf772ae268934f7ab5fa1' -- Optimism --> ETH
,'0x99c9fc46f92e8a1c0dec1b1747d010903e884be1' -- ETH --> Optimism
)
and block_timestamp < CURRENT_DATE
and symbol in ('USDC','DAI','USDT')
)
select
date_trunc('week',block_timestamp) as date,
flow,
type,
Run a query to Download Data