🔍 Debugging D+1 Snapshots for Forecasting
Date: 2025-12-16 18:45:17

📅 Recent Events and Their Snapshots:

Event: Test Events (ID: 281065)
Event Date: 2025-12-15 23:00:00
Snapshots (15):
      2025-12-01 23:00:00: D14.00, 0 tix, £0.00
      2025-12-02 23:00:00: D13.00, 0 tix, £0.00
      2025-12-03 23:00:00: D12.00, 0 tix, £0.00
      2025-12-04 23:00:00: D11.00, 0 tix, £0.00
      2025-12-05 23:00:00: D10.00, 0 tix, £0.00
      2025-12-06 23:00:00: D9.00, 0 tix, £0.00
      2025-12-07 23:00:00: D8.00, 0 tix, £0.00
      2025-12-08 23:00:00: D7.00, 0 tix, £0.00
      2025-12-09 23:00:00: D6.00, 0 tix, £0.00
      2025-12-10 23:00:00: D5.00, 0 tix, £0.00
      2025-12-11 23:00:00: D4.00, 0 tix, £0.00
      2025-12-12 23:00:00: D3.00, 0 tix, £0.00
      2025-12-13 23:00:00: D2.00, 0 tix, £0.00
      2025-12-14 23:00:00: D1.00, 0 tix, £0.00
      2025-12-15 23:59:59: D0.00, 0 tix, £0.00
❌ No D+1 snapshot found

Event: Twnty7 - Sunday Vibes at Twnty7 with Dj Sean & Friends (ID: 263934)
Event Date: 2025-12-14 23:00:00
Snapshots (21):
      2025-11-30 23:00:00: D14.00, 4 tix, £100.00
      2025-12-01 23:00:00: D13.00, 4 tix, £100.00
      2025-12-02 23:00:00: D12.00, 4 tix, £100.00
      2025-12-03 23:00:00: D11.00, 4 tix, £100.00
      2025-12-04 23:00:00: D10.00, 6 tix, £100.00
      2025-12-05 23:00:00: D9.00, 6 tix, £100.00
      2025-12-06 23:00:00: D8.00, 6 tix, £100.00
      2025-12-07 07:31:25: D7.63, 6 tix, £100.00
      2025-12-07 23:00:00: D7.00, 6 tix, £100.00
      2025-12-08 14:03:18: D6.33, 7 tix, £107.00
      2025-12-08 23:00:00: D6.00, 7 tix, £107.00
      2025-12-09 22:07:03: D5.00, 7 tix, £107.00
      2025-12-09 23:00:00: D5.00, 7 tix, £107.00
      2025-12-10 11:40:22: D4.46, 7 tix, £107.00
      2025-12-10 23:00:00: D4.00, 9 tix, £107.00
      2025-12-11 23:00:00: D3.00, 17 tix, £141.00
      2025-12-12 19:25:05: D2.13, 21 tix, £141.00
      2025-12-12 23:00:00: D2.00, 21 tix, £141.00
      2025-12-13 23:00:00: D1.00, 21 tix, £141.00
      2025-12-14 23:00:00: D0.00, 21 tix, £141.00
      2025-12-14 23:59:59: D0.00, 84 tix, £342.00
❌ No D+1 snapshot found

Event: Cite - Sundaze to Remember (ID: 271559)
Event Date: 2025-12-14 23:00:00
Snapshots (21):
      2025-11-30 23:00:00: D14.00, 0 tix, £0.00
      2025-12-01 23:00:00: D13.00, 0 tix, £0.00
      2025-12-02 23:00:00: D12.00, 0 tix, £0.00
      2025-12-03 23:00:00: D11.00, 0 tix, £0.00
      2025-12-04 23:00:00: D10.00, 0 tix, £0.00
      2025-12-05 23:00:00: D9.00, 0 tix, £0.00
      2025-12-06 23:00:00: D8.00, 0 tix, £0.00
      2025-12-07 07:31:25: D7.63, 0 tix, £0.00
      2025-12-07 23:00:00: D7.00, 0 tix, £0.00
      2025-12-08 14:03:17: D6.33, 0 tix, £0.00
      2025-12-08 23:00:00: D6.00, 0 tix, £0.00
      2025-12-09 22:07:03: D5.00, 0 tix, £0.00
      2025-12-09 23:00:00: D5.00, 0 tix, £0.00
      2025-12-10 11:40:21: D4.46, 2 tix, £0.00
      2025-12-10 23:00:00: D4.00, 2 tix, £0.00
      2025-12-11 23:00:00: D3.00, 3 tix, £0.00
      2025-12-12 19:25:05: D2.13, 4 tix, £0.00
      2025-12-12 23:00:00: D2.00, 4 tix, £0.00
      2025-12-13 23:00:00: D1.00, 4 tix, £0.00
      2025-12-14 23:00:00: D0.00, 4 tix, £0.00
      2025-12-14 23:59:59: D0.00, 11 tix, £100.00
