cypherLido Holder Behaviors - LDO actions
Updated 2022-06-02
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
›
⌄
-- 0xa2dfc431297aee387c05beef507e5335e684fbcd: 2 transfers to other address
-- 0xad4f7415407b83a081a0bee22d05a8fdc18b42da: 1 test and 1 large transfer to other address
-- 0x945755de7eac99008c8c57bda96772d50872168b: no actions
-- 0x695c388153bea0fbe3e1c049c149bad3bc917740: no actions
-- 0x09f82ccd6bae2aebe46ba7dd2cf08d87355ac430: no actions
select
block_timestamp,
origin_from_address as from_address,
contract_name,
event_name,
event_inputs:value/1e18 as LDO_amount
from flipside_prod_db.ethereum_core.fact_event_logs
where (ORIGIN_FROM_ADDRESS in (
'0x09f82ccd6bae2aebe46ba7dd2cf08d87355ac430',
'0x695c388153bea0fbe3e1c049c149bad3bc917740',
'0x945755de7eac99008c8c57bda96772d50872168b',
'0xad4f7415407b83a081a0bee22d05a8fdc18b42da',
'0xa2dfc431297aee387c05beef507e5335e684fbcd')
or ORIGIN_to_ADDRESS in (
'0x09f82ccd6bae2aebe46ba7dd2cf08d87355ac430',
'0x695c388153bea0fbe3e1c049c149bad3bc917740',
'0x945755de7eac99008c8c57bda96772d50872168b',
'0xad4f7415407b83a081a0bee22d05a8fdc18b42da',
'0xa2dfc431297aee387c05beef507e5335e684fbcd'))
and event_name = 'Transfer'
Run a query to Download Data