database of token transfers for public EOSIO chains
This service provides access to the full history of token transfers for several public EOSIO blockchains: EOS, Proton, Telos, and WAX.
The database contains irreversible transactions only.
Several spamming contracts are blacklisted. On EOS:
eosiopowcoin. On Telos:
The database schema consists of a set of tables for every chain, with blockchain name as a prefix:
SYNCcontains the last processed block number for every chain.
%%_CURRENCIESlists all known currencies, their decimal precision and multiplier.
%%_BALANCESlists all current token balances for all accounts.
%%_TRANSFERScontains token all transfers. It is indexed by
account_name, which is either receiver or sender of a token, and
deltadefines if the token is transferred in or out.
other_partyis the sender or receiver account, respectively.
%%_FAILED_DECODINGcontains transactions which could not be decoded due to ABI errors.
Public access to the data is available for any MySQL/MariaDB client.
Host in Europe:
mysql --host=eu01.pub.bdata.one --port=3303 \ --user=eosio_token_accounting_ro --password=eosio_token_accounting_ro --database=eosio_token_accounting # all token transfers for the account during December 2021 select * from wax_TRANSFERS where account_name = 'cc32dnineexp' and block_time >= '2021-12-01' and block_time < '2022-01-01';
Copyright (c) 2021 firstname.lastname@example.org