MiFID II Transaction Reporting

This dataset provides comprehensive, standardized records of securities transactions as required by MiFID II regulations, including instrument details, parties involved, execution specifics, and regulatory flags. It is ideal for regulatory reporting, market surveillance, and compliance analytics in European financial markets.

  • last updated 1 Nov 2025
  • by GoMask
The brief that made it

Regulatory transaction reporting for MiFID II compliance

Sample rows

preview · 8 of 400 rows · all 20 columns
transaction_idstringinstrument_typestringquantityfloattransaction_flagsstringtrade_datedatetrade_timedatetimereporting_entity_idstringcounterparty_idstringinstrument_idstringpricefloatcurrencystringvenuestringtransaction_typestringtransaction_statusstringexecution_methodstringsettlement_datedatebuyer_idstringseller_idstringtransaction_referencestringregulatory_reporting_codestring
Q8T1XRJ2K5equity1050regular2024-06-142024-06-14T09:32:15Z5493001KJTIIGC8Y1R12213800D1EI4B9WTZ1C62US0378331005187.24USDXNASbuyexecutedautomated2024-06-16213800D1EI4B9WTZ1C625493001KJTIIGC8Y1R12REF-20240614-EQ-01US001
F1J9PWX8B2equity220regular2024-06-152024-06-15T14:55:44Z213800D1EI4B9WTZ1C62blankDE000BASF11149.53EURXFRAsellexecutedmanual2024-06-17213800D1EI4B9WTZ1C62blankREF-20240615-EQ-02DE002
J7Q2T5L9Z8equity3570large_order2024-06-172024-06-17T11:03:27Z529900M2327A6Z2L3A42213800D1EI4B9WTZ1C62AU0000XVGZA37.85USDXNYSbuyexecutedmanual2024-06-19529900M2327A6Z2L3A42213800D1EI4B9WTZ1C62REF-20240617-EQ-03US003
K6M8B4X2N0equity80regular2024-06-162024-06-16T13:21:09Z213800D1EI4B9WTZ1C62529900M2327A6Z2L3A42GB00026349469.45GBPXLONsellexecutedautomated2024-06-18blank213800D1EI4B9WTZ1C62REF-20240616-EQ-04UK004
N3C6H2Q5R8equity150regular2024-06-152024-06-15T16:29:37Z213800D1EI4B9WTZ1C62213800L9VCQ8T4Q9KJ19CH0038863350117.6CHFXSWXbuyexecutedmanual2024-06-17213800D1EI4B9WTZ1C62213800L9VCQ8T4Q9KJ19REF-20240615-EQ-05CH005
B2L6D9V3T1equity12rare_asset2024-06-142024-06-14T19:43:55Z529900M2327A6Z2L3A42blankJP390290000415001.23JPYXTKSbuyexecutedmanual2024-06-16529900M2327A6Z2L3A42blankREF-20240614-HIGH-VALUEJP006
T5J8Q2M1V9equity950large_order2024-06-162024-06-16T08:07:10Z213800L9VCQ8T4Q9KJ19529900M2327A6Z2L3A42CA135087B39358.93CADXTSEsellexecutedmanual2024-06-18blank213800L9VCQ8T4Q9KJ19REF-20240616-EQ-07CA007
V2M4B7X3J1equity510regular2024-06-152024-06-15T21:18:02Z5299001KJTIIGC8Y1R12blankFR000013110430.11EURXPARbuyexecutedautomated2024-06-175299001KJTIIGC8Y1R12blankREF-20240615-EQ-08FR008

What the 400 rows show

from the 400-row sample

Bond (instrument type) stands out: mean quantity is 1,988,806, against 628.0 for the rest.

  • 201.0median quantity
  • 3transaction statuses
  • 3execution methods
  • 4transaction types
  • 6currencies
  • 11venues
Mean quantity by instrument_type400 rows
01M2M678.3equity307 rows2Mbond67 rows13.4derivati…11 rows49.1other15 rows
quantity400 rows, in bands of 1M
0185370362188222203105M10Mquantity →

Median 201.0, from 0.25 to 9,500,000.

transaction_flags291 rows with a value · 109 left blank
  1. regular95
  2. year_end43
  3. block_trade33
  4. large_order20
  5. rare_asset19
  6. leap_year15
  7. below_par14
  8. special_condition10
  9. employee_stock_option9
  10. corporate_action7
