mrwildcatsushi masterchef v1
Updated 2023-03-08
9
1
2
3
4
5
6
7
8
›
⌄
select date_trunc( 'day', block_timestamp ) as date,
sum(RAW_AMOUNT/pow(10,18)) as SUSHI_AMOUNT
FROM ethereum.core.fact_token_transfers
WHERE origin_function_signature = '0x441a3e70'
AND origin_to_address = '0xc2edad668740f1aa35e4d8f227fb8e17dca888cd' -- Sushi MasterChef V1
AND contract_address = '0x6b3595068778dd592e39a122f4f5a5cf09c90fe2' -- Sushi Token COntract
and block_timestamp::date >= '2022-08-01'
GROUP BY 1
Run a query to Download Data