freemartianDaily FLOOR Minted from Bonding PUNKs
Updated 2022-07-04
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
›
⌄
select
sum(event_inputs:_value)/pow(10,9) as FLOOR_minted,
date_trunc('day', block_timestamp::date) as TIME
from ethereum.core.fact_event_logs
where CONTRACT_ADDRESS = '0x91e453f442d25523f42063e1695390e325076ca2'
and event_name = 'Minted'
and tx_hash in (
select tx_hash
from ethereum.core.ez_token_transfers
where to_address = '0x91e453f442d25523f42063e1695390e325076ca2'
and contract_address in (
'0x0463a06fbc8bf28b3f120cd1bfc59483f099d332',
lower('0xFB2f1C0e0086Bcef24757C3b9bfE91585b1A280f'),
lower('0x08765C76C758Da951DC73D3a8863B34752Dd76FB'),
lower('0x269616D549D7e8Eaa82DFb17028d0B212D11232A')))
group by TIME
Run a query to Download Data