Commit Graph

99 Commits

Author SHA1 Message Date
shah
7b8d4f490f added setup documentation 2023-06-09 07:17:07 -07:00
shah
135ec945d9 added api integrations, udft and streamline udfs 2023-06-08 19:49:54 -07:00
shah
e01570a149 added streamline api_integration macros 2023-05-24 11:35:36 -07:00
drethereum
6362de2b91
input strategy (#100) 2023-05-22 19:54:02 -06:00
Austin
56d90501d1
decoding base (#99) 2023-05-18 13:46:01 -04:00
drethereum
2c6a612ed4
null price logic (#98) 2023-05-16 11:48:51 -06:00
drethereum
a2afbce8b7
add/shares-ref-usage (#97)
* added models for shares references

* adds lookback
2023-05-04 12:31:22 -06:00
drethereum
c16487ee8c
AN-3050/op-dex-upgrade (#96)
* folder structure

* dodo, frax, kyber, and woofi added

* incremental logic and complete dex swaps

* update docs and complete usd threshold

* curve pools and swaps rebuild

* pool_name

* pool address change in beethoven

* sushi and beethoven pools

* incremental logic

* where logic on frax

* fixed pool_name in curve and added legacy pools for univ3

* added event for dodo

* removed orderhistory event from dodo

* added incremental logic on velodrome cte
2023-05-01 15:18:16 -06:00
eric-laurello
3c6e229104
fix for unadj amts (#95) 2023-04-19 15:50:27 -04:00
eric-laurello
6efab04836
AN-2951 add unadj amounts (#94)
* add unadj amounts

* spacing for tags

---------

Co-authored-by: drethereum <trevor.wenokur@gmail.com>
2023-04-19 11:05:27 -04:00
drethereum
f542ffcd43
add contracts to token xfers (#92) 2023-04-17 13:11:14 -06:00
drethereum
80228bc653
adds case for null origin_to_address to resolve bug (#93) 2023-04-17 12:22:39 -06:00
drethereum
d55907f626
AN-2944/op-price-pivot (#91)
* pivoted source for core prices to crosschain

* weth address added

* changed source to original source

* removed where clause in ez_transfers

* disabled sushi schema models as part of deprecation process

* disabled silver prices

* added ez_token_transfers and updated docs

* prices change

---------

Co-authored-by: sam <sam@flipsidecrypto.com>
2023-04-11 12:40:33 -06:00
drethereum
62dbd046d6
AN-2933/dex-meta-price-pivot (#90)
* uni v3 metadata price pivot and created complete_dex_swaps

* synthetix metadata price pivot

* curve and beethoven metadata price pivot

* sushi metadata price pivot

* clean up for complete_dex_swaps columns

* inserted timestamp column for incrementals

* data type update in curve swaps tests

* removed comments

* changed price source to view for velodrome

* changed price source to view for velodrome

* silver_dex sushi models
2023-04-06 10:52:20 -06:00
Austin
869d851ce3
disable tests (#89) 2023-04-03 11:20:17 -04:00
Austin
1ef928984b
op fixes (#88) 2023-03-22 17:07:22 -04:00
Austin
345da60ac8
abi change (#87) 2023-03-20 15:54:24 -04:00
Austin
8c8a5526a6
overview page (#86) 2023-03-13 15:57:30 -06:00
drethereum
bff935b97b
added regex to remove white spaces (#85) 2023-02-22 13:15:13 -07:00
desmond-hui
805cca8ba5
community curation setup (#83)
* community curation setup

* PR fixes

* Delete .user.yml

---------

Co-authored-by: Jack Forgash <58153492+forgxyz@users.noreply.github.com>
2023-02-20 14:41:51 -08:00
drethereum
81e35922b0
additional deprecation flags (#82) 2023-02-15 11:39:05 -07:00
drethereum
2d3b9d5bbb
updated dbt test workflow for vars (#81) 2023-02-13 12:22:25 -07:00
Austin
36552013fd
proxy rework (#80) 2023-02-08 17:24:05 -05:00
drethereum
6d92038906
changed warehouse variable to ref inputs (#79) 2023-02-07 16:37:07 -07:00
drethereum
787dfb1551
updated workflows to ref env vars (#78) 2023-02-06 15:22:28 -07:00
drethereum
4528d47adf
AN-2548/op-ez-dex-swaps (#76)
* created core__ez_dex_swaps view

* added synthetix swaps models and adjusted velodrome / sushi models for necessary ez_dex columns

* fixed error in velo pools backfill seed causing duplicates

* fixed issue with silver prices causing duplicate token_address

* added univ3 pools and swaps models for integration into ez_dex_swaps

* replaced null event_names with swap

* added univ3 to dex_swaps and added not null event name test

* updated gitignore for dbt-env

* curve pools silver model

* added incremental logic to curve pools table

* adjusted data type on decimal column

* updated curve_pools and added curve_swaps

* case when for null event_name

* removed dbt-env

* snowflake tagging for ez_dex_swaps

* added beethoven swaps and pools tables, and joined them to ez_dex_swaps

* beethoven pools yml

* removed column from synthetix swaps yml

* recreated velodrome pools model using the reads udf

* change event_name to reference topic

* deleted velo_pools_backfill seed and hardcoded function sigs

* changed udf_hex_to_int ref to ethereum.public

* changed synthetix swaps to reference data instead of event inputs

* changed event_input references to data in beethoven models

* rounded usd values

* modified tx_to logic in curve swaps

* modified curve swaps for proper volumes
2023-02-02 13:15:54 -07:00
drethereum
27f344bbde
AN-2728/dev-tag-fix-op (#77)
* changed sp

* removed aws role from sp
2023-01-31 08:40:57 -07:00
drethereum
819beaad5a
added tags, macros and updates to readme for snowflake tagging (#75) 2023-01-23 10:25:39 -07:00
drethereum
08260a1fee
added dbt docs job and concurrency (#74) 2023-01-17 10:17:46 -07:00
drethereum
81a6c0ece8
AN-2620/velodrome-swaps-null-bug (#71)
* adjusted JOIN logic to account for decimal discrepancy

* reverted changes to silver model and added case when in gold view

* spacing
2023-01-09 16:48:38 -07:00
drethereum
2e15ee524d
temp/remove-temp-job (#73)
* removed temporary job

* extended dim_dates table
2023-01-09 16:07:28 -07:00
drethereum
01166170eb
temp/test-for-job-alerts (#72)
* added new temp test for testing data dog alerts

* changed cron schedule

* fixed typo
2023-01-09 13:37:33 -07:00
drethereum
f3cef88f46
added missing event based on reported bug (#70) 2023-01-09 10:30:06 -07:00
Sam
7e740e831f
incrementals (#69) 2023-01-05 21:16:51 -05:00
Sam
bc6fd61b4c
separate opensea vs quix, fix quix contracts (#65)
* separate opensea vs quix

* removed non null currency symbol test
2023-01-06 09:35:29 +08:00
Austin
f9f0abb156
odd hours (#68) 2023-01-05 19:16:06 -05:00
austin
6cf28907c4 Revert "run on odd hours"
This reverts commit 75bba56de0.
2023-01-05 19:12:14 -05:00
austin
75bba56de0 run on odd hours 2023-01-05 19:10:55 -05:00
drethereum
da7fffe79b
changed db and warehouse env_var reference (#66) 2023-01-05 08:53:35 -07:00
drethereum
796d9a35ef
updated github action jobs (#64) 2023-01-04 16:09:59 -07:00
drethereum
34a2b3d334
add/github-actions-job-update (#63)
* added and updated dbt run/test jobs for optimism

* changed naming convention

* updated incremental job name

* removed placeholder job
2023-01-04 10:59:01 -07:00
drethereum
c8c78bf62d
AN-2581/unique-key-tx-test (#60)
* changed unique keys on logs and traces and added new test to logs

* added dbt-env to gitignore for SSO functionality
2023-01-03 14:07:13 -07:00
Austin
66316c24d4
hc (#62) 2022-12-28 13:24:12 -05:00
Austin
73152b3158
quix fixes (#59) 2022-12-17 09:26:16 +08:00
eric-laurello
a8b5ee6cad
custom query tags (#58) 2022-12-13 18:14:25 -08:00
xiuy001
68858708ad
added profiles (#57)
Co-authored-by: yulike <xiuyangguan@gmail.com>
2022-12-07 13:22:06 -05:00
xiuy001
4b8302a484
updated (#56)
Co-authored-by: yulike <xiuyangguan@gmail.com>
2022-12-07 13:15:10 -05:00
Austin
8966d61f4c
back up recency (#55) 2022-12-07 23:57:50 +08:00
Austin
52fd64995c
task to model (#54) 2022-12-05 15:17:47 -05:00
Austin
9850f74212
An 2508/prices (#52)
* stash

* reworked prices

* swap
2022-11-30 14:19:59 -05:00