@paulburke's avatar
Paul Burke
@paulburke

But wouldn't that be the "Daily Lens Posts" user count? Interestingly, when I query the BigQuery public dataset from Lens I get 20,001 unique users having posted on the 11th.…

attachment
1 Comments
3 Likes
0 Mirrors
@paulburke's avatar
Paul Burke
@paulburke
Apparently @lenster.lens completely hides code blocks 😅 Here's the query: SELECT COUNT(DISTINCT(SPLIT(publication_id, '-')[OFFSET(0)])) AS unique_users FROM `lens-public-data.polygon.public_publication_pointer` WHERE DATE(block_timestamp) = '2023-04-11';
0 Comments
8 Likes
1 Mirrors