Skip to content
Dune Analytics

@phabc / New Query

SQL query

1SELECT
2  concat('0x', substring(encode(data, 'hex') from 30 for 45)) as minters,
3  substring(t."data" from 0 for 5) as data,
4  CONCAT('https://etherscan.io/tx/0x',encode(hash, 'hex')) as tx
5FROM ethereum."transactions" AS t
6WHERE t."to" = '\x0bc529c00C6401aEF6D220BE8C6Ea1667F6Ad93e'
7  AND substring(t."data" from 0 for 5) = '\x3092afd5'
8  AND t.block_number >= 10475744

SQL query results

Loading