flipside

    Meteora DLMM fees
    CyberaResearchMeteora DLMM fees
    Updated 5 days ago
    WITH unique_wallet_count AS (
    -- Count the number of unique signer wallet addresses
    SELECT
    COUNT(DISTINCT fe.signers[0]::STRING) AS Unique_Signer_Count
    FROM
    solana.core.fact_events fe
    JOIN
    solana.core.ez_events_decoded ed
    ON fe.tx_id = ed.tx_id
    AND fe.program_id = ed.program_id
    WHERE
    fe.program_id = 'LBUZKhRxPF3XUpBCjp4YzTKgLccjZhTSDM9YuVaPwxo'
    AND fe.succeeded = 'true'
    AND ed.event_type = 'claimFee'
    ),
    parsed_events AS (
    -- Parse JSON to extract mint addresses and token amounts, ensuring data integrity by filtering out incomplete rows
    SELECT
    fe.block_timestamp AS Event_Timestamp,
    fe.tx_id AS Transaction_ID,
    fe.succeeded AS Transaction_Success,
    ed.event_type AS Event_Type,
    fe.program_id AS Program_ID,
    fe.instruction AS Instruction_Details,
    fe.inner_instruction AS Inner_Instruction_Details,
    fe.signers[0]::STRING AS Signer_Wallet_Address,
    uc.Unique_Signer_Count,

    PARSE_JSON(fe.inner_instruction):instructions[0].parsed.info.mint::STRING AS Primary_Token_Address,
    PARSE_JSON(fe.inner_instruction):instructions[1].parsed.info.mint::STRING AS Secondary_Token_Address,
    PARSE_JSON(fe.inner_instruction):instructions[0].parsed.info.tokenAmount.uiAmount::NUMBER(38,9) AS Primary_Token_Amount,
    PARSE_JSON(fe.inner_instruction):instructions[1].parsed.info.tokenAmount.uiAmount::NUMBER(38,9) AS Secondary_Token_Amount
    FROM
    solana.core.fact_events fe
    JOIN
    solana.core.ez_events_decoded ed
    Last run: 5 days ago
    EVENT_TIMESTAMP
    TRANSACTION_ID
    TRANSACTION_SUCCESS
    EVENT_TYPE
    PROGRAM_ID
    INSTRUCTION_DETAILS
    INNER_INSTRUCTION_DETAILS
    SIGNER_WALLET_ADDRESS
    UNIQUE_SIGNER_COUNT
    PRIMARY_TOKEN_ADDRESS
    SECONDARY_TOKEN_ADDRESS
    PRIMARY_TOKEN_AMOUNT
    SECONDARY_TOKEN_AMOUNT
    SOL_TOKEN_AMOUNT
    USDC_TOKEN_AMOUNT
    TOTAL_SOL_TOKENS
    TOTAL_USDC_TOKENS
    SOL_TOKEN_OCCURRENCES
    USDC_TOKEN_OCCURRENCES
    TOTAL_TOKEN_ADDRESSES
    SOL_TOKEN_RATIO
    USDC_TOKEN_RATIO
    SOL_TOKEN_PERCENTAGE
    USDC_TOKEN_PERCENTAGE
    SOL_DAILY_PRICE
    SOL_TOKEN_VALUE_USD
    TOTAL_SOL_TOKEN_VALUE_USD
    COMBINED_TOTAL
    Total USD fees (100%)
    One Billion / Total USD fees (100%)
    Total USD fees (100%)/Unique_Signer_Count
    1
    		2025-04-18 09:41:25.000
    3u3pL4F8CnmPEpPFevvuptSVGuAYL2smhnrrZz6wYB79Dr79ti41P9Mw2bPyzZE7pNVfyQJT...
    		TRUEclaimFeeLBUZKhRxPF3XUpBCjp4YzTKgLccjZhTSDM9YuVaPwxo
    {"accounts":["3fg7EyMveAh6TBz22mKaWksNwfvtVsQJfeWVhsxQVuPs","LBUZKhRxPF3...
    {"index":7,"instructions":[{"parsed":{"info":{"authority":"4cJmsA24pqFoU...
    		4cJmsA24pqFoU6eA6DUxmVESHMUwyBjUkTvX98yxNatX459546PAWSxhjTyNJELywYiYTxCN857utnYmWXu7Q59Vgn6ZQSo1111111111111111111111111111111111111111216111.0473610.0161718270.01617182727500937.8450118041662083664.786935155774332137931341712900.4558630.06256545.58636.2565134.012.1671865365075087547.12996737171211.9168412995383448.03610.076950403528278.743472984
    2
    		2025-04-15 05:36:46.000
    4vsBAK2EueviYgGJBps1xKjwFhckdcy2kKwhKgNNPTvJXT2CVh6qN1wac6MtbiRV5ibZG6Pi...
    		TRUEclaimFeeLBUZKhRxPF3XUpBCjp4YzTKgLccjZhTSDM9YuVaPwxo
    {"accounts":["75gHBvcEsZectidmhsWLRvfNmY17tNCW5KNDWscac81s","LBUZKhRxPF3...
    {"index":7,"instructions":[{"parsed":{"info":{"authority":"8r1UMKVbwvVsM...
    		8r1UMKVbwvVsMHanY8osv5F76KSWciiU8RkhEtVUjz234595464StuLHHsHobhBh4BCNhreFtQ5EvSZHvbAMxJ44JWpumpSo111111111111111111111111111111111111111123116.3589690.025805570.0258055727500937.8450118041662083664.786935155774332137931341712900.4558630.06256545.58636.2565128.183.3077579635075087547.12996737171211.9168412995383448.03610.076950403528278.743472984
    3
    		2025-04-15 05:13:52.000
    4Vd5Fxjx787Mz9Cqe1DpmbrgVMhzRrrFjAFx2MdUDa4wnZ1MdDhN3QiaZPtjwpDQU4vS34e5...
    		TRUEclaimFeeLBUZKhRxPF3XUpBCjp4YzTKgLccjZhTSDM9YuVaPwxo
    {"accounts":["75gHBvcEsZectidmhsWLRvfNmY17tNCW5KNDWscac81s","LBUZKhRxPF3...
    {"index":7,"instructions":[{"parsed":{"info":{"authority":"8r1UMKVbwvVsM...
    		8r1UMKVbwvVsMHanY8osv5F76KSWciiU8RkhEtVUjz234595464StuLHHsHobhBh4BCNhreFtQ5EvSZHvbAMxJ44JWpumpSo111111111111111111111111111111111111111122570.3793070.0257436880.02574368827500937.8450118041662083664.786935155774332137931341712900.4558630.06256545.58636.2565128.183.2998259285075087547.12996737171211.9168412995383448.03610.076950403528278.743472984
    4
    		2025-04-15 03:46:26.000
    3WVfmLCj1P2mCRdPz7CeJzxeoL7e1gZHKe2Amy37hSFQMrWr7JqEGyth3F2ZaNLu8kUHVJm2...
    		TRUEclaimFeeLBUZKhRxPF3XUpBCjp4YzTKgLccjZhTSDM9YuVaPwxo
    {"accounts":["75gHBvcEsZectidmhsWLRvfNmY17tNCW5KNDWscac81s","LBUZKhRxPF3...
    {"index":7,"instructions":[{"parsed":{"info":{"authority":"8r1UMKVbwvVsM...
    		8r1UMKVbwvVsMHanY8osv5F76KSWciiU8RkhEtVUjz234595464StuLHHsHobhBh4BCNhreFtQ5EvSZHvbAMxJ44JWpumpSo111111111111111111111111111111111111111122426.4221250.0285784140.02857841427500937.8450118041662083664.786935155774332137931341712900.4558630.06256545.58636.2565128.183.6631811075075087547.12996737171211.9168412995383448.03610.076950403528278.743472984
    5
    		2025-04-15 03:27:03.000
    2j7s93b212tBmoizHCDRFW7S1NMTn6W16H8nkazfiJCr1kfRjZ7UHXWiXsFt15aLgTdLV6ig...
    		TRUEclaimFeeLBUZKhRxPF3XUpBCjp4YzTKgLccjZhTSDM9YuVaPwxo
    {"accounts":["75gHBvcEsZectidmhsWLRvfNmY17tNCW5KNDWscac81s","LBUZKhRxPF3...
    {"index":9,"instructions":[{"parsed":{"info":{"authority":"8r1UMKVbwvVsM...
    		8r1UMKVbwvVsMHanY8osv5F76KSWciiU8RkhEtVUjz23459546So111111111111111111111111111111111111111124StuLHHsHobhBh4BCNhreFtQ5EvSZHvbAMxJ44JWpump0.0344554122346.8647650.03445541227500937.8450118041662083664.786935155774332137931341712900.4558630.06256545.58636.2565128.184.416494715075087547.12996737171211.9168412995383448.03610.076950403528278.743472984
    6
    		2025-04-15 02:50:07.000
    2hy8MPxQiG4vXHrYRDgnnTyEsAbaQznLXyPCaPnL3QqSaJCyn22NrU3YxwKb3swYQMrs8J6Q...
    		TRUEclaimFeeLBUZKhRxPF3XUpBCjp4YzTKgLccjZhTSDM9YuVaPwxo
    {"accounts":["75gHBvcEsZectidmhsWLRvfNmY17tNCW5KNDWscac81s","LBUZKhRxPF3...
    {"index":9,"instructions":[{"parsed":{"info":{"authority":"8r1UMKVbwvVsM...
    		8r1UMKVbwvVsMHanY8osv5F76KSWciiU8RkhEtVUjz23459546So111111111111111111111111111111111111111124StuLHHsHobhBh4BCNhreFtQ5EvSZHvbAMxJ44JWpump0.0337219562693.3037620.03372195627500937.8450118041662083664.786935155774332137931341712900.4558630.06256545.58636.2565128.184.322480325075087547.12996737171211.9168412995383448.03610.076950403528278.743472984
    7
    		2025-04-15 02:08:23.000
    eLfaQspsS1icJnmyuitWqUzwyid7HWFrX5StXL8tTUNvcXKurwuxCDD6ZfSLfGwJ88BdkF18...
    		TRUEclaimFeeLBUZKhRxPF3XUpBCjp4YzTKgLccjZhTSDM9YuVaPwxo
    {"accounts":["75gHBvcEsZectidmhsWLRvfNmY17tNCW5KNDWscac81s","LBUZKhRxPF3...
    {"index":7,"instructions":[{"parsed":{"info":{"authority":"8r1UMKVbwvVsM...
    		8r1UMKVbwvVsMHanY8osv5F76KSWciiU8RkhEtVUjz234595464StuLHHsHobhBh4BCNhreFtQ5EvSZHvbAMxJ44JWpumpSo111111111111111111111111111111111111111122846.3229260.0276784690.02767846927500937.8450118041662083664.786935155774332137931341712900.4558630.06256545.58636.2565128.183.5478261565075087547.12996737171211.9168412995383448.03610.076950403528278.743472984
    8
    		2025-04-15 01:57:37.000
    9cMkpcBSqQNy1BKfHD9VAaAVVriYtJW9qJHAmJ2Y7GqrnvDp2V3L2U6uhkaZZPNjEEWRa238...
    		TRUEclaimFeeLBUZKhRxPF3XUpBCjp4YzTKgLccjZhTSDM9YuVaPwxo
    {"accounts":["75gHBvcEsZectidmhsWLRvfNmY17tNCW5KNDWscac81s","LBUZKhRxPF3...
    {"index":9,"instructions":[{"parsed":{"info":{"authority":"8r1UMKVbwvVsM...
    		8r1UMKVbwvVsMHanY8osv5F76KSWciiU8RkhEtVUjz23459546So111111111111111111111111111111111111111124StuLHHsHobhBh4BCNhreFtQ5EvSZHvbAMxJ44JWpump0.0277978722279.6962180.02779787227500937.8450118041662083664.786935155774332137931341712900.4558630.06256545.58636.2565128.183.5631312335075087547.12996737171211.9168412995383448.03610.076950403528278.743472984
    9
    		2025-04-14 23:46:32.000
    4goL36PYx19Tochc61dfYtxarBVbCoJNWNLCoHXKMRBAGHA1K1mENmzJZ4cCYgVLk7K6bVzL...
    		TRUEclaimFeeLBUZKhRxPF3XUpBCjp4YzTKgLccjZhTSDM9YuVaPwxo
    {"accounts":["75gHBvcEsZectidmhsWLRvfNmY17tNCW5KNDWscac81s","LBUZKhRxPF3...
    {"index":7,"instructions":[{"parsed":{"info":{"authority":"8r1UMKVbwvVsM...
    		8r1UMKVbwvVsMHanY8osv5F76KSWciiU8RkhEtVUjz234595464StuLHHsHobhBh4BCNhreFtQ5EvSZHvbAMxJ44JWpumpSo111111111111111111111111111111111111111122363.4671440.0232788430.02327884327500937.8450118041662083664.786935155774332137931341712900.4558630.06256545.58636.2565129.393.0120494965075087547.12996737171211.9168412995383448.03610.076950403528278.743472984
    10
    		2025-04-14 21:44:32.000
    3Zc55M9GzkJDoFy4LDMxyrv59d3fdR6DzDd7UKGHaggArYMGbrLQqxyZv6RzhjVntWdNXANb...
    		TRUEclaimFeeLBUZKhRxPF3XUpBCjp4YzTKgLccjZhTSDM9YuVaPwxo
    {"accounts":["75gHBvcEsZectidmhsWLRvfNmY17tNCW5KNDWscac81s","LBUZKhRxPF3...
    {"index":7,"instructions":[{"parsed":{"info":{"authority":"8r1UMKVbwvVsM...
    		8r1UMKVbwvVsMHanY8osv5F76KSWciiU8RkhEtVUjz234595464StuLHHsHobhBh4BCNhreFtQ5EvSZHvbAMxJ44JWpumpSo111111111111111111111111111111111111111122085.9677860.0242270360.02422703627500937.8450118041662083664.786935155774332137931341712900.4558630.06256545.58636.2565129.393.1347361885075087547.12996737171211.9168412995383448.03610.076950403528278.743472984
    10
    27KB
    303s