LTirrelllfg_terra_balances
    Updated 2022-06-24
    with layer_one as (
    select
    date_trunc('day', block_timestamp) as datetime,
    TX_ID,
    SENDER,
    RECIPIENT
    FROM
    terra.transfer_events
    where
    block_timestamp :: date > '2022-01-01'
    and (
    sender = 'terra1gr0xesnseevzt3h4nxr64sh5gk4dwrwgszx3nw'
    or (
    recipient = 'terra1gr0xesnseevzt3h4nxr64sh5gk4dwrwgszx3nw'
    and sender = 'terra1dp0taj85ruc299rkdvzp4z5pfg6z6swaed74e6'
    )
    )
    and (
    amount_usd > 1000
    or amount_usd is null
    )
    ),
    layer_two as (
    select
    date_trunc('day', block_timestamp) as datetime,
    TX_ID,
    SENDER,
    RECIPIENT
    FROM
    terra.transfer_events
    where
    block_timestamp :: date > '2022-01-01'
    and sender in (
    select
    distinct RECIPIENT
    from
    Run a query to Download Data