hessShare of Activities copy
Updated 2023-04-20
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 price as ( select recorded_hour::date as date, symbol , avg(price) as avg_price
from osmosis.core.ez_prices
group by 1,2)
,
platform as ( select DISTINCT sender
from axelar.core.ez_satellite
UNION
select DISTINCT sender
from axelar.core.ez_squid)
,
labels as ( select 'Axelar' as chain,address, label, label_type
from axelar.core.dim_labels
UNION
select 'Osmosis' as chain, label,address, label_type
from osmosis.core.dim_labels
UNION
select 'Terra' as chain,address, label, label_type
from terra.core.dim_address_labels
UNION
select BLOCKCHAIN as chain,address, project_name as label, label_type
from crosschain.core.address_labels)
,
transaction as ( select date(block_timestamp) as date, tx_hash, origin_from_address, origin_to_address
from arbitrum.core.fact_token_transfers
where block_timestamp::date >= current_date - 180
and origin_from_address in (select sender from platform)
UNION
select date(block_timestamp) as date, tx_hash, origin_from_address, origin_to_address
from ethereum.core.fact_token_transfers
where block_timestamp::date >= current_date - 180
and origin_from_address in (select sender from platform)
UNION
select date(block_timestamp) as date, tx_hash, origin_from_address, origin_to_address
from avalanche.core.fact_token_transfers
where block_timestamp::date >= current_date - 180
and origin_from_address in (select sender from platform)
Run a query to Download Data