Build friend.tech subgraph

[melotik]

https://www.friend.tech/

Tasks

Preview Give feedback

1. Create schema/define important metrics
2. Build Base subgraph

[bye43]

@dhruv-chauhan Going through some metrics still, but a few QA comments (these may or not be issues, but figured I would let you know)

• The TVL is about 17% different than defiLlama and it looks like this starts around 09/13
  

• The daily active buyers (which also means users) seem to be less than what Dune and Token Terminal are reporting 35K on the largest spike and we are reporting around 21K
  
  

• The buy and sell volumes seem to be different than this Dune too
  
  

• The trader and subject stats also seem to be slightly off when I am comparing this query to the Friend.Tech Subject Stats module on this Dune dashboard. Will list some differences I am seeing below:

trader: 0xef5391a73e2cb70ae0435b4395a8db4beaec1934

Metrics	Subgraph	Dune
Buy Count	2335	2218
Sell Count	680	339
Total Volume (ETH)	1270	1161
Buy Volume (ETH)	754	709
Sell Volume (ETH)	516	451

subject: 0x730905a69bbd316e2a39bdf22dd866b6d97625fe

Metrics	Subgraph	Dune
Share Price	28.73	1.26
Buy Count	13	13
Sell Count	1	1

[bye43]

@dhruv-chauhan the buy and sell volume still looks off on the newer version. And did we remove the traders and subjects entities? If so, was there a reason?

[dhruv-chauhan]

• Buy and Sell Volume:
  I think the reading on the graphs are a bit different due to timezone difference on calculating days, since the pattern and ranges otherwise look similar. Also, the cumulative of these volumes match the dune dashboard: [query]

Metrics	Dune	Subgraph
Cumulative Buy Volume (USD)	265,857,07	265821697.556003351078125
Cumulative Sell Volume (USD)	242,876,149	242733890.176980244245
Cumulative Total Volume (USD)	508,495,454	508555587.732983595323125

• Trader and Subject Stats:
  Yes, we changed Trader and Subject entities to Account and Pool respectively to match the generic schema.
  Also note, each subject is a trader; but, a trader does not compulsorily have to be a subject. For each address, there might be a Pool and an Account entity.

address: 0xef5391a73e2cb70ae0435b4395a8db4beaec1934

Pool (subject) Stats [query],

Metrics	Dune	Subgraph
Buy Count	519	521
Buy Volume (Eth)	818.4754	818.475437500000000000
Sell Count	390	391
Sell Volume (Eth)	773.2314	773.231375000000000000
Total Volume (Eth)	1.5917k	1591.706812500000000000
Share Price (Eth)	1.05625	1.056250000000000000
Supply	130	130
Fee (USD)	134.04k	133956.35218445184109375

Account (trader) Stats [query]

address: 0x730905a69bbd316e2a39bdf22dd866b6d97625fe

Pool (subject) Stats [query],

Metrics	Dune	Subgraph
Buy Count	14	14
Buy Volume (Eth)	88.1353	88.135312500000000000
Sell Count	4	4
Sell Volume (Eth)	78.4381	78.438125000000000000
Total Volume (Eth)	166.5734	166.573437500000000000
Share Price (Eth)	0.38025	0.380250000000000000
Supply	78	78
Fee (USD)	13.52k	13516.209728405909375

As Account (trader) [query]

@bye43

[bye43]

O I see that makes sense. Thanks for the explanation! This looks good to me then. Closing this out

[dhruv-chauhan]

Failed to deploy to Graph node https://api.thegraph.com/deploy/: subgraph failure::[Base Mainnet] chain is no longer supported on the hosted service. Please deploy to the decentralized network.

@melotik @bye43