SELECT

COUNT(*) AS TotalNativeTransfers,

SUM(VALUE) AS TotalNativeAmountTransferred

FROM ethereum.core.fact_transactions

WHERE BLOCK_TIMESTAMP >= DATEADD(day, -30, CURRENT_DATE) AND STATUS = 'SUCCESS'

AND VALUE > 0

SELECT

TotalNativeTransfers,

TotalNativeAmountTransferred

FROM NativeTransfersTotal;