from avalanche.core.fact_traces

where to_address = '0x8927985b358692815e18f2138964679dca5d3b79')

,

chikn_seller as ( select date, a.tx_hash, buyer, to_address as seller, sales_amount

from chikn a join avalanche.core.fact_traces b on a.tx_hash = b.tx_hash

where from_address = '0x8927985b358692815e18f2138964679dca5d3b79'

and to_address != '0x5a52b8035c755f81bc516c910e642781e2c10a55'

and avax_value != 0)

,

chikn_fee as ( select date,'Chikn' as nft, a.tx_hash, buyer, seller, sales_amount, avax_value as platform_fee

from chikn_seller a join avalanche.core.fact_traces b on a.tx_hash = b.tx_hash

where to_address = '0x5a52b8035c755f81bc516c910e642781e2c10a55')

,

Roostr as ( select date(block_timestamp) as date, tx_hash, from_address as buyer, avax_value as sales_amount

from avalanche.core.fact_traces

where to_address = '0xcf91b99548b1c17dd1095c0680e20de380635e20')

,

Roostr_seller as ( select date, a.tx_hash, buyer, to_address as seller, sales_amount

from Roostr a join avalanche.core.fact_traces b on a.tx_hash = b.tx_hash

where from_address = '0xcf91b99548b1c17dd1095c0680e20de380635e20'

and to_address != '0x5a52b8035c755f81bc516c910e642781e2c10a55'

and avax_value != 0)

,

Roostr_fee as ( select date,'Roostr' as nft, a.tx_hash, buyer, seller, sales_amount, avax_value as platform_fee

from Roostr_seller a join avalanche.core.fact_traces b on a.tx_hash = b.tx_hash

where to_address = '0x5a52b8035c755f81bc516c910e642781e2c10a55')

,

FarmLand as ( select date(block_timestamp) as date, tx_hash, from_address as buyer, avax_value as sales_amount

from avalanche.core.fact_traces

where to_address = '0x00f5d01d86008d14d04e29efe88dffc75a9cac47')

,

FarmLand_seller as ( select date, a.tx_hash, buyer, to_address as seller, sales_amount

from FarmLand a join avalanche.core.fact_traces b on a.tx_hash = b.tx_hash

where from_address = '0x00f5d01d86008d14d04e29efe88dffc75a9cac47'

and to_address != '0x5a52b8035c755f81bc516c910e642781e2c10a55'