tranches_de_taille
Answered against 22 years of US equities and 12 years of US options data and published with the query that produced it. This result is stored as of 2026-10-01, from block-trades-on-euronext-paris.
| tranche_de_taille | part_transactions_pct | part_volume_pct |
|---|---|---|
| moins de 100 titres | 90.058 | 30.529 |
| de 100 à 999 titres | 9.757 | 27.428 |
| de 1 000 à 9 999 titres | 0.177 | 5.773 |
| 10 000 titres et plus | 0.009 | 36.27 |
- Rows × columns
- 4 × 3
- Computed
- Completeness
- No missing values
- Source
- US exchange, SIP and OPRA market data
- Licence
- Strasmore terms · free, no signup
What each column holds
| Column | Type | Range | Notes |
|---|---|---|---|
tranche_de_taille |
text | 4 distinct values | |
part_transactions_pct |
number | 0.009 to 90.058 | percent |
part_volume_pct |
number | 5.773 to 36.27 | percent |
Computed from Strasmore's warehouse of US exchange, SIP and OPRA market data. Equity prices are delayed; options greeks and implied volatility are end-of-day. This result is stored, not recomputed on load — it is exactly the numbers that were returned on , and the query below is what returned them.
Run it yourself
This is the exact query behind the result above. Change a ticker, a date or a column and run it against the warehouse — no account, no key. The no-signup tier is smaller than the one this page was computed on; a query that reaches past it comes back saying which plan runs it.
WITH impressions AS
(
SELECT size
FROM global_markets.stocks_trades
WHERE ticker = 'AAPL'
AND sip_timestamp >= toDateTime('2026-06-10 08:00:00', 'UTC')
AND sip_timestamp < toDateTime('2026-06-11 01:00:00', 'UTC')
)
SELECT
multiIf(size < 100, 'moins de 100 titres',
size < 1000, 'de 100 à 999 titres',
size < 10000, 'de 1 000 à 9 999 titres',
'10 000 titres et plus') AS tranche_de_taille,
round(100 * count() / (SELECT count() FROM impressions), 3) AS part_transactions_pct,
round(100 * sum(size) / (SELECT sum(size) FROM impressions), 3) AS part_volume_pct
FROM impressions
GROUP BY tranche_de_taille
ORDER BY min(size)
Travaillez ces données dans votre assistant IA
S'ouvre prêt à interroger, avec les données de cette page. Gratuit, sans compte.