flipside
Products
For Protocols
For Analysts
For Explorers
About
Log in
Become a Partner
flipside
Copy of [06] Multiple WHERE clauses. DATE.
metricsdao
Copy of [06] Multiple WHERE clauses. DATE.
Updated 2022-11-19
Copy Reference
Fork
99
1
2
3
4
5
6
7
8
9
10
›
⌄
SELECT
block_timestamp
,
tx_hash
,
from_address
,
tx_fee
FROM
ethereum
.
core
.
fact_transactions
WHERE
from_address
=
lower
(
'0x05E793cE0C6027323Ac150F6d45C2344d28B6019'
)
-- a16z
AND
block_timestamp
::
DATE
>
'2021-12-31'
ORDER
BY
block_timestamp
::
DATE
;
Results
Run a query to Download Data