dr1888Volume of swaps
    Updated 2023-03-13
    -- forked from 0ee417db-88d5-43e8-a295-e59647ef7529

    SELECT
    BLOCK_TIMESTAMP::Date as BTD,
    sum(RAW_AMOUNT) as CDOFS,
    sum(CDOFS) over (order by BTD) as SCDOFS
    from avalanche.core.fact_token_transfers
    where
    to_address IN (lower('0xcCa0cfFBF97fB10B08c1703f1DDdcF7b48c69d69'),lower('0x2fD81391E30805Cc7F2Ec827013ce86dc591B806'), lower('0xE4e7aAA5a1Aab5b55eE44FAb2D5dd6fCd80E4D42'), lower('0xf43f906250beA2D84aEAaf28BD7ac74d5C8DbFb6'), lower('0x11C0F9134D7Db45e3dab7A78AC3c957a92229E8c'))
    or
    from_address IN (lower('0x2fD81391E30805Cc7F2Ec827013ce86dc591B806'), lower('0xcCa0cfFBF97fB10B08c1703f1DDdcF7b48c69d69'), lower('0xE4e7aAA5a1Aab5b55eE44FAb2D5dd6fCd80E4D42'), lower('0xf43f906250beA2D84aEAaf28BD7ac74d5C8DbFb6'), lower('0x11C0F9134D7Db45e3dab7A78AC3c957a92229E8c'))
    and
    contract_address LIKE lower('0x152b9d0FdC40C096757F570A51E494bd4b943E50')
    and
    BTD>=CURRENT_DATE-180
    group by 1


    Run a query to Download Data