# HELP: Latest pairs based on volume

**URL:** <https://community.bitquery.io/t/help-latest-pairs-based-on-volume/1525>\
**Category:** GraphQL API\
**Created:** [June 16, 2023, 2:07am UTC](https://community.bitquery.io/t/help-latest-pairs-based-on-volume/1525 "2023-06-16T02:07:07Z")\
**Posts on this page:** 7\
**Page:** 1

<div class="post-metadata">

**Author:** ![LordFriar](https://avatars.discourse-cdn.com/v4/letter/l/0ea827/32.png) [@LordFriar](https://community.bitquery.io/u/LordFriar)\
**Post date:** [June 16, 2023, 2:07am UTC](https://community.bitquery.io/t/help-latest-pairs-based-on-volume/1525/1 "2023-06-16T02:07:07Z")

</div>

Hi,

Long time Bitquery user here needs help with a query, it would be very useful if someone could point me in the right direction. I need a query that can find:

Uniswap/PancakeSwap V2 pairs created in the last 30 days where the  
trade volume of the pair is greater than 1k USD.

I have spent hours scanning through queries, especially by gaurav, with queries that either find the newest pairs but with no volume filter, or a volume filter but no latest pairs. I need one query that can include pairs created in the last 30 days ONLY if their volume is greater than 1k. Looping through each of these decoded pairs to confirm their volume is too inefficient.

I have tried both ethereum arguments, ethereum dexTrades, and streaming (EVM) to no avail

Please help and tell me if this is possible! I have thought about possibly using fragments or variables, also to no avail.

---

<div class="post-metadata">

**Author:** ![Divya](https://avatars.discourse-cdn.com/v4/letter/d/13edae/32.png) [@Divya](https://community.bitquery.io/u/Divya)\
**Post date:** [June 16, 2023, 10:12am UTC](https://community.bitquery.io/t/help-latest-pairs-based-on-volume/1525/2 "2023-06-16T10:12:31Z")

</div>

Is this the query you are asking? [https://ide.bitquery.io/Top-Traded-Pairs-on-Uniswap-v2-Last-30-days](https://ide.bitquery.io/Top-Traded-Pairs-on-Uniswap-v2-Last-30-days)

---

<div class="post-metadata">

**Author:** ![LordFriar](https://avatars.discourse-cdn.com/v4/letter/l/0ea827/32.png) [@LordFriar](https://community.bitquery.io/u/LordFriar)\
**Post date:** [June 16, 2023, 2:30pm UTC](https://community.bitquery.io/t/help-latest-pairs-based-on-volume/1525/3 "2023-06-16T14:30:54Z")

</div>

Its a great query, unfortunately it cannot determine whether

1. The pair was created in the past month
2. The data represents distinct pairs

---

<div class="post-metadata">

**Author:** ![Divya](https://avatars.discourse-cdn.com/v4/letter/d/13edae/32.png) [@Divya](https://community.bitquery.io/u/Divya)\
**Post date:** [June 19, 2023, 6:06am UTC](https://community.bitquery.io/t/help-latest-pairs-based-on-volume/1525/4 "2023-06-19T06:06:43Z")

</div>

1. I will check on tradevolume, you get created pairs by count [https://ide.bitquery.io/Latest-Pair-Created-by-Count](https://ide.bitquery.io/Latest-Pair-Created-by-Count)
2. Please explain, you want unique pairs right?

---

<div class="post-metadata">

**Author:** ![LordFriar](https://avatars.discourse-cdn.com/v4/letter/l/0ea827/32.png) [@LordFriar](https://community.bitquery.io/u/LordFriar)\
**Post date:** [June 19, 2023, 4:20pm UTC](https://community.bitquery.io/t/help-latest-pairs-based-on-volume/1525/5 "2023-06-19T16:20:41Z")

</div>

Correct. All unique pairs in the last 24 hours that meet the volume criteria

---

<div class="post-metadata">

**Author:** ![LordFriar](https://avatars.discourse-cdn.com/v4/letter/l/0ea827/32.png) [@LordFriar](https://community.bitquery.io/u/LordFriar)\
**Post date:** [June 19, 2023, 4:23pm UTC](https://community.bitquery.io/t/help-latest-pairs-based-on-volume/1525/6 "2023-06-19T16:23:14Z")

</div>

And by the way, both the pairs (their addresses) and the volume filter must be in the same query.

---

<div class="post-metadata">

**Author:** ![gaurav](https://avatars.discourse-cdn.com/v4/letter/g/b487fb/32.png) [@gaurav](https://community.bitquery.io/u/gaurav)\
**Post date:** [July 27, 2023, 2:53pm UTC](https://community.bitquery.io/t/help-latest-pairs-based-on-volume/1525/7 "2023-07-27T14:53:15Z")

</div>

Here is the way you can get the latest Uniswap pairs with over 1 million USD in trading vol. Only limitation this query has is that it doesn’t can’t filter pairs that are only 30 days old, rather it order by their creation date, so you can only take those results which relevant to you.

> **[Latest pairs on Uniswap with over 1 million in trading vol](https://ide.bitquery.io/Latest-pairs-on-Uniswap-with-over-1-million-in-trading-vol)**
>
> Latest pairs on Uniswap with over 1 million in trading vol
