KaskoazulStepN all tx with amount
    Updated 2022-03-01
    WITH ALLTX AS (
    select
    block_timestamp::date as fecha,
    tx_id,
    pre_mint,
    post_mint,
    tx_from_address,
    tx_to_address,
    transfer_tx_flag,
    program_id
    from solana.transactions
    where block_timestamp::date >= '2022-01-01' and block_timestamp::date <= '2022-02-27'
    and succeeded = 'TRUE'
    and (pre_mint = 'AFbX8oGjGpmVFywbVouvhQSRmiW2aR1mohfahi4Y2AdB'
    or post_mint = 'AFbX8oGjGpmVFywbVouvhQSRmiW2aR1mohfahi4Y2AdB')
    ),

    TRANSFER_AMOUNT AS (
    SELECT
    fecha,
    tx.tx_id,
    t.amount/pow(10,3) as Transfer,
    --t.pretokenbalances,
    --t.posttokenbalances,
    t.event_type
    FROM ALLTX tx
    INNER JOIN solana.transfers t
    ON tx.tx_id = t.tx_id
    )

    SELECT
    fecha,
    sum(Transfer) as TotalAmount
    --sum(Transfer) over (ORDER BY fecha) as TotalAmountAcc
    FROM TRANSFER_AMOUNT
    GROUP BY 1--, 2
    Run a query to Download Data