somkeneIn-class code
Updated 2024-02-01
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
›
⌄
--select -from -where -group by -order by
--database and table
SELECT -- * means "all"
block_timestamp,
tx_hash,
origin_from_address, --(Senders and Withdrawal)
origin_to_address, --(Receivers and Deposit)
contract_address,
amount_usd,
symbol,
token_price
FROM ethereum.core.ez_token_transfers -- Retrieving data from the ethereum.core.ez_token_transfers table
WHERE amount_usd IS NOT NULL -- IS NULL
--GROUP BY amount_usd
ORDER BY amount_usd DESC -- DESC means Descending Order - ASC means Ascending Order
LIMIT 1000
QueryRunArchived: QueryRun has been archived