Release v5.3.1

v5.3.1 - 2022-11-11

Release Name: Giosafat Barbaro

Bugs

• Fixed market cap calc #442

Release v5.3.0

v5.3.0 - 2022-11-11

Release Name: Hong Bao

Improvements

• Redesign of signature ingestion #416
  • Now tracks idx, sequence of sigs on txs
  • Now properly tracks base signature, idx for multisig keys
  • Returns more informative signature objects on txs, accounts
• Now recursively searching within MsgExec, MsgGrant, MsgRevoke for associated info #417
• Saving tx subtypes for specific msg types #417
  • Allows for searching within those subtypes as well
  • Async task to update older msgs with the newly identified subtypes
• Swapped CMC pricing out in favor of DLOB pricing #436

Bug Fixes

• Fixed unending do-while loop on getting account balance for denom #433
• Fixed Proposal eligibileAmount for quorum percentages #432
• Fixed /api/v3/accounts/tx_history not returning any data #431
• Removed Account attribute parsing
  • Now returning the object as seen on chain

Data

• Migration 1.83 - Update signature, redo join tables #416
  • Dropped signature.multi_sig_object, Added signature.address columns
  • Updated signature with new data
  • Added signature_multi_join, signature_tx tables, updated with data
• Migration 1.84 - Update ingest procedure with new signature info #416
  • Updated the ingest procedures
  • Dropped signature_join table
• Migration 1.85 - Add msg subtypes #417
  • Created table tx_msg_type_subtype, and populated with existing types
  • Updated views and ingest procedures
  • Dropped column tx_message_type_id from tx_message
  • Created table tx_msg_type_query strictly for query purposes
    • Gets inserted on trigger from tx_msg_type_subtype, flatmapping the primary/secondary types for better querying purposes

Release v5.2.2

v5.2.2 - 2022-11-07

Release Name: Diogo de Azambuja

Bug Fixes

• Removed invalid msg fee case, deleted invalid records

Data

• Migration 1.82 - Deleted incorrect fees

Release v5.2.1

v5.2.1 - 2022-11-02

Release Name: Gonçalo Álvares

Bug Fixes

• Updated the field type on asset pricing price
  • This allows for better granularity on price for the token

Release v5.2.0

v5.2.0 - 2022-10-28

Release Name: Diogo Afonso

Features

• Added CSV downloads for the Tx History chart data #406
  • Deprecated /api/v2/txs/history in favor of /api/v3/txs/history
  • GET /api/v3/txs/history/download - Using the given filters, exports the data behind the Tx History chart
  • GET /api/v3/accounts/tx_history - Returns data for the Account Tx History chart
  • GET /api/v3/accounts/tx_history/download - Using the given filters, exports the data behind the Account Tx History chart
  • Added MONTH as a granularity option
• Added APIs to get account balance for a single denom #418
  • GET /api/v3/accounts/{address}/balances/{denom} - Returns balance for the given account and denom
  • GET /api/v3/accounts/{address}/balances/utility_token - Returns balance for the utility token for the given account
  • /api/v3/accounts/{address}/balances/{height} -> /api/v3/accounts/{address}/balances_at_height - Added denom as query param

Improvements

• Extracted nhash as the utility token out into an ENV to be configurable #399
  • Also extracted the base denom decimal places, voting power multiplier, floor gas price
• Merging DLOB and CMC volumes for more accurate values

Bug Fixes

• Now using the CMC price for the utility token instead of from PE #407
• Hotfix - Fixed fee calc on success with msg fees
• Fix error where weighted vote values were being exponentialized #424

Data

• Migration 1.74 - Add index on hash to tx_cache
• Migration 1.77 - Add tx_timestamp to tx_fee #406
• Migration 1.78 - Add tx_timestamp to tx_feepayer #406
• Migration 1.79 - Add tx_timestamp to tx_message #406
• Migration 1.80 - Add tx_hash_id to tx_gas_cache #406
• Migration 1.81 - Updating ingest procedures, add materialized views #406
  • Updated associated ingest procedures
  • Created tx_history_chart_data_hourly, tx_type_data_hourly, fee_type_data_hourly materialized views, with data

