Eman-RazCLIM OVER TIME
Updated 2024-09-08
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 arbitrum as (SELECT date_trunc('hour',block_timestamp) as "Date", count(distinct to_address) as "Claimer Count",
count(distinct tx_hash) as "Claim Count", sum(amount) as "Claim Volume(NEXT)", 'Arbitrum' as "Chain"
FROM arbitrum.core.ez_token_transfers
WHERE contract_address =lower('0x58b9cB810A68a7f3e1E4f8Cb45D1B9B3c79705E8')
AND from_address='0xe6b7ab9ebcfbf1a72e489ff00cdf9c6473ff6224'
AND to_address!='0xee9dec2712cce65174b561151701bf54b99c24c8'
and block_timestamp::date>='2023-09-05'
group by 1
order by 1),
optimism as (SELECT date_trunc('hour',block_timestamp) as "Date", count(distinct to_address) as "Claimer Count",
count(distinct tx_hash) as "Claim Count", sum(amount) as "Claim Volume(NEXT)", 'Optimism' as "Chain"
FROM optimism.core.ez_token_transfers
where contract_address ='0x58b9cb810a68a7f3e1e4f8cb45d1b9b3c79705e8'
AND from_address='0x8f7492de823025b4cfaab1d34c58963f2af5deda'
and origin_to_address='0x01051113d81d7d6da508462f2ad6d7fd96cf42ef'
and ORIGIN_FUNCTION_SIGNATURE='0x4522589f'
and to_address!='0xade09131c6f43fe22c2cbabb759636c43cfc181e'
and block_timestamp::date>='2023-09-05'
group by 1
order by 1),
polygon as (SELECT date_trunc('hour',block_timestamp) as "Date", count(distinct to_address) as "Claimer Count",
count(distinct tx_hash) as "Claim Count", sum(amount) as "Claim Volume(NEXT)", 'Polygon' as "Chain"
FROM polygon.core.ez_token_transfers
where contract_address ='0x58b9cb810a68a7f3e1e4f8cb45d1b9b3c79705e8'--
AND from_address='0x11984dc4465481512eb5b777e44061c158cf2259' --
and origin_to_address='0x7598e84b2e114ab62cab288ce5f7d5f6bad35bba'--
and ORIGIN_FUNCTION_SIGNATURE='0x4522589f'
and to_address!='0xade09131c6f43fe22c2cbabb759636c43cfc181e'
and block_timestamp::date>='2023-09-05'
group by 1
order by 1),
gnosis as (SELECT date_trunc('hour',block_timestamp) as "Date", count(distinct to_address) as "Claimer Count",
count(distinct tx_hash) as "Claim Count", sum(amount) as "Claim Volume(NEXT)", 'Gnosis' as "Chain"
Auto-refreshes every 3 hours
QueryRunArchived: QueryRun has been archived