adriaparcerisasmemes activity 2
Updated 2023-05-01
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 memes AS (
SELECT
trunc(block_timestamp,'day')as day, count(distinct tx_hash) as tx,
count(distinct from_address) AS wallet_address,
SUM(AMOUNT_USD) AS volume
FROM ethereum.core.ez_token_transfers
WHERE (
contract_address = lower('0x1A963Df363D01EEBB2816b366d61C917F20e1EbE')
or contract_address=lower('0x2718fEDFc22CC6d727932c8424993218B0AcB859')
or contract_address=lower('0x2F573070E6090b3264Fe707e2C9F201716F123c7')
or contract_address=lower('0x6982508145454ce325ddbe47a25d4ec3d2311933')
)
--and from_address != origin_from_address and to_address = origin_from_address --and EVENT_TYPE = 'erc20_transfer'
and amount_usd>0 and amount_usd<1e6
GROUP BY 1
),
nomemes as (
SELECT
trunc(block_timestamp,'day')as day, count(distinct tx_hash) as tx,
count(distinct from_address) AS wallet_address,
SUM(AMOUNT_USD) AS volume
FROM ethereum.core.ez_token_transfers
WHERE (
contract_address <> lower('0x1A963Df363D01EEBB2816b366d61C917F20e1EbE')
and contract_address<>lower('0x2718fEDFc22CC6d727932c8424993218B0AcB859')
and contract_address<>lower('0x2F573070E6090b3264Fe707e2C9F201716F123c7')
and contract_address<>lower('0x6982508145454ce325ddbe47a25d4ec3d2311933')
)
--and from_address != origin_from_address and to_address = origin_from_address --and EVENT_TYPE = 'erc20_transfer'
and amount_usd>0 and amount_usd<1e6
GROUP BY 1
),
wallet_flows as (
SELECT
'Meme tokens' as type,* from memes
Run a query to Download Data