Mrftinew-red copy copy
    Updated 2025-01-12
    -- forked from new-red copy @ https://flipsidecrypto.xyz/studio/queries/1961295d-df3f-4b80-8b64-8704c068e93b

    with database as --honeyswap mint txs+details
    (
    with tbl as (
    select *
    from berachain.testnet.fact_event_logs
    where origin_to_address = '0xad1782b2a7020631249031618fb1bd09cd926b31'--honeyswap
    and contract_address = '0xad1782b2a7020631249031618fb1bd09cd926b31'
    and tx_succeeded = 'TRUE'
    and ORIGIN_FUNCTION_SIGNATURE = '0x0d4d1513' --mint txs
    )
    SELECT
    block_timestamp,
    tx_hash,
    '0x' || SUBSTR(PARSE_JSON(TOPICS)[2]::string, -40) AS user_address,
    '0x' || SUBSTR(PARSE_JSON(TOPICS)[3]::string, -40) AS token_address,
    utils.udf_hex_to_int(SUBSTRING(DATA, 67, 128))/pow (10,18) AS honey_amount,
    case
    when token_address = lower ('0x806ef538b228844c73e8e692adcfa8eb2fcf729c') then utils.udf_hex_to_int(SUBSTRING(DATA, 3, 64))/pow (10,18)
    when token_address = lower ('0xd6D83aF58a19Cd14eF3CF6fe848C9A4d21e5727c') then utils.udf_hex_to_int(SUBSTRING(DATA, 3, 64))/pow (10,6)
    when token_address = lower ('0x05D0dD5135E3eF3aDE32a9eF9Cb06e8D37A6795D') then utils.udf_hex_to_int(SUBSTRING(DATA, 3, 64))/pow (10,6)
    end as token_amount,
    token_amount-honey_amount as token_vault_amount,
    case
    when token_address = lower ('0x806ef538b228844c73e8e692adcfa8eb2fcf729c') then 'DAI'
    when token_address = lower ('0xd6D83aF58a19Cd14eF3CF6fe848C9A4d21e5727c') then 'USDC'
    when token_address = lower ('0x05D0dD5135E3eF3aDE32a9eF9Cb06e8D37A6795D') then 'USDT'
    end as token,
    from tbl
    )

    SELECT
    date_trunc (day, block_timestamp) as date,
    sum(honey_amount) as "Total $HONEY minted",
    sum ("Total $HONEY minted") over (order by date) as "Cumulative $HONEY mint",
    Auto-refreshes every 12 hours
    QueryRunArchived: QueryRun has been archived