walt/tables/trades

trades

every swap of the coin, newest first. each row opens one ticket.

definition

select slot, time, side, size_usd, wallet, signature
from chain.swaps
where mint = :coin
order by time desc
limit 50;

what it is

this is the only table walt does not write. it is the chain's own record of the coin's swaps, read through a market data api and shown as it arrived. nothing is added, rounded or smoothed.

a row here is the start of everything else on this site. the signature becomes the seed of a ticket. the size sets the budget class. the wallet is named as the payer on the receipt.

buys and sells are equal. the fee is charged on both, so both open a ticket and both buy a thought.

rows

slottime utcsidesize usdclasswalletsignature

notes

the page shows the fifty most recent swaps as of this page load. it does not refresh on its own. reload to read the chain again.

size is the dollar size of the swap as reported with the trade. walt does not price trades itself.

figure

how the loaded swaps split by side.

columns

columntypemeaning
slotu64slot the swap landed in
timei64block time in seconds, shown in utc
sidetextbuy or sell, from the coin's side
size_usdf64dollar size of the swap
walletpubkeyaccount that signed the swap
signaturetexttransaction signature, the ticket seed
walt/tables/trades: read from the chain, never written by walt.