flipside

    Farm Change
    IncrementFarm Change
    Updated 2024-02-01
    SELECT
    EXTRACT(EPOCH FROM BLOCK_TIMESTAMP) as TIME,
    event_data:tokenKey AS STAKETOKEN,
    event_data:amount AS AMOUNT,
    event_data:operator AS ADDRESS,
    TX_ID,
    'FarmDeposit' as EventType
    FROM
    flow.core.fact_events
    WHERE
    event_contract = 'A.1b77ba4b414de352.Staking'
    AND event_type = 'TokenStaked'

    UNION ALL

    SELECT
    EXTRACT(EPOCH FROM BLOCK_TIMESTAMP) as TIME,
    event_data:tokenKey AS STAKETOKEN,
    event_data:amount AS AMOUNT,
    event_data:operator AS ADDRESS,
    TX_ID,
    'FarmWithdraw' as EventType
    FROM
    flow.core.fact_events
    WHERE
    event_contract = 'A.1b77ba4b414de352.Staking'
    AND event_type = 'TokensWithdrawn'

    ORDER BY
    TIME
    Last run: over 1 year ago
    TIME
    STAKETOKEN
    AMOUNT
    ADDRESS
    TX_ID
    EVENTTYPE
    1
    		1658729283A.fa82796435e15832.SwapPair
    1291.66004330
    0x95c1afc355056c36
    		0538bb71cf06069b99366931f04325f62768bb569e798c97aaf6172d542a3007FarmDeposit
    2
    		1658729478A.fa82796435e15832.SwapPair
    13.02285209
    0x24263c125b7770e0
    		203a1273bb0a3f9d332f453866054924feb7d24e8c785edd7dd685c98987faa3FarmDeposit
    3
    		1658729569A.fa82796435e15832.SwapPair
    13.02285209
    0x24263c125b7770e0
    		3235d40a164c06b387151b3c901236f1b00409200fe9525063d5309c75dfec09FarmDeposit
    4
    		1658740404A.fa82796435e15832.SwapPair
    32.52693190
    0x51b78493f9b10367
    		4e151bd256b372a00e184ab99977a96d836d8ce55561fa81806e102dce8189e0FarmDeposit
    5
    		1658740521A.fa82796435e15832.SwapPair
    64.85870221
    0x002c479c5c9eb30f
    		38becffeede442d2a2c66fe6cf3f1614d0bdf7585617b1147821fcf2758d76f2FarmDeposit
    6
    		1658743082A.fa82796435e15832.SwapPair
    991.66004330
    0x95c1afc355056c36
    		504e808b80b82dc164a08a55763b298c2da8cd58255373502e0a543c98176c20FarmDeposit
    7
    		1658743446A.fa82796435e15832.SwapPair
    3.18065150
    0x247111edab03e3eb
    		336801037935c3367f6d2863e033531b1108e068b8dc56342d582a96befe0e09FarmDeposit
    8
    		1658743713A.fa82796435e15832.SwapPair
    29.88618623
    0x247111edab03e3eb
    		59ec6e42c8bf131b073d31cb4672cd1ec4bd5d1bf05bd04b9ecbb1f920ef5772FarmDeposit
    9
    		1658745295A.fa82796435e15832.SwapPair
    10875.58972168
    0x5a0c5ab18b02ceec
    		0b1c486e8e4b93868f6a4b2cd8cc933b99aebd93c4fcf5485998d6d684a98a5cFarmDeposit
    10
    		1658745408A.fa82796435e15832.SwapPair
    0.74418809
    0x886f3aeaf848c535
    		d4e2512d97b25792e51358895c04bc7f42e032d8a7227ff38cd8af479f2c6b39FarmDeposit
    11
    		1658745594A.fa82796435e15832.SwapPair
    7.94900000
    0xaf6fe96f5d9b42a7
    		3f0a60323cb3e15534d4aba8ad892be4f7813496a9c0aaa7b7443d2b73644a44FarmDeposit
    12
    		1658745781A.fa82796435e15832.SwapPair
    3.88264284
    0x4e5b7a910a7f433e
    		706a3851e696d210fba185e0b382067bb7fbf187152a42a215b1c0f30386cd0dFarmDeposit
    13
    		1658747330A.fa82796435e15832.SwapPair
    495.88270298
    0x34b57a6391ed7130
    		e31d6666bf32ef7d2495dd51c13be2e4aed659bd02830ce1ae9abcf4d4ff5d45FarmDeposit
    14
    		1658748242A.fa82796435e15832.SwapPair
    45.44433691
    0xa51d2c3cdbf233fe
    		a4d3e94b2b7b808eafe5fe0ce928ea64f3a03178abb7e6088e8467ef0b356de4FarmDeposit
    15
    		1658748318A.fa82796435e15832.SwapPair
    3.43532599
    0xa703739f4815ba26
    		4a6c1b0e4d04d5a17b96791e1774cc54e904818ccce346812946e6da3d18aff9FarmDeposit
    16
    		1658748487A.fa82796435e15832.SwapPair
    2.29422757
    0xd3ea017e19deb888
    		c80804a7f4dc59e8c509c00d503b85abf1245903b06a5a2ed0f2ff72480b856bFarmDeposit
    17
    		1658748921A.fa82796435e15832.SwapPair
    1.29776317
    0x639196e6ef18a145
    		a7174ca7feafad9eb537d7e2b5f73562c1b28d4670fcc3203b0194a23e3fa75eFarmDeposit
    18
    		1658751356A.fa82796435e15832.SwapPair
    336.85182025
    0xde19718387258743
    		b8231548aa36aa16b0412e9aa7d8f2d71de03afda5aa4650401d2abac2ba7eaaFarmDeposit
    19
    		1658751576A.fa82796435e15832.SwapPair
    183.20437865
    0xde19718387258743
    		9bfd3c64a5d2a486f865394b219a9af2573393811fcafe08f442d986d39e9c05FarmDeposit
    20
    		1658752439A.fa82796435e15832.SwapPair
    10.32137344
    0xde19718387258743
    		179ea14b7aff0eef27c644099b0bb6806570af4673c20023d686d5d10ea81e68FarmDeposit
    ...
    6419
    997KB
    42s