Commit Graph

14 Commits

Author SHA1 Message Date
desmond-hui
0caeaca6ae
Migrate solscan token list call to solcan v2 (#720)
* remove legacy v1 call

* use solscan v2 data moving forward

* cleanup descriptions, columns, tests and formatting

* remove this is never used, remake it if we need in future
2024-11-26 08:59:23 -08:00
desmond-hui
5f7d79fc3b
refactor using quicknode and latest liverquery function (#705)
* refactor using quicknode and latest liverquery function

* allow manual workflow execution
2024-11-08 09:35:29 -08:00
desmond-hui
034e88e344
An 3943/get compressed nft addresses (#439)
* external funcs (wip)

* call compressed nft mint parser with external func

* ignore bronze_api models

* move to match standard location

* fix missing mints due to inconsistent ordering

* add a tag to bronze_api model, exclude accordingly

* update silver table to use new bronze api data

* wip

* handle non-mint events and multi mints per tx_id

* add regression test
2024-01-15 07:46:46 -08:00
tarikceric
19ea1ac5e7
update to use local lq (#432)
* update to use local lq

* create request in udf_api call

* add missing tokens
2024-01-04 14:56:28 -08:00
tarikceric
70e0e9df85
update to Solscan Pro API (#372) 2023-10-24 11:47:22 -07:00
tarikceric
a6d57153cd
An 3947/fix solscan token macro (#352)
* add for loop

* remove wait

* add test for recency
2023-09-26 13:48:02 -05:00
tarikceric
95500d603a
update total_pages (#335) 2023-08-28 13:05:01 -07:00
tarikceric
9e7896e707
adjust limit (#329) 2023-08-23 10:56:08 -07:00
tarikceric
cc265ddf29
An 3181/compressed nfts (#320)
* get onchain cNFT events

* update model

* macro for helius data ingestion

* exclude compressed nft models

* workflow for cNFTs

* compressed nft macros and models

* add is_compressed column and union compressed nfts

* add previous exclusions

* update per review comments

* update per pr comments
2023-08-17 07:18:03 -07:00
tarikceric
af8799ba2f
block_production model (#311)
* block_production model

* fix via grouping

* add source

* revise per pr comments

* add qualify to remove dupes

* formatting
2023-07-05 13:00:18 -07:00
tarikceric
b77c603690
An 3272/solscan api key (#300)
* add token to solscan call

* add crosschain apis_key

* get solscan tokens weekly

* adjust solscan token ingestion

* increase wait time
2023-05-26 11:50:34 -07:00
eric-laurello
e92cc493a6
AN-2517 cross chain and solscan address to symbol to price (#176)
* cross chain and solscan address to symbol to price

* update incremental, rename, ephemeral swaps

* ez price simplification

* use the dim date hour view instead of distinct

* remove bronze, add to seed, remove swaps view

* dynamic filter for silver prices tables
2022-12-08 14:00:02 -05:00
desmond-hui
5a363000d8
reduce amount, throttled by solscan api 2022-11-04 12:09:57 -07:00
desmond-hui
ed2ea44948
get token metadata macro (#150)
* get token metadata macro

* pr fix

* process 100 at a time
2022-11-04 11:19:03 -07:00