dr1888Volume of swaps
Updated 2023-03-13
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
›
⌄
-- 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