scottincryptoBadger Token Metrics
Updated 2023-02-01
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
27
28
29
30
31
32
33
34
35
36
›
⌄
with badger_genesis as (
select
tx_hash
, block_number as genesis_block
, block_timestamp as genesis_timestamp
, date_trunc('day', genesis_timestamp) as genesis_day
from ethereum.core.fact_decoded_event_logs
where contract_address = lower('0x3472A5A71965499acd81997a54BBA8D852C6E53d')
and block_number = (select min(block_number) from ethereum.core.fact_decoded_event_logs where contract_address = lower('0x3472A5A71965499acd81997a54BBA8D852C6E53d'))
)
, badger_price as (
select
*
from ethereum.core.fact_hourly_token_prices
where token_address = lower('0x3472A5A71965499acd81997a54BBA8D852C6E53d')
and hour = (select max(hour) from ethereum.core.fact_hourly_token_prices where token_address = lower('0x3472A5A71965499acd81997a54BBA8D852C6E53d'))
and is_imputed = false
)
, eth_ins as (
select
from_address as address
, sum(amount) as eth_in
from ethereum.core.ez_token_transfers
where contract_address = lower('0x3472A5A71965499acd81997a54BBA8D852C6E53d')
and from_address in ('0x0000000000000000000000000000000000000000'
,lower('0xD0A7A8B98957b9CD3cFB9c0425AbE44551158e9e')
,lower('0xd4dea11288de10e73d3b3d93d88e73ef7cdea3fe')
,lower('0x042B32Ac6b453485e357938bdC38e0340d4b9276')
,lower('0x30a9c1D258F6c2D23005e6450E72bDD42C541105')
)
group by from_address
)
Run a query to Download Data