nitsNumber of bonds made for yLUNA over time
    Updated 2022-04-04
    SELECT date(block_timestamp) as day,
    sum(msg_value:execute_msg:send:amount)/pow(10,6) as amt,
    count(DISTINCT msg_value:sender) as unique_senders,
    sum(unique_senders) over (order by day) as cumulative_senders
    from terra.msgs
    WHERE
    -- tx_id ilike 'BF69A84BEAD4C6C42AB510E7EE6AD3C0A04DBCD6FDF79BCD0481BE935800CC5C' and
    msg_value:contract = 'terra17wkadg0tah554r35x6wvff0y5s7ve8npcjfuhz'
    and msg_value:execute_msg:send:contract = 'terra1ns5nsvtdxu53dwdthy3yxs6x3w2hf3fclhzllc'
    -- where msg_value:contract = 'terra1p7jp8vlt57cf8qwazjg58qngwvarmszsamzaru'
    -- and amt is NULL and contains(msg_value, 'bond')
    GROUP by 1
    limit 100