SELECT '0xGrime' as artist, 'Tips' as type, sum(amount) AS SOL, index, tx_to AS receiver FROM solana.core.fact_transfers WHERE block_timestamp :: date >= CURRENT_DATE - 30 AND mint = 'So11111111111111111111111111111111111111112' AND tx_to = '7UzMyKRsuEoYi3RGJciUoTxVCFX2cuPbU9F4UQ6ZB4VL' AND amount <= 14 /* to filter the degen poet sale of a tensorian for 15 SOL*/ AND index = 2 /* tips */ GROUP BY index, receiver UNION SELECT '0xGrime' as artist, 'Royalties' as type, sum(amount) AS SOL, index, tx_to AS receiver FROM solana.core.fact_transfers WHERE block_timestamp :: date >= CURRENT_DATE - 30 AND mint = 'So11111111111111111111111111111111111111112' AND tx_to = '7UzMyKRsuEoYi3RGJciUoTxVCFX2cuPbU9F4UQ6ZB4VL' AND amount <= 14 /* to filter the degen poet sale of a tensorian for 15 SOL*/ AND index = 2.8 /* royalties */ GROUP BY index, receiver UNION SELECT '0xstoek' as artist, 'Tips' as type, sum(amount) AS SOL, index, tx_to AS receiver FROM solana.core.fact_transfers WHERE block_timestamp :: date >= CURRENT_DATE - 30 AND mint = 'So11111111111111111111111111111111111111112' AND tx_to = '6sYxGBdpzfABtHRrHERFvS92y9yv4Sxwo8EFCvjU2vv7' AND amount <= 14 /* to filter the degen poet sale of a tensorian for 15 SOL*/ AND index = 2 /* tips */ GROUP BY index, receiver UNION SELECT '0xstoek' as artist, 'Royalties' as type, sum(amount) AS SOL, index, tx_to AS receiver FROM solana.core.fact_transfers WHERE block_timestamp :: date >= CURRENT_DATE - 30 AND mint = 'So11111111111111111111111111111111111111112' AND tx_to = '6sYxGBdpzfABtHRrHERFvS92y9yv4Sxwo8EFCvjU2vv7' AND amount <= 14 /* to filter the degen poet sale of a tensorian for 15 SOL*/ AND index = 2.8 /* royalties */ GROUP BY index, receiver UNION SELECT 'Andrew Mason' as artist, 'Tips' as type, sum(amount) AS SOL, index, tx_to AS receiver FROM solana.core.fact_transfers WHERE block_timestamp :: date >= CURRENT_DATE - 30 AND mint = 'So11111111111111111111111111111111111111112' AND tx_to = 'ERpxtwaZd6Ee2WD2vRxzhVXj1kaYdPA4xmwEvavX5iMy' AND amount <= 14 /* to filter the degen poet sale of a tensorian for 15 SOL*/ AND index = 2 /* tips */ GROUP BY index, receiver UNION SELECT 'Andrew Mason' as artist, 'Royalties' as type, sum(amount) AS SOL, index, tx_to AS receiver FROM solana.core.fact_transfers WHERE block_timestamp :: date >= CURRENT_DATE - 30 AND mint = 'So11111111111111111111111111111111111111112' AND tx_to = 'ERpxtwaZd6Ee2WD2vRxzhVXj1kaYdPA4xmwEvavX5iMy' AND amount <= 14 /* to filter the degen poet sale of a tensorian for 15 SOL*/ AND index = 2.8 /* royalties */ GROUP BY index, receiver UNION SELECT 'Bangerz' as artist, 'Tips' as type, sum(amount) AS SOL, index, tx_to AS receiver FROM solana.core.fact_transfers WHERE block_timestamp :: date >= CURRENT_DATE - 30 AND mint = 'So11111111111111111111111111111111111111112' AND tx_to = '3utDDwsPDUSqDRDBKuLXgnaKbdimvaGtLHFauCwH5YAy' AND amount <= 14 /* to filter the degen poet sale of a tensorian for 15 SOL*/ AND index = 2 /* tips */ GROUP BY index, receiver UNION SELECT 'Bangerz' as artist, 'Royalties' as type, sum(amount) AS SOL, index, tx_to AS receiver FROM solana.core.fact_transfers WHERE block_timestamp :: date >= CURRENT_DATE - 30 AND mint = 'So11111111111111111111111111111111111111112' AND tx_to = '3utDDwsPDUSqDRDBKuLXgnaKbdimvaGtLHFauCwH5YAy' AND amount <= 14 /* to filter the degen poet sale of a tensorian for 15 SOL*/ AND index = 2.8 /* royalties */ GROUP BY index, receiver UNION SELECT 'FourSixSix' as artist, 'Tips' as type, sum(amount) AS SOL, index, tx_to AS receiver FROM solana.core.fact_transfers WHERE block_timestamp :: date >= CURRENT_DATE - 30 AND mint = 'So11111111111111111111111111111111111111112' AND tx_to = '7Ph3bdzuCYsowQ1Zsc1aS9vjjuaoYKdWiv6ngSQdLB8F' AND amount <= 14 /* to filter the degen poet sale of a tensorian for 15 SOL*/ AND index = 2 /* tips */ GROUP BY index, receiver UNION SELECT 'FourSixSix' as artist, 'Royalties' as type, sum(amount) AS SOL, index, tx_to AS receiver FROM solana.core.fact_transfers WHERE block_timestamp :: date >= CURRENT_DATE - 30 AND mint = 'So11111111111111111111111111111111111111112' AND tx_to = 'DByZdxzFNC6nMi9XA6oTezKucayYyZ3MeWQR5tdbSEgz' AND amount <= 14 /* to filter the degen poet sale of a tensorian for 15 SOL*/ AND index = 2.8 /* royalties */ GROUP BY index, receiver UNION SELECT 'DAA' as artist, 'Tips' as type, sum(amount) AS SOL, index, tx_to AS receiver FROM solana.core.fact_transfers WHERE block_timestamp :: date >= CURRENT_DATE - 30 AND mint = 'So11111111111111111111111111111111111111112' AND tx_to = '8vzgGYxDHS5JVeR6rvmpBWF3uQYmvDrqH6QoajwgLR35' AND amount <= 14 /* to filter the degen poet sale of a tensorian for 15 SOL*/ AND index = 2 /* tips */ GROUP BY index, receiver UNION SELECT 'DAA' as artist, 'Royalties' as type, sum(amount) AS SOL, index, tx_to AS receiver FROM solana.core.fact_transfers WHERE block_timestamp :: date >= CURRENT_DATE - 30 AND mint = 'So11111111111111111111111111111111111111112' AND tx_to = '8vzgGYxDHS5JVeR6rvmpBWF3uQYmvDrqH6QoajwgLR35' AND amount <= 14 /* to filter the degen poet sale of a tensorian for 15 SOL*/ AND index = 2.8 /* royalties */ GROUP BY index, receiver UNION SELECT 'Degen Poet' as artist, 'Tips' as type, sum(amount) AS SOL, index, tx_to AS receiver FROM solana.core.fact_transfers WHERE block_timestamp :: date >= CURRENT_DATE - 30 AND mint = 'So11111111111111111111111111111111111111112' AND tx_to = 'ART5dr4bDic2sQVZoFheEmUxwQq5VGSx9he7JxHcXNQD' AND amount <= 14 /* to filter the degen poet sale of a tensorian for 15 SOL*/ AND index = 2 /* tips */ GROUP BY index, receiver UNION SELECT 'Degen Poet' as artist, 'Royalties' as type, sum(amount) AS SOL, index, tx_to AS receiver FROM solana.core.fact_transfers WHERE block_timestamp :: date >= CURRENT_DATE - 30 AND mint = 'So11111111111111111111111111111111111111112' AND tx_to = 'ART5dr4bDic2sQVZoFheEmUxwQq5VGSx9he7JxHcXNQD' AND amount <= 14 /* to filter the degen poet sale of a tensorian for 15 SOL*/ AND index = 2.8 /* royalties */ GROUP BY index, receiver UNION SELECT 'Jakey' as artist, 'Tips' as type, sum(amount) AS SOL, index, tx_to AS receiver FROM solana.core.fact_transfers WHERE block_timestamp :: date >= CURRENT_DATE - 30 AND mint = 'So11111111111111111111111111111111111111112' AND tx_to = '6QFmUMjs4RX8cmq11tD72UD8stkCzgaJopUkiib4NLXh' AND amount <= 14 /* to filter the degen poet sale of a tensorian for 15 SOL*/ AND index = 2 /* tips */ GROUP BY index, receiver UNION SELECT 'Jakey' as artist, 'Royalties' as type, sum(amount) AS SOL, index, tx_to AS receiver FROM solana.core.fact_transfers WHERE block_timestamp :: date >= CURRENT_DATE - 30 AND mint = 'So11111111111111111111111111111111111111112' AND tx_to = '6QFmUMjs4RX8cmq11tD72UD8stkCzgaJopUkiib4NLXh' AND amount <= 14 /* to filter the degen poet sale of a tensorian for 15 SOL*/ AND index = 2.8 /* royalties */ GROUP BY index, receiver UNION SELECT 'Madhouse' as artist, 'Tips' as type, sum(amount) AS SOL, index, tx_to AS receiver FROM solana.core.fact_transfers WHERE block_timestamp :: date >= CURRENT_DATE - 30 AND mint = 'So11111111111111111111111111111111111111112' AND tx_to = '7EQtcFSorgqFKNrdFi82DLSYq535zXGyQzSV1zQZ2c3Y' AND amount <= 14 /* to filter the degen poet sale of a tensorian for 15 SOL*/ AND index = 2 /* tips */ GROUP BY index, receiver UNION SELECT 'Madhouse' as artist, 'Royalties' as type, sum(amount) AS SOL, index, tx_to AS receiver FROM solana.core.fact_transfers WHERE block_timestamp :: date >= CURRENT_DATE - 30 AND mint = 'So11111111111111111111111111111111111111112' AND tx_to = 's8t8hCF4XqTd9pNgBgTQvfgfxrHFoxg5QtxSgsxZP9B' AND amount <= 14 /* to filter the degen poet sale of a tensorian for 15 SOL*/ AND index = 2.8 /* royalties */ GROUP BY index, receiver UNION SELECT 'Maquin' as artist, 'Tips' as type, sum(amount) AS SOL, index, tx_to AS receiver FROM solana.core.fact_transfers WHERE block_timestamp :: date >= CURRENT_DATE - 30 AND mint = 'So11111111111111111111111111111111111111112' AND tx_to = '8qqTnXzimeWpUD9ZR6txXEYn3XMj8brkc92FuKRfNeLD' AND amount <= 14 /* to filter the degen poet sale of a tensorian for 15 SOL*/ AND index = 2 /* tips */ GROUP BY index, receiver UNION SELECT 'Maquin' as artist, 'Royalties' as type, sum(amount) AS SOL, index, tx_to AS receiver FROM solana.core.fact_transfers WHERE block_timestamp :: date >= CURRENT_DATE - 30 AND mint = 'So11111111111111111111111111111111111111112' AND tx_to = '3hHmXL5CBZ4fMNFvpCAJhYH6wK8heiBfLm4y7kf727QQ' AND amount <= 14 /* to filter the degen poet sale of a tensorian for 15 SOL*/ AND index = 2.8 /* royalties */ GROUP BY index, receiver UNION SELECT 'NFNC' as artist, 'Tips' as type, sum(amount) AS SOL, index, tx_to AS receiver FROM solana.core.fact_transfers WHERE block_timestamp :: date >= CURRENT_DATE - 30 AND mint = 'So11111111111111111111111111111111111111112' AND tx_to = '6Kh1QKrGUGVW6iCpSA4KhqF7omhY4h57hgj4VACE6As7' AND amount <= 14 /* to filter the degen poet sale of a tensorian for 15 SOL*/ AND index = 2 /* tips */ GROUP BY index, receiver UNION SELECT 'NFNC' as artist, 'Royalties' as type, sum(amount) AS SOL, index, tx_to AS receiver FROM solana.core.fact_transfers WHERE block_timestamp :: date >= CURRENT_DATE - 30 AND mint = 'So11111111111111111111111111111111111111112' AND tx_to = '6Kh1QKrGUGVW6iCpSA4KhqF7omhY4h57hgj4VACE6As7' AND amount <= 14 /* to filter the degen poet sale of a tensorian for 15 SOL*/ AND index = 2.8 /* royalties */ GROUP BY index, receiver UNION SELECT 'Tiiiny Denise' as artist, 'Tips' as type, sum(amount) AS SOL, index, tx_to AS receiver FROM solana.core.fact_transfers WHERE block_timestamp :: date >= CURRENT_DATE - 30 AND mint = 'So11111111111111111111111111111111111111112' AND tx_to = 'DsSqaaKvuzkexQophftgPJqZqVi3Ki7VQcpGSwnXe9WZ' AND amount <= 14 /* to filter the degen poet sale of a tensorian for 15 SOL*/ AND index = 2 /* tips */ GROUP BY index, receiver UNION SELECT 'Tiiiny Denise' as artist, 'Royalties' as type, sum(amount) AS SOL, index, tx_to AS receiver FROM solana.core.fact_transfers WHERE block_timestamp :: date >= CURRENT_DATE - 30 AND mint = 'So11111111111111111111111111111111111111112' AND tx_to = '5y3VpFwFyaBjTkQJNbrm4bhbrsbdurviu4XLtuFsztog' AND amount <= 14 /* to filter the degen poet sale of a tensorian for 15 SOL*/ AND index = 2.8 /* royalties */ GROUP BY index, receiver

SOL earned by DRiP artists