jackguy2023-03-14 02:38 PM
Updated 2023-03-14
99
1
2
3
4
5
6
7
8
9
10
11
›
⌄
SELECT *
-- ORIGIN_FROM_ADDRESS as users,
-- sum(raw_amount / power(18, decimals)) as air_drop_volume
FROM optimism.core.fact_token_transfers
LEFT outer JOIN optimism.core.dim_contracts
ON address = contract_address
WHERE symbol LIKE 'OP'
AND from_address LIKE lower('0xFeDFAF1A10335448b7FA0268F56D2B44DBD357de')
AND ORIGIN_FUNCTION_SIGNATURE LIKE '0x2e7ba6ef'
-- GROUP by 1
LIMIT 100
Run a query to Download Data