jackguy2023-09-01 09:44 PM
Updated 2023-09-02
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 *
-- Uncomment lines below if needed
-- block_timestamp,
-- tx_hash,
-- sum(CASE when contract_address LIKE lower('0xd9aAEc86B65D86f6A7B5B1b0c42FFA531710b6CA') then raw_amount / power(10, 6) else 0 end) as amount_usdbc,
-- sum(CASE when contract_address LIKE lower('0x940181a94A35A4569E4529A3CDfB74e38FD98631') then raw_amount / power(10, 18) else 0 end) as amount_aero
FROM base.core.fact_token_transfers
JOIN (
SELECT
date(hour) as date1,
token_address,
symbol,
decimals,
median(price) as price
FROM base.price.ez_hourly_token_prices
GROUP BY 1,2,3,4
) on date(block_timestamp) = date1
AND token_address = contract_address
WHERE tx_hash in (
SELECT DISTINCT tx_hash
FROM base.core.fact_transactions
WHERE ORIGIN_FUNCTION_SIGNATURE LIKE '0xd294f093'
AND to_address IN (
-- List of addresses
lower('0xbb7e170df05231f2ceab51c80f35fe68e47d3af4'), --
lower('0xbBf71AAD6E1F8D180D3B1D898528654c1d18b2fF'), -- fBOMB/AERO
lower('0x7f670f78B17dEC44d5Ef68a48740b6f8849cc2e6'), -- WETH/AERO
lower('0x2223F9FE624F69Da4D8256A7bCc9104FBA7F8f75'), -- AERO/USDbC
lower('0x6EAB8c1B93f5799daDf2C687a30230a540DbD636'), -- DAI/USDbC
lower('0x9e4CB8b916289864321661CE02cf66aa5BA63C94'), -- WETH/DEUS
lower('0x4a3636608d7Bc5776CB19Eb72cAa36EbB9Ea683B'), -- USD+/USDbC
lower('0x1b05e4e814b3431a48b8164c41eaC834d9cE2Da6'), -- DAI+/USD+
lower('0x2d25E0514f23c6367687dE89Bd5167dc754D4934'), -- WETH/TAROT
lower('0xb680190fB16f417647e69D6A84719aE9c7E5E20a'), -- USDbC/STG
lower('0x8b432C54d6e8E1B8D1802753514AB53044Af1861'), -- DOLA/MAI
lower('0x218F511431194B2C756D67a137DE536beA74E498'), -- ERN/stERN
Run a query to Download Data