Commit Graph

913 Commits

Author SHA1 Message Date
Austin
723c789494 uni v4 2026-01-26 12:33:18 -05:00
drethereum
1b88adb52d
Merge pull request #468 from FlipsideCrypto/DAT2-211/tvl-pipeline
DAT2-211/tvl-pipeline
2026-01-22 09:30:48 -07:00
drethereum
e00363c893 Fix unverify_tvl macro - Snowflake CTEs not allowed with DELETE
Convert CTEs to inline subqueries since Snowflake does not support
WITH ... DELETE syntax.

Co-Authored-By: Claude Opus 4.5 <noreply@anthropic.com>
2026-01-21 15:02:43 -07:00
drethereum
db74160aa8 morpho 2026-01-21 13:11:46 -07:00
drethereum
c35365ef71 usd threshold var 2026-01-21 10:54:44 -07:00
Matt Romano
6478eaa3ce
Merge pull request #463 from FlipsideCrypto/DAT2-226/ink-nado-perps-curation
CUS2-45/ink-nado-perps-curation
2026-01-20 11:38:03 -08:00
mattromano
6146ec4671 update to general hourly, add to workflow sched macro 2026-01-20 11:24:46 -08:00
drethereum
8dfc21b105 nado 2026-01-20 10:59:13 -07:00
drethereum
c113992f83 Merge remote-tracking branch 'origin/main' into DAT2-211/tvl-pipeline 2026-01-20 09:57:05 -07:00
drethereum
efcdec6eb2
Merge pull request #465 from FlipsideCrypto/fix/bronze-not-null
fix/bronze-not-null
2026-01-20 09:52:40 -07:00
drethereum
7443acdfcb macro 2026-01-16 12:00:53 -07:00
mattromano
c98e902ed9 add test macro 2026-01-16 09:33:17 -08:00
Austin
8792917d0d feat: add velodrome slipstream to optimism via superchain_slipstream
- Add superchain_slipstream factory to optimism_vars.sql
- Remove separate velodrome_v3 models (use existing superchain_slipstream)
- Clean up velodrome_v3 CTEs from complete_dex models

Co-Authored-By: Claude Opus 4.5 <noreply@anthropic.com>
2026-01-16 11:57:37 -05:00
Austin
ec98bceac5 Add Velodrome v3 (CL) pools, swaps, and LP actions for Optimism
- Add silver_dex__velodrome_v3_pools.sql (both CL factories)
- Add silver_dex__velodrome_v3_swaps.sql (Uniswap v3 style)
- Add silver_dex__velodrome_v3_pool_actions.sql (Mint/Burn)
- Add v3 factory addresses to optimism_vars.sql
- Integrate into complete_dex_* models

Co-Authored-By: Claude Opus 4.5 <noreply@anthropic.com>
2026-01-15 21:02:19 -05:00
mattromano
e1b0b60948 add spot addresses 2026-01-15 11:25:01 -08:00
mattromano
e1262b0d21 Merge branch 'main' of github.com:FlipsideCrypto/fsc-evm into DAT2-226/ink-nado-perps-curation 2026-01-15 10:12:13 -08:00
drethereum
d3f1647f17 somnia vault path 2026-01-15 09:25:18 -07:00
drethereum
f6d0f58b32 Merge remote-tracking branch 'origin/main' into fix/bronze-not-null 2026-01-15 09:24:51 -07:00
Austin
64aa689140 feat: expand Uniswap v4 and Quickswap coverage
Add Uniswap v4 factory addresses:
- Arbitrum: 0x360e68faccca8ca495c1b759fd9eee466db9fb32
- BSC: 0x28e2ea090877bf75740558f6bfb36a5ffee9e9df
- Polygon: 0x67366782805870060151383f4bbff9dab53e5cd6
- Base: 0x498581ff718922c3f8e6a244956af099b2652b2b

Add Quickswap to Base:
- v1 (their v2): 0xec6540261aaae13f236a032d454dc9287e52e56a
- v4 (Algebra v4): 0xc5396866754799b9720125b104ae01d935ab9c7b

DAT2-239

Co-Authored-By: Claude Opus 4.5 <noreply@anthropic.com>
2026-01-15 11:03:24 -05:00
Austin
db0dbc147c Add Fluid DEX factory addresses for Arbitrum, Base, and Polygon
Adds the Fluid DEX v1 factory address (0x91716c4eda1fb55e84bf8b4c7085f84285c19085)
to CURATED_DEFI_DEX_SWAPS_CONTRACT_MAPPING for multi-chain support.

