OneDataAnalystInflow Sushi Treasury
Updated 2022-06-29
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
›
⌄
SELECT DATE_TRUNC('day',BLOCK_TIMESTAMP) AS Date, SYMBOL, SUM(AMOUNT_USD) AS Amount, SUM(amount) AS Token_Amount,
CASE
WHEN FROM_ADDRESS = '0x0000000000000000000000000000000000000000' THEN 'Null Address'
WHEN FROM_ADDRESS = '0xf73b31c07e3f8ea8f7c59ac58ed1f878708c8a76' THEN 'SushiSwap: Dev Fund'
WHEN FROM_ADDRESS = '0xcbe6b83e77cdc011cc18f6f0df8444e5783ed982' THEN 'SushiSwap: Merkle Distributor'
WHEN FROM_ADDRESS = '0xc2edad668740f1aa35e4d8f227fb8e17dca888cd' THEN 'SushiSwap: MasterChef LP Staking Pool'
WHEN FROM_ADDRESS = '0x19b3eb3af5d93b77a5619b047de0eed7115a19e7' THEN 'SushiSwap: Operation Multisig'
WHEN FROM_ADDRESS = '0x8b4334d4812c530574bd4f2763fcd22de94a969b' THEN 'Tokemak: Treasury Address'
ELSE FROM_ADDRESS
END AS FROM_ADDRESS
FROM ethereum.core.ez_token_transfers
WHERE TO_ADDRESS = LOWER('0xe94b5eec1fa96ceecbd33ef5baa8d00e4493f4f3')
AND SYMBOL IN ('SUSHI','USDC','TOKE')
GROUP BY 1,2,5
Run a query to Download Data