Another Python 3 script to connect to an LND node via gRPC, cache daily routing economics in SQLite, and report monthly profit:

• Forwarding fee income
• Rebalancing fee costs
• Net routing profit (forwards - rebalances)

Example output:Example output:

⚡️ Lightning Routing Fees
Date window: 2025-01-01 -> 2026-01-01 (tz=-03)
Database: lnd_fees.sqlite
Inserted 1 daily row(s):
  📅 2026-01-01: rev 52,177 sats, cost 59,027 sats, net -6,850 sats
Node alias:               Friendspool | BR⚡️LN
Node pubkey:              023e24602891c28a7872ea1ad5c1bb41abe4206ae1599bb981e3278a121e7895d6

📅 D-1 daily profit:
  2026-01-01: rev 52,177 sats, cost 59,027 sats, net -6,850 sats

📆 Monthly routing profit snapshot (as of 2026-01-02)
  ⭐️ Current month (2026-01): rev 52,177 sats, cost 59,027 sats, net -6,850 sats
  🗓  Last month (2025-12): rev 1,818,786 sats, cost 1,423,233 sats, net 395,553 sats
  🕰  Previous months:
    2025-11: rev 1,385,730 sats, cost 985,917 sats, net 399,813 sats
    2025-10: rev 879,655 sats, cost 663,731 sats, net 215,924 sats
    2025-09: rev 884,657 sats, cost 852,810 sats, net 31,847 sats
    2025-08: rev 1,036,209 sats, cost 917,913 sats, net 118,296 sats
    2025-07: rev 1,199,099 sats, cost 958,744 sats, net 240,355 sats
    2025-06: rev 2,382,823 sats, cost 2,059,326 sats, net 323,497 sats
    2025-05: rev 3,477,756 sats, cost 3,294,374 sats, net 183,382 sats
    2025-04: rev 1,160,084 sats, cost 1,033,804 sats, net 126,280 sats
    2025-03: rev 762,972 sats, cost 645,350 sats, net 117,622 sats
    2025-02: rev 536,419 sats, cost 424,720 sats, net 111,699 sats
    2025-01: rev 528,441 sats, cost 403,746 sats, net 124,695 sats

📅 Current Year Results:
  2026-01-01 -> 2026-01-01: rev 52,177 sats, cost 59,027 sats, net -6,850 sats