freemartianInk Workstation
    Updated 2025-01-14
    SELECT * FROM ink.core.fact_transactions







    -- with prices AS(
    -- SELECT hour::date AS price_day, AVG(price) AS price
    -- FROM ethereum.price.ez_prices_hourly
    -- WHERE symbol = 'WETH'
    -- AND hour::date >= '2024-12-06'
    -- GROUP BY 1
    -- ),

    -- deposits AS (
    -- SELECT
    -- block_timestamp, tx_hash, to_address AS user, amount, amount * price AS amount_usd
    -- FROM ink.core.ez_native_transfers
    -- LEFT JOIN prices ON (price_day = block_timestamp::date)
    -- WHERE origin_from_address = '0x7ae4cf86b2bf1a9e99875b7e2d9b6a84426c2830'
    -- AND trace_address = '0_0_0_2'
    -- ORDER BY 2 ASC
    -- LIMIT 100
    -- ),
    -- deposit_txs AS(
    -- SELECT
    -- block_timestamp, tx_hash, to_address AS user, amount, amount_usd
    -- FROM ink.core.ez_native_transfers
    -- where from_address = '0xef684c38f94f48775959ecf2012d7e864ffb9dd4'
    -- AND origin_function_signature = '0x2e378115'
    -- ORDER BY 2 asc
    -- ),
    -- withdraw_txs AS (
    -- SELECT
    QueryRunArchived: QueryRun has been archived