Set up Postgres Instance

[johnrichardrinehart]

• [x] Install Postgres
• [x] Connect to Redash.io
• [x] Document credentials
• [ ] Document migration procedure
• [ ] Apply migrations
• [ ] Populate with some dummy data
• [ ] Generate a few Redash.io plots
  1. • [ ] From SOL on-chain data
       1. • [ ] Number of daily transactions on Solana
       2. • [ ] Number of daily active Solana addresses
       3. • [ ] Number of new daily Solana addresses
       4. • [ ] Daily volume of SOL transfers
       5. • [ ] Daily fees of all SOL/SPL transfers
       6. • [ ] Daily median USD cost of SOL and SPL transfer
       7. • [ ] Daily USD revenue of Solana stakers
       8. • [ ] Daily Solana addresses with balance over $X ($1k, $10k, $100k, $1M, $10M
  2. • [ ] From DEX data
       1. • [ ] Total monthly DEX trading volume on Solana (with DEX splits - Serum, Raydium etc.)
       2. • [ ] Number of monthly unique liquidity providers on Serum
       3. • [ ] Number of monthly unique trading addresses on Serum
       4. • [ ] Number of monthly trades on Serum
       5. • [ ] Total number of unique addresses interacting with Solana DeFi apps with splits by each project (https://solana.com/ecosystem?categories=defi)
       6. • [ ] Total stacked daily TVL of all Solana DeFi projects (https://solana.com/ecosystem?categories=defi)
       7. • [ ] Daily outstanding debt of Jet Protocol (https://www.jetprotocol.io/)
       8. • [ ] Total daily supply of stablecoins issued on Solana (https://solana.com/ecosystem?categories=stablecoin)

[DieracDelta]

TODO what does SOL&SPL transfer mean?

how to get Daily USD revenue of Solana stakers/what does staking info mean/what are we interested in there

Identify way to find high balance addresses for timestamp t

how to identify stable coins