Monitize AI$PIRATE Claimers Sell Stats (with 2nd and 3rd) copy
Updated 2024-07-14
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 $PIRATE Claimers Sell Stats (with 2nd and 3rd) @ https://flipsidecrypto.xyz/edit/queries/3aabd943-db61-4e35-80f3-772217292145
-- forked from $PIRATE Claimers Sell Stats with 2nd and 3rd @ https://flipsidecrypto.xyz/edit/queries/107ff597-5ca6-49ac-afe6-c4f04e706020
with claimert as (
select
distinct to_ADDRESS as claimer,
Block_timestamp as claim_date,
amount as Claimed_Amount
from ethereum.core.ez_token_transfers
where contract_address = lower('0x7613c48e0cd50e42dd9bf0f6c235063145f6f8dc')
and FROM_ADDRESS = lower('0x543ba3e063197b3025a4b2751e9b4b6a2489fa07')
),
balancet as (
SELECT
user_address as user,
current_bal as balance
from ethereum.core.ez_current_balances
join claimert on USER_ADDRESS = claimer
where contract_address = '0x7613c48e0cd50e42dd9bf0f6c235063145f6f8dc'
order by 2 desc
),
stakert as (
select
distinct DECODED_LOG:"user"::text as staker,
TX_HASH as stake_tx,
BLOCK_TIMESTAMP as stake_date,
DECODED_LOG:"amount"::int/1e18 as stake_amount
from ethereum.core.ez_decoded_event_logs
where contract_address = lower('0x6759aCD57cB5EA451a3eDF397734eDDDFc123049')
and Block_timestamp > '2024-06-01'
and DECODED_LOG:"user"::text in (select claimer from claimert)
and topics[0] in ('0x90890809c654f11d6e72a28fa60149770a0d11ec6c92319d6ceb2bb0a4ea1a15','0xf279e6a1f5e320cca91135676d9cb6e44ca8a08c0b88342bcdb1144f6511b568')
),
QueryRunArchived: QueryRun has been archived