Hey @jacek, I'm curious regarding the recent update to dune query. It seems likes are now tied to the day a cast was made, not when the like was given. Does that mean future reactions can affect past allowances? Just double-checking if this is intentional or if there might be a glitch. 

cc @rjs @wake

husband, father of two sexy girls, crypto community manager, bizniz owner and opinionated conservative. jesus guns girls america 🇺🇸

@wake.bsky.social

Husband, dad, dev • @dune.eth wizard • Ultimate Ⓜ️oxie Dashboard https://tinyurl.com/moxiedash •  I'm just zis guy, you know?

I’m here to tip artists, 85% of the time 🎩 BP 2833

For example, on April 9th I received 46 likes on casts written that day, so in the morning of April 10th the query is run to compute my allowance based on that, but by the end of the month, as I receive 11 more likes on those casts over the following days, when the query is run again for the claim, it will …

…have 57 rather than 46 reactions attributed to that day and will thus yield a different allowance for me—as well as everyone else, given the sum for that day also changes. I hope I’m mistaken and heve misunderstood the query, as this would make allowances quite unpredictable.

Here's a query to explore yourself, https://dune.com/queries/3688661

Thanks. I studied the new formula this morning (CEST) and I didn't find this difference.

100 $degen