按成交记录

计价币变动 USDT

select a.usdt + b.usdt + c.usdt + d.usdt
from
(select IFNULL(-sum(amount),0) as usdt
from walk_account_taker_trade where uid = 67300 and if_bid = 1 and symbol_id = 13) a,
(select IFNULL(sum(amount)-sum(fee),0) as usdt
from walk_account_taker_trade where uid = 67300 and if_bid = 0 and symbol_id = 13) b,
(select IFNULL(-sum(amount),0) as usdt
from walk_account_maker_trade where uid = 67300 and if_bid = 1 and trade_type = 2 and symbol_id = 13) c,
(select IFNULL((sum(amount)-sum(fee)),0) as usdt
from walk_account_maker_trade where uid = 67300 and if_bid = 0 and trade_type = 2 and symbol_id = 13) d

判断：计价币原始可用 + 计价币原始冻结 = 计价币现在可用 + 计价币现在冻结 + 计价币变动

交易币变动 BTC

select a.btc + b.btc + c.btc + d.btc
from 
(select IFNULL(sum(num)-sum(fee), 0) as btc
from walk_account_taker_trade where uid = 67300 and if_bid = 1 and symbol_id = 13) a,
(select IFNULL(-sum(num),0) as btc
from walk_account_taker_trade where uid = 67300 and if_bid = 0 and symbol_id = 13) b,
(select IFNULL(sum(num)-sum(fee), 0) as btc
from walk_account_maker_trade where uid = 67300 and if_bid = 1 and trade_type = 2 and symbol_id = 13) c,
(select IFNULL(-sum(num),0) as btc
from walk_account_maker_trade where uid = 67300 and if_bid = 0 and trade_type = 2 and symbol_id = 13) d

判断：交易币原始可用 + 交易币原始冻结 = 交易币现在可用 + 交易币现在冻结 + 交易币变动

账户总账 USDT

select a.num + b.fee + c.fee
from 
(select balance_num + freeze_num as num from walk_account where uid = 67300 and currency_id = 1) a,
(select IFNULL(sum(fee),0) as fee from walk_account_maker_trade where uid = 67300 and symbol_id = 13 and fee_currency_id = 1) b,
(select IFNULL(sum(fee),0) as fee from walk_account_taker_trade where uid = 67300 and symbol_id = 13 and fee_currency_id = 1) c

账户总账 BTC

select a.num + b.fee + c.fee
from 
(select balance_num + freeze_num as num from walk_account where uid = 67300 and currency_id = 2) a,
(select IFNULL(sum(fee),0) as fee from walk_account_maker_trade where uid = 67300 and symbol_id = 13 and fee_currency_id = 2) b,
(select IFNULL(sum(fee),0) as fee from walk_account_taker_trade where uid = 67300 and symbol_id = 13 and fee_currency_id = 2) c

按订单成交额

select o.amount as '买单成交总额(无委托中订单)', a.amount + b.amount as '成交总额'
from
(select IFNULL(sum(amount),0) as amount
from walk_account_maker_trade
where uid = 383980 and symbol_id = 13 and if_bid = 1 and trade_type=2) a,
(select IFNULL(sum(amount),0) as amount
from walk_account_taker_trade
where uid = 383980 and symbol_id = 13 and if_bid = 1) b,
(select sum(trade_amount)as amount
from walk_order
where uid = 383980 and symbol_id = 13 and if_bid = 1 and state in (2,3,5)) o

select o.amount as '卖单成交总额(无委托中订单)', a.amount + b.amount as '成交总额'
from
(select IFNULL(sum(num),0) as amount
from walk_account_maker_trade
where uid = 383980 and symbol_id = 13 and if_bid = 0 and trade_type=2) a,
(select IFNULL(sum(num),0) as amount
from walk_account_taker_trade
where uid = 383980 and symbol_id = 13 and if_bid = 0) b,
(select sum(trade_num) as amount
from walk_order
where uid = 383980 and symbol_id = 13 and if_bid = 0 and state in (2,3,5)) o

交易所交易手续费交易所分成统计

通过trade查询某交易所某一币种某一天与平台手续费分成统计

SELECT (m.maker_fee + t.taker_fee) * cast(f.fee_rate as decimal(2,2)) as '交易所手续费', (m.maker_fee + t.taker_fee) * cast((1 - f.fee_rate) as decimal(2,2)) as '平台手续费'
from
(SELECT IFNULL(sum(fee), 0) as maker_fee from walk_account.walk_account_maker_trade where trade_time >= '2020-10-28 00:00:00' and trade_time <= '2020-10-28 23:59:59' and site_id=1041 and fee_currency_id=10) m,
(SELECT IFNULL(sum(fee), 0) as taker_fee from walk_account.walk_account_taker_trade where trade_time >= '2020-10-28 00:00:00' and trade_time <= '2020-10-28 23:59:59' and site_id=1041 and fee_currency_id=10) t,
(SELECT fee_rate from walk_admin.sys_site where id=1041) f

通过手续费流水查询某交易所某一币种某一天分的手续费

select percentage from walk_account_fee_flow where site_id=1041 and fee_date=20201028 and currency_id=10 and trade_type=1

交易所交易手续费平台分成统计

第一条sql将各交易所币种的平台手续费分成求和平台统计

select percentage from walk_account_fee_flow where site_id=0 and fee_date=20201028 and currency_id=1 and trade_type=1 
select percentage from walk_account_fee_flow where site_id=0 and fee_date=20201028 and currency_id=2 and trade_type=1 
select percentage from walk_account_fee_flow where site_id=0 and fee_date=20201028 and currency_id=10 and trade_type=1 
```### ### ## # ## ### ##