SELECT

date_trunc({{time_granularity}}, block_timestamp)::date AS date

, count(tx_id) AS total_txs

, count_if(tx ILIKE '%unbond%') AS total_unBOND_txs

, total_txs - total_unBOND_txs AS total_BOND_txs

, count_if(tx ILIKE '%ibc/517E13F14A1245D4DE8CF467ADD4DA0058974CDCC880FA6AE536DBCA1D16D84E%') AS total_bWHALE_txs

, count_if(tx ILIKE '%ibc/B3F639855EE7478750CC8F82072307ED6E131A8EFF20345E1D136B50C4E5EC36%') AS total_ampWHALE_txs

, count_if(

tx ILIKE '%unbond%'

AND tx ILIKE '%ibc/517E13F14A1245D4DE8CF467ADD4DA0058974CDCC880FA6AE536DBCA1D16D84E%'

) AS bWHALE_unBONDERS

, count_if(

tx ILIKE '%unbond%'

AND tx ILIKE '%ibc/B3F639855EE7478750CC8F82072307ED6E131A8EFF20345E1D136B50C4E5EC36%'

) AS ampWHALE_unBONDERS

, count_if(

tx ILIKE '%"bond%'

AND tx ILIKE '%ibc/517E13F14A1245D4DE8CF467ADD4DA0058974CDCC880FA6AE536DBCA1D16D84E%'

) AS bWHALE_BONDERS

, total_bWHALE_txs - bWHALE_unBONDERS AS bWHALE_BONDERS_1

, count_if(

tx ILIKE '%"bond%'

AND tx ILIKE '%ibc/B3F639855EE7478750CC8F82072307ED6E131A8EFF20345E1D136B50C4E5EC36%'

) AS ampWHALE_BONDERS

, total_ampWHALE_txs - ampWHALE_unBONDERS AS ampWHALE_BONDERS_1

FROM terra.core.fact_transactions

WHERE 1 = 1

AND tx ILIKE '%bond%'

AND tx ILIKE '%terra1qa5a8fkynmthlrh9wsae4sqnuxdrespsls7c7acayqqvs5s63eksm53snj%'

AND (tx ILIKE '%ibc/517E13F14A1245D4DE8CF467ADD4DA0058974CDCC880FA6AE536DBCA1D16D84E%'

OR

tx ILIKE '%ibc/B3F639855EE7478750CC8F82072307ED6E131A8EFF20345E1D136B50C4E5EC36%')

AND block_timestamp > current_date - INTERVAL '{{days_back}} day'

GROUP BY 1