ally arbitrum supply retention final copy
Updated 2023-03-20
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
›
⌄
-- forked from 51ff097b-fa8f-4795-9952-a27b74d09226
-- forked from 21fe6edd-a630-4e44-8115-d1f5d88f497d
-- forked from cc615954-5f31-4776-9330-cc12ba946556
-- forked from a7156281-99ea-4adf-8b70-92b82f236596
-- forked from 4161d707-4d84-4c83-bf75-ebf25311e922
-- forked from b1694198-bc1d-4e38-93f4-7f3bd8690220
with
nft_transfers as (
select
BLOCK_TIMESTAMP,
tx_hash,
ORIGIN_TO_ADDRESS as router_addrs,
ORIGIN_FROM_ADDRESS as user
from
arbitrum.core.fact_event_logs
where
BLOCK_TIMESTAMP >= CURRENT_TIMESTAMP() - INTERVAL '13 months'
and EVENT_NAME = 'Supply'
),
gas_fees as (
select
tx_hash,
BLOCK_TIMESTAMP,
TX_FEE as fees
from
arbitrum.core.fact_transactions
WHERE
BLOCK_TIMESTAMP >= CURRENT_TIMESTAMP() - INTERVAL '13 months'
group by
1,
Run a query to Download Data