samUntitled Query
Updated 2022-08-01
99
1
2
3
4
5
6
7
8
9
10
11
12
13
›
⌄
select BLOCK_TIMESTAMP::date as date,count(distinct TX_HASH),
case
when CONTRACT_ADDRESS='0xcf4d2994088a8cde52fb584fe29608b63ec063b2' then 'celer'
when CONTRACT_ADDRESS='0x0e0e3d2c5c292161999474247956ef542cabf8dd' then 'hop usdc'
when CONTRACT_ADDRESS='0x3749c4f034022c39ecaffaba182555d4508caccc' then 'hop eth'
when CONTRACT_ADDRESS='0x72209fe68386b37a40d6bca04f78356fd342491f' then 'hop usdt'
when CONTRACT_ADDRESS='0x3749c4f034022c39ecaffaba182555d4508caccc' then 'hop eth'
when CONTRACT_ADDRESS =lower('0xaBBc5F99639c9B6bCb58544ddf04EFA6802F4064') then 'gmx'
when CONTRACT_ADDRESS='0xcf4d2994088a8cde52fb584fe29608b63ec063b2' then 'connext'
when CONTRACT_ADDRESS='0x13ab946c6a9645edff2a33880e0fc37f67122170' then 'yield' end as protocols
from arbitrum.core.fact_event_logs
where protocols is not null
group by 1,3
Run a query to Download Data