SELECT

to_char(

date_trunc('day', block_timestamp),

'yyyy-mm-dd'

) as date,

tx_id,

TX_FROM_ADDRESS as user_wallet,

EVENT_INPUTS : value / POW(10, 18) as amount,

contract_address

FROM

ethereum.events_emitted

WHERE

TX_TO_ADDRESS = '0xd9e1ce17f2641f24ae83637ab66a2cca9c378b9f'

and event_name = 'Transfer'

and EVENT_INPUTS :

from

:: string = '0x0000000000000000000000000000000000000000'

and TX_SUCCEEDED = 'TRUE'

)

SELECT

COUNT(DISTINCT user_wallet) as num_LPs

FROM

lps