purifDapp users shares
Updated 2024-11-26
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
›
⌄
with buys as (
select concat('0x',substr(TOPICS[1], 27,64)) as user, count(distinct tx_hash) as txs
from berachain.testnet.fact_event_logs
where contract_address=lower('0xB5A27c33bA2ADEcee8CdBE94cEF5576E2F364A8f')
and origin_to_address=lower('0xB5A27c33bA2ADEcee8CdBE94cEF5576E2F364A8f')
and ORIGIN_FUNCTION_SIGNATURE='0xba002b70'
and TOPICS[0]='0x3590f0a355392f9c1de13cd72ea564d10019bb3605905ea543b424a360b9a88e'
--and block_timestamp <= timestamp '2024-09-25 16:20'
group by 1
)
,
sells as (
select concat('0x',substr(TOPICS[1], 27,64)) as user, count(distinct tx_hash) as txs
from berachain.testnet.fact_event_logs
where contract_address=lower('0xB5A27c33bA2ADEcee8CdBE94cEF5576E2F364A8f')
and origin_to_address=lower('0xB5A27c33bA2ADEcee8CdBE94cEF5576E2F364A8f')
and ORIGIN_FUNCTION_SIGNATURE='0x26124288'
and TOPICS[0]='0xffc36e4a73526964b1bc25e2a44a90e979636de95ea6e59e01b6b83f2e20ae1e'
--and block_timestamp <= timestamp '2024-09-25 16:20'
group by 1
),
exercise as (
select concat('0x',substr(TOPICS[1], 27,64)) as user, count(distinct tx_hash) as txs
from berachain.testnet.fact_event_logs
where contract_address=lower('0xB5A27c33bA2ADEcee8CdBE94cEF5576E2F364A8f')
and origin_to_address=lower('0xB5A27c33bA2ADEcee8CdBE94cEF5576E2F364A8f')
and ORIGIN_FUNCTION_SIGNATURE='0x1b6b7298'
and TOPICS[0]='0x199b105faa55cbba66c6c51adb78bf93238b4ad0cfadd14c986af220da77e7c8'
--and block_timestamp <= timestamp '2024-09-25 16:20'
group by 1
),
redeem as (
select concat('0x',substr(TOPICS[1], 27,64)) as user, count(distinct tx_hash) as txs
from berachain.testnet.fact_event_logs
where contract_address=lower('0xB5A27c33bA2ADEcee8CdBE94cEF5576E2F364A8f')
and origin_to_address=lower('0xB5A27c33bA2ADEcee8CdBE94cEF5576E2F364A8f')
QueryRunArchived: QueryRun has been archived