feeble_seeds as (

select

-- *

tx_hash

, from_address

from blast.core.fact_transactions

where status = 'SUCCESS'

and to_address in ('0x6f30e8768233452aeabdbb209a8ccf708bfaf993', '0x142c84dd365f56d03b165767b3b8e7f01b384b8e')

and origin_function_signature = '0x0d10e149'

, feeble_seeds_buys as (

select

date_trunc('{{time}}', block_timestamp) as "Date"

, count(distinct a.from_address) as "Distinct Buyers"

, sum(raw_amount / POWER(10,18)) as "Yield Spent"

, sum(raw_amount / POWER(10,18)) / 1 as "Seeds Bought"

, 'Feeble' as "Seed Type"

from blast.core.fact_token_transfers a inner join feeble_seeds b

on a.tx_hash = b.tx_hash and a.from_address = b.from_address

where

to_address = '0x0000000000000000000000000000000000000000'

group by 1

order by 1

, pico_seeds as (

select

-- *

tx_hash

, from_address

from blast.core.fact_transactions

where status = 'SUCCESS'

and to_address in ('0x6f30e8768233452aeabdbb209a8ccf708bfaf993', '0x142c84dd365f56d03b165767b3b8e7f01b384b8e')