Query: portals join tokens and transactions by Paulo Sousa

1select tokens.*, withdraws.* EXCLUDE (key, symbol, year, month, day)
2from @portals.tokens.tokens tokens
3     INNER JOIN @portals.transactions.withdraws withdraws ON (withdraws.key = tokens.key)
4limit 10

key	name	decimals	symbol	price	address	platform	network	updatedat	createdat	tokens	liquidity	image	tokenid	totalsupply	addresses_ethereum	metrics_volumeusd1d	addresses_bsc	addresses_avalanche	addresses_base	addresses_arbitrum	addresses_optimism	addresses_polygon	addresses_fantom	addresses_gnosis	images	pooladdress	metrics_apy	metrics_baseapy	metrics_volumeusd7d	metadata_tags	reserves	metrics_stakedapy	pricepershare	addresses_fraxtal	metadata_description	metadata_redemptionvault	metadata_marketaddress	metadata_expiry	metadata_expired	year	month	day	hour	transactionhash	amount	time
arbitrum:0x186cf879186986a20aadfb7ead50e3c20cb26cec	2BTC-ng	18	2BTC-ng	100257.89888136569	0x186cf879186986a20aadfb7ead50e3c20cb26cec	curve	arbitrum	2024-12-13 14:18:35.326+00	2024-06-20 10:45:09.475+00	['0x2f2a2543b76a4166549f7aab2e75bef0aefc5b0f', '0x6c84a8f1c29108f47a79964b5fe888d4f4d0de40']	6493602.5217412785	nan	09ef6f3e-dba8-4cfc-9e7f-e783c1bfb3a1	64.76898672517666	nan	67490.49	nan	nan	nan	0x186cf879186986a20aadfb7ead50e3c20cb26cec	nan	nan	nan	nan	['https://assets.coingecko.com/coins/images/12124/large/Curve.png', 'https://assets.coingecko.com/coins/images/7598/large/wrapped_bitcoin_wbtc.png?1696507857', 'https://assets.coingecko.com/coins/images/11224/large/0x18084fba666a33d37592fa2633fd49a74dd93a88.png?1696511155']	0x186cf879186986a20aadfb7ead50e3c20cb26cec	0.4	0.4	1177107.79	['#pool']	['32.79314784', '32.161252870290872056']	null	null	nan	nan	nan	nan	null	nan	2024	12	13	14	0xdc29f11cc8a775df6e645903f9cad673634962c6531302a8173a94eb64b3e7e9	0.00034507557811249	2024-12-20 08:36:47+00
optimism:0x3e29d3a9316dab217754d13b28646b76607c5f04	Alchemix ETH	18	ALETH	3805.92	0x3e29d3a9316dab217754d13b28646b76607c5f04	basic	optimism	2024-12-13 14:18:20.494+00	2023-10-12 14:08:09.479+00	[]	173265902	https://assets.coingecko.com/coins/images/16271/large/aleth.png?1696515869	8b633350-93db-42b7-a490-6b016fccbea7	45525.41883634801	0x0100546f2cd4c9d97f798ffc9755e47865ff7ee6	1151989.2123453964	nan	nan	nan	nan	0x3e29d3a9316dab217754d13b28646b76607c5f04	nan	nan	nan	nan	nan	null	null	null	nan	nan	null	null	nan	nan	nan	nan	null	nan	2024	12	13	14	0x9463430315b22a3883cb6a85409402ace2f680dac1213591b19a55903b01711e	0.001399323308491001	2025-03-03 02:15:45+00
base:0x1dd2d631c92b1acdfcdd51a0f7145a50130050c4	AlienBase	18	ALB	0.390201	0x1dd2d631c92b1acdfcdd51a0f7145a50130050c4	basic	base	2024-12-13 14:18:20.494+00	2023-10-12 14:08:09.479+00	[]	46170676	https://assets.coingecko.com/coins/images/31301/large/alb_token.jpg?1696530121	0d66022b-f5a0-48bf-8d09-f2dfdaeee31f	347020748.5763149	nan	969156.4027782346	nan	nan	0x1dd2d631c92b1acdfcdd51a0f7145a50130050c4	nan	nan	nan	nan	nan	nan	nan	null	null	null	nan	nan	null	null	nan	nan	nan	nan	null	nan	2024	12	13	14	0x7958fe9a274a74ba575329ed2ea053bd5c5e03eccd1cb4d095748a3b0be22f5c	1838.702510645579	2025-01-22 05:01:59+00
base:0x393893caeb06b5c16728bb1e354b6c36942b1382	Arcadia V2 Senior Wrapped Ether	18	srarcV2WETH	4095.61462258875	0x393893caeb06b5c16728bb1e354b6c36942b1382	arcadia-v2	base	2024-12-13 14:18:28.571+00	2024-09-17 07:58:23.292+00	['0x4200000000000000000000000000000000000006']	3057706.987886199	nan	e7345bc4-9aa9-40dc-b3dd-880f6d8bdbb1	746.5807380952966	nan	-31150.901294348274	nan	nan	0x393893caeb06b5c16728bb1e354b6c36942b1382	nan	nan	nan	nan	nan	['https://icons.llamao.fi/icons/protocols/arcadia-v2', 'https://coin-images.coingecko.com/coins/images/39810/large/weth.png?1724139790']	0x803ea69c7e87d1d6c86adeb40cb636cc0e6b98e2	1.459	1.459	16651.522846593012	['#yield']	['778.490171927418542611']	null	1.042740767614137	nan	nan	nan	nan	null	nan	2024	12	13	14	0x8852a6b639461508876f852bf0af8de0b42a2c5b3d322dac494a56a70d29a9a1	0.011481849753162842	2025-01-28 17:15:21+00
ethereum:0x3ee8862c3920d6d3b78baf633d5277f5547752ae	Balancer 50rETH-50RPL Aura Deposit	18	aura50rETH-50RPL	265.0908241913005	0x3ee8862c3920d6d3b78baf633d5277f5547752ae	aura	ethereum	2024-12-13 14:18:25.009+00	2024-02-29 09:09:04.635+00	['0x9f9d900462492d4c21e9523ca95a7cd86142f298']	237714.12481928247	nan	ad4e41ed-6f5a-4a5e-9b3d-31ad4ec3f7d8	896.7270954944036	0x3ee8862c3920d6d3b78baf633d5277f5547752ae	0	nan	nan	nan	nan	nan	nan	nan	nan	['https://assets.coingecko.com/coins/images/25942/large/logo.png', 'https://assets.coingecko.com/coins/images/2090/large/rocket_pool_%28RPL%29.png?1696503058', 'https://assets.coingecko.com/coins/images/20764/large/reth.png?1696520159']	0x4b9f8f3ca7443f1ebcd959d9bf169a4f03f12eaf	166.521	166.521	20160.343949586717	['#yield']	nan	null	null	nan	nan	nan	nan	null	nan	2024	12	13	14	0x232847683437c971aa814aef29921eb05cfe1a9ae412953d341f8fa61250a9f7	200.74870322389367	2024-12-27 01:49:59+00
fraxtal:0x7edca1457aaeacebb2bcbfc3f1c6683ac4a05af4	Balancer sFRAX/FRAX	18	sFRAX/FRAX	1.0192552764584017	0x7edca1457aaeacebb2bcbfc3f1c6683ac4a05af4	balancerv2boosted	fraxtal	2024-12-13 14:18:29.266+00	2024-12-09 15:14:27.323+00	['0xfc00000000000000000000000000000000000001', '0xfc00000000000000000000000000000000000008']	648.9269360988028	nan	421b3d3f-c0c4-4bb2-8f48-af4224bf6bcd	636.6677230787799	nan	null	nan	nan	nan	nan	nan	nan	nan	nan	['https://assets.coingecko.com/coins/images/11683/large/Balancer.png?', 'https://coin-images.coingecko.com/coins/images/35847/large/frax.png?1709894380', 'https://coin-images.coingecko.com/coins/images/51387/large/sFRAX.JPEG?1730985861']	nan	null	null	null	['#pool']	['2596148429267406.618579371320893796', '321.48810030787484295', '298.998591271150042947']	null	null	0x7edca1457aaeacebb2bcbfc3f1c6683ac4a05af4	nan	nan	nan	null	nan	2024	12	13	14	0x79290f2461e11318288e159ee2032c303353b1fec49e6bc8a6b556e11ca69b86	0.9940900764658903	2025-04-17 14:55:43+00
arbitrum:0x186cf879186986a20aadfb7ead50e3c20cb26cec	2BTC-ng	18	2BTC-ng	100257.89888136569	0x186cf879186986a20aadfb7ead50e3c20cb26cec	curve	arbitrum	2024-12-13 14:18:35.326+00	2024-06-20 10:45:09.475+00	['0x2f2a2543b76a4166549f7aab2e75bef0aefc5b0f', '0x6c84a8f1c29108f47a79964b5fe888d4f4d0de40']	6493602.5217412785	nan	09ef6f3e-dba8-4cfc-9e7f-e783c1bfb3a1	64.76898672517666	nan	67490.49	nan	nan	nan	0x186cf879186986a20aadfb7ead50e3c20cb26cec	nan	nan	nan	nan	['https://assets.coingecko.com/coins/images/12124/large/Curve.png', 'https://assets.coingecko.com/coins/images/7598/large/wrapped_bitcoin_wbtc.png?1696507857', 'https://assets.coingecko.com/coins/images/11224/large/0x18084fba666a33d37592fa2633fd49a74dd93a88.png?1696511155']	0x186cf879186986a20aadfb7ead50e3c20cb26cec	0.4	0.4	1177107.79	['#pool']	['32.79314784', '32.161252870290872056']	null	null	nan	nan	nan	nan	null	nan	2024	12	13	14	0xa11b8606b85909d049c1f68ee1856f10e7af58247f3b1f15899d1daedffa2e9c	0.10002810754041158	2024-12-19 17:33:24+00
optimism:0x3e29d3a9316dab217754d13b28646b76607c5f04	Alchemix ETH	18	ALETH	3805.92	0x3e29d3a9316dab217754d13b28646b76607c5f04	basic	optimism	2024-12-13 14:18:20.494+00	2023-10-12 14:08:09.479+00	[]	173265902	https://assets.coingecko.com/coins/images/16271/large/aleth.png?1696515869	8b633350-93db-42b7-a490-6b016fccbea7	45525.41883634801	0x0100546f2cd4c9d97f798ffc9755e47865ff7ee6	1151989.2123453964	nan	nan	nan	nan	0x3e29d3a9316dab217754d13b28646b76607c5f04	nan	nan	nan	nan	nan	null	null	null	nan	nan	null	null	nan	nan	nan	nan	null	nan	2024	12	13	14	0xded1708525c694a8265af81aed3c90099e4115148831338a3a4f6e2eba90cdd6	0.004768687641114706	2025-04-26 08:27:23+00
base:0x1dd2d631c92b1acdfcdd51a0f7145a50130050c4	AlienBase	18	ALB	0.390201	0x1dd2d631c92b1acdfcdd51a0f7145a50130050c4	basic	base	2024-12-13 14:18:20.494+00	2023-10-12 14:08:09.479+00	[]	46170676	https://assets.coingecko.com/coins/images/31301/large/alb_token.jpg?1696530121	0d66022b-f5a0-48bf-8d09-f2dfdaeee31f	347020748.5763149	nan	969156.4027782346	nan	nan	0x1dd2d631c92b1acdfcdd51a0f7145a50130050c4	nan	nan	nan	nan	nan	nan	nan	null	null	null	nan	nan	null	null	nan	nan	nan	nan	null	nan	2024	12	13	14	0xb8d217ed54ebd7346770bc9a5dea9840f9dedab33025406446cfb584982f2b24	897.7060189246062	2025-01-17 13:08:39+00
base:0x393893caeb06b5c16728bb1e354b6c36942b1382	Arcadia V2 Senior Wrapped Ether	18	srarcV2WETH	4095.61462258875	0x393893caeb06b5c16728bb1e354b6c36942b1382	arcadia-v2	base	2024-12-13 14:18:28.571+00	2024-09-17 07:58:23.292+00	['0x4200000000000000000000000000000000000006']	3057706.987886199	nan	e7345bc4-9aa9-40dc-b3dd-880f6d8bdbb1	746.5807380952966	nan	-31150.901294348274	nan	nan	0x393893caeb06b5c16728bb1e354b6c36942b1382	nan	nan	nan	nan	nan	['https://icons.llamao.fi/icons/protocols/arcadia-v2', 'https://coin-images.coingecko.com/coins/images/39810/large/weth.png?1724139790']	0x803ea69c7e87d1d6c86adeb40cb636cc0e6b98e2	1.459	1.459	16651.522846593012	['#yield']	['778.490171927418542611']	null	1.042740767614137	nan	nan	nan	nan	null	nan	2024	12	13	14	0xa2af32e314ad1308e508a6bfdfa17e7bff5da68a398a247080ff0ad7852192e6	0.009566415201479444	2025-01-29 11:15:03+00