LTirrell2022-04-08_algo_flipside-behavior_payments
    Updated 2022-04-08
    with block_info as(
    select
    block_timestamp,
    block_id
    from
    algorand.block
    ),
    flipside_payments as (
    select
    block_timestamp,
    block_id,
    tx_group_id,
    tx_id,
    inner_tx,
    sender,
    receiver,
    amount,
    fee
    from
    algorand.payment_transaction
    where
    sender = 'TLR47MQCEIC6HSSYLXEI7NJIINWJESIT3XROAYC2DUEFMSRQ6HBVJ3ZWLE'
    and amount < 10000
    and asset_id = 0
    ),
    account_info as (
    select
    block_info.block_timestamp,
    created_at,
    address,
    balance
    from
    algorand.account
    inner join block_info on created_at = block_info.block_id
    )
    select
    Run a query to Download Data