20 columns by typefrom the column list below
  • string 15
  • float 2
  • date 2
  • datetime 1

Columns

20 columns in three groups
blueprint · 20 columns
columntypedescriptionexample
Text 15 columns
transaction_idstringUnique identifier for the reported transactionuniqueQ8T1XRJ2K5
reporting_entity_idstringUnique identifier for the reporting firm (LEI or other regulatory code)5493001KJTIIGC8Y1R12
counterparty_idstringUnique identifier for the transaction counterparty (LEI or other regulatory code)optional213800D1EI4B9WTZ1C62
instrument_idstringUnique identifier for the financial instrument (ISIN or equivalent)US0378331005
instrument_typestringType of financial instrument (e.g., equity, bond, derivative)equity · bond · derivative · otherequity
currencystringCurrency code in which the transaction was executed (ISO 4217)6 currenciesUSD
venuestringTrading venue identifier (MIC code or 'XOFF' for off-venue)11 venuesXNAS
transaction_typestringType of transaction (e.g., buy, sell, transfer, other)buy · sell · transfer · otherbuy
transaction_statusstringStatus of the transaction (e.g., executed, cancelled, amended)executed · cancelled · amendedexecuted
execution_methodstringMethod of execution (e.g., automated, manual)automated · manual · other · optionalautomated
buyer_idstringUnique identifier for the buyer (LEI or other regulatory code)optional213800D1EI4B9WTZ1C62
seller_idstringUnique identifier for the seller (LEI or other regulatory code)optional5493001KJTIIGC8Y1R12
transaction_referencestringReference code or number for the transaction, if applicableoptionalREF-20240614-EQ-01
transaction_flagsstringRegulatory flags or codes indicating special conditions (e.g., short sale, liquidity provider)optionalregular
regulatory_reporting_codestringCode indicating the regulatory reporting requirement or categoryoptionalUS001
Numbers 2 columns
quantityfloatNumber of units traded in the transaction0 or more1050
pricefloatPrice per unit of the instrument at execution0 or more187.24
Dates and times 3 columns
trade_datedateDate when the transaction was executed2024-06-14
trade_timedatetimeExact timestamp of the transaction execution2024-06-14T09:32:15Z
settlement_datedateDate when the transaction is settledoptional2024-06-16

Use it for

  • median quantity201.0400 rowsmean quantity by inst…678.3equi…2Mbond13.4deri…49.1other

    A finance dashboard

    Quantity by instrument_type and a breakdown of transaction_flags. Excel, Power BI or Tableau.

  • Why do the 67 bond rows have a mean quantity of 1,988,806?

    A root-cause class exercise

    Hand out the rows and one question. The answer is in the data, not in the brief.

  • A software demo

    Believable transactions with trade_date, trade_time and reporting_entity_id to fill a screen in front of a buyer.

Not quite right?

Make it yours.

Same 20 columns, your size and your rules. See 20 rows before you pay.

Preview 20 rows free

1,000 rows: $1.99 · 10,000: $12.99One-time. No subscription. All prices

This dataset400 rows20 columns
Yours1,000 rows20 columns

blueprint · mifid-ii-transaction-reporting-2

Behind this dataset

Same schema. As many rows as you need.

These 400 rows came out of a blueprint — 20 columns with generation rules behind each one. Open it in Data Factory to retune a column, add your own, wire in foreign keys, and run it at the size you actually need.

Rules it was built with
  • All securities transactions reported
  • Over 60 fields per transaction
  • ISIN code for instrument
  • LEI for legal entities
  • Trading venue identification
  • Price and quantity details
  • Buyer and seller information
  • Execution timestamp precise to microsecond
Rows
Open the blueprint in Data Factory

1 credit per row. New accounts start with 25 free credits.

Exports
CSV, JSON, JSONL, Parquet, SQL, Excel, TSV, XML
Licence
yours to use, including commercially
API slug
mifid-ii-transaction-reporting-2

More in Finance

Browse all
Also in FinanceISO20022 Payment Status Report (pain.002)Bank Transaction Category ClassificationBank Transaction Categorization SampleAll 1,954 datasets

What should your data show?

Preview 20 rows free
No signup. No card.