saeedmznNot Your Keys -
Updated 2022-11-18
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
›
⌄
-- Credit: https://app.flipsidecrypto.com/velocity/queries/bb56d191-232c-421b-99ff-93e4d1311ce1 **Jack The Guy**
with transactions as (
select tx_id,
ATTRIBUTE_VALUE chain
from axelar.core.fact_msg_attributes
where ATTRIBUTE_KEY = 'destinationChain'
and block_timestamp::date >= CURRENT_DATE - 30
),
users as (
select ATTRIBUTE_VALUE user,
tx_id
from axelar.core.fact_msg_attributes
where tx_id in (select tx_id from transactions)
and ATTRIBUTE_KEY = 'spender'
group by 1 ,2
),
ALL_ as (
select user,
block_timestamp daily,
tx_id,
chain,
ATTRIBUTE_VALUE
from axelar.core.fact_msg_attributes t1 join transactions using (tx_id)
join users using (tx_id)
where MSG_TYPE = 'coin_spent'
and ATTRIBUTE_INDEX = 1
group by 1,2 ,3,4,5
),
labels as (
select daily,
ATTRIBUTE_VALUE,
tx_id,
user,
chain,
case when attribute_value like '%uaxl%' then 'AXL'
Run a query to Download Data