Commit Graph

47 Commits

Author SHA1 Message Date
drethereum
288b86157a
AN-5990/arb-migration (#321)
* models - streamline - core , decoder

* delete bronze subfolders

* models - docs, gh

* silver - observablity, core, abis, prices, stats, nft transfers

* gold - stats, price, core, nft transfers

* sources

* tests, dbt project, packages, makefile, python folder, slack notify yml

* macros, and empty folders

* remove base

* update for fsc-evm changes - package, makefile, sources, dbt_project, workflows, docs

* gold tags

* silver bridge tags

* dex tags

* lending tags

* nft tags

* protocol tags

* temp package

* docs

* wh

* 48

---------

Co-authored-by: sam <sam@flipsidecrypto.com>
2025-05-08 10:03:03 -06:00
drethereum
384d1b11e4
AN-5775/sl2-migration-arb (#307)
* initial build pt 1

* decoder changes

* dbt project

* arbtrace_block history

* global node url

* comments

* removed macro

* partition_key

* prod uri
2025-02-19 10:21:38 -07:00
San Yong
ee626ef6f1
topic updates (#305)
* topic updates

* remove tx_status

* updated to topic_0

* changes for standardization

---------

Co-authored-by: drethereum <trevor.wenokur@gmail.com>
2025-02-12 14:12:03 -07:00
Sam
9fb6bb11fd
An 5332/arb standardization v2 (#301)
* decoded logs

* core changes

* update silver core

* add bridge

* add dex

* add lending

* add nft

* add nft remaining

* fix nft

* add olas

* docs

* add docs

* remove dupe

* remove origin from silver nft transfers

* remove changes to fact traces col positions

* misc

* revert native transfer changes

* revert native transfers

* docs

* remove identifier, clean up

* revert

* tests

* base feee

* update deprecation date to March 10
2025-02-10 21:21:28 +07:00
Austin
e59ae662c0
typo (#282) 2024-11-19 15:35:07 -05:00
Austin
5afa615908
use better process (#277)
* use better process

* schedule

* check query

* updates

* dev refresh

* comment

* 5 day

* monday

* param
2024-11-19 15:04:15 -05:00
Matt Romano
c474faf8ab
AN-5192/vertex-blitz-failures (#269)
* add product qualifies

* get rid of changes

* add back in tests

* revert model changes

* format

* push back test
2024-09-18 10:20:50 -07:00
Austin
0f1e330251
predicate (#267) 2024-09-12 11:17:06 -04:00
Austin
80b1f158dc
Test marco update (#266)
* stash

* predicates
2024-09-11 23:26:10 -04:00
Austin
965838ce19
predicate (#264) 2024-09-11 17:20:30 -04:00
Austin
af4c00e4d4
An 4954/fsc evm traces macros (#261)
* core traces 2

* fr flag

* params

* 10m

* fr

* version
2024-09-10 16:52:01 -04:00
Austin
c288f38486
block number filter (#251) 2024-07-01 12:18:12 -04:00
Austin
c99070cb97
update test (#248) 2024-06-27 00:04:49 -04:00
Matt Romano
0183969e70
AND block_timestamp < sysdate() - INTERVAL '2 days' (#238) 2024-05-24 11:27:00 -07:00
Matt Romano
7c0999e933
vertex-product-recency-update (#235)
* add buffer

* dim product updates for v2 products

* switch to macro level
2024-05-14 10:45:39 -07:00
Matt Romano
c829221f3f
update vert prod rec (#232) 2024-04-23 13:52:43 -07:00
Austin
400253fe8f
missing logs (#227) 2024-04-11 12:04:10 -04:00
Matt Romano
5bc4942acd
AN-4567/vertex-curated-tables (#224)
* add market stats started model

* working funding rates pull

* market stats final

* market stats and market depth models

* add staking model

* quick push

* add edge trading model

* update market stats and depth

* incremental updates

* add gold layer vertex skeleton

* ADD YML COLUMNS

* doc update

* add final docs

* add edge trades

* staking fix and test fixes

* FIX EDGE TRADES

* remove market stats no fr config

* fix market stats model

* format models

* remove no FR config for initial PR

* overview doc

* add ranks to account stats

* add custom tests for API call completeness

* update tests to take filter variable

* add product level rece tests

* change ez names plus add spot to account stats

* typo

* typo

* overview doc fixes

* typo

* update edge trade format

* add tests to new edge fields

* gold doc fixes

* updated market depth id

---------

Co-authored-by: Austin <austin@flipsidecrypto.com>
2024-04-04 13:50:10 -07:00
Austin
e04810fdda
exclude error code (#144) 2023-10-04 15:01:16 -06:00
Austin
61fb75b6fe
select (#136) 2023-09-07 09:56:05 -04:00
Austin
8cd754bc33
An 3670/precise columns (#107)
* stash

* 0s and create udf

* data

* fix
2023-08-03 14:05:13 -04:00
Austin
9a6030ac46
remove (#102) 2023-07-27 12:11:33 -07:00
Matt Romano
522b873ef3
An 3575/full-test-updates (#101)
* update tx test

* update to fix tests inline with data observability models

* simplify missing tx macro

* create monthly test yml

* test workflow env

* remove unneeded to_address column

* add traces macro

* reformat

* add updates to macro, add block filter for test views

* fix merge conflicts

* fix conflicts 2

* add filter to tx full view

* wrong file edit

* add additional test filters

* exclude null gas txs
2023-07-27 15:07:43 -04:00
drethereum
4cddb0414c
fix/eth-value (#99)
* ilike

* arb trace fix

* updates

* tweaks

---------

Co-authored-by: Austin <austin@flipsidecrypto.com>
2023-07-24 07:41:14 -04:00
Matt Romano
c91f846036
AN-3464/utils-macros-update (#89)
* update package version and re-point macros + tests

* missed deletes

* delete decode logs macro

* 1.4.1 update
2023-07-18 13:42:40 -07:00
Austin
b293decc8e
An 3414/data observability (#83)
* stash

* workflows

* logic upgrades

* commit

* clean1

* clean2

* remove origin

* updates

* config

* exclude dupe txs
2023-07-12 17:26:17 -04:00
drethereum
bc6332984b
AN-3534/arb-streamline-migration (#82)
* workflow changes

* models macro

* logs table docs

* gold layer changes

* silver legacy changes

* silver core tests

* timestamp cast type

* workflow changes schedule

* gas price column names
2023-07-11 10:54:30 -06:00
drethereum
2c39eac837
filtered for arbtrace call (#78) 2023-07-07 12:50:17 -06:00
drethereum
d1f18bb538
AN-3234/arb-core-streamline (#75)
* workflows and realtime models for retry logic

* tests and retry logic

* incremental logic and comments

* traces incremental logic
2023-07-06 10:00:05 -06:00
Austin
3eb53e4ebc
inserted change (#65) 2023-06-14 11:01:40 -04:00
Austin
8870ea0dcd
bump block range (#63) 2023-06-12 15:02:19 -04:00
drethereum
b625c74885
add/fsc-utils (#60)
* added package

* updated workflows

* env

* main

* inputs

* create udfs
2023-06-06 12:41:34 -06:00
Austin
deba806b11
Test/decoder (#53)
* add hook

* prod decoder

* proxy change

* coalesce

* add history

* dupe source
2023-06-01 11:05:42 -04:00
Ryan-Loofy
e663710c90
An 3213/an 3214/an 3215/arbitrum streamline (#54)
* Arbitrum Streamline

* Update batches and run time

* Update complete models, update actions

* Update .github/workflows/dbt_run_streamline_history.yml

Co-authored-by: Shah Newaz Khan <shahnewazk@gmail.com>

* Update XXX and batching

---------

Co-authored-by: Shah Newaz Khan <shahnewazk@gmail.com>
2023-05-31 15:00:59 -04:00
Austin
a678a5e9d9
decoding base (#50) 2023-05-18 13:43:05 -04:00
drethereum
8daba498f3
AN-2728/dev-tag-fix-arb (#38)
* changed sp

* removed aws role from sp
2023-01-31 08:41:07 -07:00
drethereum
fde91e434f
implemented snowflake tags, macros and updated readme (#36) 2023-01-23 10:28:51 -07:00
drethereum
b52f79a7eb
AN-2582/unique-key-tx-test (#29)
* changed unique key in logs and traces and added new test in logs

* added dbt-env to gitignore for SSO functionality

* added .env to .gitignore to match current file

* fixed typo
2023-01-03 14:06:56 -07:00
desmond-hui
1b6b48686d
community curation setup (#30) 2022-12-20 13:01:03 -08:00
eric-laurello
8012421e14
custom query tags (#28) 2022-12-13 18:55:32 -08:00
Austin
08a299232f
task to model (#27) 2022-12-05 15:22:18 -05:00
Austin
786f19e89b
An 2469/get contracts (#26)
* stash

* docs and contracts

* back off
2022-11-30 10:49:46 -05:00
drethereum
38af6345e8
added project level variable and associated IF statements to on-run-start macros to default UDF/SP updates to False (#23) 2022-11-14 14:22:21 -05:00
Austin
d7604aec6a
store failures (#12) 2022-08-09 16:39:03 -04:00
Austin
278fc65c16
Add/comment lite mode (#5)
* save

* remove on run start

* prod db
2022-06-28 09:20:13 -04:00
Austin
94d3fa90b4
An 1643/labels (#2)
* docs, labels, db comments

* traces fix

* add docs
2022-06-22 16:02:23 -04:00
Austin
6f43a4df08
Inital/setup (#1)
* initial commit

* arb set up
2022-06-16 18:19:56 -04:00