-- forked from metricsdao / [05] MDAO 101: SQL WHERE AND @ https://flipsidecrypto.xyz/metricsdao/q/mdao-101-sql-order-by-4-6w00Tu
-- MetricsDAO Blockchain Analytics 101
-- https://docs.metricsdao.xyz/analyst-resources/blockchain-data-101
select
*
from ethereum.core.fact_transactions
where from_address = '0x66b870ddf78c975af5cd8edc6de25eca81791de1'
and block_timestamp >= current_date - 3
and eth_value >= '0'
ORDER BY block_timestamp DESC
-- alternatively, try changing the block_timestamp filter to the below
-- and block_timestamp >= current_date - 3
limit 100;