Release v5.1.0

v5.1.0 - 2022-10-07

Release Name: Symon Semeonis

Features

• Added APIs for CoinMarketCap data #388
  • GET /api/v3/utility_token/historical_pricing - Returns a list of daily historical pricing for the utility token, queryable by date range
  • GET /api/v3/utility_token/latest_pricing - Returns the latest pricing for the utility token
• Added APIs for Authz grant and Feegrant data on an address #265
  • GET /api/v3/grants/authz/{address}/grantee - Returns a paginated list of authz grants granted to the address
  • GET /api/v3/grants/authz/{address}/granter - Returns a paginated list of authz grants granted by the address
  • GET /api/v3/grants/feegrant/{address}/grantee - Returns a paginated list of feegrant allowances granted to the address
  • GET /api/v3/grants/feegrant/{address}/granter - Returns a 501 until the supporting gRPC query is applied to the chain
• Added dedicated API for getting Attribute Names by address #346
  • GET /api/v2/names/{address}/owned - Returns attribute names owned by the address; applies to contracts as well

Improvements

• Removed calls to Figment #385
• Added API to check account balance at height #387
• Updated Prov Protos from 1.11.0 to 1.12.0 #391
• Added proper exception on invalid JWT token #394
• Added caching on image urls from Keybase #396
  • Reduces calls to Keybase so it doesnt yell at us
• Updated the MsgTypeSet enum to include an additionalType list that can be included in the module-based tx list #405
  • This allows assets created and traded via smart contract to show those transactions under the asset page
• Add list of associated values to a tx hash #340

Bug Fixes

• Swapped Long for BigDecimal in places that will need it, specifically for large nhash quantities #380
• Rounding circulating supply, community pool values as those are whole nhash values #381
• Fix Null pointer on reading to EventFee object
• Fixed calcs for tx fees, including failed #387
• Updated tx hash uniqueness to include block height #384
  • Added blockHeight query param to APIs where tx hash is used as the identifier
  • Updated the tx detail response to include a list of other blocks the hash was found in
• Fixed calc for tx fees, including success, during 1.11 block range #397
• Fixed error on validator fetch when validator is no longer in state #395
• Fixed IBC denom ingest when its a known denom instead of ibc/...

Data

• Migration 1.67 - Adding CMC data caching support #388
  • Added token_historical_daily table
  • Inserted cache_update record for utility_token_latest key
• Migration 1.68 - Fixing tx_fee data, again #387
  • Update recipient values that are blank to null
  • Delete duplicate fee records due to incorrect unique key
  • Correct the unique key, and update the ingest procedure to use it
• Migration 1.69 - Adding height uniqueness to tx hash keys #384
  • Addressed tx_cache, gov_deposit, tx_address_join, tx_feepayer, tx_gas_cache, tx_marker_join,
    tx_nft_join, tx_single_message_cache, tx_sm_code, tx_sm_contract, validator_market_rate, add_tx(), add_tx_debug()
• Migration 1.70 - Update tx_fee records for non-fee failures #387
  • Updated BASE_FEE_USED fee type to 0
  • Deleted any extra records
• Migration 1.71 - Update rollup functions #397
  • Updated update_gas_fee_volume() function to aggregate fees from tx_fee table
  • Updated insert_tx_gas_cache() function to reset processed to false and update the fee amount
    • This will ensure the rollups will be reaggregated
  • Updated insert_validator_market_rate() to update the market rate value on duplicate
  • Updated insert_tx_fees() to delete all related fee records first, then insert
  • Inserted new cache_update record for 1.11 block range to reprocess those blocks for correct fees
• Migration 1.72 - Update validator_state to include new removed field #395
  • Added removed column
  • Updated current_validator_state view to include the new column
  • Updated get_validator_list() function to include new column
  • Updated get_all_validator_state() function to include new column
• Migration 1.73 - Add address_image table to store image urls against an address #396
  • Added address_image table
  • Updated current_validator_state view to include the new table join
  • Updated get_validator_list() function to include new column from the view
  • Updated get_all_validator_state() function to include new column from the view
