Loading dataset
Data viewTableSummary
Data viewTableSummary
Updated

258 MB across 3 parts, newest sealed 12 November 2026 at 22:44 UTC. The first build wrote 3 parts and 8.2M rows.

All 2 checks passed.
  • One row per key passed.
  • Change count passed.

filer_cik

integer

The filing manager's SEC Central Index Key (CIK).

9,152 distinct values, no chart

Valid
8,152,670 · 100%
Missing
0 · 0%
Distinct
9,152 · 0.1% of valid
Min
2230
25%
1277557
Median
1632966
75%
1883134
Max
2151773

report_period

date

The quarter end the change runs to, and the column the table partitions on.

  • 2026-06-3034%
  • 2026-03-3133%
  • 2025-12-3132%
Valid
8,152,670 · 100%
Missing
0 · 0%
Distinct
3 · 0% of valid

cusip

string

The nine-character CUSIP of the security.

40,877 distinct values, no chart

Valid
8,152,670 · 100%
Missing
0 · 0%
Distinct
40,877 · 0.5% of valid

put_call

string

none for a direct holding, put or call for an option position.

  • none96%
  • call2%
  • put2%
Valid
8,152,670 · 100%
Missing
0 · 0%
Distinct
3 · 0% of valid

prior_period

date

The previous quarter end the position is compared with.

  • 2026-03-3134%
  • 2025-12-3133%
  • 2025-09-3032%
Valid
8,152,670 · 100%
Missing
0 · 0%
Distinct
3 · 0% of valid

filer_name

string

The filing manager's name.

9,319 distinct values, no chart

Valid
8,152,670 · 100%
Missing
0 · 0%
Distinct
9,319 · 0.1% of valid

filer_crd_number

integer

The manager's CRD number, which joins to the advisers table.

4,991 distinct values, no chart

Valid
3,690,771 · 45.3%
Missing
4,461,899 · 54.7%
Missing over timeMissing share of filer_crd_number over time, 54% to 56%.
Distinct
4,991 · 0.1% of valid
Min
0
25%
117153
Median
155216
75%
288863
Max
801119436

issuer_name

string

The issuer name as the manager wrote it.

199,521 distinct values, no chart

Valid
8,152,670 · 100%
Missing
0 · 0%
Distinct
199,521 · 2.4% of valid

ticker

string

The ticker symbol for the CUSIP, where the holdings table has one.

13,704 distinct values, no chart

Valid
7,829,952 · 96%
Missing
322,718 · 4%
Missing over timeMissing share of ticker over time, 3% to 5%.
Distinct
13,704 · 0.2% of valid

change_type

string

new when the manager reported the security this quarter and not the last, exited when it dropped out, increased, decreased or unchanged by quantity held, and first_report when the manager filed no holdings for the previous quarter.

  • increased32%
  • decreased28%
  • unchanged14%
Valid
8,152,670 · 100%
Missing
0 · 0%
Distinct
6 · 0% of valid

shares

integer

Shares held at the quarter end. Zero for an exited position.

Histogram: 0 to 1323750000, 8,152,660; 1323750001 to 2647500000, 7; 2647500001 to 3971250000, 0; 3971250001 to 5295000000, 0; 5295000001 to 6618750000, 0; 6618750001 to 7942500000, 1; 7942500001 to 9266250000, 1; 9266250001 to 10590000000, 1
010590000000
Valid
8,152,670 · 100%
Missing
0 · 0%
Distinct
860,535 · 10.6% of valid
Min
0
25%
628
Median
7800
75%
49471
Max
10590000000

prior_shares

integer

Shares held at the previous quarter end. Empty when there was no prior position.

Histogram: 0 to 1323750000, 6,924,915; 1323750001 to 2647500000, 6; 2647500001 to 3971250000, 0; 3971250001 to 5295000000, 0; 5295000001 to 6618750000, 0; 6618750001 to 7942500000, 1; 7942500001 to 9266250000, 1; 9266250001 to 10590000000, 1
010590000000
Valid
6,924,924 · 84.9%
Missing
1,227,746 · 15.1%
Missing over timeMissing share of prior_shares over time, 14% to 16%.
Distinct
836,294 · 12.1% of valid
Min
0
25%
1907
Median
11553
75%
64539
Max
10590000000

