Skip to content
Dune Analytics

@tianqi / 买入龙虎榜

SQL query results

Loading
 

SQL query

1
2/*with trade as (
3select t.exchange_address,t.token_symbol,sum(t.usd_value_of_eth) volum from uniswap."view_eth_purchase" t
4where t.block_time > now() - interval '1 day'
5group by 1,2
6union
7select t.exchange_address,t.token_symbol,sum(t.usd_value_of_eth) volum from uniswap."view_token_purchase" t
8where t.block_time > now() - interval '1 day'
9group by 1,2
10
11)
12
13select t.exchange_address,
14case t.exchange_address when '\x05cde89ccfa0ada8c88d5a23caaa79ef129e7883' then 'HEX' 
15when '\x64a9edd3f5fce0252cd708e26c8dd11205742826' then 'ANJ'
16when '\xfc96e234d4b31c63051e707105fcc4aba37807fa' then 'UBT'
17else t.token_symbol end as token_symbol,
18sum(t.volum) 成交量
19from trade t  
20--where t.block_time > now()- interval '1 day'
21group by 1,2
22order by 3 desc
23limit 10
24*/
25with largest_buyer as (...