flipside
Products
For Protocols
For Analysts
For Explorers
About
Log in
Become a Partner
flipside
swap today
boomer77
swap today
Updated 2021-10-24
Copy Reference
Fork
9
1
2
3
›
⌄
select
*
,
ROW_NUMBER
(
)
OVER
(
ORDER
BY
block_timestamp
asc
)
AS
number
,
case
when
tx_id
is
not
null
then
'1'
else
'nil'
end
as
fq
from
thorchain
.
swaps
where
date
(
block_timestamp
)
=
'2021-10-23'
Results
Run a query to Download Data