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