ClickHouse / CryptoHouse

Artifacts including queries and materialized views used for CryptoHouse
https://crypto.clickhouse.com
Apache License 2.0
28 stars 3 forks source link

Support on adding new decoding tables for NFT Trades in Solana #3

Open jensenity opened 1 month ago

jensenity commented 1 month ago

Provide the example query you'd like to add

I want to contribute and planning to add example NFT trade in Solana here. 2 largest marketplaces like MagicEden & Tensor. There are a few decoded instruction_calls(call in dune) I would love to add here, hence my first question, is there any plans to add decoded tables?

If so, how can for instance I can help to add these decoded calls into CryptoHouse as well?

Tensor

TSWAPaqyCSx2KABk68Shruf4rp7CxcNi8hAsbdwmHbN

  1. v1: buyNft
  2. v1: buySingleListing
  3. v1: sellNftTokenPool

TCMPhJdwDryooaGtiocG1u3xcYbRpiJzb283XfCZsDp

  1. v2: takeBidFullMeta
  2. v2: takeBidMetaHash
  3. v2: buy

Does the view need a materialized view?

Not Sure

jeffling commented 1 month ago

We have plans on adding the instructions table first, then we can look into decoded tables after (possible with a materialized view)

the ideal would be to be able to do decoding right in clickhouse through a UDF