Lordking987..
Updated 2022-11-03
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
a as (
select
ORIGIN_FROM_ADDRESS as user ,
RAW_AMOUNT/pow(10,18) as volume ,
BLOCK_TIMESTAMP as date ,
TX_HASH
from bsc.core.fact_token_transfers
where
ORIGIN_TO_ADDRESS ='0x3c11e74d8996508c62f1ee0dd2e07a5b1ec36edb'
and
CONTRACT_ADDRESS = '0x9029fdfae9a03135846381c7ce16595c3554e10a'
and
ORIGIN_FUNCTION_SIGNATURE ='0x2e7ba6ef'
--tx_hash ='0x006945588f5892e65c113a35aaa80941cae142394cc6e21d76db8ea7329e8326'
)
select
EVENT_NAME ,
count (distinct a.tx_hash )
from a
inner join bsc.core.fact_event_logs as l
on user = ORIGIN_FROM_ADDRESS
where l.BLOCK_TIMESTAMP > a.date
and EVENT_NAME is not null
group by 1
-- What did Users do after Claiming
Run a query to Download Data