theericstonearb price guess copy
Updated 2023-03-20
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
›
⌄
-- forked from 6628926f-2b88-47c1-b075-3f3326aa8281
--0xcbb928dd4ab696aaffd83402483745c5081bbc12
SELECT
CONCAT('0x', SUBSTR(TOPICS[1], -40, 40)) AS recipient,
ethereum.public.udf_hex_to_int (DATA) / pow(10, 18) AS drop_amount_arb,
{{arb_price}} AS arb_value_usd,
{{arb_price}} * (ethereum.public.udf_hex_to_int (DATA) / pow(10, 18)) AS drop_amount_arb_usd
FROM
arbitrum.core.fact_event_logs
WHERE
BLOCK_TIMESTAMP > '2023-03-15' -- to speed up query
AND BLOCK_NUMBER >= 70506697
AND ORIGIN_TO_ADDRESS = lower('0x67a24ce4321ab3af51c2d0a4801c3e111d88c9d9')
AND ORIGIN_FUNCTION_SIGNATURE = '0xae373c1b'
AND TX_STATUS = 'SUCCESS'
AND recipient = lower('{{address}}')
Run a query to Download Data