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

196 Commits

Author SHA1 Message Date
WHYTEWYLL
537a8b57c0
v2 to v1 (#296) 2024-03-14 19:25:31 -06:00
WHYTEWYLL
022390ebdc
Fix target (#295) 
* hardcoding v2

* v2
 2024-03-14 18:58:58 -06:00
WHYTEWYLL
131146940b
hardcoding v2 (#294) 2024-03-14 18:34:20 -06:00
WHYTEWYLL
0dee1c27e9
adding batch methods for chain and cronjob (#284) 
Finetune
 2024-03-14 15:38:49 -06:00
Shah Newaz Khan
3d493da486
Stream 803/throughput tune mn 18 (#283) 
* add var read for invoke streams

* WIP throughput tune

* added mn 19 batch model

* remove transient tx-results-batch bronze table

* add concurent_requests

---------

Co-authored-by: shah <info@shahnewazkhan.ca>
 2024-03-08 14:50:04 -08:00
Shah Newaz Khan
0d3128f868
Stream 798/tx batch tuning (#280) 
* adds tx result batch make directive | bronze make directive

* batch tx_results success

* revert collections bronze scope

* revert tx results history bronze

---------

Co-authored-by: shah <info@shahnewazkhan.ca>
 2024-03-04 13:33:25 -08:00
eric-laurello
5734a9b743
fix inc stats models (#281) 2024-03-01 14:40:47 -05:00
WHYTEWYLL
989fdb6cfa
add stats flow, gas pending (#279) 
* add stats flow, gas pending

* fee to table

* stats flow

* fix float, schedule
 2024-02-26 16:13:58 -03:00
WHYTEWYLL
3cc7463512
semicolumn (#278) 2024-02-21 07:21:05 -03:00
WHYTEWYLL
6b65655da8
Finetune (#277) 
* test a from the base line on env var

* quotes

* fine tune trasnactions and results

* format

* error

* increasing producer_batch_size

* add: transactions mainnet

* mainet 18

* reducing job

* var del

* increasing producer batch size

* increasing batch size and worker

* workers limit

* reducing producer

* add fin

* fix doubled key values
 2024-02-20 12:07:10 -03:00
WHYTEWYLL
7384530ccf
Finetune (#276) 
* test a from the base line on env var

* quotes

* fine tune trasnactions and results

* format

* error

* increasing producer_batch_size

* add: transactions mainnet

* mainet 18

* reducing job

* var del

* increasing producer batch size

* increasing batch size and worker

* workers limit

* reducing producer
 2024-02-15 20:03:40 -03:00
WHYTEWYLL
4a723f90c5
Finetune (#275) 
* test a from the base line on env var

* quotes

* fine tune trasnactions and results

* format

* error

* increasing producer_batch_size

* add: transactions mainnet

* mainet 18

* reducing job

* var del

* increasing producer batch size

* increasing batch size and worker

* workers limit
 2024-02-15 19:18:36 -03:00
WHYTEWYLL
99d1e0812a
Finetune (#274) 
* test a from the base line on env var

* quotes

* fine tune trasnactions and results

* format

* error

* increasing producer_batch_size

* add: transactions mainnet

* mainet 18

* reducing job

* var del

* increasing producer batch size

* increasing batch size and worker
 2024-02-15 19:07:37 -03:00
WHYTEWYLL
7c5cca0278
Finetune (#273) 
* test a from the base line on env var

* quotes

* fine tune trasnactions and results

* format

* error

* increasing producer_batch_size

* add: transactions mainnet

* mainet 18

* reducing job

* var del

* increasing producer batch size
 2024-02-15 18:09:34 -03:00
WHYTEWYLL
1043c83d4f
Finetune (#272) 
* test a from the base line on env var

* quotes

* fine tune trasnactions and results

* format

* error

* increasing producer_batch_size

* add: transactions mainnet

* mainet 18

* reducing job

* var del
 2024-02-15 17:08:45 -03:00
WHYTEWYLL
298a2530b9
Finetune (#271) 
* test a from the base line on env var

* quotes

* fine tune trasnactions and results

* format

* error

* increasing producer_batch_size

* add: transactions mainnet

* mainet 18
 2024-02-15 13:10:51 -03:00
WHYTEWYLL
17191eacd0
Finetune (#270) 
* test a from the base line on env var

* quotes

* fine tune trasnactions and results

* format

* error
 2024-02-14 15:07:30 -03:00
Jack Forgash
668b22097b
expliticly call putstanding NV and methods (#268) 2024-02-13 14:50:37 -07:00
WHYTEWYLL
35c6053bcd
Finetune (#266) 
* test a from the base line on env var

* quotes
 2024-02-13 11:30:01 -03:00
WHYTEWYLL
759836fc8d
An 4437 add or account for all day burned moments (#263) 
* a

* filter previus attempts

* fix empty pack

* del filt

* severity adjust
 2024-02-05 15:07:51 -03:00
WHYTEWYLL
6d53230f0a
Fix labels (#265) 
* add deleted

* hotfix
 2024-01-31 16:11:00 -03:00
WHYTEWYLL
39d17e3f12
add deleted (#264) 2024-01-31 14:20:56 -03:00
WHYTEWYLL
e7615a0cc6
Update labels (#262) 
* a

* lavels source updated

* add core view

* unique id

* delete coalesces
 2024-01-31 13:44:59 -03:00
Jack Forgash
cb95faf856
beta view w rosters (#259) 2024-01-20 14:32:15 -07:00
Jack Forgash
e0818966ad
AN-4428/add user agent to topshot and upd metadata job (#258) 
* add user agent to topshot and upd metadata job

* upd agent

* upd limit to 600
 2024-01-18 09:19:18 -07:00
WHYTEWYLL
59b3a5b4b5
fix: parse (#248) 
* fix: parse

* fix: hex parse

* fix: format

* add: fix

* delete: last month filter

* a

* fix: parser

* delete: date filter
 2024-01-16 12:09:37 -07:00
Jack Forgash
7c87cd4225
Beta allday espn id view (#255) 2024-01-05 12:57:55 -07:00
Jack Forgash
074c11c55a
fix id col in dim allday metadata (#253) 2024-01-04 09:03:25 -07:00
Jack Forgash
b26bf67732
upd desc on views (#251) 2023-12-19 17:26:19 -05:00
Jack Forgash
4c4ef12ca8
AN-4333/beta views for archiving espn ids for livequery use (#249) 
* beta views for archiving espn ids for livequery use

* list cols
 2023-12-19 13:40:30 -05:00
WHYTEWYLL
50962af5a5
fix: usdc mint transfers (#247) 
* fix: usdc mint transfers

* format

* refactor
 2023-12-18 11:57:18 -03:00
WHYTEWYLL
5c4e7bfdf8
fix: errors (#246) 
* fix: errors

* format

* fix: typo
 2023-12-15 07:21:42 -08:00
WHYTEWYLL
e8851383c9
Flow - add pk/inserted & modified dates/_invocation id (#239) 
* add: keys core

* add: silver labels jk

* add: silver metadata jk

* add silver prices pk

* add: silver staking jk

* add: silver swaps and transfers jk

* fix: doc

* gold core pk

* gold: defi keys

* price and half nfts

* add missing comma in silver__streamline_blocks

* add: nfts

* fix: models

* list col names in swaps_events_s

* add underscore _invocation

* fix: gold layer

* delete: description

* fix: order and names

* delete: unecesarry qualify

* fix: errors

* fix: name

* dix: name

* rename id

* add: pk to topshot

* add: dim rename

* fix dim metadata views

---------

Co-authored-by: Jack Forgash <58153492+forgxyz@users.noreply.github.com>
 2023-12-12 11:49:18 -08:00
Jack Forgash
28e4dd0981
upd lookback in tx res cte (#241) 
* upd lookback in tx res cte

* autofmt
 2023-12-06 16:13:17 -07:00
WHYTEWYLL
9dae9f240f
Pipeline metadata (#238) 
* add: if condition

* removed row_list

* add:  gold view, fix macro, and silver models

* gold view extension

* add: test bronce

* g

* adding test

* add: test

* add: working test

* delete: tags

* delete: hardcode ref
 2023-12-04 07:16:32 -08:00
WHYTEWYLL
150fbea1ab
fix: dedeuplicates (#237) 2023-11-29 08:44:07 -08:00
WHYTEWYLL
3e5e0a4bdd
Update silver__nft_allday_metadata_s.sql (#236) 2023-11-29 08:29:39 -08:00
WHYTEWYLL
6d6f478df6
alldaynft metadata with LQ (#229) 
* base

* clean up; add: silver model

* add: new standards

* fix: refactor

* delete: folders

* refactor simplying

* remove no longer needed

* fix: refactor to silver layer

* ready to merge

---------

Co-authored-by: Desmond Hui <desmond@flipsidecrypto.com>
 2023-11-27 07:55:44 -08:00
Jack Forgash
b33dc89a39
swap set description col (#232) 
* swap set description col

* cast str
 2023-11-20 16:39:47 -07:00
Jack Forgash
c82c04ad5d
del invocation id from gold (#231) 2023-11-20 16:30:38 -07:00
Jack Forgash
121c3e6a2c
AN-4203/ufc strike metadata (#230) 
* ufc strike metadata, plus organized nft folder better

* upd db tag on gold

* upd col name to serial number

* del listing id

* add back listing id
 2023-11-20 16:26:39 -07:00
Jack Forgash
821214294c
AN-4096/DEX Swaps Bug (#228) 
* add event counts col to easily ignore infra events

* excl txs where to/from is null

* add tests
 2023-11-15 17:15:56 -07:00
Jack Forgash
cff19a7bb6
upd test window (#227) 2023-11-14 17:42:25 -07:00
Jack Forgash
80c2462ac4
core v non-core tags and gha workflow (#225) 2023-11-10 14:30:57 -07:00
Jack Forgash
5b096dd83f
upd labels source (#223) 2023-11-07 11:48:11 -07:00
WHYTEWYLL
d17d5f06d7
deprecation (#222) 
* deprecation

* del old udf creation

---------

Co-authored-by: forgash_ <jmfxyz@pm.me>
 2023-11-07 10:40:24 -07:00
Jack Forgash
cc6f797d71
alter test on bitquery job (#217) 2023-10-31 11:48:27 -06:00
Jack Forgash
eb40b6d91d
Backfill Model - Incorporate all external tables (#211) 
* upd sources, convert blocks to loop model, fix collections history

* multiple external tbl query macro and blocks update

* del network version.yml output

* add back rt blocks

* lower blocks

* revert str blocks and collections and move change to history view

* bronze history views and move into folders

* history workflow - blocks

* del history step from streamline blocks

* create complete get history models and upd get history streamline views - BLOCKS

* upd remaining method get history views to use history complete tables

* upd txs history dependency note

* upd history gha and del parameterized models

* fix collections external table config

* collections template fix

* upd txs templates

* upd history views

* fix to tx results template / views

* set history schedule to hourly

* del commented out backfill from streamline RT GHAs

* move blocks filter up to cte
 2023-10-26 11:31:19 -06:00
desmond-hui
63ab57f844
An 4065/incremental load tuning (#215) 
* modify how dbt performs merges by default

* require at least dbt 1.4

* adjust cluster keys, add incremental pred

* ensure query is being pruned on timestamp

* add cluster key
 2023-10-26 07:02:53 -07:00
Jack Forgash
45a07a1da8
An 4050/txs final test (#214) 
* test on str txs final for pending response

* add events final gap test

* upd test to check gaps
 2023-10-24 11:52:01 -06:00