# Subgraph For Wrapped Ether

**URL:** <https://forum.thegraph.com/t/subgraph-for-wrapped-ether/115>\
**Category:** Showroom\
**Created:** [January 22, 2021, 12:43am UTC](https://forum.thegraph.com/t/subgraph-for-wrapped-ether/115 "2021-01-22T00:43:54Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![dennison](https://avatars.discourse-cdn.com/v4/letter/d/ee7513/32.png) [@dennison](https://forum.thegraph.com/u/dennison)\
**Post date:** [January 22, 2021, 12:43am UTC](https://forum.thegraph.com/t/subgraph-for-wrapped-ether/115/1 "2021-01-22T00:43:54Z")

</div>

I had a project a bit back where I wanted to query Wrapped Ether so, of course, I built a subgraph for that.

I imagine it should be useful since nearly everyone user WETH in one way or another in DeFi but for the most part folks connect directly to the contract and read with Web3.

Also as you might imagine, it’s taking incredibly long to sync this subgraph, it’s been 8 days and it’s up to 93.4% and 27 Million entities!

Ironically, I found a small bug (really silly one too), but because it’s taking so long to sync I’m going to wait till it finishes syncing and then push up a new version. That way the first version remains available while it goes through another epic sync.

Have a look!

> **[KING WETH Subgraph](https://thegraph.com/explorer/subgraph/subgraphking/king-weth)**

---

<div class="post-metadata">

**Author:** ![dennison](https://avatars.discourse-cdn.com/v4/letter/d/ee7513/32.png) [@dennison](https://forum.thegraph.com/u/dennison)\
**Post date:** [February 2, 2021, 3:02pm UTC](https://forum.thegraph.com/t/subgraph-for-wrapped-ether/115/2 "2021-02-02T15:02:55Z")

</div>

Well Fam, it’s finally synced!

It took **TWENTY** days, and has over 62 **MILLION** entities, but it’s there. The whole of the WETH Ecosystem!

Want to see all the transaction with WETH where the users paid over 1000000 GAS?

```auto
transactions(
  where: {
    gasUsed_gt: 1000000
  } orderBy:value orderDirection:desc
){
  gasUsed
  gasPrice
  from {
    id
  }
  to {
    id
  }
}
}

```

---

<div class="post-metadata">

**Author:** ![dennison](https://avatars.discourse-cdn.com/v4/letter/d/ee7513/32.png) [@dennison](https://forum.thegraph.com/u/dennison)\
**Post date:** [February 2, 2021, 3:06pm UTC](https://forum.thegraph.com/t/subgraph-for-wrapped-ether/115/3 "2021-02-02T15:06:00Z")

</div>

Or maybe you want to see all the transactions where people sent ZERO Tokens, yet paid gas:

```auto
{
  tokenTransfers(
    where:{
      amount_lt: 1
    }
  ){
    amount
    transaction{
      id
      gasUsed
      gasPrice
    }
  }
}

```

---

<div class="post-metadata">

**Author:** ![indexer\_payne](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.thegraph.com/indexer_payne/32/44_2.png) [@indexer\_payne](https://forum.thegraph.com/u/indexer_payne)\
**Post date:** [February 3, 2021, 1:31am UTC](https://forum.thegraph.com/t/subgraph-for-wrapped-ether/115/4 "2021-02-03T01:31:42Z")

</div>

Hah, this is pretty cool 🕶