purifBeradrome testnet v2 - Daily activity
Updated 2024-12-13
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 Beradrome testnet - Daily activity @ https://flipsidecrypto.xyz/studio/queries/c272e375-1496-4a48-a9d1-7eb7da5dec18
with buys as (
select day, count(tx_hash) as count_b from (
select date_trunc('day',block_timestamp) as day, tx_hash
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')
group by 1),
sells as (
select day, count(tx_hash) as count_s from (
select date_trunc('day',block_timestamp) as day,tx_hash
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')
group by 1
),
exercise as (
select day, count(tx_hash) as count_exercise from (
select date_trunc('day',block_timestamp) as day,tx_hash
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')
group by 1
),
redeem as (
select day, count(tx_hash) as count_redeem from (
select date_trunc('day',block_timestamp) as day,tx_hash
from berachain.testnet.fact_event_logs
where contract_address=lower('0xB5A27c33bA2ADEcee8CdBE94cEF5576E2F364A8f')
QueryRunArchived: QueryRun has been archived