fantasimilar user profiles
Updated 2022-04-26
9
1
2
3
4
5
6
7
›
⌄
select distinct EVENT_INPUTS:to as users from ethereum_core.fact_event_logs
where contract_address='0xae7ab96520de3a18e5e111b5eaab095312d7fe84'
and EVENT_INPUTS:from='0x0000000000000000000000000000000000000000'
and date(block_timestamp) > DATEADD(month, -3, CURRENT_DATE) and EVENT_INPUTS:to in (select distinct EVENT_INPUTS:to as users from ethereum_core.fact_event_logs
where contract_address='0xae78736cd615f374d3085123a210448e74fc6393'
and EVENT_INPUTS:from='0x0000000000000000000000000000000000000000'
and date(block_timestamp) > DATEADD(month, -3, CURRENT_DATE))
Run a query to Download Data