Query editor
select'Arcade' as protocol,case when max(date) = DATE_TRUNC('week', NOW()) then cast('Updated ✅' as varchar) else cast('Update manually ❗ 'as varchar) end as status,'<a href=https://dune.com/queries/3833326' || ' target=_blank">' || cast('🔗' as varchar) || '</a>' as linkfrom dune."nftfi-team".result_od_by_collection_arcadeunion allselect'BendDao' as protocol,case when max(date) = DATE_TRUNC('week', NOW()) then cast('Updated ✅' as varchar) else cast('Update manually ❗ 'as varchar) end as status,'<a href=https://dune.com/queries/3833323' || ' target=_blank">' || cast('🔗' as varchar) || '</a>' as linkfrom dune."nftfi-team".result_od_by_collection_benddaounion allselect'Blur (Blend)' as protocol,case when max(date) = DATE_TRUNC('week', NOW()) then cast('Updated ✅' as varchar) else cast('Update manually ❗ 'as varchar) end as status,'<a href=https://dune.com/queries/3833330' || ' target=_blank">' || cast('🔗' as varchar) || '</a>' as linkfrom dune."nftfi-team".result_od_by_collection_blurunion allselect'Cyan' as protocol,case when max(date) = DATE_TRUNC('week', NOW()) then cast('Updated ✅' as varchar) else cast('Update manually ❗ 'as varchar) end as status,'<a href=https://dune.com/queries/3833322' || ' target=_blank">' || cast('🔗' as varchar) || '</a>' as linkfrom dune."nftfi-team".result_od_by_collection_cyanunion allselect'Gondi' as protocol,case when max(date) = DATE_TRUNC('week', NOW()) then cast('Updated ✅' as varchar) else cast('Update manually ❗ 'as varchar) end as status,'<a href=https://dune.com/queries/3833321' || ' target=_blank">' || cast('🔗' as varchar) || '</a>' as linkfrom dune."nftfi-team".result_od_by_collection_gondiunion allselect'Jpegd' as protocol,case when max(date) = DATE_TRUNC('week', NOW()) then cast('Updated ✅' as varchar) else cast('Update manually ❗ 'as varchar) end as status,'<a href=https://dune.com/queries/3833337' || ' target=_blank">' || cast('🔗' as varchar) || '</a>' as linkfrom dune."nftfi-team".result_od_by_collection_jpegdunion allselect'MetaStreet' as protocol,case when max(date) = DATE_TRUNC('week', NOW()) then cast('Updated ✅' as varchar) else cast('Update manually ❗ 'as varchar) end as status,'<a href=https://dune.com/queries/3833333' || ' target=_blank">' || cast('🔗' as varchar) || '</a>' as linkfrom dune."nftfi-team".result_od_by_collection_metastreetunion allselect'Nftfi' as protocol,case when max(date) = DATE_TRUNC('week', NOW()) then cast('Updated ✅' as varchar) else cast('Update manually ❗ 'as varchar) end as status,'<a href=https://dune.com/queries/3833328' || ' target=_blank">' || cast('🔗' as varchar) || '</a>' as link