select * from ethereum.core.dim_contracts where address = '0xf76e2d2bba0292cf88f71934aff52ea54baa64d9'

WITH Lil_Nouns_logs AS(

SELECT T1._LOG_ID, T1.BLOCK_NUMBER, T1.BLOCK_TIMESTAMP, T1.TX_HASH,

T1.ORIGIN_FUNCTION_SIGNATURE, T1.ORIGIN_FROM_ADDRESS, T1.ORIGIN_TO_ADDRESS, T1.EVENT_INDEX, T1.CONTRACT_ADDRESS,

T1.EVENT_INPUTS:proposalId::string AS proposalId,

--T1.EVENT_INPUTS:reason::string AS reason,

T1.EVENT_INPUTS:support::string AS support,

T1.EVENT_INPUTS:voter::string AS voter,

T1.EVENT_INPUTS:votes::string AS votes

FROM ethereum.core.fact_event_logs T1

WHERE T1.TX_STATUS = 'SUCCESS'

AND T1.EVENT_REMOVED = 'false'

AND T1.EVENT_NAME = 'VoteCast'

AND T1.block_number = 14887882

AND T1.tx_hash = '0x783d64b2146de10f7545e1053a6fa58d2846ee78fb5dc30ed635182ac5313e9b'

SELECT *

FROM Lil_Nouns_logs t1

JOIN ethereum.core.fact_transactions tx on tx.TX_HASH = T1.TX_HASH

LIMIT 50

select PLATFORM from ethereum.core.ez_dex_swaps GROUP by PLATFORM

select * from ethereum.core.fact_event_logs where ORIGIN_TO_ADDRESS = lower('0x881d40237659c251811cec9c364ef91dc08d300c')

limit 1

select * from ethereum.core.ez_dex_swaps where ORIGIN_FROM_ADDRESS= '0x2559ef946f459f1842b513adcb62e1668edcc61d'