flipside

    Untitled Query
    ramishoowUntitled Query
    Updated 2022-12-15
    with Ramishow as (select FLOOR((sum(volume_received) over (order by time))) as "received volume in", floor((sum(volume_sent) over (order by time))) as "sent volume out",
    time from (select * from (select to_date(block_timestamp) as time, sum(AMOUNT)/1e6 as volume_received from terra.core.ez_transfers where
    RECEIVER in (select ADDRESS from (Select ADDRESS from terra.core.dim_address_labels where LABEL_TYPE='defi')) and CURRENCY='uluna'
    --RECEIVER in (select ADDRESS from (Select ADDRESS from terra.core.dim_address_labels where LABEL_TYPE='defi')) and CURRENCY='uluna'
    --terra
    group by time) data_one inner join ( select to_date(block_timestamp) as date_one, sum(AMOUNT)/1e6 as volume_sent
    from terra.core.ez_transfers where sender in (select ADDRESS from (Select ADDRESS from terra.core.dim_address_labels
    where LABEL_TYPE='defi')) and CURRENCY='uluna' group by date_one) data_two on data_one.time = data_two.date_one) ) select * from ramishow
    Run a query to Download Data