Commit Graph

511 Commits

Author SHA1 Message Date
Eric Laurello
6a30a3a3f0 typo 2025-07-23 15:57:18 -04:00
Eric Laurello
7f5241164c use new stats 2025-07-23 15:54:19 -04:00
Eric Laurello
0d7847a3d8 Merge branch 'main' into protocol-level 2025-07-23 15:49:18 -04:00
eric-laurello
1f906c20ee
Protocol interactions (#501)
* .

* prot interactions

* add in the hard start
2025-07-23 15:49:04 -04:00
Eric Laurello
52bcff3a53 bad push to main 2025-07-23 13:24:48 -04:00
Eric Laurello
8e5ffb2955 minor check 2025-07-23 13:23:34 -04:00
Eric Laurello
5610b2c734 protocol level 2025-07-23 11:48:13 -04:00
Eric Laurello
dbc9143abb fix base seed 2025-07-23 10:22:25 -04:00
drethereum
0dee5bcf86
revert (#497)
* revert

* revert lookbacks
2025-07-22 20:20:28 -06:00
drethereum
92e9a53393
temp incremental logic (#499) 2025-07-22 14:17:58 -06:00
drethereum
17afb6a0f5
wh (#496) 2025-07-22 13:10:44 -06:00
Austin
7cfa334303
all (#495) 2025-07-22 13:27:55 -04:00
Austin
acf1e7a934
version update (#494)
* version update

* updates
2025-07-22 13:23:15 -04:00
drethereum
077195c60a
protocol-column/defi (#490)
* protocol and protocol_version columns

* remove mantle

* columns

* platform as protocol

* remove fact tables

* added back to hourly job

* protocol

* Tags

* platform

* token updates

---------

Co-authored-by: Austin <austin@flipsidecrypto.com>
2025-07-22 11:06:10 -06: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
drethereum
ffa55e9852
exclude (#492) 2025-07-22 09:06:28 -06:00
eric-laurello
1f0ba69c3a
Protocol transfers (#483)
* checks

* tvl view and transfer summary with quality users

* checks

* .

* ..

* del tvl

* proc stats

* checkin

* allows (#487)

* xfer

* vc

* ready for review
2025-07-21 17:07:22 -04:00
Eric Laurello
8e301b796e fix for old modified data 2025-07-21 12:28:05 -04:00
Austin
0579273992
verified contracts (#489)
* verified contracts

* cluster
2025-07-21 11:22:53 -04:00
Eric Laurello
a57aea364c solana views 2025-07-18 14:53:10 -04:00
eric-laurello
0bf9f0c0de
Allowlists (#488)
* checks

* tvl view and transfer summary with quality users

* checks

* .

* ..

* del tvl

* proc stats

* checkin

* allows

* rm

* .
2025-07-18 14:18:24 -04:00
Mike Stepanovic
14332b319a
added qualify statement to remove duplicate address thor1ef...qdz (#486)
Co-authored-by: Mike Stepanovic <mike.stepanovic@flipsidecrypto.com>
2025-07-18 09:55:13 -06:00
eric-laurello
e827738b00
chain stats views (#485) 2025-07-18 08:15:01 -04:00
Matt Romano
8cd5747b16
AN-6425/protocol-label-standardization (#484)
* breakout protocol and version, pull into gold views

* morpho and aave amm case when

* update to morpho_blue

* joe lend updates
2025-07-17 12:28:25 -07:00
eric-laurello
83ded831a6
Token-flows-and-tvl stats (#482)
* checks

* tvl view and transfer summary with quality users

* pr comments, add protocol TVL

* rename to add in chain to the table name
2025-07-16 15:26:11 -04:00
Eric Laurello
23880c4731 performance 2025-07-15 23:02:59 -04:00
tarikceric
b3e084a565
replace deprecated dim_tokens for solana metadata (#479)
* replace deprecated dim_tokens for solana metadata

* update qualify
2025-07-15 10:04:48 -07:00
eric-laurello
3bae6f93ec
cex and stable stats (#477)
* cex and stable work

* checks

* docs
2025-07-15 13:00:40 -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
drethereum
33b87749b9
revert uk (#478) 2025-07-14 10:04:49 -06:00
Eric Laurello
a7720c48cd reset hard coded dates to 1/1 2025-07-10 10:31:40 -04:00
eric-laurello
adfcb8f006
dex stats (#476) 2025-07-10 10:01:19 -04:00
eric-laurello
a7a3e80cb5
Ez_bridge_stats (#468)
* check

* daily

* update defi, add stats

* desc

* ov

* add ink and core

* rm space

* add to gitignore and del file

* .
2025-07-08 15:11:52 -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
drethereum
c23f572782
Add/negative-price-logic (#474)
* price 0

* alias

* spacing
2025-06-30 15:14:48 -06: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
3d8afe2ad1 coalesce for non cmc/cg 2025-06-20 21:36:27 -04:00
Eric Laurello
32cf5edf1a hotfix/test misses 2025-06-19 08:54:32 -04:00
Sam
7b046f51e6
lookback and col (#469) 2025-06-19 08:58:19 +07:00
Austin
b9251fce45
update keys (#472) 2025-06-18 20:34:34 -04:00
Austin
d45f724340
key (#471) 2025-06-18 18:03:04 -04:00
eric-laurello
5043e23526
hotfix cmc imputed (#470) 2025-06-18 17:17:20 -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
drethereum
22d1574f31
default values (#467) 2025-06-17 14:20:23 -06:00
drethereum
bc3981eab3
AN-6358/price-adhoc (#465)
* history range prices model

* comment
2025-06-17 13:52:31 -06:00
Jack Forgash
c3f4acfd0e
upd to asset id col (#466) 2025-06-17 09:51:59 -06:00
Eric Laurello
1e438fc789 add workflow_dispatch: 2025-06-05 10:34:02 -04:00