❌ No D+1 snapshot found

Event: Haus - Saturday Night at Cococure Sean's Haus (ID: 254013)
Event Date: 2025-12-13 23:00:00
Snapshots (23):
      2025-11-29 23:00:00: D14.00, 1 tix, £310.00
      2025-11-30 23:00:00: D13.00, 1 tix, £310.00
      2025-12-01 23:00:00: D12.00, 7 tix, £360.00
      2025-12-02 23:00:00: D11.00, 7 tix, £360.00
      2025-12-03 23:00:00: D10.00, 7 tix, £360.00
      2025-12-04 23:00:00: D9.00, 7 tix, £360.00
      2025-12-05 23:00:00: D8.00, 7 tix, £360.00
      2025-12-06 23:00:00: D7.00, 7 tix, £560.00
      2025-12-07 07:31:15: D6.63, 8 tix, £577.50
      2025-12-07 23:00:00: D6.00, 8 tix, £577.50
      2025-12-08 14:03:12: D5.33, 13 tix, £728.50
      2025-12-08 23:00:00: D5.00, 13 tix, £728.50
      2025-12-09 22:06:57: D4.00, 13 tix, £728.50
      2025-12-09 23:00:00: D4.00, 14 tix, £838.50
      2025-12-10 14:33:58: D3.33, 19 tix, £869.50
      2025-12-10 23:00:00: D3.00, 22 tix, £884.50
      2025-12-11 23:00:00: D2.00, 26 tix, £924.50
      2025-12-12 19:24:59: D1.13, 30 tix, £975.50
      2025-12-12 23:00:00: D1.00, 38 tix, £1075.50
      2025-12-13 23:00:00: D0.00, 42 tix, £1138.50
      2025-12-13 23:59:59: D0.00, 131 tix, £2363.50
  🎯 D+1 2025-12-14 23:00:00: D-1.00, 1 tix, £100.00
  🎯 D+1 2025-12-14 23:59:59: D-1.00, 143 tix, £2543.50
✅ D+1 snapshot found: 143 tickets

Event: TWNTY7 - Let's Get LIT Saturdays (ID: 263787)
Event Date: 2025-12-13 23:00:00
Snapshots (23):
      2025-11-29 23:00:00: D14.00, 4 tix, £29.99
      2025-11-30 23:00:00: D13.00, 4 tix, £29.99
      2025-12-01 23:00:00: D12.00, 5 tix, £39.99
      2025-12-02 23:00:00: D11.00, 5 tix, £39.99
      2025-12-03 23:00:00: D10.00, 7 tix, £49.99
      2025-12-04 23:00:00: D9.00, 8 tix, £59.99
      2025-12-05 23:00:00: D8.00, 12 tix, £199.99
      2025-12-06 23:00:00: D7.00, 12 tix, £199.99
      2025-12-07 07:31:25: D6.63, 12 tix, £199.99
      2025-12-07 23:00:00: D6.00, 12 tix, £199.99
      2025-12-08 14:03:14: D5.33, 14 tix, £229.99
      2025-12-08 23:00:00: D5.00, 16 tix, £339.99
      2025-12-09 22:06:57: D4.00, 19 tix, £359.99
      2025-12-09 23:00:00: D4.00, 19 tix, £359.99
      2025-12-10 14:33:58: D3.33, 21 tix, £372.49
      2025-12-10 23:00:00: D3.00, 23 tix, £397.49
      2025-12-11 23:00:00: D2.00, 33 tix, £459.99
      2025-12-12 19:25:05: D1.13, 38 tix, £484.99
      2025-12-12 23:00:00: D1.00, 38 tix, £484.99
      2025-12-13 23:00:00: D0.00, 39 tix, £489.99
      2025-12-13 23:59:59: D0.00, 104 tix, £1427.49
  🎯 D+1 2025-12-14 23:00:00: D-1.00, 3 tix, £24.99
  🎯 D+1 2025-12-14 23:59:59: D-1.00, 127 tix, £1782.49
✅ D+1 snapshot found: 127 tickets

🤖 Testing Current Forecasting Logic:
Testing with event 250474:

✅ Debug complete.