-- Query 1

SELECT date_trunc('day', block_timestamp::date) AS dt,

tx_hash, decoded_log:to::string AS event_to,

decoded_log:from::string AS event_from, decoded_log:tokenId::string AS token_id, 'genkongz' AS category

FROM ethereum.core.fact_decoded_event_logs

WHERE block_timestamp > '2021-04-15 19:56:00.000'

AND contract_address = lower('0x57a204aa1042f6e66dd7730813f4024114d74f37')

AND event_name = 'Transfer'

UNION ALL

-- Query 2

SELECT date_trunc('day', block_timestamp::date) AS dt,

tx_hash, decoded_log:to::string AS event_to,

decoded_log:from::string AS event_from, decoded_log:tokenId::string AS token_id, 'genkai' AS category

FROM ethereum.core.fact_decoded_event_logs

WHERE block_timestamp > '2023-07-15 19:56:00.000'

AND contract_address = lower('0x1F7c16FCe4fC894143aFB5545Bf04f676bf7DCf3')

AND event_name = 'Transfer'

UNION ALL

-- Query 3

SELECT date_trunc('day', block_timestamp::date) AS dt,

tx_hash, decoded_log:to::string AS event_to,

decoded_log:from::string AS event_from, decoded_log:tokenId::string AS token_id, 'vxkongz' AS category

FROM ethereum.core.fact_decoded_event_logs

WHERE block_timestamp > '2021-08-05'

AND contract_address = lower('0x7EA3Cca10668B8346aeC0bf1844A49e995527c8B')

AND event_name = 'Transfer'

),

transfers AS (

-- Same definition as in the individual queries

SELECT

event_to AS wallet,