jonome[05] MDAO 101: SQL WHERE AND copy
    Updated 2023-06-02
    -- 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;



    Run a query to Download Data