0xasmrUntitled Query
Updated 2022-09-03Copy Reference Fork
99
1
2
3
4
5
6
7
8
9
10
11
12
13
›
⌄
SELECT
tx_hash,
topics[1] AS user,
ethereum.public.udf_hex_to_int(data)/pow(10, 18) AS eth_withdrawn
FROM ethereum.core.fact_event_logs
WHERE contract_address = '0x70b97a0da65c15dfb0ffa02aee6fa36e507c2762'
AND origin_to_address = '0x3b968d2d299b895a5fcf3bba7a64ad0f566e6f88'
AND origin_function_signature = '0x36118b52'
AND topics[0] = '0x3ed4ee04a905a278b050a856bbe7ddaaf327a30514373e65aa6103beeae488c3'
AND block_timestamp >= CURRENT_DATE - interval '1 month'
LIMIT 10
Run a query to Download Data