freemartianTotal and Daily Selling Assets
Updated 2022-06-28
99
1
2
3
4
5
6
7
8
9
10
11
12
13
›
⌄
select contract_address, address_name, date_trunc('day', block_timestamp::date) as TIME,
case
when contract_address = '0xc2132d05d31c914a87c6611c10748aeb04b58e8f' then sum(raw_amount)/pow(10,6)
when contract_address = '0x2791bca1f2de4661ed88a30c99a7a9449aa84174' then sum(raw_amount)/pow(10,6)
else sum(raw_amount)/pow(10,18)
end as amount
from polygon.core.fact_token_transfers t
inner join polygon.core.dim_labels l on l.address = t.contract_address
where tx_hash in (
select tx_hash from polygon.core.fact_event_logs
where origin_to_address = lower('0x059d306A25c4cE8D7437D25743a8B94520536BD5')
and ORIGIN_FUNCTION_SIGNATURE = '0x6b29e1bd')
group by contract_address, address_name, TIME
Run a query to Download Data