select

block_id,

block_timestamp,

tx_id,

trader,

from_currency as token,

pool_ids,

(to_amount - from_amount) * pow(10,-from_decimal) as profit

from osmosis.defi.fact_swaps

where block_timestamp > '2021-06-20'

--and block_timestamp < '2022-01-01'

and tx_succeeded

and from_currency = to_currency

and to_amount > from_amount

and pool_ids[2] is not null

),

price_infos as(

select

price,

symbol,

recorded_at

from osmosis.price.dim_prices

where recorded_at > '2021-06-20'

and provider = 'coin market cap'

),

token_infos as (

select

address,

project_name,

label