-- forked from Flipside Treasury Payments @ https://flipsidecrypto.xyz/edit/queries/c6354886-4c39-4d2f-952d-f7e0522828bd -- FLOW SELECT DISTINCT recipient as paid_user_wallet FROM flow.core.ez_token_transfers WHERE sender IN ( '0x4fca974d4658d42b', '0x9bd48bb0f0c0fe48', '0x92a125bdd1dc6964' ) AND recipient NOT IN ( '0x4fca974d4658d42b', '09bd48bb0f0c0fe48', '0x92a125bdd1dc6964' ) AND block_timestamp :: date >= '2023-01-01' AND block_timestamp :: date <= '2023-03-31' AND tx_succeeded UNION -- ETH mainnet SELECT DISTINCT to_address as paid_user_wallet FROM ethereum.core.ez_token_transfers WHERE from_address IN (LOWER('0xC2f41b3a1FF28Fd2A6EeE76EE12e51482fcFd11F'), LOWER('0x4faFB87de15cFf7448bD0658112F4e4B0d53332c')) AND to_address NOT IN (LOWER('0xC2f41b3a1FF28Fd2A6EeE76EE12e51482fcFd11F'), LOWER('0x4faFB87de15cFf7448bD0658112F4e4B0d53332c')) AND block_timestamp :: date >= '2023-01-01' AND block_timestamp :: date <= '2023-03-31' UNION -- AVAX SELECT DISTINCT avax_to_address as paid_wallet_address FROM avalanche.core.ez_avax_transfers WHERE avax_from_address IN (LOWER('0xC2f41b3a1FF28Fd2A6EeE76EE12e51482fcFd11F'), LOWER('0xeD639298998518cCb0405ea675A6198048de4fE3')) AND block_timestamp :: date >= '2023-01-01' AND block_timestamp :: date <= '2023-03-31' UNION -- Axelar SELECT DISTINCT receiver as paid_user_wallet FROM axelar.core.fact_transfers WHERE sender IN ('axelar1cvmw32achlrv8fh0ffyhsyuu4f8lwpzsmxwlnt', 'axelar1ggewp0sdcpcpv87qwfyzm03exkhfmgld88dgpu') AND receiver NOT IN ('axelar1cvmw32achlrv8fh0ffyhsyuu4f8lwpzsmxwlnt', 'axelar1ggewp0sdcpcpv87qwfyzm03exkhfmgld88dgpu') AND block_timestamp :: date >= '2023-01-01' AND block_timestamp :: date <= '2023-03-31' UNION -- NEAR SELECT DISTINCT tx_receiver as paid_user_wallet FROM near.core.fact_transfers WHERE tx_signer IN ('426f0f2383edcb4780b12f509a3731e02a9df32211fe4da8e698e6225fdee383', '79501b068d4fcbbcea3e7c332891a7d8abfd9864657b9c2cc3c18c944b1db558') AND tx_receiver NOT IN ('426f0f2383edcb4780b12f509a3731e02a9df32211fe4da8e698e6225fdee383', '79501b068d4fcbbcea3e7c332891a7d8abfd9864657b9c2cc3c18c944b1db558') AND block_timestamp :: date >= '2023-01-01' AND block_timestamp :: date <= '2023-03-31' AND status UNION -- Osmosis SELECT DISTINCT receiver as paid_user_wallet FROM osmosis.core.fact_transfers WHERE sender IN ('osmo1cvmw32achlrv8fh0ffyhsyuu4f8lwpzshnt8wc', 'osmo1ggewp0sdcpcpv87qwfyzm03exkhfmgldtjgsu0', 'osmo1ljll6ewqtngm5je40q8pgzxc8j9yvhkssuh2ey') AND receiver NOT IN ('osmo1cvmw32achlrv8fh0ffyhsyuu4f8lwpzshnt8wc', 'osmo1ggewp0sdcpcpv87qwfyzm03exkhfmgldtjgsu0', 'osmo1ljll6ewqtngm5je40q8pgzxc8j9yvhkssuh2ey') AND block_timestamp :: date >= '2023-01-01' AND block_timestamp :: date <= '2023-03-31' AND tx_succeeded UNION -- Polygon SELECT DISTINCT to_address as paid_user_address FROM polygon.core.fact_token_transfers WHERE from_address IN (LOWER('0xC2f41b3a1FF28Fd2A6EeE76EE12e51482fcFd11F'), LOWER('0x22AF3aC7Ce20441220C6AeC524854DE03150A4d7')) AND to_address NOT IN (LOWER('0xC2f41b3a1FF28Fd2A6EeE76EE12e51482fcFd11F'), LOWER('0x22AF3aC7Ce20441220C6AeC524854DE03150A4d7')) AND block_timestamp :: date >= '2023-01-01' AND block_timestamp :: date <= '2023-03-31' UNION -- Thorchain SELECT DISTINCT to_address as paid_user_address FROM thorchain.core.fact_transfers WHERE from_address IN ('thor12vcn44pdlqzpvm9kr2d4a245jfsg7ufmfr04g9', 'thor1wg6ua25qqvdxz6kqt5paetx7qn3dphnemld7se') AND to_address NOT IN ('thor12vcn44pdlqzpvm9kr2d4a245jfsg7ufmfr04g9', 'thor1wg6ua25qqvdxz6kqt5paetx7qn3dphnemld7se') AND block_timestamp :: date >= '2023-01-01' AND block_timestamp :: date <= '2023-03-31' UNION -- Solana SELECT DISTINCT tx_to FROM solana.core.fact_transfers WHERE block_timestamp :: date >= '2023-01-01' AND block_timestamp :: date <= '2023-03-31' AND tx_from IN ('DwEAXyPRtEJyxtWNCStsfd2sVabzTXmRDzE1Sv6cyjcU', 'FPDwXFUzHYh3uBh68jPZyyvFCoqcGktMX9MTSZPixqkB') AND tx_to NOT IN ('DwEAXyPRtEJyxtWNCStsfd2sVabzTXmRDzE1Sv6cyjcU', 'FPDwXFUzHYh3uBh68jPZyyvFCoqcGktMX9MTSZPixqkB') UNION -- Terra SELECT DISTINCT receiver as paid_user_address FROM terra.core.ez_transfers WHERE block_timestamp :: date >= '2023-01-01' AND block_timestamp :: date <= '2023-03-01' AND sender in ('terra1v0yhsvk9gzwglu27c02md9z9kmg0vqgrf4q433', 'terra1tu5z28h9ssattvsltlzt5c8r2mvs2006qvq3tvjk5c8fxve85xss84w8vr') AND receiver NOT IN ('terra1v0yhsvk9gzwglu27c02md9z9kmg0vqgrf4q433', 'terra1tu5z28h9ssattvsltlzt5c8r2mvs2006qvq3tvjk5c8fxve85xss84w8vr')

Query	Creator	Created
Flipside Treasury Payments Q1 2023 terra thorchain flow axelar near	jkhuhnke11	Jun 1, 2023
number of liquidity providers terra ibc	jkhuhnke11	Jun 8, 2023
Swap Volume terra ibc	jkhuhnke11	Jun 8, 2023
On-Chain Interactions terra ibc	jkhuhnke11	Jun 8, 2023
Flipside Treasury Payments terra thorchain flow axelar near	jkhuhnke11	Jun 1, 2023

jkhuhnke11