flipside
Insights
Studio
Quests
For Chains
For Analysts
For Explorers
About
Log in
Sign up
flipside
2023-04-01 03:58 PM
pavlyshyn
2023-04-01 03:58 PM
Updated 2023-04-01
Copy Reference
Fork
9
1
2
3
4
5
›
⌄
SELECT
tx_hash
,
eth_from_address
,
eth_to_address
,
amount
,
amount_usd
FROM
ethereum
.
core
.
ez_eth_transfers
WHERE
DATE_TRUNC
(
'day'
,
block_timestamp
)
=
DATE_TRUNC
(
'day'
,
DATEADD
(
'day'
,
-
1
,
CURRENT_TIMESTAMP
)
)
ORDER
BY
amount
DESC
LIMIT
1
;
Results
Run a query to Download Data