datavortexNew Inflow
Updated 2024-09-17
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
›
⌄
WITH weekly_transfer_summary AS (
SELECT
DATE_TRUNC('week', block_timestamp) AS week,
SUM(CAST(amount_precise AS NUMERIC) * token_price) AS net_volume
FROM
optimism.core.ez_token_transfers
WHERE
contract_address = LOWER('0x296F55F8Fb28E498B858d0BcDA06D955B2Cb3f97')
GROUP BY
DATE_TRUNC('week', block_timestamp)
)
SELECT
week,
SUM(net_volume) AS net_weekly_inflow
FROM
weekly_transfer_summary
GROUP BY
week
ORDER BY
week;
QueryRunArchived: QueryRun has been archived