flip/flow-models
1
0
Fork 0
mirror of https://github.com/FlipsideCrypto/flow-models.git synced 2026-02-06 14:22:06 +00:00
Code Issues Actions 29 Packages Projects Releases Wiki Activity
479 Commits 103 Branches 0 Tags 26 MiB
main
Commit Graph

340 Commits

Author SHA1 Message Date
Jack Forgash
dce99ad2f7
upd metadata view (#118) 2023-04-26 11:43:39 -06:00
Jack Forgash
23702dfd7c
addl set (#117) 2023-04-18 17:13:16 -06:00
Jack Forgash
769c1f1354
add exception to moment date test (#113) 2023-04-04 10:29:27 -06:00
Jack Forgash
e6b181c95c
adjust swaps for bad txs (#112) 2023-03-13 12:12:00 -06:00
Jack Forgash
6b44229b32 excl another tx 2023-03-12 21:49:46 -06:00
Jack Forgash
13f911ca79 excl tx with dup swap 2023-03-12 19:07:08 -06:00
Jack Forgash
0541445003
excl another tx (#110) 2023-02-14 11:05:17 -07:00
Jack Forgash
f4bc1f2687
docs page (#109) 2023-02-14 11:02:34 -07:00
Jack Forgash
9c775deae5
metadata update (#108) 2023-02-13 17:53:49 -07:00
Jack Forgash
47e679b9d8
tweaks (#107) 2023-02-02 13:38:43 -07:00
Jack Forgash
09aa518880
An 2719/actions labels tweaks (#105) 
* use template for GHA

* add custom notification

* move nft models to folder

* put silver models in folder

* swap labels to crosschain

* move script

* move script

* update failed test list if none
 2023-01-26 09:24:49 -07:00
Jack Forgash
6e6fbc3bdd
tags (#104) 2023-01-23 10:59:46 -07:00
eric-laurello
d3c20cd76b
AN-2668 topshot packs (#103) 
* ts packs

* alpha version topshot packs

* beta schema
 2023-01-18 17:33:48 -05:00
desmond-hui
e5863f899a
An 2569/only retry req 3 times (#98) 
* model api responses that resulted in no metadata

* dont try to get metadata after 3 retries

* fix PR comment

* use bronze model per PR
 2022-12-14 17:05:19 -08:00
Jack Forgash
404b413147
An 2526/prices (#94) 
* silver prices

* core view

* deprecating notice

* swap source

* silver source
 2022-12-12 11:18:15 -07:00
Jack Forgash
c1d8aabc39
Minor test fixes (#93) 
* threshold for gaps

* transfers
 2022-12-02 13:08:25 -07:00
desmond-hui
791aeba098
use silver table instead of bronze (#91) 
* use silver table instead of bronze

* add allday

* rename to event_contract in topshot

Co-authored-by: Jack Forgash <jmfxyz@pm.me>
 2022-12-01 17:16:15 -07:00
Jack Forgash
458895896a
Silver Events Column (#72) 
* adjusted bad events table to hold 3 error types

* typo

* clean

* main and tweak

* del bad events table
 2022-12-01 16:57:51 -07:00
Jack Forgash
6be5eea928
An-2435/core liga (#92) 
* core view

* restructure

* test

* unique key on metadata tbl

* la liga silver models

* la liga metadata

* final

* now its final

* final to table
 2022-12-01 10:15:11 -07:00
desmond-hui
f12f90ede9
source external tables from streamline db (#90) 2022-11-30 14:16:13 -08:00
Jack Forgash
cffac5a733
moments to table (#87) 
* moments to table

* unique key

* change nfl allday
 2022-11-17 16:37:39 -07:00
Jack Forgash
06643d4fd9
An 2434/swap labels (#86) 
* need to match poolid to contract

* pier swap pool labels

* metapier labels test & docs

* swaps labels core view

* doc comment
 2022-11-17 15:41:06 -05:00
Jack Forgash
bca375668b
comma (#84) 2022-11-08 13:35:16 -07:00
Jack Forgash
c29567fb36
AN-2632/liga play metadata (#83) 
* liga

* incr

* typo
 2022-11-08 12:01:17 -07:00
Jack Forgash
b9d6ef2823
AN-2310/rewrite swaps (#82) 
* add trades and swaps

* revert old swaps model and branch into new

* swaps v2 still some bugs

* dup token0 issue

* swaps2

* final

* tweak

* del todo

* incr
 2022-11-08 11:07:42 -07:00
Jack Forgash
009f0dacab
str (#79) 2022-10-28 17:31:36 -06:00
Jack Forgash
33df30f43e
AN-2290/giglabs (#78) 
* nft updates, gig mid

* handle erronous records from missing event data

* marketplace

* add to nft union

* test
 2022-10-28 09:41:20 -06:00
Jack Forgash
179ebb95f4
del old fact (#77) 2022-10-24 12:25:09 -06:00
Jack Forgash
06e6b4cb78
An-2311/marketplaces (#76) 
* nft updates, gig mid

* marketplace update
 2022-10-20 19:10:33 -06:00
Jack Forgash
12d2cd0544
silence (#74) 2022-10-17 15:01:51 -06:00
Jack Forgash
e70d5e8fd0
ref (#73) 2022-10-14 12:27:29 -04:00
Jack Forgash
81f6b817fd
AN-2005/reduce dup tests (#61) 
* blocks and txs - silver

* fewer tests

* clean-up

* a few more
 2022-10-11 15:20:02 -06:00
Jack Forgash
506de6354d
An 2242/nftz (#71) 
* nft_two

* fixed - just move the logic over to the main model

* fix 2 marketplace interactions

* findpack nft
 2022-10-07 14:07:09 -06:00
Jack Forgash
1c6f55b3e4
oops (#69) 2022-09-28 23:15:00 -06:00
Jack Forgash
2dff91ae4a
gaia (#68) 2022-09-28 22:49:17 -06:00
Jack Forgash
44d45693aa
An 2186/nft markets batch 1 (#67) 
* addtional markets

* add to test

* is_purchased fix
 2022-09-27 13:47:34 -04:00
Jack Forgash
b541b628cc
AN-2178/events fix (#66) 
* test excl bad events

* del date filter

* prices fix

* nft tweaks

* clean
 2022-09-26 19:04:17 -04:00
Jack Forgash
78927966ff
AN-2009/nft enhancements (#62) 
* secondary mkt first token withdrawal

* new secondary market model structure

* enhancooor

* overhaul with minimal error - todo comments to review

* further omit multi buys

* no date filter

* excl errors
 2022-09-19 17:49:04 -04:00
Jack Forgash
ee7efe3851
AN-2168/Add network (#65) 
* net data

* add version
 2022-09-19 17:48:12 -04:00
Jack Forgash
1d89e84073
AN-2161/events location (#64) 
* events location

* its nested

* coalesce approach

* events fix
 2022-09-17 00:52:31 -06:00
Jack Forgash
c11814ef95
allday view (#60) 2022-09-02 13:58:10 -06:00
Jack Forgash
505f166046
AN-1945/fixes (#59) 
* nft sales and dep tag

* fixes before removing dup tests

* test fixes

* nft sales

* avoid dupes

* return silver blocks test to split out that change in another pr

* last tweak
 2022-09-02 13:51:19 -06:00
Jack Forgash
96a5f01ac8
AN-1988/events handle (#58) 
* events try 1

* cte

* coalesce tweak
 2022-09-01 18:24:04 -06:00
Jack Forgash
a4be724d15
AN-1900/ez (#57) 
* ez views

* add comment to description and legacy fact view

* tag ez models

* add dex in yml name
 2022-08-31 19:34:52 -06:00
Jack Forgash
317a8ab617
An-1968/allday silver (#55) 
* allday metadata silver

* fixes
 2022-08-29 11:45:02 -06:00
desmond-hui
bcc90bacc2
bronze table now holds more than just topshot metadata (#54) 2022-08-26 12:27:26 -07:00
Jack Forgash
861e667d4b
AN-1870/allday ids (#51) 
* allday nft ids

* silver topshot view for compat

* limit allday to 3000

* str

* add nfl all day metadata integration and refactor streamline process

* no longer needed

Co-authored-by: Desmond Hui <desmond@flipsidecrypto.com>
 2022-08-26 11:07:40 -07:00
Jack Forgash
edb39921fa
AN-1807/store tests (#53) 
* store tests

* dbt 1.2

* test names and off for ingested at
 2022-08-19 14:13:02 -06:00
Jack Forgash
c5e8289666
AN-1865/bridge fix (#52) 
* seed update

* usdc fix
 2022-08-18 13:55:31 -06:00
Jack Forgash
779baa4122
AN-1780/staking (#50) 
* delegators

* staking events

* docs and core view

* date filter
 2022-08-17 18:26:33 -06:00
Ava Masucci
417f5df20d
An 1779/ez token transfers (#49) 
* Token transfers model and tests

* logic to include transfers only

* Ez token transfers and tests

* Silver incremental model and core view

* Incremental adds and date change
 2022-08-17 11:19:09 -07:00
Jack Forgash
123d690227
AN-45/nft models updated (#48) 
* nft models updated

* tx_succeeded field

* docs and test
 2022-08-11 11:42:29 -06:00
Jack Forgash
264f9103a9
AN-1837/events fix (#47) 
* new vertex patch

* prices adjustment
 2022-08-09 09:30:45 -06:00
Jack Forgash
a7cbfb04bc
AN-1830/topshot nft ids (#45) 
* add sales to list

* distinct

* list columns
 2022-07-28 11:35:09 -06:00
Jack Forgash
1f4208dd91
AN-1822/caps for comment (#44) 
* caps for comment

* del comma
 2022-07-27 10:32:46 -06:00
Jack Forgash
04282e9466
handle escape character (#42) 2022-07-11 18:28:59 -04:00
Jack Forgash
38f0b9d205
docs and core view (#41) 2022-07-07 17:51:34 -04:00
Jack Forgash
f0e071cc6a
AN-1714/prices from swaps (#37) 
* init silver model

* cluster by block_timestamp

* column fixes

* prices from swaps, need to update core to add symbol & contract

* token labels seed and updated core view

* docs
 2022-07-06 16:36:41 -04:00
Jack Forgash
a952c32600
AN-1690/topshot_metadata (#36) 
* topshot metadata

* adjust stats column names

* bronze view and inserted_timestamp
 2022-07-06 10:39:24 -04:00
Jack Forgash
d8b0e8d0f0
add assets (#39) 2022-07-01 11:01:37 -06:00
Jack Forgash
6854a94ed1
AN-1638/inserted_timestamp (#35) 
* bronze

* del netlify

* append column

* cluster

* incremental logic

* bridge tables

* docs
 2022-06-30 13:12:08 -06:00
Jack Forgash
6ceec78b93
An 1346/bridges (#33) 
* just a couple ctes

* add array

* blocto inbound

* blocto teleports final

* celer bridge

* tweaks

* core view

* docs

* docs

* list columns, add incremental to celer, move bridge.md to right dir
 2022-06-29 10:00:29 -06:00
desmond-hui
a1bdcbb529
An 1625/integrate moments minted api (#34) 
* clone stages to dev

* add api integration for topshot metadata
 2022-06-28 09:24:09 -07:00
Jack Forgash
3de7b7918d
date to 420 (#32) 2022-06-23 13:05:04 -06:00
Jack Forgash
c31c362d48
An 1640/nft ids (#31) 
* update silver

* yml
 2022-06-21 12:44:25 -06:00
Jack Forgash
86cbe28096
An 1343/swaps (#29) 2022-06-16 06:06:13 -06:00
Jack Forgash
f9ec13fa9d
AN-1378/nft secondary market sales (#28) 
* nft purchase txs v1

* v2 and tokenflow

* v3 and v4

* comments no changes

* blocto transactions

* nfts

* silver models

* topshot tokenflow

* silver nft sales

* small tweak

* excl outlier
 2022-06-09 10:44:52 -06:00
Jack Forgash
1eaa67e407
AN-1534/add 0x (#27) 
* add 0x

* fix null when 0 auth
 2022-06-08 13:59:22 -06:00
Jack Forgash
978df9b8ed
AN-1375/tests (#26) 
* nft purchase txs v1

* gap tests

* del nft
 2022-06-06 12:05:26 -06:00
Jack Forgash
19841544e8
AN-1344/prices (#24) 
* cmc prices

* gecko prices

* adjust $

* core view, no description yet pending swap prices

* prices

* price to price_usd

* address nulls and del mcap

* tests

* test fix
 2022-06-02 12:17:34 -06:00
Jack Forgash
a005424621
AN-1339/nft market (#25) 
* topshot sales

* add tx_succeeded

* core nft sales

* docs blocks

* del ingested at

* del last line
 2022-06-02 11:54:31 -06:00
Jack Forgash
ab821e4154
AN-1348/refactor into silver (#23) 
* squish

* del docs until gitignore updated

* where not and
 2022-05-26 14:25:38 -06:00
Jack Forgash
445ef689f2
AN-1295/labels (#19) 
* core view

* docs;

* validator labels

* del docs files
 2022-05-25 12:22:56 -06:00
Jack Forgash
a956618336
AN-1201/tests (#18) 
* tests

* docs

* date filter

* and

* events
 2022-05-19 17:53:07 -06:00
Jack Forgash
24f877ec55
An 1219/events labels (#17) 
* event labels

* docs

* rename contract_labels

* del source.md

* move distinct

* docs
 2022-05-18 16:48:59 -06:00
Jack Forgash
e2913e5330
An 1212/hotfix (#16) 
* unique key fix

* docs generate
 2022-05-17 16:07:27 -06:00
Jack Forgash
79e8096768
An 1212/gold events (#11) 
* gold blocks

* fixes

* revert blocks

* events

* address AN-1269

* format and core

* core yml

* revise event_id and event_data in yml
 2022-05-17 15:03:40 -06:00
Jack Forgash
37095a607f
An 1221/gold transactions (#14) 
* gold

* format
 2022-05-17 14:48:57 -06:00
Jack Forgash
14dbded6a7
An 1220/gold blocks (#13) 
* gold blocks

* fixes

* format

* test
 2022-05-16 16:22:34 -06:00
Jack Forgash
6381b49a6a
An 1215/labels (#10) 
* labels

* typo

* cluster by address

* docs

* varchar
 2022-05-16 16:21:54 -06:00
Jack Forgash
aa849c8f44
An 1179/docs (#9) 
* docs

* attribute descriptions

* attributes docs

* docs generated
 2022-05-06 09:06:14 -06:00
Jack Forgash
ce36c6b66f
An 1194/silver event attributes (#8) 
* init

* initial model

* convert addresses to hex

* wip

* adjust for missing leading 0s

* some tests

* changes

* fixed upstream
 2022-05-05 18:48:25 -06:00
Jack Forgash
6aab9785d1
An 1210/error messages (#7) 
* error msg

* format

* error msgs

* cast

* yml for tx index

* index;
 2022-05-05 17:52:43 -06:00
Jack Forgash
3c680bc634
remove collection guarantee (#6) 2022-05-05 13:58:11 -06:00
Jack Forgash
80c84fda4a
AN-1122/Silver tx events (#5) 
* init. not run or tested

* hard coding silver txs temp

* coalesce, rename type to event_type

* typo

* tests

* formatting

* newline

* nothing

* underscore in config block

* incremental jinga underscore

* upstream underscores

* reconfig cases
 2022-05-04 16:40:38 -06:00
Jack Forgash
de575d0b70
AN-1120/Initial Silver blocks merge (#4) 
* silver blocks

* config block

* in progress

* yml

* coalesce, tests

* auto-format

* tweak
 2022-05-03 12:10:44 -06:00
Jack Forgash
c3a240d429
AN-1121 Initial push of Silver Transactions (#3) 
* tx structure

* yml, qualify, ingested_at

* tests

* block_height

* tests, format, rename error column
 2022-05-02 16:01:51 -06:00
Jack Forgash
1ac3da072e del alias 2022-04-18 10:34:27 -06:00
Jack Forgash
007226ac31 bronze txs view 2022-04-18 10:19:06 -06:00
Desmond Hui
fdc4e6cf12 initial setup files 2022-04-14 11:34:12 -07:00