Sbhn_NPDaily Number of Transactions Divided by Action
Updated 2023-01-15
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 stake as ( select staking_action_type as status,
date_trunc('day',block_timestamp) as date,
tx_hash,
origin_from_address as wallet
from optimism.velodrome.ez_staking_actions
where date >= '2022-12-15')
,
nft as ( select 'NFT' as status,
date_trunc('day',block_timestamp) as date,
tx_hash,
origin_from_address as wallet
from optimism.core.ez_nft_sales
where date >= '2022-12-15')
,
liquidity as ( select lp_action as status,
date_trunc('day',block_timestamp) as date,
tx_hash,
sender_address as wallet
from optimism.velodrome.ez_lp_actions
where date >= '2022-12-15')
,
transfer as ( select 'Transfer' as status,
date_trunc('day',block_timestamp) as date,
tx_hash,
origin_from_address as wallet
from optimism.core.fact_token_transfers
where date >= '2022-12-15')
,
swap as ( select 'Swap' as status,
date_trunc('day',a.block_timestamp) as date,
a.tx_hash,
a.origin_from_address as wallet
from optimism.velodrome.ez_swaps a
full join optimism.sushi.ez_swaps b
on a.block_timestamp=b.block_timestamp
where date >= '2022-12-15')
Run a query to Download Data