adriaparcerisasmemes activity 3
Updated 2023-05-01
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
›
⌄
WITH memes AS (
SELECT
distinct tx_hash
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
),
nomemes as (
SELECT
distinct tx_hash
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
),
wallet_flows as (
SELECT
'Meme tokens' as type,* from memes
union
SELECT
'No Meme tokens' as type,* from nomemes
)
,
Run a query to Download Data