KuramaUntitled Query
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
›
⌄
with deposit as (
select sum(value)/1e18 as total_deposit_eth ,
count( distinct `from`) as total_depositors
from ethereum.core.fact_traces
where block_timestamp > '2020-10-14'
and lower(to_address) =lower('0x00000000219ab540356cBB839Cbe05303d7705Fa')
)
select * from deposit
select --to_number(data:value, 'XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX')
-- too big
--select udf_hex_to_int('200000000000000000000000000000211');
-- success
-- udf_hex_to_int('0xde0b6b3a76400000'), udf_hex_to_int(data:value), data, a.*
ethereum.public.udf_hex_to_int('0xde0b6b3a76400000'), ethereum.public.udf_hex_to_int(data:value), a.*
from ethereum.core.fact_traces a
where block_timestamp > '2020-10-14'
and lower(to_address) =lower('0x00000000219ab540356cBB839Cbe05303d7705Fa')
and tx_hash = '0x376770e99d78ddaa23d19984d2f60abf3775d3ee3db81925eb673a4bc549318b'
limit 10
-- 0xde0b6b3a76400000
Run a query to Download Data