freemartianInk Workstation
Updated 2025-01-14
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
›
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