SELECT

DATE_TRUNC('day', BLOCK_TIMESTAMP) AS date,

COUNT(*) AS total_txns,

SUM((gas_used * gas_unit_price) / 1e8) AS total_gas_on_txns_usd

FROM

aptos.core.fact_transactions

WHERE

SENDER = '{{wallet_address}}'

GROUP BY

DATE_TRUNC('day', BLOCK_TIMESTAMP)

),

nft_sales AS (

SELECT

DATE_TRUNC('day', BLOCK_TIMESTAMP) AS date,

COUNT(*) AS number_of_nft_sales,

SUM(TOTAL_PRICE_USD) AS total_nft_sales_usd

FROM

aptos.nft.ez_nft_sales

WHERE

SELLER_ADDRESS = '{{wallet_address}}'

GROUP BY

DATE_TRUNC('day', BLOCK_TIMESTAMP)

),

highest_sale AS (

SELECT

DATE_TRUNC('day', BLOCK_TIMESTAMP) AS date,

(PROJECT_NAME) AS highest_sale_project,

MAX(TOTAL_PRICE_USD) AS highest_sale_value

FROM

aptos.nft.ez_nft_sales

WHERE

SELLER_ADDRESS = '{{wallet_address}}'

GROUP BY

DATE_TRUNC('day', BLOCK_TIMESTAMP), PROJECT_NAME

ORDER BY