Monitize AIPirate Airdrop 1 copy
Updated 2024-10-22
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
›
⌄
⌄
-- forked from Pirate Airdrop 1 @ https://flipsidecrypto.xyz/studio/queries/c76c20df-bf8e-4ceb-9ba2-d885387a34e8
-- forked from Pirate 1 copy copy @ https://flipsidecrypto.xyz/studio/queries/7d2a09df-bc30-4e2b-bee1-50930a1dd8e2
select
--date_trunc('day', BLOCK_TIMESTAMP) as dates,
distinct FROM_ADDRESS,
to_address,
ORIGIN_FUNCTION_SIGNATURE,
BLOCK_TIMESTAMP,
amount,
amount_usd
from ethereum.core.ez_token_transfers
where contract_address = lower('0xc555D625828c4527d477e595fF1Dd5801B4a600e')
--and FROM_ADDRESS = lower('0x543ba3e063197b3025a4b2751e9b4b6a2489fa07')
--and ORIGIN_FUNCTION_SIGNATURE = '0x2e7ba6ef'
order by BLOCK_TIMESTAMP ASC
limit 5000
-- 0xf3decd8880528a55d9f279f19a4626de77b1e245 as Liquidity
-- 0xff3733f2b5b42f0bf145561a2ceb12a15b8b781c as Community
/*where "from" = 0x554b49f1595e579ab0841e7a09a4a5654ab73578
and contract_address = 0xAcd2c239012D17BEB128B0944D49015104113650*/
QueryRunArchived: QueryRun has been archived