Pmisha-bmlMdxCEX.transfers.Solana.Dec
    Updated 2022-01-19
    SELECT date_trunc('day',block_timestamp) as d1,
    count(tx_id) as CEX_transfers
    from
    solana.transactions
    where (
    tx_to_address IN (
    '6ZRCB7AAqGre6c72PRz3MHLC73VMYvJ8bi9KHf1HFpNk',
    '57vSaRTqN9iXaemgh4AoDsZ63mcaoshfMK8NP3Z5QNbs',
    '88xTWZMeKfiTgbfEmPLdsUCQcZinwUfk25EBQZ21XMAZ',
    'Amf2mf2Ciap5wYAEKDtGoQHfHPWaKbyFYhutMK46hTRF',
    'FWznbcNXWQuHTawe9RxvQ2LdCENssh12dsznf4RiouN5',
    'FxteHmLwG9nk1eL4pjNve3Eub2goGkkz6g6TbvdmW46a',
    'H8sMJSCQxfKiFTCfDR3DUMLPwcRbM61LGFJ8N4dK3WjS',
    'u6PJ8DtQuPFnfmwHbGFULQ4u4EgjDiyYKjVEsynXq2w'
    )
    or
    tx_from_address in (
    '6ZRCB7AAqGre6c72PRz3MHLC73VMYvJ8bi9KHf1HFpNk',
    '57vSaRTqN9iXaemgh4AoDsZ63mcaoshfMK8NP3Z5QNbs',
    '88xTWZMeKfiTgbfEmPLdsUCQcZinwUfk25EBQZ21XMAZ',
    'Amf2mf2Ciap5wYAEKDtGoQHfHPWaKbyFYhutMK46hTRF',
    'FWznbcNXWQuHTawe9RxvQ2LdCENssh12dsznf4RiouN5',
    'FxteHmLwG9nk1eL4pjNve3Eub2goGkkz6g6TbvdmW46a',
    'H8sMJSCQxfKiFTCfDR3DUMLPwcRbM61LGFJ8N4dK3WjS',
    'u6PJ8DtQuPFnfmwHbGFULQ4u4EgjDiyYKjVEsynXq2w'
    )
    )
    AND MONTH(block_timestamp) = '12'
    AND YEAR(block_timestamp) = '2021'
    group by 1
    order by d1 desc
    Run a query to Download Data