share_change

integer

Shares held now minus shares held at the previous quarter end.

Histogram: -10590000000 to -9121087667, 1; -9121087666 to -7652175334, 1; -7652175333 to -6183263001, 1; -6183263000 to -4714350668, 0; -4714350667 to -3245438334, 0; -3245438333 to -1776526001, 0; -1776526000 to -307613668, 12; -307613667 to 1161298665, 6,924,909
-105900000001161298665
Valid
6,924,924 · 84.9%
Missing
1,227,746 · 15.1%
Missing over timeMissing share of share_change over time, 14% to 16%.
Distinct
617,741 · 8.9% of valid
Min
-10590000000
25%
-1684
Median
0
75%
543
Max
1161298665

share_change_pct

decimal

The change in shares as a percentage of the prior shares. Empty for new positions and first reports.

Histogram: -100 to 30862400, 6,918,047; 30862400 to 61724900, 12; 61724900 to 92587400, 7; 92587400 to 123449900, 1; 123449900 to 154312400, 3; 154312400 to 185174900, 0; 185174900 to 216037400, 3; 216037400 to 246899900, 1
-100.00246899900.00
Valid
6,918,074 · 84.9%
Missing
1,234,596 · 15.1%
Missing over timeMissing share of share_change_pct over time, 14% to 16%.
Distinct
146,398 · 2.1% of valid
Min
-100.00
25%
-17.34
Median
0.00
75%
5.64
Max
246899900.00

value_usd

integer

Market value at the quarter end in US dollars. Zero for an exited position.

Histogram: 0 to 52842053849, 8,152,477; 52842053850 to 105684107699, 132; 105684107700 to 158526161549, 29; 158526161550 to 211368215398, 16; 211368215399 to 264210269248, 3; 264210269249 to 317052323098, 6; 317052323099 to 369894376948, 4; 369894376949 to 422736430797, 3
0422736430797
Valid
8,152,670 · 100%
Missing
0 · 0%
Distinct
3,508,551 · 43% of valid
Min
0
25%
16474
Median
428931
75%
2698030
Max
422736430797

prior_value_usd

integer

Market value at the previous quarter end in US dollars.

Histogram: 0 to 51858367038, 6,924,762; 51858367039 to 103716734077, 108; 103716734078 to 155575101116, 26; 155575101117 to 207433468155, 14; 207433468156 to 259291835194, 2; 259291835195 to 311150202233, 5; 311150202234 to 363008569272, 5; 363008569273 to 414866936311, 2
0414866936311
Valid
6,924,924 · 84.9%
Missing
1,227,746 · 15.1%
Missing over timeMissing share of prior_value_usd over time, 14% to 16%.
Distinct
3,374,129 · 48.7% of valid
Min
0
25%
95731
Median
592136
75%
3439628
Max
414866936311

value_change_usd

integer

Market value now minus market value at the previous quarter end, in US dollars. It mixes price moves with trading.

Histogram: -97263876923 to -74336688501, 2; -74336688500 to -51409500078, 5; -51409500077 to -28482311656, 10; -28482311655 to -5555123233, 198; -5555123232 to 17372065190, 6,924,633; 17372065191 to 40299253612, 67; 40299253613 to 63226442035, 7; 63226442036 to 86153630457, 2
-9726387692386153630457
Valid
6,924,924 · 84.9%
Missing
1,227,746 · 15.1%
Missing over timeMissing share of value_change_usd over time, 14% to 16%.
Distinct
2,769,277 · 40% of valid
Min
-97263876923
25%
-129749
Median
0
75%
120613
Max
86153630457

Table profile

Profile of the served version, all rows, computed 16 Nov 2026, 17:57 UTC

