* docs update
* silver and gold tables
* reformat
* clean up
* filter to suceeded sales
* coalesce for pk
* update desc
* join to metadata and use set sol var
* udf to grab program data logs from log messages
* output table with encoded program data in tx logs
* add comments
* setup views and source
* update tag
* wip realtime view
* wip
* fix bad join
* wip
* decoded logs
* add event_type, index, inner_index and refactor existing
* handle additional nested calls
* add columns, add to SO
* use backfill macro
* handle non-contiguous program log messaging
* add log index description
* wip schema
* fix macro name
* add desc and tests for more columns
* refactor logic
* add descriptions
* remove unnecessary offset
* remove commented out code from schema
* add scheduler
* (wip) initial model
* remove testing lines, add depends on comment
* handle more than one sale per tx
* separate sol escrow from margin account
* use min_price as sale price for bid sales
* fix column name
* add model docs and tests
* add caveat for tensorswap sales amount description
* add business logic tests
* wip
* change udf name, fix surrogate key for inner instruct calls
* (wip) decoded instructions backfill helpers
* complete backfill helpers, clean up views with 0 requests
* rename
* revert
* temp change will revert
* rename
* use streamline 2.0 verify idl api endpoint
* this is placeholder model, will replace existing when ready
* reorg files
* add workflow for decode instructions real time
* use pip cache
* update with prod endpoints
* update sql limit to real value, should be union all
* use ref for model names
* remove placeholder, replace existing model logic
* add new decoder flow to gha
* temp disable incremental
* add inner index to core tables
* match existing behavior until we properly incorporate inner_instruction txs
* temp disable
* wip
* seperate silver models and create core
* update tag and desc
* update per pr comment
* use prod db source
* adjust fr partition range
* add batc load var
* add gold col descriptions
* wip
* silver and core tables
* add description
* wip updates
* update location and nft_mint_actions
* update logic
* optimize filter and add _inserted_timestamp
* select metaplex events and join to
* update per pr comments
* add back in program filter
* add instant_sell model
* marketplace description
* model creation
* add test cases
* finalize logic
* exclude instant_sell model
* update amm_sell model name
* create testing data
* table w failed and successful txfers
* initial model
* create transfers2 and testing data
* add expected results
* testing additions
* check-in
* remove not-null requirement
* add business test cases, simplify, need acct owners
* wip
* clean tests and update model
* update model for edge cases
* fix expected test case
* check in
* logic for unordered swaps
* create single model for all dex swaps
* check in updates
* remove mint actions
* general model
* remove jup v4
* clean up
* update transfers2
* update name
* test that specific tx are excluded
* initial changes per pr comments
* add program_id
* Add base_events and combine union
* uncomment incremental logic
* move block_id filter to base_events
* remove flatten, map accounts directly to transfer to/from
* filter out non-swap actions and fix join logic
* remove raydium logic and rename
* remove raydium swap in test
* Include TRPY swaps
* update table config
* add program_id column to yml
* initial aggregated swaps model
* remove dependency on csv for tx excluded test
* remove duplicate test case
* add additional test records
* updates per PR comments
* remove dependency of excluded tx test on csv
* remove unnecessary program_id
* remove orca dex references
* additional inner join logic
* query cleanup/formatting
* add test cases
* add back delegate mapping for saber + test cases
* An 2455/intermediate swaps raydium (#161)
* Intermediate swaps model for raydium
* add test cases, remove unnecessary filter and hook
* tweak event filters and join optimizations
* revisions per pr comments
* update excluded tx tests and remove csv dependency
* add token accts
* add test cases, round amts to 8 decimals
* use associated accts given in swap instruction
* handle multisig authorities
* add test case
Co-authored-by: Desmond Hui <desmond@flipsidecrypto.com>
* include raydium, update test cases
* formatting
* add reusable swap col descriptions
* add test cases from other intermediate models
* fix dupes, add tests
* use new silver model and dim labels
* remove unused transfers2 model
* add missing test case
* update demo share
Co-authored-by: tarikceric <tarik@flipsidecrypto.com>
Co-authored-by: tarikceric <46071768+tarikceric@users.noreply.github.com>
* intial lido model
* wip
* change action words, add more pools
* wip'
* redo deposit stake logic
* initial socean model
* stake pool column descriptions
* wip
* force dbt to 0.9.2
* fix model syntax, update test
* socean tests
* match output columns with other models, add tests
* marinade stake pool model
* update description to specify SOL
* initial core view
* eversol wip
* eversol actions and tests
* add core stake pool
