mattkstewHODL or Sell? 5
Updated 2022-06-11Copy Reference Fork
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
›
⌄
with tab1 as (
SELECT
origin_address as address
FROM ethereum.udm_events
where contract_address = '0xae7ab96520de3a18e5e111b5eaab095312d7fe84' --stETH
and from_address = '0x0000000000000000000000000000000000000000'
and origin_function_signature = '0xa1903eab'
and to_address = origin_address
and amount_usd / amount not between 1000 and 2600
)
select
45045 - count(distinct origin_from_address)
from ethereum.core.ez_dex_swaps
where origin_from_address in (select address from tab1)
and symbol_in like 'stETH'
Run a query to Download Data