KaskoazulUntitled Query
Updated 2022-03-20
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
›
⌄
select*
from ethereum.transactions
where to_label = 'rari capital'
and to_address != '0xd291e7a03283640fdc51b121ac401383a46cc623' --RGT Token
and to_address != '0x5ea4a9a7592683bf0bc187d6da706c6c4770976f' --RGT Reserves
and to_label_subtype = 'pool'
and block_timestamp >= '2022-01-01'
--group by pool
--tx_id = '0x0da59251949251154ab0e3e8c078cf2ef1a2a28f29e08014142697235ea268ae'
-- tx_to_label = 'rari capital'
--and tx_to_label_subtype = 'pool'
--contract_address = '0x66f4856f1bbd1eb09e1c8d9d646f5a3a193da569' --USDC Pool
--contract_address = '0xafd2aade64e6ea690173f6de59fc09f5c9190d74' --DAI Pool
--case
Run a query to Download Data