emirprince95LP tokens for LOOP
    Updated 2022-07-07
    with
    mints as (select date_trunc('hour', block_timestamp) as hour_ts, sum(event_attributes:share/pow(10,6)) as LP_amount,
    event_attributes:"0_contract_address" as LP_address ------------!!!!!!!!!----------------
    from terra.msg_events
    where event_attributes:"0_contract_address" in ('terra123neekasfmvcs4wa70cgw3j3uvwzqacdz2we03', 'terra106a00unep7pvwvcck4wylt4fffjhgkf9a0u6eu',
    'terra1tus5ec9qsdht8dapq9ldfnsf8eehnfmwvsut83', 'terra1dw5j23l6nwge69z0enemutfmyc93c36aqnzjj5', 'terra1jfp5ew4tsru98wthajsqegtzaxt49ty4z2qws0',
    'terra1jkr0ef9fpghdru38ht70ds6jfldprgttw6xlek','terra1cpzkckgzz90pq8fkumdjc58ee5llrxt2yka9fp', 'terra1lgazu0ltsxm3ayellqa2mhnhlvgx3hevkqeqy2',
    'terra13eggta6zqfg03mxgqg9p5paqka7tgaaxnkhuuu','terra1f6d3pggq7h2y7jrgwxp3xh08yhvj8znalql87h', 'terra15568nqrqcawm263yqcuuuvj5mh763tp8jyscq3',
    'terra1whns5nyc8sw328uw3qqnyafxd5yfqsytkdkgqz','terra1x4msd26x8ncqcng3dapx8306rmgwuwtlg30a2j','terra178yhudw6cwtnrn4fq593z87y385m0xe9n6x423' )--aust-ust, LOOP-UST, LUNA-UST, LOOP-LOOPR, LUNA-LOOP, LOOPR-UST,TWD-UST, SPEC-UST, MIR-UST, STT-UST, MINE-UST, ANC-UST, LOTA-UST, ALTE-UST, LOOP-weWETH, DPH-UST
    and event_type = 'wasm'
    and event_attributes:"2_action" = 'mint'
    and tx_status = 'SUCCEEDED'
    group by date_trunc('hour', block_timestamp), LP_address

    UNION
    select date_trunc('hour', block_timestamp) as hour_ts, sum(event_attributes:share/pow(10,6)) as LP_amount,
    event_attributes:"0_contract_address" as LP_address from terra.msg_events
    where event_attributes:"0_contract_address" ='terra154jt8ppucvvakvqa5fyfjdflsu6v83j4ckjfq3'
    and event_type = 'wasm'
    and msg_index = 2
    and event_attributes:"3_action" = 'mint'
    and tx_status = 'SUCCEEDED'
    group by date_trunc('hour', block_timestamp), LP_address

    UNION
    select date_trunc('hour', block_timestamp) as hour_ts, sum(event_attributes:share/pow(10,6)) as LP_amount,
    event_attributes:"0_contract_address" as LP_address from terra.msg_events
    where event_attributes:"0_contract_address" = 'terra1sgu6yca6yjk0a34l86u6ju4apjcd6refwuhgzv'
    and event_type = 'wasm'
    and event_attributes:"1_action" = 'mint'
    and tx_status = 'SUCCEEDED'
    group by date_trunc('hour', block_timestamp), LP_address
    ),
    Run a query to Download Data