flipside

    Strategy events_emitted exploration - FRAX vault
    scottincryptoStrategy events_emitted exploration - FRAX vault
    Updated 2021-08-10
    with event_list as (
    select
    block_timestamp,
    contract_address,
    contract_name,
    event_index,
    event_name,
    -- event_inputs,
    event_inputs:debtOutstanding::numeric as debtOutstanding,
    event_inputs:debtPayment::numeric as debtPayment,
    event_inputs:loss::numeric as loss,
    event_inputs:profit::numeric as profit
    from ethereum.events_emitted
    where contract_address in (lower('0x8423590CD0343c4E18d35aA780DF50a5751bebae'), lower('0x8c312B63Bc4000f61E1C4df4868A3A1f09b31A73'))
    and event_name = 'Harvested'
    order by contract_address, block_timestamp, event_index
    )

    /*select
    *
    from event_list
    */

    select distinct event_name from ethereum.events_emitted
    where contract_address = lower ('0xB4AdA607B9d6b2c9Ee07A275e9616B84AC560139')

    -- lower ('0xB4AdA607B9d6b2c9Ee07A275e9616B84AC560139') Vault
    -- lower('0x8423590CD0343c4E18d35aA780DF50a5751bebae') - CRV stategy
    -- lower('0x8c312B63Bc4000f61E1C4df4868A3A1f09b31A73') - CVX strategy
    Run a query to Download Data