maybeyonasmain_prots
    Updated 2022-02-13
    -- apollo dao
    with interact as(
    select
    block_timestamp,
    tx_id,
    msg_value:contract::string as contract
    from terra.msgs
    where msg_module = 'wasm' and tx_status='SUCCEEDED'
    and block_timestamp >= getdate() - interval '90 days'
    ),
    interact_names_main as(
    select
    block_timestamp,
    tx_id,
    contract,
    label,
    address_name,
    label_type,
    label_subtype
    from interact left outer join terra.labels on contract = address
    -- where label != 'cw20Token'
    ),
    pylon as(
    select
    block_timestamp,
    tx_id,
    contract,
    'pylon' as label,
    address_name,
    label_type,
    label_subtype
    from interact_names_main
    where contract in (
    'terra1rqkyau9hanxtn63mjrdfhpnkpddztv3qav0tq2',
    'terra19nek85kaqrvzlxygw20jhy08h3ryjf5kg4ep3l',
    'terra1xu8utj38xuw6mjwck4n97enmavlv852zkcvhgp',
    Run a query to Download Data