-- forked from Yousefi_1994 / Aurora Contract - Daily User Interacted @ https://flipsidecrypto.xyz/Yousefi_1994/q/2023-04-24-08-51-pm-UXWD-_

fix_parameter as (

select

case

when '{{Days}}' = 'Last 30 Days' then 30

when '{{Days}}' = 'Last 60 Days' then 60

when '{{Days}}' = 'Last 90 Days' then 90

when '{{Days}}' = 'Last 180 Days' then 180

when '{{Days}}' = 'Last 365 Days' then 365

when '{{Days}}' = 'All Time' then 2000

else 30

end as time_frame

),

near_contract_address as (

select distinct

address

from

near.core.dim_address_labels

),

user_interacted_with_aurora_transactions as (

select

tx_hash,

block_timestamp,

tx_signer,

transaction_fee * pow(10, -24) as fee

from

near.core.fact_transactions

where

tx_status = 'Success'

and tx_receiver in ('aurora')

and tx_signer not in ('aurora')

and tx_signer not ilike '%.aurora'

and tx_signer not in (