flipside

    KittyPunch farm staking all by pools
    adriaparcerisasKittyPunch farm staking all by pools
    Updated 7 days ago
    WITH
    prices as (
    select avg(price) as flow_price
    from flow.price.ez_prices_hourly where symbol='FLOW' and hour>=current_date-1
    ),
    all_farms_in AS (
    SELECT
    x.tx_hash,
    x.block_timestamp,
    x.origin_from_address,
    x.origin_to_address,
    CASE
    WHEN lower(x.origin_to_address) = lower('0xFCd501d350bf31c5a2E2Aa9C62DC1BEd5920d802') THEN (utils.udf_hex_to_int(x.data) / pow(10,18))
    WHEN lower(x.origin_to_address) = lower('0x289ca59F51893d566255588F4C8407B07644f5D6') THEN (utils.udf_hex_to_int(x.data) / pow(10,18))
    WHEN lower(x.origin_to_address) = lower('0x9D2eB1A2afDD44B310A2bBA06Bc5A060BF83c1C5') THEN (utils.udf_hex_to_int(x.data) / pow(10,18)) *1e2
    WHEN lower(x.origin_to_address) = lower('0xb334B50fc34005c87C7e6420E3E2D9a027E4D662') THEN (utils.udf_hex_to_int(x.data) / pow(10,18)) *3e7
    WHEN lower(x.origin_to_address) = lower('0x2E2756e83D165C9727A48313746CD33044B70077') THEN (utils.udf_hex_to_int(x.data) / pow(10,18))
    END AS amount_in,
    CASE
    WHEN lower(x.origin_to_address) = lower('0xFCd501d350bf31c5a2E2Aa9C62DC1BEd5920d802') THEN 'USDF-stgUSDC'
    WHEN lower(x.origin_to_address) = lower('0x289ca59F51893d566255588F4C8407B07644f5D6') THEN 'FLOW-ankrFLOW'
    WHEN lower(x.origin_to_address) = lower('0x9D2eB1A2afDD44B310A2bBA06Bc5A060BF83c1C5') THEN 'WETH-WFLOW'
    WHEN lower(x.origin_to_address) = lower('0xb334B50fc34005c87C7e6420E3E2D9a027E4D662') THEN 'WFLOW-USDF'
    WHEN lower(x.origin_to_address) = lower('0x2E2756e83D165C9727A48313746CD33044B70077') THEN 'WETH-USDF'
    END AS pool_name
    FROM flow.core_evm.fact_event_logs x, prices
    WHERE
    lower(x.origin_to_address) IN (
    lower('0xFCd501d350bf31c5a2E2Aa9C62DC1BEd5920d802'),
    lower('0x289ca59F51893d566255588F4C8407B07644f5D6'),
    --lower('0x2E2756e83D165C9727A48313746CD33044B70077'), ENDED
    lower('0x9D2eB1A2afDD44B310A2bBA06Bc5A060BF83c1C5'),
    lower('0xb334B50fc34005c87C7e6420E3E2D9a027E4D662')
    )
    AND x.origin_function_signature = '0xa694fc3a'
    AND x.event_index = 0
    Last run: 7 days ago
    DATE
    POOL_NAME
    ACTIVE_LIQUIDITY_PROVIDERS
    NEW_LIQUIDITY_PROVIDER
    UNIQUE_LIQUIDITY_PROVIDERS
    LIQUIDITY_ACTIONS
    TOTAL_LIQUIDITY_ACTIONS
    AMOUNT_IN_USD
    AMOUNT_OUT_USD
    AVG_AMOUNT_IN_USD
    AVG_AMOUNT_OUT_USD
    NET_AMOUNT_SUPPLIED
    TOTAL_AMOUNT_IN_USD
    TOTAL_AMOUNT_OUT_USD
    CURRENT_TVL
    1
    		2025-04-19 00:00:00.000FLOW-ankrFLOW1128182786159.6574746450786159.657474645786159.6574746454462819.210920011883707.649568772579111.56135124
    2
    		2025-04-18 00:00:00.000FLOW-ankrFLOW0271810118191118191-1181913676659.553445371883707.649568771792951.9038766
    3
    		2025-04-17 00:00:00.000FLOW-ankrFLOW102718011819101181911181913676659.553445371765516.649568771911142.9038766
    4
    		2025-04-16 00:00:00.000FLOW-ankrFLOW112717910928.700516027010928.70051602710928.7005160273558468.553445371765516.649568771792951.9038766
    5
    		2025-04-15 00:00:00.000FLOW-ankrFLOW21263781164.4454413420388.1484804471164.4454413423547539.852929341765516.649568771782023.20336057
    6
    		2025-04-14 00:00:00.000FLOW-ankrFLOW10251753.93905177403.9390517743.9390517743546375.4074881765516.649568771780858.75791923
    7
    		2025-04-13 00:00:00.000FLOW-ankrFLOW10251746.36237414806.3623741486.3623741483546371.468436231765516.649568771780854.81886746
    8
    		2025-04-12 00:00:00.000FLOW-ankrFLOW102527359.032614085117505.41159.032614085117505.411-117446.3783859153546365.106062081765516.649568771780848.45649331
    9
    		2025-04-06 00:00:00.000FLOW-ankrFLOW21252713062.72996529601531.3649826483062.7299652963546306.073447991648011.238568771898294.83487922
    10
    		2025-04-05 00:00:00.000FLOW-ankrFLOW1024469517541.556890783144405.482830628517541.55689078348135.160943543373136.0740601553543243.34348271648011.238568771895232.10491393
    11
    		2025-04-03 00:00:00.000FLOW-ankrFLOW102416513.53793905013.5379390513.537939053025701.786591911503605.755738141522096.03085377
    12
    		2025-04-02 00:00:00.000FLOW-ankrFLOW2124464151147.545421781703752.40874245875573.77271089351876.204371229-552604.8633206773025688.248652861503605.755738141522082.49291472
    13
    		2025-04-01 00:00:00.000FLOW-ankrFLOW21236607297.29471071718092.8773213461459.45894214318092.877321346-10795.5826106292874540.70323108799853.3469956842074687.3562354
    14
    		2025-03-30 00:00:00.000FLOW-ankrFLOW2122354842568.84944160850958.10358736421284.42472080450958.10358736791610.7458542482867243.40852037781760.4696743392085482.93884603
    15
    		2025-03-29 00:00:00.000FLOW-ankrFLOW102135150958.1035873652307.9288160550958.1035873626153.964408025-1349.825228692024674.55907876730802.3660869791293872.19299178
    16
    		2025-03-28 00:00:00.000FLOW-ankrFLOW202134850955.25943061550947.91247622425477.62971530850947.9124762247.3469543921973716.4554914678494.4372709291295222.01822047
    17
    		2025-03-27 00:00:00.000FLOW-ankrFLOW02114508394.587907178394.58790717-8394.587907171922761.19606078627546.5247947061295214.67126608
    18
    		2025-03-26 00:00:00.000FLOW-ankrFLOW10211443429.55608987603429.5560898763429.5560898761922761.19606078619151.9368875361303609.25917325
    19
    		2025-03-25 00:00:00.000FLOW-ankrFLOW42214434842.98298678201210.7457466954842.9829867821919331.63997091619151.9368875361300179.70308337
    20
    		2025-03-24 00:00:00.000FLOW-ankrFLOW101923950953.00777700150958.1035873650953.00777700150958.10358736-5.0958103591914488.65698413619151.9368875361295336.72009659
    ...
    237
    39KB
    7s