Query editor
WITH rng AS (SELECT CAST(CURRENT_DATE - INTERVAL '90' DAY AS TIMESTAMP) AS ts_start, CAST(CURRENT_TIMESTAMP AS TIMESTAMP) AS ts_end),sol_price AS (SELECT minute, priceFROM prices.usdCROSS JOIN rngWHERE blockchain = 'solana'AND symbol = 'SOL'AND minute BETWEEN ts_start AND ts_end),fee_raw AS (SELECT tx_id, 'gmgn' AS src, 'SOL' AS token, balance_change / 1e9 AS fee_amtFROM solana.account_activityCROSS JOIN rngWHERE tx_successAND address = 'BB5dnY55FXS1e1NXqZDwCzgdYJdMCj3B92PU6Q5Fb6DT'AND balance_change > 0AND block_time BETWEEN ts_start AND ts_endUNION ALLSELECT tx_id, 'bullx' AS src, 'SOL' AS token, balance_change / 1e9 AS fee_amtFROM solana.account_activityCROSS JOIN rngWHERE tx_successAND ((address = 'F4hJ3Ee3c5UuaorKAMfELBjYCjiiLH75haZTKqTywRP3' AND block_time <= TIMESTAMP '2024-11-18')OR (address = '9RYJ3qr5eU5xAooqVcbmdeusjcViL5Nkiq7Gske3tiKq' AND block_time >= TIMESTAMP '2024-11-16'))AND balance_change > 0AND block_time BETWEEN ts_start AND ts_endUNION ALLSELECT tx_id, 'photon' AS src, 'SOL' AS token, balance_change / 1e9 AS fee_amtFROM solana.account_activityCROSS JOIN rngWHERE tx_successAND address = 'AVUCZyuT35YSuj4RH7fwiyPu82Djn2Hfg7y2ND2XcnZH'AND balance_change > 0AND balance_change < 1e12AND block_time BETWEEN ts_start AND ts_endUNION ALLSELECT tx_id, 'moonshot' AS src, 'USDC' AS token, amount / 1e6 AS fee_amtFROM tokens_solana.transfersCROSS JOIN rngWHERE block_time BETWEEN ts_start AND ts_endAND to_owner = '5wkyL2FLEcyUUgc3UeGntHTAfWfzDrVuxMnaMm7792Gk'AND token_mint_address = 'EPjFWdd5AufqSSqeM2qN1xzybapC8G4wEGGkZwyTDt1v'UNION ALLSELECT tx_id, 'moonshot' AS src, 'SOL' AS token, balance_change / 1e9 AS fee_amtFROM solana.account_activityCROSS JOIN rngWHERE block_time BETWEEN ts_start AND ts_endAND address = '5wkyL2FLEcyUUgc3UeGntHTAfWfzDrVuxMnaMm7792Gk'AND balance_change > 0AND balance_change < 1e12AND tx_successUNION ALLSELECT tx_id, 'vector' AS src, 'SOL' AS token, balance_change / 1e9 AS fee_amtFROM solana.account_activityCROSS JOIN rngWHERE tx_success