WarningFreshnessLatest event 136 d before this version
WarningGaps179 empty days, 1 Jan to 30 Mar and 1 Apr to 29 Jun
WarningAnomaliesSpike on 31 Dec, 2,637,935 rows against about 0, and 2 more
PassedUnique keysEvery filer_cik · report_period · cusip · put_call is unique
Rows per day
Rows per day, 182 buckets from 31 Dec 2025 to 30 Jun 2026, at most 2,792,798 rows, 179 empty, 3 marked as anomalies.3m31 Dec 2025: 2,637,935 rows, spike, about 0 expected1 Jan 2026: 0 rows2 Jan 2026: 0 rows3 Jan 2026: 0 rows4 Jan 2026: 0 rows5 Jan 2026: 0 rows6 Jan 2026: 0 rows7 Jan 2026: 0 rows8 Jan 2026: 0 rows9 Jan 2026: 0 rows10 Jan 2026: 0 rows11 Jan 2026: 0 rows12 Jan 2026: 0 rows13 Jan 2026: 0 rows14 Jan 2026: 0 rows15 Jan 2026: 0 rows16 Jan 2026: 0 rows17 Jan 2026: 0 rows18 Jan 2026: 0 rows19 Jan 2026: 0 rows20 Jan 2026: 0 rows21 Jan 2026: 0 rows22 Jan 2026: 0 rows23 Jan 2026: 0 rows24 Jan 2026: 0 rows25 Jan 2026: 0 rows26 Jan 2026: 0 rows27 Jan 2026: 0 rows28 Jan 2026: 0 rows29 Jan 2026: 0 rows30 Jan 2026: 0 rows31 Jan 2026: 0 rows1 Feb 2026: 0 rows2 Feb 2026: 0 rows3 Feb 2026: 0 rows4 Feb 2026: 0 rows5 Feb 2026: 0 rows6 Feb 2026: 0 rows7 Feb 2026: 0 rows8 Feb 2026: 0 rows9 Feb 2026: 0 rows10 Feb 2026: 0 rows11 Feb 2026: 0 rows12 Feb 2026: 0 rows13 Feb 2026: 0 rows14 Feb 2026: 0 rows15 Feb 2026: 0 rows16 Feb 2026: 0 rows17 Feb 2026: 0 rows18 Feb 2026: 0 rows19 Feb 2026: 0 rows20 Feb 2026: 0 rows21 Feb 2026: 0 rows22 Feb 2026: 0 rows23 Feb 2026: 0 rows24 Feb 2026: 0 rows25 Feb 2026: 0 rows26 Feb 2026: 0 rows27 Feb 2026: 0 rows28 Feb 2026: 0 rows1 Mar 2026: 0 rows2 Mar 2026: 0 rows3 Mar 2026: 0 rows4 Mar 2026: 0 rows5 Mar 2026: 0 rows6 Mar 2026: 0 rows7 Mar 2026: 0 rows8 Mar 2026: 0 rows9 Mar 2026: 0 rows10 Mar 2026: 0 rows11 Mar 2026: 0 rows12 Mar 2026: 0 rows13 Mar 2026: 0 rows14 Mar 2026: 0 rows15 Mar 2026: 0 rows16 Mar 2026: 0 rows17 Mar 2026: 0 rows18 Mar 2026: 0 rows19 Mar 2026: 0 rows20 Mar 2026: 0 rows21 Mar 2026: 0 rows22 Mar 2026: 0 rows23 Mar 2026: 0 rows24 Mar 2026: 0 rows25 Mar 2026: 0 rows26 Mar 2026: 0 rows27 Mar 2026: 0 rows28 Mar 2026: 0 rows29 Mar 2026: 0 rows30 Mar 2026: 0 rows31 Mar 2026: 2,721,937 rows, spike, about 0 expected1 Apr 2026: 0 rows2 Apr 2026: 0 rows3 Apr 2026: 0 rows4 Apr 2026: 0 rows5 Apr 2026: 0 rows6 Apr 2026: 0 rows7 Apr 2026: 0 rows8 Apr 2026: 0 rows9 Apr 2026: 0 rows10 Apr 2026: 0 rows11 Apr 2026: 0 rows12 Apr 2026: 0 rows13 Apr 2026: 0 rows14 Apr 2026: 0 rows15 Apr 2026: 0 rows16 Apr 2026: 0 rows17 Apr 2026: 0 rows18 Apr 2026: 0 rows19 Apr 2026: 0 rows20 Apr 2026: 0 rows21 Apr 2026: 0 rows22 Apr 2026: 0 rows23 Apr 2026: 0 rows24 Apr 2026: 0 rows25 Apr 2026: 0 rows26 Apr 2026: 0 rows27 Apr 2026: 0 rows28 Apr 2026: 0 rows29 Apr 2026: 0 rows30 Apr 2026: 0 rows1 May 2026: 0 rows2 May 2026: 0 rows3 May 2026: 0 rows4 May 2026: 0 rows5 May 2026: 0 rows6 May 2026: 0 rows7 May 2026: 0 rows8 May 2026: 0 rows9 May 2026: 0 rows10 May 2026: 0 rows11 May 2026: 0 rows12 May 2026: 0 rows13 May 2026: 0 rows14 May 2026: 0 rows15 May 2026: 0 rows16 May 2026: 0 rows17 May 2026: 0 rows18 May 2026: 0 rows19 May 2026: 0 rows20 May 2026: 0 rows21 May 2026: 0 rows22 May 2026: 0 rows23 May 2026: 0 rows24 May 2026: 0 rows25 May 2026: 0 rows26 May 2026: 0 rows27 May 2026: 0 rows28 May 2026: 0 rows29 May 2026: 0 rows30 May 2026: 0 rows31 May 2026: 0 rows1 Jun 2026: 0 rows2 Jun 2026: 0 rows3 Jun 2026: 0 rows4 Jun 2026: 0 rows5 Jun 2026: 0 rows6 Jun 2026: 0 rows7 Jun 2026: 0 rows8 Jun 2026: 0 rows9 Jun 2026: 0 rows10 Jun 2026: 0 rows11 Jun 2026: 0 rows12 Jun 2026: 0 rows13 Jun 2026: 0 rows14 Jun 2026: 0 rows15 Jun 2026: 0 rows16 Jun 2026: 0 rows17 Jun 2026: 0 rows18 Jun 2026: 0 rows19 Jun 2026: 0 rows20 Jun 2026: 0 rows21 Jun 2026: 0 rows22 Jun 2026: 0 rows23 Jun 2026: 0 rows24 Jun 2026: 0 rows25 Jun 2026: 0 rows26 Jun 2026: 0 rows27 Jun 2026: 0 rows28 Jun 2026: 0 rows29 Jun 2026: 0 rows30 Jun 2026: 2,792,798 rows, spike, about 0 expected
Rows per 2 days by filer_cik · cusip · put_call, 10 of 3,293,779
Rows per 2 days by filer_cik · cusip · put_call, 10 of 3,293,779, with the share of days that have rows on the right.2,230 · 00287Y1…2%2,230 · 00548F1…2%2,230 · 0079031…2%2,230 · 02079K3…2%2,230 · 0231351…2%2,230 · 0326541…2%2,230 · 0378331…2%2,230 · 0404132…2%2,230 · 0605051…2%2,230 · 0846707…2%2,230 · 00287Y109 · none: 3 rows, 179 of 182 buckets empty2,230 · 00548F105 · none: 3 rows, 179 of 182 buckets empty2,230 · 007903107 · none: 3 rows, 179 of 182 buckets empty2,230 · 02079K305 · none: 3 rows, 179 of 182 buckets empty2,230 · 023135106 · none: 3 rows, 179 of 182 buckets empty2,230 · 032654105 · none: 3 rows, 179 of 182 buckets empty2,230 · 037833100 · none: 3 rows, 179 of 182 buckets empty2,230 · 040413205 · none: 3 rows, 179 of 182 buckets empty2,230 · 060505104 · none: 3 rows, 179 of 182 buckets empty2,230 · 084670702 · none: 3 rows, 179 of 182 buckets empty2026FebMarAprMayJun

Support

Talk to Mostly Right

Loading chat…