feyikemienergetic-red
Updated 2024-08-20
99
1
2
3
4
5
6
7
8
9
10
11
12
13
›
⌄
SELECT
-- Block_timestamp,
-- ORIGIN_FROM_ADDRESS,
-- ORIGIN_FUNCTION_SIGNATURE,
-- COUNT(*)
min(block_timestamp)
FROM osmosis.core.fact_transfers
where CURRENCY = 'ibc/9A76CDF0CBCEF37923F32518FA15E5DC92B9F56128292BC4D63C4AEA76CBB110'
--AND BLOCK_TIMESTAMP :: Date >= '2023-09-26'
--AND BLOCK_TIMESTAMP :: Date <='2023-10-17'
--Limit 10
--GROUP BY 1, 2, 3
--ORDER BY 4 DESC
QueryRunArchived: QueryRun has been archived