0xC2eAf96831Cd62f8dC3B85674D749154F205562cTxVolume - External copy
999
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
›
⌄
-- forked from 0xAD5d421Ee9D918276de32F06Af845960847b26a5 / TxVolume - External @ https://flipsidecrypto.xyz/0xAD5d421Ee9D918276de32F06Af845960847b26a5/q/d-AP2wMGQYXB/txvolume---external
SELECT
blockchain,
dt,
fee_bps,
token,
amount,
symbol,
name,
decimals,
normalized_amount,
normalized_fee_amount,
price,
amount_usd_value,
fee_usd_value
FROM
(
SELECT
blockchain,
dt,
fee_bps,
token,
amount,
symbol,
name,
ifnull(decimals, 18) as decimals,
amount / pow(10, ifnull(decimals, 18)) as normalized_amount,
normalized_amount * fee_bps / 10000 as normalized_fee_amount,
price,
normalized_amount * price as amount_usd_value,
normalized_fee_amount * price as fee_usd_value
FROM
(
SELECT
'cross-chain' as blockchain,
Run a query to Download Data