flip/user_metrics
1
0
Fork 0
mirror of https://github.com/FlipsideCrypto/user_metrics.git synced 2026-02-06 19:28:14 +00:00
Code Issues Actions Packages Projects Releases Wiki Activity
126 Commits 6 Branches 0 Tags 227 MiB
max-height
Commit Graph

50 Commits

Author SHA1 Message Date
gronders
4799cc1c19 added activity stats for a few chains 2023-04-17 14:59:30 -06:00
Eric Stone
181ace8ab6
joining to amounts based on from currency causing mismatches 2023-04-13 20:55:03 -04:00
jhuhnke
cb38416d22 changes to osmosis qs 2023-03-23 08:30:12 -05:00
jhuhnke
6234c8edad Merge branch 'main' of https://github.com/FlipsideCrypto/user_metrics 2023-03-23 08:11:29 -05:00
jhuhnke
4f052f08c6 push changes to osmosis qs 2023-03-23 08:11:07 -05:00
Angela Minster
3c4f3645bf creating flowscored 2023-02-13 18:10:21 -05:00
jhuhnke
a71449719a axelar token balance queries 2023-01-30 10:09:26 -06:00
jhuhnke
cd294073ce two axelar bagzzzz queries 2023-01-27 17:32:39 -06:00
jhuhnke
86eabcd72e cosmos queries - what we can do so far 2023-01-12 09:03:56 -06:00
jhuhnke
5f8517b1c5 axelar schema has no balances table, no dexes or NFTs on Axelar 2023-01-11 14:54:11 -06:00
jhuhnke
e8d4fcd6de osmosis big project queries 2022-12-19 10:13:06 -06:00
Nick Payiatis
b58685ba02
Merge pull request #14 from FlipsideCrypto/algorand-r2 
bridge cex nft
 2022-12-16 12:26:40 -05:00
Carlos R. Mercado
9f13d60daa Create lp_activity.sql 
NOTE: multi-calls, aggregators, routers, vaults can all get missed.
Also, some garbage coins have deposits but no known price information.
USD Volume comes from hourly price table where hour = max, i.e., most recent.
 2022-12-16 12:18:48 -05:00
Carlos R. Mercado
05841bac53 + Exchangooor and Hedgoooor 
Too many groups for current next app***
 2022-12-16 10:49:39 -05:00
Carlos R. Mercado
98385add1d Merge branch 'main' of https://github.com/FlipsideCrypto/user_metrics 2022-12-15 18:11:27 -05:00
Carlos R. Mercado
cfadf61e07 Create post_airdrop_actions.sql 2022-12-15 18:11:21 -05:00
Eric Laurello
40065a28e7 bridge cex nft 2022-12-15 15:18:04 -05:00
Eric Laurello
73c4d6f902 algo activity dex 2022-12-14 15:04:29 -05:00
Carlos R. Mercado
037fc2209b Merge branch 'main' of https://github.com/FlipsideCrypto/user_metrics 2022-12-13 13:55:16 -05:00
Carlos R. Mercado
5dbf0fcf3a Fixed SENDER problem 
SENDER is often the ROUTER; not the EOA.
ORIGIN_FROM_ADDRESS is better; although issues w/ multi-sigs, smart wallets, and other tx.origin issues may remain.

Good for now
 2022-12-13 13:55:04 -05:00
Angela Minster
1d4b1e069c fixing op queries 2022-12-06 17:58:56 -05:00
Kellen Blumberg
714b64743d solana sql queries 2022-12-02 16:17:09 -08:00
Carlos R. Mercado
9cddd1dcc9 + Ethereum user metrics 2022-11-30 15:09:28 -05:00
Angela Minster
68ff6a064e new optimism app 2022-11-11 14:35:38 -05:00
Angela Minster
246505acb1 adding queries for optimist score 2022-11-11 08:46:45 -05:00
Angela Minster
f6bcb1dc7b update git ignores 2022-11-11 08:44:38 -05:00
Angela Minster
dfa916f335 Merge branch 'main' of github.com:FlipsideCrypto/user_metrics 2022-11-09 15:00:13 -05:00
Graham Onders
b48ebe7dd4
Delete .DS_Store 2022-11-09 12:57:18 -07:00
Graham Onders
aba456d38e
Delete .DS_Store 2022-11-09 12:56:58 -07:00
Graham Onders
dd737385df
Delete .DS_Store 2022-11-09 12:56:23 -07:00
Angela Minster
f6ed371a7f base query updates for flow 2022-11-09 14:49:26 -05:00
gronders
9731e58ae8 fix sweat 2022-11-02 10:22:02 -06:00
gronders
d47f49fd7c adding sweat activity 2022-11-02 09:20:53 -06:00
gronders
3e6706794c embr sql added 2022-11-01 16:35:25 -06:00
gronders
8949f76c8e added nearcrowd sql 2022-11-01 16:01:24 -06:00
gronders
07ea09732c fix nft listings near 2022-10-27 09:02:41 -06:00
gronders
2494a3c9ed more activity fixes 2022-10-27 08:57:49 -06:00
gronders
425c70cd03 fix near activity stats 2022-10-27 08:55:04 -06:00
Angela Minster
6b64a2567d rename query 2022-10-26 15:42:49 -04:00
gronders
8e5c489392 adding spaces at the end 2022-10-26 11:05:26 -06:00
gronders
85019fcb13 add nft_listings 2022-10-26 11:02:34 -06:00
gronders
1a1fea32b7 added accumulation and fixed bridge 2022-10-25 19:03:24 -06:00
gronders
0eb0389be6 Merge branch 'main' into near_sql 2022-10-25 16:59:41 -06:00
gronders
68dbb1ee14 lots of fixes 2022-10-25 16:57:43 -06:00
Angela Minster
5f9e4fe61a angela's updates lol 2022-10-24 15:20:51 -04:00
gronders
b7a018361d some fixes 2022-10-24 13:06:22 -06:00
gronders
e11692a1a0 added near metrics 2022-10-24 13:03:42 -06:00
Angela Minster
1de9344170 more qwerties 2022-10-13 14:12:57 -04:00
Angela Minster
36a95677a8 flow nft trades 2022-10-12 13:01:38 -04:00
Angela Minster
1db6d66f1f lfg! 2022-09-30 15:56:24 -04:00