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

Hope this is a glitch. If I cast a minute before the new day all reactions will be affected to the previous day? 
And if a cast received a ton of reactions days after cast date, that would also affect a reduction of the allowance of all the other users, risking that all the users over tip.

@jacek

husband & father, Ethereum enthusiastic, @CyborgDao, @bottodao, DeFiLover, @ensdomains lover, waiting for web3 explosion.
deca.art/mrrevix

Yeah, totally! My cast is actually great illustrative example: made it half an hour before midnight UTC, got 8 likes the same day, the majority came the next day. I should’ve stayed up another half hour to cast later 😂

In rare cases, allowance can change retroactively. For example, I made my cast within the last hour of May 2nd and received 8 likes on the same day. Now, if May 2nd turns out to be the median among the past eight days, then allowance for May 3rd will continue to increase as I get more likes through the following days.

I'm confused... Think I need to reread the query again to understand why you say this 🤔

LOL!

Imagine if it happens for a cast of someone among the top positions for allowance...