with list1 as (
select date_trunc('day', block_timestamp) as date, (sum(SWAP_TO_AMOUNT) / sum(SWAP_FROM_AMOUNT)) as price from solana.core.fact_swaps
where swap_to_mint = 'EPjFWdd5AufqSSqeM2qN1xzybapC8G4wEGGkZwyTDt1v'
and swap_from_mint = 'AURYydfxJib1ZkTir1Jn1J9ECYUtjb6rKQVmtYaixWPP'
and date >= current_date - 10
and succeeded = 1
group by date
),
list2 as (
select date_trunc('day', block_timestamp) as date, count(distinct(tx_id)) as nft_volume from solana.core.fact_transactions
where succeeded = 1
and block_timestamp::date >= current_date - 10
and inner_instructions[0]:instructions[1]:parsed:info:destination = 'aury7LJUae7a92PBo35vVbP61GX8VbyxFKausvUtBrt'
and date >= current_date - 10
group by date
)
select list1.date, nft_volume, price from list1
join list2 on list1.date = list2.date
order by date