• Migration 1.74 - Update known IBC denoms
  • Identifies known IBC denoms (NOT ibc/...)
  • Finds the base, updates records as needed, and deletes the errant known IBC denoms
• Migration 1.75 - Add function to fetch associated values to a tx hash #340
  • Added get_tx_associated_values() function

Release v5.0.0

v5.0.0 - 2022-07-28

Release Name: Odoric of Pordenone

Features

• Updated Provenance proto set to 1.11.0 #371
• Add Support for Tx Msg building #355
  • Now supports building Tx msgs through API
    • POST /api/v3/gov/types/supported - Gives list of proposal types supported for governance msgs
    • POST /api/v3/gov/submit/{type} - Crafts a Submit Proposal msg from the given data
    • POST /api/v3/gov/deposit - Crafts a Deposit msg
    • POST /api/v3/gov/vote - Crafts a Vote msg
    • POST /api/v3/staking/delegate - Crafts a Delegate msg
    • POST /api/v3/staking/redelegate - Crafts a Redelegate msg
    • POST /api/v3/staking/undelegate - Crafts an Undelegate msg
    • POST /api/v3/staking/withdraw_rewards - Crafts a Withdraw Rewards msg
    • POST /api/v3/staking/withdraw_commission - Crafts a Withdraw Commission msg
    • POST /api/v2/accounts/send - Crafts a Send msg
  • Validations included to allow for better support
  • Docs included to help with usage
• Add Support for Vesting Accounts #366
  • GET /api/v3/accounts/{address}/balances - Returns paginated balances, broken down by spendable vs locked
  • GET /api/v3/accounts/{address}/vesting - Returns Vesting detail and vesting schedule
  • Now ingests properly
• Add Support for Custom Msg Fees #367
  • Updated fee ingestion to accommodate custom msg fees
  • Also saves the original fee amount and denom for historical purposes
• Add APIs for CoinMarketCap #375
  • GET /api/v3/utility_token/stats - Moved from /api/v2/token/stats, returns breakdown of nhash allocation on a broader scale
  • GET /api/v3/utility_token/distribution - Moved from /api/v2/assets/distribution, returns distribution of nhash across valid accounts
    • all accounts - nhash marker - zeroSeq - modules - contracts
  • GET /api/v3/utility_token/rich_list - Returns the top X accounts rich in nhash
    • all accounts - nhash marker - zeroSeq - modules - contracts
  • GET /api/v3/utility_token/max_supply - Returns the maximum supply ever of nhash on chain
  • GET /api/v3/utility_token/total_supply - Returns the total current supply of nhash
    • max - burned
  • GET /api/v3/utility_token/circulating_supply - Returns the current circulating supply of nhash
    • max - burned - modules - zeroSeq - pool - nonspendable
  • Updated nhash listview and detail supply values to use new total_supply
  • Added burned amount, max_supply amount to token stats chart data
  • Updated Chain Value AUM to use new total_supply for nhash

Improvements

• Added Validation message collection to allow for multiple validations at once #355
• Updated Tx Type lists with new types

Release v4.3.1

v4.3.1 - 2022-06-24

Release Name: James of Ireland

Bug Fixes

• Fixed blocks erroring out due to same Recv on 2 different txs within the same block

Release v4.3.0

v4.3.0 - 2022-06-23

Release Name: Wang Dayuan

Features

• Separated out Proposal votes into a paginated API #362
  • Deprecated /api/v2/gov/proposals/{id}/votes in favor of /api/v3/gov/proposals/{id}/votes
  • Moved Voting params and counts into the proposal detail / proposal listview responses
• Add Name APIs #134
  • /api/v2/names/tree - tree map of names on chain, including restriction and owner

Improvements

• Now saving applicable block heights to pull governance param sets #341
  • This is used to populate past proposals/votes/deposits based on the contemporary parameters on chain
• Now have the ability to fetch data at height from the chain
• Added Exposed functionality for Arrays and ArrayAgg Postgres function

Bug Fixes

