jackguysynth fees
Updated 2022-08-17
99
1
2
3
4
5
6
7
8
9
10
11
›
⌄
SELECT
date_trunc('day', block_timestamp) as day,
sum(event_inputs:value/power(10, 18)),
count(DISTINCT tx_hash)
--date_trunc('day', block_timesapmt)
FROM optimism.core.fact_event_logs
--WHERE tx_hash LIKE '0xbccf33bd0b19aeb374bc9e749f208b360b18051ee87206d26d6297faa522d1ec'
WHERE event_inputs:account LIKE '0xfeefeefeefeefeefeefeefeefeefeefeefeefeef'
AND event_name LIKE 'Issued'
--LIMIT 100
GROUP BY 1
Run a query to Download Data