saeedmznBridge via blocto - total
Updated 2024-11-30
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
›
⌄
with bridge_txns as (
select BLOCK_TIMESTAMP::date date ,
tx_id TX_HASH,
SOURCE_ADDRESS SENDER,
DESTINATION_ADDRESS RECEIVER,
SOURCE_CHAIN SOURCE_CHAIN_NAME,
DESTINATION_CHAIN DESTINATION_CHAIN_NAME,
TOKEN_ADDRESS,
AMOUNT_USD,
AMOUNT,
iff(SOURCE_CHAIN='flow','outbound','inbound') direction
from flow.defi.ez_bridge_activity
where platform ='blocto'
-- and BLOCK_TIMESTAMP ::date >= '2023-01-01'
),
prices as (
select date_trunc(day,HOUR)::date date ,
TOKEN_ADDRESS ,
SYMBOL,
avg(PRICE) USD
from flow.price.ez_prices_hourly
-- where HOUR::date >= '2024-01-01'
group by 1 ,2,3
UNION
select date_trunc(day,HOUR)::Date date ,
'A.ead892083b3e2c6c.DapperUtilityCoin' TOKEN_ADDRESS ,
SYMBOL,
avg(PRICE) USD
from flow.price.ez_prices_hourly
-- where HOUR::date >= '2024-01-01'
where TOKEN_ADDRESS ='A.b19436aae4d94622.FiatToken'
group by 1 ,2,3
UNION
select date_trunc(day,HOUR)::date date ,
'A.ead892083b3e2c6c.FlowUtilityToken' TOKEN_ADDRESS ,
SYMBOL,
QueryRunArchived: QueryRun has been archived