intellidegentWeek 2 Assignment
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
›
⌄
-- Frax/USDC: 0x6c6Bc977E13Df9b0de53b251522280BB72383700 swaps on Frax
-- uniV3 Frax/USDC pool: 0xc63b0708e2f7e69cb8a1df0e1389a98c35a76d52
-- Staked Frax Ether (sfrxETH) contract addy: 0xac3E018457B222d93114458476f3E3416Abbe38F
-- Mint = add_liquidity
-- Burn = remove_liquidity
select
event_name,
count(1)
from ethereum.core.ez_decoded_event_logs
where contract_address = lower('0xac3E018457B222d93114458476f3E3416Abbe38F')
group by 1
-------------------------
select *
from ethereum.core.ez_decoded_event_logs
where contract_address = lower('0xac3E018457B222d93114458476f3E3416Abbe38F')
and event_name = 'Withdraw'
and block_timestamp >= '2023-01-01'
select *
from ethereum.core.ez_decoded_event_logs
where tx_hash = '0x7c8a09a2ab7d2f25b7aaacf74377948c2d40b1bcfb043e43db9efc3529b18a6a'
and event_name = 'Deposit'
select *
from ethereum.core.ez_decoded_event_logs
where tx_hash = '0x7c8a09a2ab7d2f25b7aaacf74377948c2d40b1bcfb043e43db9efc3529b18a6a'
and event_name = 'Deposit'
Run a query to Download Data