theericstoneFind LFG_reserve address
    Updated 2022-03-15
    -- commented out how i found the lfg address...
    --select sender as address,
    -- sender_address_label as address_label,
    -- sender_address_name as address_name,
    -- 'inbound' as direction,
    -- currency,
    -- amount,
    -- amount_usd from
    -- terra.transfer_events
    -- where block_timestamp > '2022-02-17' and block_timestamp < '2022-02-19'
    -- and recipient = 'terra1tmnqgvg567ypvsvk6rwsga3srp7e3lg6u0elp8' -- anchor reserves address
    --and amount > 1000000;

    with outbounds as (
    select recipient as address,
    recipient_label as address_label,
    recipient_address_name as address_name,
    'outbound' as direction,
    currency,
    sum(amount) * -1 as amount,
    sum(amount_usd) * -1 as amount_usd FROM
    terra.transfer_events
    where
    block_timestamp > current_date - 100
    and sender = 'terra13h0qevzm8r5q0yknaamlq6m3k8kuluce7yf5lj'
    group by 1,2,3,4,5
    ),

    inbounds as (
    select sender as address,
    sender_address_label as address_label,
    sender_address_name as address_name,
    'inbound' as direction,
    currency,
    sum(amount) as amount,
    sum(amount_usd) as amount_usd FROM
    Run a query to Download Data