maybeyonasterra_passive_daily
    Updated 2022-05-08
    with
    anchor_reg as (
    select
    block_timestamp,
    tx_id,
    value::string as passive_user,
    'onchain storage' as type,
    'registration' as subtype
    from terra.msgs m,
    lateral flatten(input => m.msg_value:execute_msg:register_anchor_users)
    where msg_value:execute_msg:register_anchor_users is not null
    ),
    recievers as (
    select
    block_timestamp,
    tx_id,
    msg_value:to_address::string as passive_user,
    'native token recievers' as type,
    'recieve native' as subtype
    from terra.msgs
    -- where tx_id = '544F32B3F78998508BC075B7D8F81F64712845DB4F903D601BAE614E7A66B14F'
    where msg_type = 'bank/MsgSend'
    ),
    multi_recievers as (
    select
    block_timestamp,
    tx_id,
    value:address::string as passive_user,
    'native token recievers' as type,
    'multisend' as subtype
    from terra.msgs m,
    lateral flatten(input => m.msg_value:outputs)
    where msg_type = 'bank/MsgMultiSend'
    ),
    whitelist as (
    select
    Run a query to Download Data