382 rows yesterday at 12:49 PM
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
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
select
'Coinbase' as chart_z,
date_trunc('week', timestamp) as chart_x,
sum(token_unit_amount(chain_name, chain_network_name, '0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48',input_2_value_uint256)) as chart_y
from
evm_events_ethereum_mainnet
where
timestamp >= '2021-05-01'
and address = '0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48' -- USDC token Address
and signature = 'Transfer(address,address,uint256)'
and input_1_value_address in (
'0x71660c4005BA85c37ccec55d0C4493E66Fe775d3', -- Coinbase 1
'0x503828976D22510aad0201ac7EC88293211D23Da', -- Coinbase 2
'0xddfAbCdc4D8FfC6d5beaf154f18B778f892A0740', -- Coinbase 3
'0x3cD751E6b0078Be393132286c442345e5DC49699', -- Coinbase 4
'0xb5d85CBf7cB3EE0D56b3bB207D5Fc4B82f43F511', -- Coinbase 5
'0xeB2629a2734e272Bcc07BDA959863f316F4bD4Cf', -- Coinbase 6
'0x02466E547BFDAb679fC49e96bBfc62B9747D997C', -- Coinbase 8
'0xA9D1e08C7793af67e9d92fe308d5697FB81d3E43', -- Coinbase 10
'0x77696bb39917C91A0c3908D577d5e322095425cA', -- Coinbase 11
'0x7c195D981AbFdC3DDecd2ca0Fed0958430488e34', -- Coinbase 12
'0x95A9bd206aE52C4BA8EecFc93d18EACDd41C88CC', -- Coinbase 13
'0xb739D0895772DBB71A89A3754A160269068f0D45' -- Coinbase 14
)
group by
chart_x
order by
chart_x asc
UNION ALL
select
'Binance' as chart_z,
date_trunc('week', timestamp) as chart_x,
sum(token_unit_amount(chain_name, chain_network_name, '0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48',input_2_value_uint256)) as chart_y
from
evm_events_ethereum_mainnet
where
timestamp >= '2021-05-01'
and address = '0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48' -- USDC token Address
and signature = 'Transfer(address,address,uint256)'
and input_1_value_address in (
'0x3f5CE5FBFe3E9af3971dD833D26bA9b5C936f0bE', -- Binance
'0xD551234Ae421e3BCBA99A0Da6d736074f22192FF', -- Binance 2
'0x564286362092D8e7936f0549571a803B203aAceD', -- Binance 3
'0x0681d8Db095565FE8A346fA0277bFfdE9C0eDBBF', -- Binance 4
'0xfE9e8709d3215310075d67E3ed32A380CCf451C8', -- Binance 5
'0x4E9ce36E442e55EcD9025B9a6E0D88485d628A67', -- Binance 6
'0xBE0eB53F46cd790Cd13851d5EFf43D12404d33E8', -- Binance 7
'0xF977814e90dA44bFA03b6295A0616a897441aceC', -- Binance 8
'0x001866Ae5B3de6cAa5a51543FD9fB64f524F5478', -- Binance 9
'0x85b931A32a0725Be14285B66f1a22178c672d69B', -- Binance 10
'0x708396f17127c42383E3b9014072679b2F60B82f', -- Binance 11
'0xE0F0CfDe7Ee664943906f17F7f14342E76A5CeC7', -- Binance 12
'0x8f22f2063d253846b53609231ed80fa571bc0c8f', -- Binance 13
'0x28C6c06298d514Db089934071355E5743bf21d60', -- Binance 14
'0x21a31Ee1afC51d94C2eFcCAa2092aD1028285549', -- Binance 15
'0xDFd5293D8e347dFe59E90eFd55b2956a1343963d' -- Binance 16
)
group by
chart_x
order by
chart_x asc