binhachonTop Kashi Pairs III
Updated 2022-05-22
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
›
⌄
with contract_address as (
select
address,
decimals,
symbol,
lower(contract_metadata:asset::string) as asset,
lower(contract_metadata:collateral::string) as collateral
from flipside_prod_db.ethereum_core.dim_contracts
where symbol like '%km%'
and symbol like '%/%-%'
),
token_balance as (
select
contract_address,
sum(case when from_address = '0x0000000000000000000000000000000000000000' then raw_amount else -raw_amount end) as raw_amount
from flipside_prod_db.ethereum_core.fact_token_transfers
where contract_address in (select address from contract_address)
and (from_address = '0x0000000000000000000000000000000000000000' or to_address = '0x0000000000000000000000000000000000000000')
group by 1
),
token_balance_1 as (
select
contract_address,
symbol,
asset,
collateral,
raw_amount --/pow(10, decimals) as amount
from token_balance
left join contract_address on (contract_address = address)
),
mint_burn_transactions as (
select
block_timestamp,
tx_hash,
contract_address as kashi_token,
raw_amount as raw_kashi_amount
Run a query to Download Data