llamatron on Warpcast

llamatron pfp

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

10 replies

2 recasts

12 reactions

MrRevix 🎩🔵 pfp

MrRevix 🎩🔵

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

2 replies

0 recast

1 reaction

llamatron pfp

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 😂

3 replies

0 recast

0 reaction

Ryan J. Shaw pfp

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

1 reply

0 recast

0 reaction

llamatron pfp

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.

3 replies

0 recast

0 reaction

llamatron pfp

Statistically seen this will happen to about 12.5% of users on any given day, and the increase will be bounded by the next-higher median, ie less than standard deviation, so my guess would be the daily sum will usually fluctuate by a few percent only, which is well within the 50% tolerance interval. cc @jacek @wake

1 reply

0 recast

1 reaction

Ryan J. Shaw pfp

Confused again... 😅 In my experiment I moved 45 likes from day 1 to day 2 and it altered median reactions at the 20th, 30th and 50th percentiles

1 reply

0 recast

0 reaction

llamatron pfp

Let me try another example. Yesterday, my allowance was 67 based on likes received for casts made on Monday (as that day happened to be the median pick) now, if in the future someone were to like my old casts from Monday, my allowance for yesterday would increase retroactively.

1 reply

0 recast

1 reaction

Ryan J. Shaw pfp

I get that part, and I added it into the V7 update with credit to your original post BTW.... I got confused by how reactions changing days can shift the median, because it's the same total number, but I think I understand now - the sample is too small, it likely wouldn't happen with e.g. 10min intervals 100 $degen

1 reply

0 recast

2 reactions