maybeyonasmetamask_interact_contract_daily
Updated 2022-06-24
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
metamask_users as (
select
distinct from_address as user
from ethereum.core.fact_transactions
where to_address = '0x881d40237659c251811cec9c364ef91dc08d300c'
),
meta_txs as (
select
block_timestamp,
tx_hash,
to_address,
from_address
from ethereum.core.fact_transactions
where from_address in (
select user from metamask_users
)
),
interactions as (
select
date(block_timestamp) as date,
to_address as contract,
case contract
when '0x7a250d5630b4cf539739df2c5dacb4c659f2488d' then 'uniswap v2'
when '0x7be8076f4ea4a4ad08075c2508e481d6c946d12b' then 'opensea'
when '0xdac17f958d2ee523a2206206994597c13d831ec7' then 'usdt'
when '0x881d40237659c251811cec9c364ef91dc08d300c' then 'metamask'
when '0x7f268357a8c2552623316e2562d90e642bb538e5' then 'opensea'
when '0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2' then 'weth'
when '0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48' then 'usdc'
when '0x68b3465833fb72a70ecdf485e0e4c7bd8665fc45' then 'uniswap v3'
when '0xe592427a0aece92de3edee1f18e0157c05861564' then 'uniswap v3'
when '0xfbddadd80fe7bda00b901fbaf73803f2238ae655' then 'strongblock'
when '0xd9e1ce17f2641f24ae83637ab66a2cca9c378b9f' then 'uniswap v2'
when '0x283af0b28c62c092c9727f1ee09c02ca627eb7f5' then 'ens'
when '0x7d1afa7b718fb893db30a3abc0cfc608aacfebb0' then 'matic'
Run a query to Download Data