with
liquid_staking_platform_cte as (
select
value:platform platform
, value:contract_address contract_address
from table(flatten(input => parse_json(
'
[
{
"platform": "Lido",
"contract_address": "0xae7ab96520de3a18e5e111b5eaab095312d7fe84"
},
{
"platform": "Stakewise",
"contract_address": "0xc874b064f465bdd6411d45734b56fac750cda29a"
},
{
"platform": "Ankr",
"contract_address": "0x84db6ee82b7cf3b47e8f19270abde5718b936670"
},
{
"platform": "Bifrost",
"contract_address": "0xec1d6163e05b3f5d0fb8f354881f6c8b793ad612"
},
{
"platform": "SharedStake",
"contract_address": "0xbca3b7b87dcb15f0efa66136bc0e4684a3e5da4d"
},
{
"platform": "Swellnetwork",
"contract_address": "0xe0c8df4270f4342132ec333f6048cb703e7a9c77"
},
{
"platform": "Blockdaemon",
"contract_address": "0xea6b7151b138c274ed8d4d61328352545ef2d4b7"
},