THORChain Nearest Block
Apr 17, 2023 - Will default to Snowflake's CURRENT_TIMESTAMP if no timestamp is provided. Please provide timestamp in UNIX seconds format (use a cool tool like http://www.unixtimestampconverter.com/).
Average Asset Volume By Period
May 11, 2023 - NOTES: 1. Asset volumes include Synth volume. 2. For period format, use Snowflake's Documentation: https://docs.snowflake.com/en/sql-reference/functions/date_part
Investigation - Partition Issue with Affiliate Fee Address
Jul 29, 2023 - Relevant Links: Github: https://github.com/FlipsideCrypto/sql_models/blob/main/models/thorchain/gold/thorchain__swaps.sql#L11C1-L45C28 Midgard: https://midgard.ninerealms.com/v2/actions?txid=FA34494476CB84AC34CEBAA030196E66483BA30B53FB034D49DCD50115A53023 Viewblock: https://viewblock.io/thorchain/tx/FA34494476CB84AC34CEBAA030196E66483BA30B53FB034D49DCD50115A53023