SELECT

-24 * 1 AS date_range,

1000 AS lmt, -- Limit

5 AS roo -- Remove Outliers Offset (Percent)

), universe AS (

SELECT FROM_ADDRESS AS ADDRESS, BLOCK_TIMESTAMP

FROM base.core.fact_transactions

), contracts AS (

SELECT ADDRESS, CREATED_BLOCK_TIMESTAMP

FROM base.core.dim_contracts

WHERE CREATED_BLOCK_TIMESTAMP >= DATEADD(

HOUR, (SELECT date_range FROM variables), CURRENT_DATE()

)

), accounts AS (

SELECT DISTINCT(t1.address)

FROM universe t1

LEFT JOIN contracts t2 ON t2.address = t1.address

WHERE t2.address IS NULL

AND t1.BLOCK_TIMESTAMP >= DATEADD(

HOUR, (SELECT date_range FROM variables), CURRENT_DATE()

)

), raw_data AS (

SELECT ADDRESS

FROM accounts

QUALIFY ROW_NUMBER() OVER (ORDER BY RANDOM()) <= (SELECT lmt FROM variables)

), Q AS (

SELECT t1.address AS address, t2.TX_FEE AS q

FROM raw_data t1

LEFT JOIN base.core.fact_transactions t2 ON t2.FROM_ADDRESS = t1.address

WHERE t2.BLOCK_TIMESTAMP >= DATEADD(

HOUR, (SELECT date_range FROM variables), CURRENT_DATE()

)

), raw AS (

SELECT

address,