KaskoazulState of the Art - Flipside users
    Updated 2022-03-06
    SELECT
    tx.block_timestamp::date as fecha,
    sum(array_size (tx_to)) as Paid_bounties_per_day,
    sum(Paid_bounties_per_day) over (order by fecha) as Acc_paid_bounties,
    --tx.tx_id,
    --event_amount,
    sum(event_amount_usd) as Bounties_USD_per_day,
    sum(Bounties_USD_per_day) over (order by fecha) as Acc_bounties_USD
    --event_currency
    FROM
    terra.transactions tx
    INNER JOIN terra.transfers tf
    ON tx.tx_id = tf.tx_id
    WHERE CONTAINS (tx_from,'terra13v8hmfld6747h7fx9gzzqvv80qwz24uvcqwrap')
    GROUP BY 1


    Run a query to Download Data