• Fixed the Validator missed block count
• Added else case for IBC Recvs where the effected Recv is in the same tx as an uneffected Recv, which makes the block error out
• Added VotWeighted msg type to getGovMsgDetail() function
• Fixed how addresses were being associated with txs

Data

• Migration 1.64 - Updates for gov params at height #341
  • Updated gov_proposal with deposit_param_check_height, voting_param_check_height, inserted data
  • Updated insert_gov_proposal() procedure
  • Created get_last_block_before_timestamp() function
• Migration 1.65 - Add naming tree #134
  • Created name table, and inserted records

Release v4.2.0

v4.2.0 - 2022-05-24

Release Name: Odoric of Pordenone

Features

• Add notification/announcement support #328
  • /api/v2/notifications/proposals - List of NON-UPGRADE OPEN proposals, List of UPGRADE OPEN proposals
  • /api/v2/notifications/upgrades - List of expected, scheduled upgrades
  • /api/v2/notifications/announcement - PUT an announcement to be displayed in Explorer
  • /api/v2/notifications/announcement/all - Paginated list of announcements, can filter by fromDate
  • /api/v2/notifications/announcement/{id} - GET an announcement by ID
  • /api/v2/notifications/announcement/{id} - DELETE an existing announcement
• Add new IBC APIs #336
  • /api/v2/txs/ibc/chain/{ibcChain} - txs per IBC chain id, query params supporting narrowing by channel
  • /api/v2/ibc/channels/src_port/{srcPort}/src_channel/{srcChannel}/relayers - relayers by channel

Improvements

• Update vote ingestion to include Weighted Votes #323
• Updated the Dockerfile to include support for Vault secrets
• IBC ingestion supports actual IBC flow #336
• Increased frequency for asset-price polling from every 30 minutes to every 15 minutes
• Removing 0-sequenced account balances from circulation totals #335
• Updated existing Smart Contract Code and Contract queries with new query params #339
  • /api/v2/smart_contract/codes/all - added filters on creator, has_contracts
  • /api/v2/smart_contract/contract/all - added filters on creator, admin, label
  • /api/v2/smart_contract/code/{id}/contracts - added filters on creator, admin
• Added API to fetch list of unique non-UUID contract labels #339
  • /api/v2/smart_contract/contract/labels
• Updated the Pricing Engine API pathing
• Added @jarrydallison as a CODEOWNER

Bug Fixes

• Updated how the service runs on an empty DB
• Fixed pagination on Validators at Height API #326
• Fixed how gov proposals were being processed if they hadn't gotten out of the deposit period #330
• Fixed processing of IBC msgs #331
  • Related to incorrect value mapping
  • Added sort to block retry so they process in height order
• Fixed how the weighted vote percentage was being ingested
• Fixed chain version fetch from Github #349
  • Due to a limit of count on records from the Github API
• Fixed Validators' missed block count, bond height values #352
  • Missed blocks -> incorrect values being calculated
  • Bond Height -> query for signing infos was being limited, so not returning all records, thus missing some

Data

• Migration 1.58 - Add weight to proposal votes #323
  • Updated gov_vote to add weight column
  • Split out tx ingestion pieces into their own routines for easier updating
  • Inserting existing weighted votes
• Migration 1.59 - Add cache_update records for spotlight processing, default avg block time
  • Used to ensure values are present for some initial data processing
• Migration 1.60 - Add announcements table #328
• Migration 1.61 - IBC Ledger updates #336
  • Modifying ibc_ledger - adding sequence, unique_hash, removing acknowledgement columns
  • Inserting into new columns, updating unique key
  • Created ibc_ledger_ack table to hold all corresponding response txs to a ledger record, and inserted records
  • Created tx_ibc table to hold all IBC-related txs, and inserted prelim records
  • Created ibc_relayer table to hold relayer addresses associated with a channel, and inserted records
• Migration 1.62 - Ingestion procedure updates #336
  • Updated insert_ibc_ledger() procedure, created ingest procedures for new tables
  • Updated add_tx_debug(), add_tx() procedures with new ingestions
• Migration 1.63 - Add function for uuid_or_null() #339
  • Added function to determine if a string is a UUID, and if not, return null