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
| slot | time utc | side | size usd | class | wallet | signature |
|---|
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
| column | type | meaning |
|---|---|---|
| slot | u64 | slot the swap landed in |
| time | i64 | block time in seconds, shown in utc |
| side | text | buy or sell, from the coin's side |
| size_usd | f64 | dollar size of the swap |
| wallet | pubkey | account that signed the swap |
| signature | text | transaction signature, the ticket seed |