gergabyteUntitled Query
Updated 2022-12-19
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
›
SELECT TOP 100 * FROM ethereum.core.fact_transactions WHERE to_address = lower('0xbEae5b147D0F416492bA0D95B6d08Bf2928E754c')
-- SELECT TOP 200 block_timestamp, to_address, amount, symbol, event_name, event_type
-- FROM ethereum.udm_events WHERE to_address = lower('0xaBEA9132b05A70803a4E85094fD0e1800777fBEF')
-- zkSync - 0xaBEA9132b05A70803a4E85094fD0e1800777fBEF
-- WITH NATIVE_ETH_DEPOSITS AS (
-- SELECT sum(amount) AS totaleth
-- FROM ethereum.udm_events WHERE to_address = lower('0xaBEA9132b05A70803a4E85094fD0e1800777fBEF') and amount > 0 and event_type = 'native_eth'
-- )
-- SELECT * FROM ethereum.events_emitted WHERE contract_address = lower('0xaBEA9132b05A70803a4E85094fD0e1800777fBEF')
-- SELECT balance, symbol FROM ethereum.erc20_balances
-- WHERE user_address = lower('0xaBEA9132b05A70803a4E85094fD0e1800777fBEF')
-- SELECT sum(amount) AS totaleth
-- FROM NATIVE_ETH_WITHDRAWLS
-- WITH NATIVE_ETH_WITHDRAWLS AS (
-- SELECT block_timestamp, from_address, amount, symbol, event_name, event_type
-- FROM ethereum.udm_events WHERE from_address = lower('0xaBEA9132b05A70803a4E85094fD0e1800777fBEF') and amount > 0 and event_type = 'native_eth'
-- )
-- WITH NATIVE_ETH_DEPOSITS AS (
-- SELECT TOP 200 block_timestamp, contract_address, to_address, amount, symbol, event_name, event_type
-- FROM ethereum.udm_events WHERE to_address = lower('0xaBEA9132b05A70803a4E85094fD0e1800777fBEF') and amount > 0 and event_type = 'native_eth'
-- )