Days Category | 01 contract | 02 contracts | 03-05 contracts | 06-10 contracts | 11-20 contracts | 21-50 contracts | 51-100 contracts | Over 100 contracts | Summation | |
|---|---|---|---|---|---|---|---|---|---|---|
1 | Over 100 days | 355 | 125 | 325 | 464 | 1004 | 3749 | 7417 | 6569 | 20008 |
2 | 51-100 days | 316 | 200 | 879 | 1645 | 4780 | 15208 | 20260 | 5050 | 48338 |
3 | 21-50 days | 1497 | 2931 | 3671 | 14124 | 62668 | 153504 | 39129 | 2170 | 279694 |
4 | 11-20 days | 3119 | 4645 | 13227 | 64790 | 213436 | 189294 | 9993 | 150 | 498654 |
5 | 06-10 days | 11390 | 11310 | 95423 | 182864 | 157068 | 47192 | 1327 | 11 | 506585 |
6 | 03-5 days | 75625 | 104083 | 211424 | 105305 | 36906 | 6125 | 145 | 0 | 539613 |
7 | 02 days | 164151 | 61579 | 46911 | 13884 | 3183 | 478 | 13 | 0 | 290199 |
8 | 01 day | 293733 | 35818 | 17391 | 4345 | 983 | 230 | 9 | 13 | 352522 |
eferScroll_Overlap
Updated 2025-04-27
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
›
⌄
SELECT
value:"days_category" AS "Days Category",
value:"01 contract"::numeric AS "01 contract",
value:"02 contracts"::numeric AS "02 contracts",
value:"03-05 contracts"::numeric AS "03-05 contracts",
value:"06-10 contracts"::numeric AS "06-10 contracts",
value:"11-20 contracts"::numeric AS "11-20 contracts",
value:"21-50 contracts"::numeric AS "21-50 contracts",
value:"51-100 contracts"::numeric AS "51-100 contracts",
value:"Over 100 contracts"::numeric AS "Over 100 contracts",
value:"Sum"::numeric AS "Summation"
FROM (
SELECT livequery.live.udf_api(
'https://raw.githubusercontent.com/eferbarn/scroll-marks-sampler/main/assets/Overlap.json'
) AS response
), lateral FLATTEN (input => response:data:data:rows)
Last run: 22 days agoAuto-refreshes every 24 hours
8
502B
2s