Co-Authored-By: Claude Opus 4.5 <noreply@anthropic.com>
2026-01-14 20:23:03 -05:00
Austin
59dd1e7a81 Add Fluid DEX v1 models for Ethereum
Adds Fluid DEX protocol support with pools, swaps, and LP actions models.

New models:
- silver_dex__fluid_v1_pools: Pool creation from DexT1Deployed events
- silver_dex__fluid_v1_swaps: Swap events with direction handling
- silver_dex__fluid_v1_pool_actions: Collateral deposit/withdraw as LP actions

Integrations:
- Added Fluid factory addresses to ethereum_vars
- Added fluid_v1 to complete_dex_swaps
- Added fluid_v1 to complete_dex_liquidity_pools
- Added fluid_v1 to complete_dex_liquidity_pool_actions

Co-Authored-By: Claude Opus 4.5 <noreply@anthropic.com>
2026-01-14 17:06:11 -05:00
drethereum
05141a60a8 null filter 2026-01-14 08:37:33 -07:00
Matt Romano
59a1e9d597
Merge pull request #451 from FlipsideCrypto/DAT2-192/upgrade-dbt-version-1.10
DAT2-192/upgrade-dbt-version-1.11
2026-01-13 12:42:52 -08:00
drethereum
9be76804a9 aave fork version 2026-01-12 14:31:25 -07:00
drethereum
9e0ad3f65d somnia vars and revert realtime alt node logic 2026-01-12 13:25:06 -07:00
mattromano
ed6bf5b32b Merge branch 'main' of github.com:FlipsideCrypto/fsc-evm into DAT2-192/upgrade-dbt-version-1.10 2026-01-12 09:26:02 -08:00
drethereum
ce0c35d45b morpho 2026-01-09 15:02:42 -07:00
mattromano
712471305d configure for nado ink 2026-01-09 10:33:00 -08:00
drethereum
c385ff4394 merge 2026-01-07 11:45:54 -07:00
drethereum
6937463f77 heal filter 2026-01-06 11:47:54 -07:00
drethereum
ac487d2bac delete macro updates 2026-01-06 10:34:55 -07:00
drethereum
1c2abb10ee
Merge branch 'main' into DAT2-135/generic-reads 2026-01-06 09:28:04 -07:00
drethereum
19d90c3959 unverify tvl 2026-01-05 11:53:23 -07:00
drethereum
a52f95899a newly verified/unverify uni pools 2026-01-05 10:08:39 -07:00
mattromano
b87c064abc update custom name macro for dbt 1.8.6 changes 2025-12-31 11:23:52 -08:00
drethereum
036fda053a Merge remote-tracking branch 'origin/main' into DAT2-58/somnia-ankr-node 2025-12-29 12:45:32 -07:00
drethereum
141dca64ca ink 2025-12-29 08:23:58 -07:00
drethereum
9524636f5e recency vars 2025-12-29 08:11:07 -07:00
drethereum
43dba945e8 alt node vars 2025-12-23 09:53:37 -07:00
mattromano
a32a98e644 revert and fix predicates alias 2025-12-16 15:45:13 -08:00
mattromano
024b4d6c1c try new version 2025-12-16 15:08:07 -08:00
mattromano
b5f5ca7943 update deprecated incremental predicates function 2025-12-16 14:53:04 -08:00
mattromano
77ded773d2 update get merge 2025-12-16 14:41:18 -08:00
mattromano
c11ad42cef update get merge 2025-12-16 12:18:59 -08:00
drethereum
4f8e40db8c update vars 2025-12-10 15:05:08 -07:00
mattromano
debbeba3de override get merge macro 2025-12-10 11:03:33 -08:00
mattromano
654d6a26f6 update incremental predicates for 1.10 2025-12-10 10:40:56 -08:00
drethereum
d71c511b52 integrate stablecoin reads into generic pipeline, add heal logic 2025-12-09 11:49:35 -07:00
drethereum
50bb0bc8b7 merge 2025-12-09 11:12:30 -07:00
drethereum
8de859b55c curated recency exclusion for uni v1 2025-12-04 11:47:25 -07:00