select * from ethereum.core.fact_decoded_event_logs where block_timestamp > '2023-10-12' and block_timestamp < '2023-12-11 17:48:23.000' and contract_address = lower('0x00000000000000ADc04C56Bf30aC9d3c0aAF14dC') and event_name = 'OrderValidated' ; select * from ethereum.core.fact_blocks limit 10; select * from ethereum.core.fact_transactions where tx_type = 3 limit 10; select * from ethereum.core.fact_decoded_event_logs where block_timestamp > '2023-11-01' and block_timestamp < '2023-12-01' and contract_address = lower('0x9af316bf28406868c1e8fcf6ec04311108358f9e') and event_name = 'Deposit' -- and transaction_hash = '0x9e973e84b71f43d33151f4a17324196227adcb7e2dd257af75638610eb50f5b5' limit 10; select event_name, count(1) from ethereum.core.fact_decoded_event_logs where contract_address = lower('0x00000000000000adc04c56bf30ac9d3c0aaf14dc') and block_timestamp > '2023-10-12' and block_timestamp < '2023-12-11 20:01:35.000' group by event_name limit 10; -- 64511036 select count(*) from ethereum.core.dim_contracts ; select * from ethereum.core.dim_contracts where contract_metadata = ; -- Find transactions with the highest usd value select tx_hash, sum(usd) from ( select tx_hash, sum(amount_usd) usd from polygon.core.ez_native_transfers where block_timestamp >= '2024-02-20' and block_timestamp < '2024-02-28' and amount > 0 group by tx_hash union all select tx_hash, sum(amount_usd) usd from polygon.core.ez_token_transfers where block_timestamp >= '2024-02-20' and block_timestamp < '2024-02-28' and amount > 0 group by tx_hash ) group by tx_hash order by sum(usd) desc nulls last limit 10 ; -- Search by specific transaction select * from ( select tx_hash, tx_position, amount_usd from polygon.core.ez_native_transfers where block_timestamp >= '2024-02-20' and block_timestamp < '2024-02-28' and amount > 0 and tx_hash = '0xc20c4824fb3ef5b0e40a16a3c5ededbb376b5b6034ef2e6fb518adf727692657' union all select tx_hash, event_index, amount_usd from polygon.core.ez_token_transfers where block_timestamp >= '2024-02-20' and block_timestamp < '2024-02-28' and amount > 0 and tx_hash = '0xc20c4824fb3ef5b0e40a16a3c5ededbb376b5b6034ef2e6fb518adf727692657' ) ; select count(distinct address) from ( select DISTINCT from_address address from polygon.core.ez_native_transfers where block_timestamp >= '2024-03-12' and block_timestamp < '2024-03-20' -- and amount > 0 union select DISTINCT to_address address from polygon.core.ez_native_transfers where block_timestamp >= '2024-03-12' and block_timestamp < '2024-03-20' -- and amount > 0 union select DISTINCT from_address address from polygon.core.ez_token_transfers where block_timestamp >= '2024-03-12' and block_timestamp < '2024-03-20' -- and amount > 0 union select DISTINCT to_address address from polygon.core.ez_token_transfers where block_timestamp >= '2024-03-12' and block_timestamp < '2024-03-20' -- and amount > 0 ) ; select * from near.core.fact_blocks where block_id = 115170650 ; select count(distinct(tx_hash)) from ethereum.core.ez_token_transfers where block_timestamp >= '2024-03-28' and block_timestamp < '2024-04-03' ; select sum(count) from ( select count(*) count from ethereum.core.ez_native_transfers where block_timestamp >= '2024-03-28' and block_timestamp < '2024-04-03' -- and amount > 0 union select count(*) count from ethereum.core.ez_token_transfers where block_timestamp >= '2024-03-28' and block_timestamp < '2024-04-03' -- and amount > 0 ) ; select sum(usd) from ( select sum(amount_usd) usd from ethereum.core.ez_native_transfers where block_timestamp >= '2024-03-28' and block_timestamp < '2024-04-03' and amount > 0 union select sum(amount_usd) usd from ethereum.core.ez_token_transfers where block_timestamp >= '2024-03-28' and block_timestamp < '2024-04-03' and amount > 0 ) ; -- select count(*) -- from ethereum.core.fact_decoded_traces -- where block_number between 19592971 and 19662125 -- and to_address = lower('0x3dfd23A6c5E8BbcFc9581d2E864a68feb6a076d3') -- ; select * from polygon.core.fact_decoded_traces where block_number between 55490533 and 55858389 and to_address = lower('0x3dfd23A6c5E8BbcFc9581d2E864a68feb6a076d3') ; -- select distinct function_name -- from ethereum.core.fact_decoded_traces -- where block_number between 19592971 and 19662125 -- and to_address = lower('0x87870Bca3F3fD6335C3F4ce8392D69350B4fA4E2') -- ; -- select function_name, count(*) -- from ethereum.core.fact_decoded_traces -- where block_number between 19592971 and 19662125 -- and to_address = lower('0x87870Bca3F3fD6335C3F4ce8392D69350B4fA4E2') -- group by function_name -- order by count(*) -- ; -- select * -- from ethereum.core.fact_decoded_traces -- where block_number between 19592971 and 19662125 -- and to_address = lower('0x87870Bca3F3fD6335C3F4ce8392D69350B4fA4E2') -- and function_name = 'getReservesCount' -- ; select DISTINCT(function_name) from ethereum.core.fact_decoded_traces where block_number between 19592971 and 19662125 and to_address = lower('0x87870Bca3F3fD6335C3F4ce8392D69350B4fA4E2') and lower(function_name) not in ( lower('withdraw'), lower('supplyWithPermit'), lower('getReserveAddressById'), lower('setUserEMode'), lower('setReserveInterestRateStrategyAddress'), lower('liquidationCall'), lower('getUserAccountData'), lower('setUserUseReserveAsCollateral'), lower('finalizeTransfer'), lower('supply'), lower('getUserEMode'), lower('repayWithPermit'), lower('borrow'), lower('flashLoanSimple'), lower('getReserveNormalizedVariableDebt'), lower('deposit'), lower('resetIsolationModeTotalDebt'), lower('FLASHLOAN_PREMIUM_TOTAL'), lower('getReserveNormalizedIncome'), lower('MAX_STABLE_RATE_BORROW_SIZE_PERCENT'), lower('setConfiguration'), lower('getUserConfiguration'), lower('ADDRESSES_PROVIDER'), lower('repay'), lower('flashLoan'), lower('getEModeCategoryData'), lower('repayWithATokens'), lower('mintToTreasury'), lower('getReserveData'), lower('getConfiguration'), lower('initReserve') ) ; select * from ethereum.core.fact_decoded_event_logs limit 10; select * from ethereum.core.fact_decoded_traces limit 10; select count(*) from ethereum.core.ez_decoded_event_logs where block_number between 11356700 and 19741281 ; select * from ethereum.core.ez_current_balances limit 10; select * from ethereum.core.ez_snapshot limit 10;

Query	Creator	Created
2023-11-30 02:19 PM	loganbon	Nov 30, 2023
Getting Started	loganbon	Nov 30, 2023
2023-12-08 10:14 AM ethereum evm	loganbon	Dec 8, 2023

loganbon