Exchange_traded_Products

idProductNameTickerSymbolAssetClassTotalAssetsExitFee
1AAPLAAPLEquity239.670.01
2MSFTMSFTEquity286.210.015
3GOOGGOOGEquity262.330.01
4AMZNAMZNEquity356.330.01
5TSLATSLAEquity109.860.01

Unit_investment_Trusts

idTrustNameTickerSymbolNetAssetValueNumberOfUnitsExitFee
1ABCDABCD10.01000000.01
2EFGHEFGH12.5800000.015
3IJKLIJKL8.2500000.01
4MNOPMNOP7.6600000.015
5QRSTQRST9.8750000.01

Customers

idCustomerNameEmailAddressPhoneNumberAccountBalance
1John Doejohndoe@example.com12345678905000.0
2Jane Smithjanesmith@example.com098765432110000.0
3Alice Johnsonalicejohnson@example.com555555555515000.0
4Bob Brownbobbrown@example.com555555555620000.0
5Charlie Greencharliegreen@example.com555555555725000.0

Orders

OrderIDCustomerIdProductTypeQuantityPriceDateOrdered
(→ Customers.id)
11Exchange_traded_product101002022-01-01 12:00:00
22Exchange_traded_product51202022-01-01 12:01:00
33Exchange_traded_product101102022-01-01 12:02:00
44Exchange_traded_product151302022-01-01 12:03:00
55Exchange_traded_product201402022-01-01 12:04:00

Transactions

TransactionIdOrderIdAmountFeesPaymentMethodStatusProcessDate
(→ Orders.OrderID)
111000.020.0Debit CardCompleted2022-01-01 12:00:00
22600.012.0PayPalCompleted2022-01-01 12:01:00
331100.022.0Bank TransferCompleted2022-01-01 12:02:00
441300.024.0CheckCompleted2022-01-01 12:03:00
551400.026.0Wire TransferCompleted2022-01-01 12:04:00