jackguyCopy of iofghweprphwe copy
Updated 2023-05-10
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
›
⌄
-- forked from Copy of iofghweprphwe @ https://flipsidecrypto.xyz/edit/queries/74abcfdc-4656-49b7-ab4a-d2a545f3ccc2
with tab1 as (
SELECT tx_hash
FROM arbitrum.core.fact_token_transfers
LEFT OUTER JOIN ethereum.core.dim_contracts
on address = contract_address
WHERE to_address LIKE lower('0xce16f69375520ab01377ce7b88f5ba8c48f8d666')
--AND SYMBOL LIKE 'USDC'
--LIMIT 100
)
SELECT
symbol,
COUNT(DISTINCT TX_HASH) as events
FROM arbitrum.core.fact_token_transfers
LEFT outer JOIN arbitrum.core.dim_contracts
ON address = contract_address
WHERE tx_hash in (SELECT * FROM tab1)
AND block_timestamp BETWEEN '{{ start_day }}' and '{{ end_day }}'
GROUP BY 1
HAVING NOT symbol LIKE 'USDC'
AND not symbol LIKE 'axlUSDC'
Run a query to Download Data