Important: select the correct block_num_column and tx_column parameters, per the below:

• FLOW = block_height & tx_id
• Osmosis = block_id & tx_id
• All EVM = block_number & tx_hash
• Both Solana and NEAR use block_hash and references the parent so this needs revising for those chains. Neither block_height nor block_id should be trusted, here.
  • NEAR = block_id & tx_hash
  • Solana = block_height & tx_id

Expected blocks is inferred from max - min on the day and may not be accurate if gaps are large.

date_interval should be in the proper format to be inserted into the following where clause:

where block_timestamp > current_date - {{ date_interval }}

Transaction gaps is based on known data, tx_count from the block header. This will not include transactions missing due to blocks gaps.