adambalaUntitled Query
Updated 2022-10-18
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
›
⌄
with
main as (
select
ORIGIN_FROM_ADDRESS as claimer ,
RAW_AMOUNT/pow(10,18) as volume ,
BLOCK_TIMESTAMP ,
TX_HASH
from optimism.core.fact_token_transfers
where
ORIGIN_TO_ADDRESS ='0xfedfaf1a10335448b7fa0268f56d2b44dbd357de' and
CONTRACT_ADDRESS = '0x9029fdfae9a03135846381c7ce16595c3554e10a' and
FROM_ADDRESS ='0xfedfaf1a10335448b7fa0268f56d2b44dbd357de' and
ORIGIN_FUNCTION_SIGNATURE ='0x2e7ba6ef'
)
select
BLOCK_TIMESTAMP::date as date ,
count(distinct TX_HASH) as trxs ,
count(distinct claimer) as claimers ,
sum(volume) as OP
from main
group by 1
Run a query to Download Data