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 | 348 | 126 | 318 | 461 | 1004 | 3737 | 7389 | 6542 | 19925 |
2 | 51-100 days | 314 | 200 | 882 | 1636 | 4782 | 15167 | 20214 | 5043 | 48238 |
3 | 21-50 days | 1467 | 2929 | 3640 | 14105 | 62580 | 152997 | 39089 | 2182 | 278989 |
4 | 11-20 days | 3083 | 4623 | 13018 | 64516 | 212542 | 189400 | 10018 | 150 | 497350 |
5 | 06-10 days | 11279 | 11295 | 95340 | 182526 | 157809 | 47307 | 1326 | 11 | 506893 |
6 | 03-5 days | 75014 | 103724 | 210748 | 105540 | 36992 | 6174 | 149 | 0 | 538341 |
7 | 02 days | 163459 | 61067 | 46842 | 13977 | 3203 | 476 | 13 | 0 | 289037 |
8 | 01 day | 291420 | 35517 | 17058 | 4343 | 989 | 232 | 9 | 13 | 349581 |
eferScroll_Overlap
Updated 23 hours ago
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: about 23 hours agoAuto-refreshes every 24 hours
8
503B
2s