Commit Graph

60 Commits

Author SHA1 Message Date
eric-laurello
78357f8e20
Add sui to verified tokens (#518)
Some checks failed
docs_update / docs_update (push) Waiting to run
docs_update / notify-failure (push) Blocked by required conditions
dbt_repo_activity_contributors_weekly / dbt (push) Has been cancelled
dbt_repo_activity_contributors_weekly / notify-failure (push) Has been cancelled
dbt_run_heal_models / run_dbt_jobs (push) Has been cancelled
dbt_run_heal_models / notify-failure (push) Has been cancelled
* check

* md

* add seeds for native variants

* add native variants
2025-07-30 15:00:37 -04:00
Austin
6811ec65b6
Verify stg usdc (#519)
* verify stgUSDC

* id check

* or

* sysdate
2025-07-30 09:12:54 -04:00
eric-laurello
cd577fbc0d
WH tokens and boba and verified (#514)
* .

* wf

* clean lower

---------

Co-authored-by: Austin <austin@flipsidecrypto.com>
2025-07-29 12:01:43 -04:00
Austin
94a0974229
manually verified (#511)
* manually verified

* tag

* update
2025-07-28 16:33:02 -04:00
Austin
f9c286f87e
wusdl (#510) 2025-07-28 15:31:05 -04:00
tarikceric
c1ec444b95
add eclipse to manual verify; case-sensitive addr (#498)
* add eclipse to manual verify; case-sensitive addr

* update token info
2025-07-23 13:22:07 -07:00
Eric Laurello
dbc9143abb fix base seed 2025-07-23 10:22:25 -04:00
Austin
acf1e7a934
version update (#494)
* version update

* updates
2025-07-22 13:23:15 -04:00
eric-laurello
e3a8b993be
stable stats - net xfer (#493)
* net xfer

* seed change

---------

Co-authored-by: Austin <austin@flipsidecrypto.com>
2025-07-22 12:06:51 -04:00
Austin
3fb84c0b74
updates (#481) 2025-07-15 11:01:29 -04:00
Eric Laurello
9e6f001097 fix seed 2025-07-14 14:57:47 -04:00
Austin
82d3643508
add evm stablecoins (#480)
* add evm stablecoins

* add aptos

* verified modified timestamp

* manully add verified solana stablecoins

* set verified to true for sol stables

---------

Co-authored-by: Eric Laurello <eric.laurello@flipsidecrypto.com>
Co-authored-by: tarikceric <tarik@flipsidecrypto.com>
2025-07-14 14:56:33 -04:00
eric-laurello
768d1dad4b
AN-6387 add tokens for aptos to seed (#475)
* add tokens for aptos to seed

* bad '
2025-07-02 13:34:55 -04:00
Sam
58132eb4e7
Add standardised chain names for bridging & join on gold bridge table (#473)
* add file and join

* add seed

* standardize names

* add
2025-06-26 22:38:09 +08:00
Matt Romano
68b4d00ccc
AN-6288/outcomes-reference-table (#459)
* add view model and yml

* update yml

* defillama protocol matching

* add matching strategies

* move to silver, add to sources, update inc

* add seed

* fix formatting

* add filter fix

* update

* add highest priority manual match into seed file

* delete redundant

* fuzzy match updates

* comments

* add top symbols agg, add restriction params

* small updates

* remove long columns, add usd volume for lp and swap aggs

* add coalesce to swap

* update incremental skip if no new data

* fix refresh to only when there's new platforms

* revert models to full run daily, with 30 day windowon symbols

* drop restrictions

* Update data/silver__outcomes_protocol_mappings.csv

Co-authored-by: Copilot <175728472+Copilot@users.noreply.github.com>

* update top symbols model

* update models

* update yml and incremental

* update ymls

* Update models/sources.yml

Co-authored-by: Copilot <175728472+Copilot@users.noreply.github.com>

* remove symbols model

---------

Co-authored-by: Copilot <175728472+Copilot@users.noreply.github.com>
Co-authored-by: Austin <austin@flipsidecrypto.com>
2025-06-25 11:36:32 -04:00
eric-laurello
5e048aedaf
AN-6030 applying verified tag and cmc/cg metadata (#464)
* add token metadata/legit score model

* add blockchain score summary dim

* add comments

* add osmos

* update to boolean

* v1

* .

* add other chains

* add chains

* tweaks

* check

* format

* updates - only use metadata once

* add token metadata and percentiles ymls

* use the new tokens table and not dim contracts

* rollback prices updates

* .

* .

* com

* checks

* updts

* more updates

* test upd

* gold, is_verified, more cleanup

* exclude token, add check to make sure enhanced and all doesnt overlap

* fix is_ver and add SO on the d+i field

* update metadata threshold metrics

* update spike ratio metrics

* rounds

* FR for newly verified tokens

* Add manual mapping and override
Add test for unmapped but verified tokens

* fix test

* update scores, add contract creation date, update weights

* ver mod ts

* .

* final check in

* aptos 0xa

* evm mapped tokens

* upd near and flow verified token mapping

* aptos,maya,tho

* test serv -> warn

---------

Co-authored-by: mattromano <mattromano88@gmail.com>
Co-authored-by: Austin <austin@flipsidecrypto.com>
Co-authored-by: Jack Forgash <58153492+forgxyz@users.noreply.github.com>
2025-06-18 15:22:03 -04:00
Eric Laurello
14e11930a9 more perf upgrades 2025-05-29 11:08:51 -04:00
eric-laurello
fd56dc6873
AN-6027 stats activity table (#456)
* build stats activity table

* .

* sei address mapping and more performance upgrades

* final performance updates

* evms

* clean up

* edge case for null dates

* add metrics_daily workflow at 6am UTC

* columns descriptions overview
2025-05-27 13:48:13 -04:00
tarikceric
6cef0550b3
fix native solana decimal (#457) 2025-05-19 15:14:52 -07:00
tarikceric
e255edcc5f
unifai sl ingestion bronze and silver (#441)
* unifai sl ingestion bronze and silver

* use call_function_v2 and add exploded_key

* use exploded key

* adjust float values

* use data col

* use secret

* add chain to qualify and pk

* update worker
2025-05-06 11:25:35 -07:00
Mike Stepanovic
5ceeed9137
add movement (#429)
Co-authored-by: Mike Stepanovic <mike.stepanovic@flipsidecrypto.com>
2025-03-17 11:28:50 -06:00
Graham Onders
d51c845dfb
update seed file (#428) 2025-03-07 12:37:49 -05:00
Jack Forgash
c0d5174a27
add 4 native assets (#427) 2025-03-07 09:27:56 -07:00
Graham Onders
fce12c7de9
bybit hack tag (#426) 2025-03-05 15:16:19 -05:00
drethereum
9144bcad8c
new assets (#422) 2025-02-13 10:59:17 -07:00
Graham Onders
816f5f44f5
flow_evm tags (#403)
* flow_evm tags

* fix dates
2024-11-20 09:38:38 -07:00
drethereum
1e42fded1c
Add/aleo-native-asset (#396)
* aleo

* add tags
2024-11-12 13:56:22 -07:00
drethereum
a9258e7e75
mantle mnt (#394) 2024-10-31 15:53:15 -06:00
drethereum
60f4c356ed
core asset (#391) 2024-10-08 18:37:53 -06:00
WHYTEWYLL
03acafed2e
Update silver__near_github_repos.csv (#369)
column name was deleted
2024-07-15 09:23:27 -07:00
s-n-park
800f2afdc5
Additional repos from EC mid-year update (#365) 2024-07-15 08:55:33 -07:00
s-n-park
ff47885fb6
Update silver__near_github_repos.csv (#352)
added additional repos from near.toml file
2024-06-17 00:19:01 -07:00
drethereum
8e2368a457
AN-4627/prices-v2 (#338)
* deprecation notices and references for new models

* remove lower for solana

* source name

* aurora

* modified timestamp for edge case

* carve out aptos as special token address format

---------

Co-authored-by: Eric Laurello <eric.laurello@flipsidecrypto.com>
2024-05-01 10:45:21 -06:00
drethereum
3368c0bb11
add/new-native-tokens1 (#334)
* new native assets

* updated name and id
2024-04-22 13:57:47 -06:00
drethereum
cf7ddbcc90
Add/prices-v2-test-configs (#319)
* test configs

* adjust cron schedule

* remove test

* m instead of s

* remove schedule

* priority for missing prices with :30 timestamp

* unique key

* delete foo

* adj platform
2024-04-15 11:17:21 -06:00
drethereum
fa258ad3ea
AN-4628/native-prices (#314)
* initial models

* updates for symbol

* complete and views

* updated native seed

* unique key

* native prices

* native assets unioned into gold views

* native

* is_native

* docs

* decimals

* 18

* docs
2024-04-05 14:58:51 -06:00
drethereum
82332272c8
AN-4377/rebuild silver prices (#298)
* imputing period

* gap test

* >0

* cmc imputing

* all providers draft

* filters

* edits to asset metadata and last timestamp

* comments

* source

* token address adj

* comments

* rebuild all providers asset metadata

* rebuild all providers prices

* gap test filter

* typo

* osmo 2

* osmo2 yml

* lookback

* is deprecated

* tag for new models

* remove tag

* https filter

* http filter

* inner join solana cmc

* http

* final adj

* more filters

* trim quote

* denom extracted
2024-03-19 09:16:28 -06:00
drethereum
0f30a4b0a2
add tasks (#296) 2024-03-14 16:20:31 -06:00
drethereum
62b8406184
remove (#295) 2024-03-14 13:08:44 -06:00
drethereum
a7f0be3308
fix/history-timing (#294)
* new history model and tasks

* schedule

* backfill model

* history

* history sched

* filters

* revert commit
2024-03-14 12:55:23 -06:00
s-n-park
98dbe3cccd
Add additional NEAR repos to pipeline (#286)
* Add additional NEAR repos to pipeline

* Add repos from organizations
2024-03-12 00:13:04 -03:00
WHYTEWYLL
9daa6fa629
new repos (#269) 2024-02-27 13:15:38 -03:00
WHYTEWYLL
6ff1c026cb
Retry logic for 202 (#195)
* adding full refresh

* handling 202 retry

* adding colum

* rename

* core

* deleting coma

* 1 call

* 5 and system wait

* adding frequency

* working version

* refactored

* adjusting limit

* working version

* contributors job

* refactor

* fix: format

* add: missing repos

* job adjust

* csv updated

* livequery update

* jobs run
2023-11-03 06:27:23 -07:00
Graham Onders
e8e9f0f56a
Israel tags (#209)
* fixes to sanctioned address tags

* sei ambassador tags
2023-10-31 14:51:13 -06:00
WHYTEWYLL
19f2c08452
addin dev activity (#179)
* add: base github

* fix: arrays

* fix: list

* fix: SW script to javascript

* fix: execite

* working version

* env_variable

* add: frecuency

* rentry logic

* stable code'

* delete extra

* refactor no SYSTEMWAIT

* limit

* Working version

* jobs and working version

* deleting: type column

* data unpacking

* silver model and test

* fix: limit; delete: not used functions;

* working version

* add: date

* secret name

* add: secret string
2023-09-27 12:51:55 -07:00
Graham Onders
70f9113eae
opensea name tags (#175) 2023-09-12 14:41:03 -06:00
Graham Onders
c0998ae7ec
add verified token tag (#165) 2023-08-22 16:29:19 -06:00
Graham Onders
54fc865991
Bridge label + influencer/fund tags (#144)
* fix labels to bridge from layer2

* tags for fund/influencer addresses
2023-06-13 09:55:47 -06:00
Graham Onders
2134343e31
add dydx delegate tag (#133) 2023-05-18 11:45:35 -07:00
Graham Onders
5a393e97b3
add chainlink seed file (#115) 2023-03-15 11:30:27 -06:00