0xaimanNumber of Shorters and Total Short Position
    Updated 2022-06-30
    select count( distinct tx_from_address)::string as n_address_short, sum(n_short_opt_bought)::string as n_short_opt_bought
    from (select tx_from_address, count(tx_id) as n_short_opt_bought from ethereum.events_emitted

    where --x_id='0x122f2e39cf477f6cdefa71e9d8f94770bdddb058ce486d273a114fa1125d2d6d'and
    tx_to_address='0xa653e22a963ff0026292cc8b67941c0ba7863a38' and event_name='Transfer'
    --tx_id='0x6e765fec43e83768007c3969772c5b27a0613df9abaf0e4d91c4076562d3d0f4' and
    --contract_address='0xf1b99e3e573a1a9c5e6b2ce818b617f0e664e86b' and

    group by 1 order by 1)

    Run a query to Download Data