Top Vector Earners

0xgabeTop Vector Earners

Updated 2025-02-12

-- forked from jackguy / Vector 1 copy @ https://flipsidecrypto.xyz/jackguy/q/R0VmRUaK1sd0/vector-1-copy

-- with tab1 as (

-- SELECT

-- DISTINCT tx_id

-- from solana.core.fact_events

-- where program_id like 'VFeesufQJnGunv2kBXDYnThT1CoAYB45U31qGDe5QjU'

-- and block_timestamp > '2024-09-01'

-- and SUCCEEDED

-- )

-- SELECT *

-- FROM (

-- SELECT

-- date_trunc('day', block_timestamp) as date,

-- count(DISTINCT tx_id) as events,

-- count(DISTINCT swapper) as swappers,

-- sum(

-- case when not SWAP_FROM_AMOUNT_USD is null then SWAP_FROM_AMOUNT_USD

-- when not SWAP_to_AMOUNT_USD is null then SWAP_to_AMOUNT_USD else 0 end

-- ) AS SWAP_VOLUME_USD,

-- swap_volume_usd * 0.01 as fees_usd

-- from solana.defi.ez_dex_swaps

-- where tx_id in (SELECT * from tab1)

-- and block_timestamp > '2024-09-01'

-- GROUP BY 1

-- )

-- where date > '2024-09-01'

-- treasury wallet EkM9LuFxS1RfXbGrUf46kSZPP9dHV75G3vbvpi7sjFtV

-- team wallet 9VaTAuXjAWkc99cQAxy4r4E5624LST7pPAaDnn3owLDQ

with top_earners as (SELECT

tx_to as earners,

SUM(amount) as total_sol_earned

QueryRunArchived: QueryRun has been archived