adriaparcerisasKittyPunch farm staking FLOW-ankrFLOW
Updated 2025-04-08
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 flow.core_evm.fact_event_logs where tx_hash='0x58c3bbe6fe41b3206339b1d71c1d84a6ecc996acda3117adbfb722d3acd5b8ab'
WITH
farms_in AS (
SELECT
x.tx_hash,
x.block_timestamp,
x.origin_from_address,
(utils.udf_hex_to_int(x.data) / pow(10,18)) AS amount_in
FROM flow.core_evm.fact_event_logs x
WHERE
lower(x.origin_to_address) = lower('0x289ca59F51893d566255588F4C8407B07644f5D6')
AND x.origin_function_signature = '0xa694fc3a' and x.event_index=0 --and origin_from_address='0x0000000000000000000000028484A9953eD6e9cF'
),
farms_out AS (
SELECT
x.tx_hash,
x.block_timestamp,
x.origin_from_address,
(utils.udf_hex_to_int(x.data) / pow(10,18)) AS amount_out
FROM flow.core_evm.fact_event_logs x
WHERE
lower(x.origin_to_address) = lower('0x289ca59F51893d566255588F4C8407B07644f5D6')
AND x.origin_function_signature = '0x2e1a7d4d' and x.event_index=0 --and origin_from_address='0x0000000000000000000000028484A9953eD6e9cF'
),
news AS (
SELECT DISTINCT origin_from_address AS user, MIN(trunc(block_timestamp,'day')) AS debut
FROM farms_in
GROUP BY 1
),
price AS (
SELECT
trunc(hour, 'day') AS day,
avg(price) AS price_usd
FROM flow.price.ez_prices_hourly
WHERE symbol ILIKE '%flow%'
QueryRunArchived: QueryRun has been archived