Zanyar_98SYBL
Updated 2022-09-05
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
29
30
31
32
33
34
35
36
›
⌄
-- SELECT *
-- FROM ethereum.core.ez_eth_transfers
-- WHERE ETH_TO_ADDRESS='0x49d72e3973900a195a155a46441f0c08179fdb64' --AND ETH_FROM_ADDRESS != '0x3bdc69c4e5e13e52a65f5583c23efb9636b469d6'-- AND ORIGIN_FUNCTION_SIGNATURE = '0xd0e30db0' -- LIMIT 200 --AND ORIGIN_FUNCTION_SIGNATURE = '0x22895118'
-- ORIGIN_FUNCTION_SIGNATURE = '0x3876de3a'
-- AND IDENTIFIER = 'CALL_ORIGIN'
SELECT *
FROM ethereum.core.ez_eth_transfers
WHERE ETH_TO_ADDRESS = '0x00000000219ab540356cbb839cbe05303d7705fa' AND ORIGIN_FUNCTION_SIGNATURE != '0x22895118' ORDER by BLOCK_TIMESTAMP DESC
LIMIT 250
-- SELECT * FROM ethereum.core.ez_eth_transfers WHERE TX_HASH = '0xbb1c251ee79eb10b8f268c258a38f2e9e4e6949ed9862b9bc6196be07da877d8'
-- SELECT SUM(AMOUNT_USD) FROM ethereum.core.ez_token_transfers
-- where from_address = '0x0000000000000000000000000000000000000000'
-- and contract_address = '0xae7ab96520de3a18e5e111b5eaab095312d7fe84'
-- select
-- 'Lido' as "Protocol",
-- count(*) as "Total Number of Stakes",
-- count(distinct event_inputs:to) as "Total Number of Unique Staker",
-- sum(event_inputs:value/1e18) as "Total Amount of ETH Staked",
-- ("Total Amount of ETH Staked"/"Total Number of Stakes") as "Average Deposit Size",
-- ("Total Amount of ETH Staked"/"Total Number of Unique Staker") as "Average Amount of ETH Staked per Staker",
-- ("Total Number of Stakes"/"Total Number of Unique Staker") as "Average Number of Stake per Staker"
-- from ethereum_core.fact_event_logs
-- where contract_address = '0xae7ab96520de3a18e5e111b5eaab095312d7fe84'
-- and event_inputs:from = '0x0000000000000000000000000000000000000000'
-- and event_name = 'Transfer'
-- group by 1
-- SELECT block_timestamp::date as days, sum(event_inputs:value/1e18) as "Total Amount of ETH Staked"
-- from ethereum_core.fact_event_logs
-- where contract_address = '0xae7ab96520de3a18e5e111b5eaab095312d7fe84'
-- and event_inputs:from = '0x0000000000000000000000000000000000000000'
-- and event_name = 'Transfer'
-- GROUP by days
Run a query to Download Data