PUT Request

📘

PUT Request on Presigned URL

Once the job is successfully created, upload the payload using HTTP PUT method on generated presigned url. Read More

JSON Payload

This API accepts payload in following three formats:

Tradebook

View Workbook

👍

Click here to learn more about this JSON Payload

{
  "name": "tradebook_workbook",
  "@entity": "workbook",
  "sheets": [
    {
      "name": "stock_sheet",
      "@entity": "sheet",
      "blocks": [
        {
          "name": "stock_tradebook_table",
          "@entity": "table",
          "header": [
            "trade_id",
            "isin",
            "symbol",
            "is_listed",
            "is_stt_paid",
            "quantity",
            "date",
            "price",
            "transaction_type",
            "fmv",
            "brokerage",
            "clearing_charges",
            "exchange_transaction_charges",
            "sebi_turnover_fees",
            "stt",
            "stamp_duty",
            "sgst",
            "cgst",
            "igst",
            "other_transfer_expenses",
            "label",
            "product_type"
          ],
          "rows": [
            [
              "SUNMAQYIBRDSM4Y2TVW9",
              "INE462A01022",
              "BAYERCROP",
              true,
              true,
              25,
              1718582400000,
              4203.45,
              "buy",
              4199.55,
              45.6,
              45.6,
              45.6,
              45.6,
              45.6,
              45.6,
              45.6,
              45.6,
              45.6,
              45.6,
              null,
              "delivery"
            ],
            [
              "CJ1CLC4YCBFEZ4CVDNMH",
              "INE002A01018",
              "AJANTAPHARMA",
              true,
              true,
              1590,
              1463356800000,
              136,
              "buy",
              438,
              45.6,
              45.6,
              45.6,
              45.6,
              45.6,
              45.6,
              45.6,
              45.6,
              45.6,
              45.6,
              null,
              "delivery"
            ],
            [
              "PEB6U5ERJBDTNFSLPOI2",
              "INE462A01022",
              "BAYERCROP",
              true,
              true,
              37,
              1482451200000,
              4089,
              "buy",
              4199.55,
              45.6,
              45.6,
              45.6,
              45.6,
              45.6,
              45.6,
              45.6,
              45.6,
              45.6,
              45.6,
              null,
              "delivery"
            ],
            [
              "KZUG2ZMGMH4WFE2C9RMG",
              "INE03Q201024",
              "GLS",
              true,
              true,
              50,
              1499644800000,
              5000,
              "buy",
              5500,
              21.5,
              22.6,
              23.5,
              58,
              67,
              21.5,
              21.5,
              21.5,
              21.5,
              21.5,
              null,
              "delivery "
            ],
            [
              "VTHPFZ7KXVG5LMNZNBHT",
              "INE00E101023",
              "BIKAJI",
              true,
              true,
              1540,
              1592611200000,
              189,
              "buy",
              0,
              45.6,
              45.6,
              45.6,
              45.6,
              45.6,
              45.6,
              45.6,
              45.6,
              45.6,
              45.6,
              null,
              "delivery"
            ],
            [
              "YKSLVQ6HJEUROPF8Z7TL",
              "INE00E101023",
              "BIKAJI",
              true,
              true,
              435,
              1602547200000,
              209,
              "buy",
              0,
              45.6,
              45.6,
              45.6,
              45.6,
              45.6,
              45.6,
              45.6,
              45.6,
              45.6,
              45.6,
              null,
              "delivery"
            ],
            [
              "KQN4SO7YRL1T1YKS8XSO",
              "INE01C001018",
              "ADANIPORTS",
              true,
              true,
              348,
              1631145600000,
              270,
              "buy",
              137,
              45.6,
              45.6,
              45.6,
              45.6,
              45.6,
              45.6,
              45.6,
              45.6,
              45.6,
              45.6,
              null,
              "delivery"
            ],
            [
              "XEPL8VAO3PWPBVZRBSCE",
              "INE00E101023",
              "BIKAJI",
              true,
              true,
              200,
              1631923200000,
              221,
              "buy",
              0,
              45.6,
              45.6,
              45.6,
              45.6,
              45.6,
              45.6,
              45.6,
              45.6,
              45.6,
              45.6,
              null,
              "delivery"
            ],
            [
              "XEPL8VAO3PWPBVZRBSCE",
              "INE00E101023",
              "BIKAJI",
              true,
              true,
              85,
              1632009600000,
              225,
              "buy",
              0,
              45.6,
              45.6,
              45.6,
              45.6,
              45.6,
              45.6,
              45.6,
              45.6,
              45.6,
              45.6,
              null,
              "delivery"
            ],
            [
              "ZVQAT2PZ1RSLYWWYZTXP",
              "INE767A01016",
              "ADANIENT",
              true,
              true,
              57,
              1710288000000,
              1950,
              "buy",
              1260,
              45.6,
              45.6,
              45.6,
              45.6,
              45.6,
              45.6,
              45.6,
              45.6,
              45.6,
              45.6,
              null,
              "delivery"
            ],
            [
              "90VSCSRGLVSHW6FYHQDE",
              "INE00E101023",
              "BIKAJI",
              true,
              false,
              85,
              1741824000000,
              269,
              "buy",
              0,
              45.6,
              45.6,
              45.6,
              45.6,
              45.6,
              45.6,
              45.6,
              45.6,
              45.6,
              45.6,
              null,
              "intraday"
            ],
            [
              "OUYO53NES6HVEGSBXALX",
              "INE364U01010",
              "ADANIGREEN",
              true,
              false,
              15,
              1712275200000,
              281,
              "buy",
              127,
              45.6,
              45.6,
              45.6,
              45.6,
              45.6,
              45.6,
              45.6,
              45.6,
              45.6,
              45.6,
              null,
              "intraday"
            ],
            [
              "YYUFIXODHUCNJPZL0TB1",
              "INE767A01016",
              "ADANIENT",
              true,
              true,
              23,
              1745884800000,
              2016,
              "buy",
              1260,
              45.6,
              45.6,
              45.6,
              45.6,
              45.6,
              45.6,
              45.6,
              45.6,
              45.6,
              45.6,
              null,
              "delivery"
            ],
            [
              "ZR0GPABQCZJDEBAVL85E",
              "INE462A01022",
              "BAYERCROP",
              true,
              true,
              29,
              1746921600000,
              4198.05,
              "buy",
              4199.55,
              45.6,
              45.6,
              45.6,
              45.6,
              45.6,
              45.6,
              45.6,
              45.6,
              45.6,
              45.6,
              null,
              "delivery"
            ],
            [
              "ZDUUQFIZKFI1LPZJIGC1",
              "INE364U01010",
              "ADANIGREEN",
              true,
              true,
              47,
              1749340800000,
              310,
              "buy",
              127,
              45.6,
              45.6,
              45.6,
              45.6,
              45.6,
              45.6,
              45.6,
              45.6,
              45.6,
              45.6,
              null,
              "delivery"
            ],
            [
              "J9SYLEPLST8YFGPUOFCG",
              "INE002A01018",
              "AJANTAPHARMA",
              true,
              true,
              145,
              1749945600000,
              578,
              "buy",
              438,
              45.6,
              45.6,
              45.6,
              45.6,
              45.6,
              45.6,
              45.6,
              45.6,
              45.6,
              45.6,
              null,
              "delivery"
            ],
            [
              "KZ4XUMQL7O4OL1T0NWLW",
              "INE00E101023",
              "BIKAJI",
              true,
              true,
              140,
              1750032000000,
              327,
              "buy",
              0,
              45.6,
              45.6,
              45.6,
              45.6,
              45.6,
              45.6,
              45.6,
              45.6,
              45.6,
              45.6,
              null,
              "delivery"
            ],
            [
              "KZ4XUMQL7O4OL1T0NWLW",
              "INE00E101023",
              "BIKAJI",
              true,
              false,
              267,
              1718582400000,
              329,
              "buy",
              0,
              45.6,
              45.6,
              45.6,
              45.6,
              45.6,
              45.6,
              45.6,
              45.6,
              45.6,
              45.6,
              null,
              "intraday"
            ],
            [
              "RP9WLFA5LS29NBTKARXN",
              "INE462A01022",
              "BAYERCROP",
              true,
              false,
              25,
              1752278400000,
              4254,
              "buy",
              4199.55,
              45.6,
              45.6,
              45.6,
              45.6,
              45.6,
              45.6,
              45.6,
              45.6,
              45.6,
              45.6,
              null,
              "intraday"
            ],
            [
              "G3NSSV7XHVFUJ8BTPBIR",
              "INE462A01022",
              "BAYERCROP",
              true,
              true,
              29,
              1752364800000,
              4221,
              "buy",
              4199.55,
              45.6,
              45.6,
              45.6,
              45.6,
              45.6,
              45.6,
              45.6,
              45.6,
              45.6,
              45.6,
              null,
              "delivery"
            ],
            [
              "JOQYLFGNAJXEBBANLTJ9",
              "INE364U01010",
              "ADANIGREEN",
              true,
              true,
              20,
              1752710400000,
              290,
              "buy",
              127,
              45.6,
              45.6,
              45.6,
              45.6,
              45.6,
              45.6,
              45.6,
              45.6,
              45.6,
              45.6,
              null,
              "delivery"
            ],
            [
              "RZ4TQQXBXGQZ4CIGW89W",
              "INE01C001018",
              "ADANIPORTS",
              true,
              false,
              30,
              1752796800000,
              410,
              "buy",
              137,
              45.6,
              45.6,
              45.6,
              45.6,
              45.6,
              45.6,
              45.6,
              45.6,
              45.6,
              45.6,
              null,
              "intraday"
            ],
            [
              "ABHV4GJO8FEWYZYYZXJ9",
              "INE01C001018",
              "ADANIPORTS",
              true,
              true,
              20,
              1721174400000,
              429,
              "buy",
              137,
              45.6,
              45.6,
              45.6,
              45.6,
              45.6,
              45.6,
              45.6,
              45.6,
              45.6,
              45.6,
              null,
              "delivery"
            ],
            [
              "VQLDME6IOJZR95BDEKQ9",
              "INE010B01019",
              "CADILAHC",
              true,
              false,
              254,
              1724025600000,
              1290.98,
              "buy",
              120,
              45.6,
              45.6,
              45.6,
              45.6,
              45.6,
              45.6,
              45.6,
              45.6,
              45.6,
              45.6,
              null,
              "intraday"
            ],
            [
              "XAOZHKSKJV0S5IENATLG",
              "INE462A01022",
              "BAYERCROP",
              true,
              false,
              28,
              1759017600000,
              4289,
              "buy",
              4199.55,
              45.6,
              45.6,
              45.6,
              45.6,
              45.6,
              45.6,
              45.6,
              45.6,
              45.6,
              45.6,
              null,
              "intraday"
            ],
            [
              "8BARHLFV3FZVGYTSJ012",
              "INE03Q201024",
              "GLS",
              true,
              true,
              50,
              1721433600000,
              5000,
              "sell",
              5500,
              45.6,
              45.6,
              45.6,
              45.6,
              45.6,
              45.6,
              45.6,
              45.6,
              45.6,
              45.6,
              null,
              "delivery"
            ],
            [
              "CYX9TQSTWUYK8C9Z7BCE",
              "INE002A01018",
              "AJANTAPHARMA",
              true,
              true,
              645,
              1713594550000,
              580,
              "sell",
              438,
              45.6,
              45.6,
              45.6,
              45.6,
              45.6,
              45.6,
              45.6,
              45.6,
              45.6,
              45.6,
              null,
              "delivery"
            ],
            [
              "VXFUFI5Q9HH7FEJPLV3B",
              "INE010B01019",
              "CADILAHC",
              true,
              true,
              254,
              1724025600000,
              1301.78,
              "sell",
              120,
              45.6,
              45.6,
              45.6,
              45.6,
              45.6,
              45.6,
              45.6,
              45.6,
              45.6,
              45.6,
              null,
              "intraday"
            ],
            [
              "JOVR7LN5HKWR3H7LR3LK",
              "INE364U01010",
              "ADANIGREEN",
              true,
              true,
              15,
              1712275200000,
              250,
              "sell",
              127,
              45.6,
              45.6,
              45.6,
              45.6,
              45.6,
              45.6,
              45.6,
              45.6,
              45.6,
              45.6,
              null,
              "intraday"
            ],
            [
              "K0TMWRLU5HDBSNDITGWA",
              "INE01C001018",
              "ADANIPORTS",
              true,
              true,
              256,
              1714262400000,
              409,
              "sell",
              137,
              45.6,
              45.6,
              45.6,
              45.6,
              45.6,
              45.6,
              45.6,
              45.6,
              45.6,
              45.6,
              null,
              "delivery"
            ],
            [
              "NJK6VY186PT29EQOL5ZS",
              "INE767A01016",
              "ADANIENT",
              true,
              true,
              60,
              1726963200000,
              2300,
              "sell",
              1260,
              45.6,
              45.6,
              45.6,
              45.6,
              45.6,
              45.6,
              45.6,
              45.6,
              45.6,
              45.6,
              null,
              "delivery"
            ],
            [
              "DPB5UCBWCTWCCZQZAECT",
              "INE767A01016",
              "ADANIENT",
              true,
              true,
              20,
              1727395200000,
              2456,
              "sell",
              1260,
              45.6,
              45.6,
              45.6,
              45.6,
              45.6,
              45.6,
              45.6,
              45.6,
              45.6,
              45.6,
              null,
              "delivery"
            ],
            [
              "OCFAGNA9WLZOS2GPVEWY",
              "INE364U01010",
              "ADANIGREEN",
              true,
              true,
              40,
              1716681600000,
              365,
              "sell",
              127,
              45.6,
              45.6,
              45.6,
              45.6,
              45.6,
              45.6,
              45.6,
              45.6,
              45.6,
              45.6,
              null,
              "delivery"
            ],
            [
              "USTNCKBL23ZGYFBS1FWW",
              "INE01C001018",
              "ADANIPORTS",
              true,
              true,
              44,
              1714521600000,
              418,
              "sell",
              137,
              45.6,
              45.6,
              45.6,
              45.6,
              45.6,
              45.6,
              45.6,
              45.6,
              45.6,
              45.6,
              null,
              "delivery"
            ],
            [
              "AMLDHHSPBR225CYDH1G3",
              "INE01C001018",
              "ADANIPORTS",
              true,
              true,
              20,
              1752796800000,
              436,
              "sell",
              137,
              45.6,
              45.6,
              45.6,
              45.6,
              45.6,
              45.6,
              45.6,
              45.6,
              45.6,
              45.6,
              null,
              "intraday"
            ],
            [
              "G4FILRR9JSAWETX5BFEG",
              "INE01C001018",
              "ADANIPORTS",
              true,
              true,
              58,
              1727568000000,
              447,
              "sell",
              137,
              45.6,
              45.6,
              45.6,
              45.6,
              45.6,
              45.6,
              45.6,
              45.6,
              45.6,
              45.6,
              null,
              "delivery"
            ],
            [
              "3S1E2CVMTK3I115OG5IT",
              "INE002A01018",
              "AJANTAPHARMA",
              true,
              true,
              900,
              1734412800000,
              618,
              "sell",
              438,
              45.6,
              45.6,
              45.6,
              45.6,
              45.6,
              45.6,
              45.6,
              45.6,
              45.6,
              45.6,
              null,
              "delivery"
            ],
            [
              "HJWC2DJPNJV7KBYAVLMP",
              "INE002A01018",
              "AJANTAPHARMA",
              true,
              true,
              190,
              1724544000000,
              689,
              "sell",
              438,
              45.6,
              45.6,
              45.6,
              45.6,
              45.6,
              45.6,
              45.6,
              45.6,
              45.6,
              45.6,
              null,
              "delivery"
            ],
            [
              "8LWK9OAGZ64HKNYHYX6H",
              "INE462A01022",
              "BAYERCROP",
              true,
              true,
              31,
              1713484800000,
              4217.67,
              "sell",
              4199.55,
              45.6,
              45.6,
              45.6,
              45.6,
              45.6,
              45.6,
              45.6,
              45.6,
              45.6,
              45.6,
              null,
              "delivery"
            ],
            [
              "ROJM9PXLTVRGADTWZXMX",
              "INE462A01022",
              "BAYERCROP",
              true,
              true,
              10,
              1716076800000,
              4228,
              "sell",
              4199.55,
              45.6,
              45.6,
              45.6,
              45.6,
              45.6,
              45.6,
              45.6,
              45.6,
              45.6,
              45.6,
              null,
              "delivery"
            ],
            [
              "ROJM9PXLTVRGADTWZXMX",
              "INE462A01022",
              "BAYERCROP",
              true,
              true,
              9,
              1716076800000,
              4249,
              "sell",
              4199.55,
              45.6,
              45.6,
              45.6,
              45.6,
              45.6,
              45.6,
              45.6,
              45.6,
              45.6,
              45.6,
              null,
              "delivery"
            ],
            [
              "UCB2JO0JMYBFRYRHILMZ",
              "INE462A01022",
              "BAYERCROP",
              true,
              true,
              25,
              1752278400000,
              4239,
              "sell",
              4199.55,
              45.6,
              45.6,
              45.6,
              45.6,
              45.6,
              45.6,
              45.6,
              45.6,
              45.6,
              45.6,
              null,
              "intraday"
            ],
            [
              "1JQ2PDASHYXZCVH6IFTC",
              "INE462A01022",
              "BAYERCROP",
              true,
              true,
              70,
              1725062400000,
              4278.08,
              "sell",
              4199.55,
              45.6,
              45.6,
              45.6,
              45.6,
              45.6,
              45.6,
              45.6,
              45.6,
              45.6,
              45.6,
              null,
              "delivery"
            ],
            [
              "AU2VBOKJGOGV82FMOSZL",
              "INE462A01022",
              "BAYERCROP",
              true,
              true,
              28,
              1727568000000,
              4298,
              "sell",
              4199.55,
              45.6,
              45.6,
              45.6,
              45.6,
              45.6,
              45.6,
              45.6,
              45.6,
              45.6,
              45.6,
              null,
              "intraday"
            ],
            [
              "IAVLRAW3OKLIHPD0DLKQ",
              "INE00E101023",
              "BIKAJI",
              true,
              true,
              640,
              1708819200000,
              265,
              "sell",
              0,
              45.6,
              45.6,
              45.6,
              45.6,
              45.6,
              45.6,
              45.6,
              45.6,
              45.6,
              45.6,
              null,
              "delivery"
            ],
            [
              "YHEZMWYMV85DIO52CY1B",
              "INE00E101023",
              "BIKAJI",
              true,
              true,
              110,
              1707868800000,
              257,
              "sell",
              0,
              45.6,
              45.6,
              45.6,
              45.6,
              45.6,
              45.6,
              45.6,
              45.6,
              45.6,
              45.6,
              null,
              "delivery"
            ],
            [
              "DLQMNK7WJJEH6SZOCZO6",
              "INE00E101023",
              "BIKAJI",
              true,
              true,
              85,
              1741824000000,
              273,
              "sell",
              0,
              45.6,
              45.6,
              45.6,
              45.6,
              45.6,
              45.6,
              45.6,
              45.6,
              45.6,
              45.6,
              null,
              "intraday"
            ],
            [
              "7UBKDTDSUWJEWXI71MB5",
              "INE00E101023",
              "BIKAJI",
              true,
              true,
              250,
              1714262400000,
              317,
              "sell",
              0,
              45.6,
              45.6,
              45.6,
              45.6,
              45.6,
              45.6,
              45.6,
              45.6,
              45.6,
              45.6,
              null,
              "delivery"
            ],
            [
              "SVYLOESSMFAWL2P1V4YN",
              "INE00E101023",
              "BIKAJI",
              true,
              true,
              260,
              1716076800000,
              334,
              "sell",
              0,
              45.6,
              45.6,
              45.6,
              45.6,
              45.6,
              45.6,
              45.6,
              45.6,
              45.6,
              45.6,
              null,
              "delivery"
            ],
            [
              "UZB55NEDOEZEB81QTBOI",
              "INE00E101023",
              "BIKAJI",
              true,
              true,
              267,
              1718582400000,
              321,
              "sell",
              0,
              45.6,
              45.6,
              45.6,
              45.6,
              45.6,
              45.6,
              45.6,
              45.6,
              45.6,
              45.6,
              null,
              "intraday"
            ],
            [
              "T2D14C472FNCQD8A9SEL",
              "INE00E101023",
              "BIKAJI",
              true,
              true,
              730,
              1721520000000,
              339,
              "sell",
              0,
              45.6,
              45.6,
              45.6,
              45.6,
              45.6,
              45.6,
              45.6,
              45.6,
              45.6,
              45.6,
              null,
              "delivery"
            ],
            [
              "IHQR3WDABXX5LWECAVD4",
              "INE00E101023",
              "BIKAJI",
              true,
              true,
              349,
              1722297600000,
              345,
              "sell",
              0,
              45.6,
              45.6,
              45.6,
              45.6,
              45.6,
              45.6,
              45.6,
              45.6,
              45.6,
              45.6,
              null,
              "delivery"
            ],
            [
              "ZJZZOQLJZWYQRMSHK2E3",
              "INE00E101023",
              "BIKAJI",
              true,
              true,
              321,
              1725062400000,
              370,
              "sell",
              0,
              45.6,
              45.6,
              45.6,
              45.6,
              45.6,
              45.6,
              45.6,
              45.6,
              45.6,
              45.6,
              null,
              "delivery"
            ]
          ]
        },
        {
          "name": "dividend_table",
          "@entity": "table",
          "header": [
            "isin",
            "symbol",
            "quantity",
            "date",
            "dividend_per_share",
            "dividend_amount",
            "tax_withheld"
          ],
          "rows": [
            [
              "INE00E101023",
              "BIKAJI",
              5,
              1725062400000,
              2,
              10,
              null
            ],
            [
              "INE010B01019",
              "CADILAHC",
              1,
              1725062400000,
              5,
              5,
              null
            ]
          ]
        }
      ]
    },
    {
      "name": "future_sheet",
      "@entity": "sheet",
      "blocks": [
        {
          "name": "future_tradebook_table",
          "@entity": "table",
          "header": [
            "trade_id",
            "isin",
            "contract_name",
            "asset_class",
            "quantity",
            "date",
            "price",
            "transaction_type",
            "brokerage",
            "clearing_charges",
            "exchange_transaction_charges",
            "sebi_turnover_fees",
            "stt",
            "stamp_duty",
            "sgst",
            "cgst",
            "igst",
            "other_transfer_expenses",
            "label"
          ],
          "rows": [
            [
              "GGFCHMYLKDQYZRRINTEE",
              "INE914J01012",
              "BANKNIFTY 01 Jun 2023 FUT",
              "equity",
              45,
              1711756800000,
              363.1,
              "buy",
              51,
              98,
              75,
              55,
              32,
              219,
              11,
              142,
              55,
              36,
              null
            ],
            [
              "AUGUWEK01EI4YOIMH7RK",
              "INE519I01013",
              "BANKNIFTY 15 Jun 2023 FUT",
              "equity",
              50,
              1714176000000,
              363.15,
              "buy",
              7,
              56,
              55,
              223,
              245,
              330,
              106,
              144,
              103,
              9,
              null
            ],
            [
              "55MCNYCUWJO7C3ZAXWIX",
              "INE512D09106",
              "FUTCOM CRUDEOIL 16 OCT 2022",
              "commodity",
              100,
              1727731200000,
              415,
              "buy",
              107,
              8,
              114,
              111,
              90,
              43,
              36,
              48,
              119,
              21,
              null
            ],
            [
              "JDNI9UJFKN2PGFJZ5U9O",
              "INE579I01014",
              "FUTCUR USDINR 27 JAN 2023 ",
              "currency",
              135,
              1728585600000,
              90.69,
              "buy",
              134,
              183,
              209,
              9,
              100,
              50,
              202,
              60,
              140,
              214,
              null
            ],
            [
              "5NGIOMFGDRBG5Q8XTNBP",
              "INE512R02109",
              "NIFTY 23 JAN 2023 FUT",
              "equity",
              75,
              1728412800000,
              147.89,
              "buy",
              143,
              44,
              39,
              61,
              130,
              216,
              102,
              90,
              158,
              37,
              null
            ],
            [
              "ANH3LZISNL7R8DPFNHJ0",
              "INE512R02109",
              "NIFTY 23 JAN 2023 FUT",
              "equity",
              125,
              1728979200000,
              153.89,
              "buy",
              84,
              60,
              3,
              129,
              221,
              239,
              11,
              42,
              160,
              8,
              null
            ],
            [
              "S4LOWQJP4P6SFB42C460",
              "INE769A01020",
              "FINNIFTY 25 JAN 2023 FUT",
              "equity",
              35,
              1729756800000,
              3450.67,
              "buy",
              23,
              98,
              64,
              214,
              268,
              161,
              118,
              116,
              9,
              21,
              null
            ],
            [
              "Z0FCJBWODSL8GF3KKVPY",
              "INE563D01013",
              "NIFTY 15 JAN 2023 FUT",
              "equity",
              250,
              1730620800000,
              168,
              "buy",
              27,
              73,
              8,
              224,
              284,
              306,
              42,
              111,
              5,
              17,
              null
            ],
            [
              "CIKTMLOWJQLROEGJXMFF",
              "INE118D01016",
              "NIFTY 25 JAN 2023 FUT",
              "equity",
              100,
              1729584000000,
              175.55,
              "buy",
              65,
              76,
              54,
              192,
              58,
              74,
              149,
              50,
              17,
              20,
              null
            ],
            [
              "NKN2PS2TJZWDA9CDP1RA",
              "INE002A01018",
              "FINNIFTY 15 FEB 2023 FUT",
              "equity",
              155,
              1730707200000,
              194.9,
              "buy",
              39,
              85,
              72,
              144,
              40,
              15,
              16,
              39,
              66,
              47,
              null
            ],
            [
              "TWF45MCZTDWEWSJXU3EF",
              "INE0C5901014",
              "NIFTY 23 FEB 2023 FUT",
              "equity",
              175,
              1730828800000,
              194.9,
              "buy",
              50,
              107,
              81,
              244,
              314,
              247,
              91,
              42,
              72,
              44,
              null
            ],
            [
              "8LEGU2BN0HXVHXYBIIRZ",
              "INE435D01014",
              "BANKNIFTY 20 MAR 2023 FUT",
              "equity",
              125,
              1730950400000,
              1500,
              "buy",
              62,
              53,
              28,
              146,
              85,
              446,
              149,
              77,
              165,
              22,
              null
            ],
            [
              "GB8MD1GQRMB7M3KIPYBT",
              "INE0C5901014",
              "NIFTY 17 APR 2023 FUT",
              "equity",
              145,
              1731260800000,
              457.89,
              "buy",
              131,
              77,
              80,
              49,
              161,
              373,
              17,
              130,
              77,
              16,
              null
            ],
            [
              "GUEQKVCN1OGWGMPXO1WQ",
              "INE322R01014",
              "FINNIFTY 20 MAY 2023 FUT",
              "equity",
              130,
              1731699200000,
              698.03,
              "buy",
              85,
              110,
              89,
              148,
              121,
              426,
              32,
              65,
              22,
              31,
              null
            ],
            [
              "JG3ZELDXI8SYG4HLXSCG",
              "INE694N01015",
              "RIL 15 OCT 2023 FUT",
              "equity",
              50,
              1726963200000,
              559.39,
              "buy",
              111,
              42,
              44,
              189,
              145,
              307,
              57,
              64,
              43,
              28,
              null
            ],
            [
              "1HLEP1MBFH5JINCYGEJB",
              "INE197R01010",
              "RIL 01 NOV 2023 FUT",
              "equity",
              175,
              1728000000000,
              1000,
              "buy",
              72,
              52,
              33,
              117,
              71,
              327,
              39,
              67,
              132,
              3,
              null
            ],
            [
              "YFVS53SUIXO1FBXICSP8",
              "INE576G01015",
              "INFY 30 OCT 2023 FUT",
              "equity",
              100,
              1728518400000,
              175,
              "buy",
              40,
              81,
              12,
              197,
              124,
              314,
              159,
              79,
              166,
              3,
              null
            ],
            [
              "EGTDOZWR9NJKLHJDXYSO",
              "INE197R01010",
              "RIL 31 OCT 2023 FUT",
              "equity",
              250,
              1728864000000,
              186,
              "buy",
              150,
              2,
              17,
              244,
              29,
              366,
              100,
              41,
              15,
              36,
              null
            ],
            [
              "JBJYWGG6VA3VFF3J7OWZ",
              "INE512R01010",
              "INFY 25 OCT FUT",
              "equity",
              225,
              1729123200000,
              180,
              "buy",
              69,
              65,
              61,
              243,
              278,
              69,
              18,
              109,
              55,
              17,
              null
            ],
            [
              "52VUZC1SJ5MW4IKAJPIA",
              "INE512D09106",
              "FUTCOM CRUDEOIL 16 OCT 2022",
              "commodity",
              25,
              1727817600000,
              423,
              "sell",
              106,
              107,
              78,
              45,
              79,
              100,
              14,
              58,
              70,
              85,
              null
            ],
            [
              "2FPD4QFGHO2ICG3SK0KG",
              "INE512D09106",
              "FUTCOM CRUDEOIL 16 OCT 2022",
              "commodity",
              50,
              1728681600000,
              456,
              "buy",
              80,
              89,
              33,
              66,
              61,
              71,
              116,
              120,
              55,
              33,
              null
            ],
            [
              "XPDDDCPTROUOHFWCQH7O",
              "INE512D09106",
              "FUTCOM CRUDEOIL 16 OCT 2022",
              "commodity",
              125,
              1729804800000,
              449,
              "sell",
              4,
              73,
              78,
              84,
              113,
              71,
              1,
              75,
              118,
              18,
              null
            ],
            [
              "KMY2EC1UMISH0BUMIEGT",
              "INE573G07017",
              "FUTCOM SILVERM 21 Nov 2022 ",
              "commodity",
              50,
              1729632000000,
              135,
              "buy",
              237,
              56,
              15,
              18,
              104,
              15,
              22,
              76,
              89,
              112,
              null
            ],
            [
              "KMY2EC1UMISH0BUMIEGT",
              "INE573G07017",
              "FUTCOM SILVERM 21 Nov 2022 ",
              "commodity",
              80,
              1729632000000,
              142,
              "buy",
              188,
              53,
              11,
              89,
              31,
              92,
              119,
              77,
              58,
              6,
              null
            ],
            [
              "JAWOZXSLWYKHKUWGWS6L",
              "INE573G07017",
              "FUTCOM SILVERM 21 Nov 2022 ",
              "commodity",
              70,
              1729728000000,
              148,
              "sell",
              77,
              57,
              74,
              83,
              42,
              83,
              110,
              104,
              60,
              102,
              null
            ],
            [
              "JAWOZXSLWYKHKUWGWS6L",
              "INE573G07017",
              "FUTCOM SILVERM 21 Nov 2022 ",
              "commodity",
              30,
              1729814400000,
              150,
              "sell",
              187,
              112,
              77,
              67,
              93,
              19,
              84,
              19,
              54,
              47,
              null
            ],
            [
              "1AW8BG2NTK1BPSLMR0TV",
              "INE573G07017",
              "FUTCOM SILVERM 21 Nov 2022 ",
              "commodity",
              140,
              1730419200000,
              137,
              "buy",
              234,
              97,
              29,
              100,
              39,
              72,
              49,
              115,
              110,
              93,
              null
            ],
            [
              "XOUZUWMHBDCRPKRGDD1Q",
              "INE573G07017",
              "FUTCOM SILVERM 21 Nov 2022 ",
              "commodity",
              80,
              1732060800000,
              154,
              "sell",
              136,
              76,
              35,
              49,
              98,
              56,
              75,
              2,
              15,
              75,
              null
            ],
            [
              "XOUZUWMHBDCRPKRGDD1Q",
              "INE573G07017",
              "FUTCOM SILVERM 21 Nov 2022 ",
              "commodity",
              20,
              1732060800000,
              153,
              "buy",
              211,
              31,
              34,
              6,
              18,
              105,
              104,
              41,
              67,
              52,
              null
            ],
            [
              "LAGBHUZEYUH1K2OMGP49",
              "INE573G07017",
              "FUTCOM SILVERM 21 Nov 2022 ",
              "commodity",
              130,
              1732492800000,
              156,
              "sell",
              110,
              41,
              105,
              57,
              47,
              64,
              63,
              34,
              46,
              26,
              null
            ],
            [
              "GR4XEL9XWBSYPARPT0EF",
              "INE113J07012",
              "FUTCOM GOLD 29 OCT 2023",
              "commodity",
              55,
              1726012800000,
              124.56,
              "sell",
              103,
              48,
              70,
              111,
              21,
              40,
              84,
              69,
              15,
              16,
              null
            ],
            [
              "M5ZXEWJZFFR9DR1ECYIE",
              "INE113J07012",
              "FUTCOM GOLD 29 OCT 2023",
              "commodity",
              55,
              1726272000000,
              121,
              "buy",
              125,
              52,
              36,
              22,
              92,
              17,
              67,
              79,
              46,
              109,
              null
            ],
            [
              "FUWODRFMJFABB1VZGX5D",
              "INE113J07012",
              "FUTCOM GOLD 29 NOV 2023",
              "commodity",
              85,
              1728604800000,
              135,
              "buy",
              212,
              24,
              78,
              32,
              52,
              54,
              7,
              83,
              8,
              119,
              null
            ],
            [
              "XVFHRXHI6QWNJUUKBJ0J",
              "INE113J07012",
              "FUTCOM GOLD 29 NOV 2023",
              "commodity",
              35,
              1729036800000,
              138,
              "buy",
              25,
              89,
              59,
              114,
              63,
              56,
              108,
              2,
              64,
              35,
              null
            ],
            [
              "OHNNDTMWFFACP6JQ82GM",
              "INE113J07012",
              "FUTCOM GOLD 29 NOV 2023",
              "commodity",
              90,
              1731369600000,
              142,
              "sell",
              108,
              57,
              19,
              77,
              25,
              94,
              115,
              78,
              71,
              117,
              null
            ],
            [
              "RRCAFBZWEKTPVLYJCRB4",
              "INE113J07012",
              "FUTCOM GOLD 29 NOV 2023",
              "commodity",
              10,
              1731542400000,
              149,
              "sell",
              130,
              3,
              116,
              15,
              41,
              119,
              118,
              26,
              76,
              77,
              null
            ],
            [
              "JDNI9UJFKN2PGFJZ5U9O",
              "INE579I01014",
              "FUTCUR USDINR 27 JAN 2023 ",
              "currency",
              145,
              1728585600000,
              87.45,
              "buy",
              212,
              202,
              223,
              125,
              116,
              48,
              71,
              75,
              100,
              24,
              null
            ],
            [
              "4TXSMROXNCO4YKN01YBF",
              "INE579I01014",
              "FUTCUR USDINR 27 JAN 2023 ",
              "currency",
              165,
              1728240000000,
              94.78,
              "sell",
              177,
              48,
              234,
              38,
              176,
              182,
              159,
              80,
              200,
              136,
              null
            ],
            [
              "D1VHUJNJ1WGO9JVCK2AZ",
              "INE579I01014",
              "FUTCUR USDINR 27 JAN 2023 ",
              "currency",
              100,
              1729104000000,
              45.98,
              "sell",
              97,
              219,
              153,
              19,
              118,
              231,
              228,
              31,
              185,
              186,
              null
            ],
            [
              "D1VHUJNJ1WGO9JVCK2AZ",
              "INE579I01014",
              "FUTCUR USDINR 27 JAN 2023 ",
              "currency",
              15,
              1729756800000,
              78.3,
              "sell",
              94,
              93,
              127,
              162,
              79,
              232,
              149,
              211,
              83,
              6,
              null
            ],
            [
              "UVSIUTXLTZHDRHICW9C0",
              "INE645F01015",
              "FUTCUR EURINR 13 MAY 2023",
              "currency",
              50,
              1731174400000,
              245.78,
              "sell",
              46,
              228,
              186,
              237,
              75,
              6,
              46,
              97,
              203,
              34,
              null
            ],
            [
              "V7L7EV2WB1F06YIJSHQS",
              "INE645F01015",
              "FUTCUR EURINR 13 MAY 2023",
              "currency",
              50,
              1731174400000,
              260.7,
              "buy",
              178,
              162,
              152,
              207,
              202,
              185,
              95,
              232,
              121,
              209,
              null
            ],
            [
              "8GTJ7JADP09KTKDPFWQJ",
              "INE645F01015",
              "FUTCUR EURINR 13 MAY 2023",
              "currency",
              145,
              1731347200000,
              278,
              "sell",
              20,
              164,
              152,
              121,
              98,
              148,
              35,
              194,
              110,
              34,
              null
            ],
            [
              "XNAQJZ3OTJFDZ2FEGVVQ",
              "INE645F01015",
              "FUTCUR EURINR 13 MAY 2023",
              "currency",
              145,
              1711756800000,
              289,
              "buy",
              25,
              85,
              159,
              60,
              145,
              36,
              46,
              146,
              237,
              157,
              null
            ],
            [
              "NU9Y7DKWYXX1B8HUGX0G",
              "INE714H01019",
              "FUTCUR GBPINR 27 OCT 2023",
              "currency",
              75,
              1725667200000,
              4500,
              "buy",
              21,
              179,
              65,
              29,
              21,
              92,
              124,
              178,
              153,
              12,
              null
            ],
            [
              "NU9Y7DKWYXX1B8HUGX0G",
              "INE714H01019",
              "FUTCUR GBPINR 27 OCT 2023",
              "currency",
              75,
              1725667200000,
              4509,
              "sell",
              15,
              93,
              151,
              111,
              104,
              103,
              55,
              238,
              153,
              97,
              null
            ],
            [
              "7BN92HT8TUYNDOW29YPQ",
              "INE714H01019",
              "FUTCUR GBPINR 27 OCT 2023",
              "currency",
              113,
              1726185600000,
              4492.367,
              "buy",
              57,
              230,
              240,
              67,
              116,
              76,
              6,
              3,
              169,
              150,
              null
            ],
            [
              "QRJDSFMYL79ULAWADZ4C",
              "INE714H01019",
              "FUTCUR GBPINR 27 OCT 2023",
              "currency",
              60,
              1726876800000,
              4499.876,
              "sell",
              145,
              184,
              130,
              50,
              35,
              17,
              90,
              146,
              149,
              199,
              null
            ],
            [
              "FZJQJNQWOJE78OSAKILB",
              "INE714H01019",
              "FUTCUR GBPINR 27 OCT 2023",
              "currency",
              43,
              1728691200000,
              5008.596,
              "sell",
              47,
              22,
              47,
              31,
              24,
              32,
              128,
              195,
              47,
              87,
              null
            ],
            [
              "BZAB3NIFLVXCEWLNXF0C",
              "INE632P01025",
              "FUTCUR JPYINR 24 AUG 2023",
              "currency",
              120,
              1731184000000,
              345.89,
              "sell",
              7,
              203,
              116,
              18,
              12,
              64,
              159,
              151,
              211,
              148,
              null
            ],
            [
              "EUCWBOWYUQF5LLS2MG9P",
              "INE632P01025",
              "FUTCUR JPYINR 24 AUG 2023",
              "currency",
              80,
              1731788800000,
              325.67,
              "buy",
              44,
              87,
              14,
              179,
              169,
              178,
              97,
              26,
              72,
              170,
              null
            ],
            [
              "EUCWBOWYUQF5LLS2MG9P",
              "INE632P01025",
              "FUTCUR JPYINR 24 AUG 2023",
              "currency",
              30,
              1731788800000,
              319.78,
              "buy",
              89,
              205,
              71,
              145,
              106,
              166,
              209,
              67,
              6,
              124,
              null
            ],
            [
              "MUYD0KEIED2TJLMOBKEM",
              "INE632P01025",
              "FUTCUR JPYINR 24 AUG 2023",
              "currency",
              40,
              1731961600000,
              329.587,
              "sell",
              59,
              42,
              140,
              65,
              52,
              47,
              80,
              128,
              39,
              105,
              null
            ],
            [
              "DROFW5LAACDWOCFKDQET",
              "INE914J01012",
              "BANKNIFTY 01 Jun 2023 FUT",
              "equity",
              45,
              1730841600000,
              450.09,
              "sell",
              111,
              55,
              14,
              84,
              291,
              436,
              146,
              24,
              168,
              39,
              null
            ],
            [
              "Y9V66LWUBLF8P2I8FDAR",
              "INE519I01013",
              "BANKNIFTY 15 Jun 2023 FUT",
              "equity",
              25,
              1731100800000,
              469.22,
              "sell",
              78,
              91,
              80,
              41,
              123,
              291,
              83,
              151,
              115,
              11,
              null
            ],
            [
              "2C7BGL8DLAEX6DMFGRTF",
              "INE519I01013",
              "BANKNIFTY 15 Jun 2023 FUT",
              "equity",
              25,
              1730403200000,
              425.3,
              "sell",
              22,
              107,
              62,
              188,
              249,
              158,
              117,
              82,
              21,
              18,
              null
            ],
            [
              "CJLNLY40ORWJXUKGVC8E",
              "INE894N01016",
              "NIFTY 23 JAN 2023 FUT",
              "equity",
              25,
              1728153600000,
              135.67,
              "sell",
              69,
              101,
              25,
              74,
              90,
              300,
              128,
              21,
              56,
              3,
              null
            ],
            [
              "GFHNW8Q8GH4F408UZQ0M",
              "INE894N01017",
              "NIFTY 23 JAN 2023 FUT",
              "equity",
              45,
              1729104000000,
              129.89,
              "sell",
              132,
              88,
              37,
              24,
              279,
              212,
              148,
              43,
              116,
              26,
              null
            ],
            [
              "LL4ESNCPAINCWUTVOYKX",
              "INE894N01018",
              "NIFTY 23 JAN 2023 FUT",
              "equity",
              50,
              1730620800000,
              147.89,
              "sell",
              53,
              67,
              8,
              87,
              63,
              171,
              86,
              89,
              83,
              9,
              null
            ],
            [
              "WI62KWVR0MYO0WXLDQ4J",
              "INE694C01015",
              "NIFTY 23 JAN 2023 FUT",
              "equity",
              80,
              1730793600000,
              150,
              "sell",
              10,
              50,
              68,
              204,
              60,
              36,
              24,
              6,
              43,
              16,
              null
            ],
            [
              "IJPDDNJO9BNNH0TB9NPJ",
              "INE769A01020",
              "FINNIFTY 25 JAN 2023 FUT",
              "equity",
              35,
              1731139200000,
              2568.98,
              "sell",
              132,
              85,
              15,
              82,
              101,
              10,
              152,
              75,
              46,
              11,
              null
            ],
            [
              "VLNYY0FTJTUGELL1TK8D",
              "INE563D01013",
              "NIFTY 15 JAN 2023 FUT",
              "equity",
              25,
              1729411200000,
              146,
              "sell",
              105,
              53,
              3,
              114,
              193,
              397,
              8,
              2,
              58,
              43,
              null
            ],
            [
              "VLNYY0FTJTUGELL1TK8D",
              "INE563D01013",
              "NIFTY 15 JAN 2023 FUT",
              "equity",
              75,
              1729670400000,
              158,
              "sell",
              54,
              105,
              28,
              102,
              11,
              64,
              41,
              148,
              143,
              3,
              null
            ],
            [
              "VY3TYTSPMWLYJQAEMGTZ",
              "INE563D01013",
              "NIFTY 15 JAN 2023 FUT",
              "equity",
              150,
              1730707200000,
              255,
              "sell",
              138,
              32,
              42,
              214,
              44,
              13,
              146,
              43,
              52,
              35,
              null
            ],
            [
              "YQT2WZWDNZPPCRDSQFR9",
              "INE118D01016",
              "NIFTY 25 JAN 2023 FUT",
              "equity",
              100,
              1730880000000,
              126.78,
              "sell",
              18,
              23,
              81,
              239,
              107,
              183,
              158,
              64,
              137,
              50,
              null
            ],
            [
              "9ZLDZGRMJBSSAIJTBTHN",
              "INE002A01018",
              "FINNIFTY 15 FEB 2023 FUT",
              "equity",
              155,
              1731315200000,
              174.55,
              "sell",
              130,
              33,
              69,
              197,
              298,
              266,
              24,
              142,
              9,
              19,
              null
            ],
            [
              "RHSYRUIXEC7M4HJBK46H",
              "INE0C5901014",
              "NIFTY 23 FEB 2023 FUT",
              "equity",
              55,
              1731488000000,
              174.8,
              "sell",
              111,
              86,
              26,
              17,
              303,
              388,
              149,
              16,
              53,
              20,
              null
            ],
            [
              "I3RI1TXUYSFLFU4N8IWZ",
              "INE0C5901014",
              "NIFTY 23 FEB 2023 FUT",
              "equity",
              120,
              1732243200000,
              210.89,
              "sell",
              115,
              42,
              78,
              151,
              292,
              262,
              98,
              151,
              37,
              30,
              null
            ],
            [
              "BYSC5G1EPZIWIJJ6BAUB",
              "INE435D01014",
              "BANKNIFTY 20 MAR 2023 FUT",
              "equity",
              125,
              1732329600000,
              615.89,
              "sell",
              101,
              83,
              15,
              219,
              125,
              349,
              140,
              154,
              129,
              6,
              null
            ],
            [
              "MWLF0LTSOJNEXKVXSGWN",
              "INE0C5901014",
              "NIFTY 17 APR 2023 FUT",
              "equity",
              135,
              1732761600000,
              489.67,
              "sell",
              132,
              94,
              74,
              184,
              190,
              173,
              30,
              72,
              61,
              48,
              null
            ],
            [
              "B67GMDMHCZAHJBXKDGL0",
              "INE322R01014",
              "FINNIFTY 20 MAY 2023 FUT",
              "equity",
              120,
              1732761600000,
              745.32,
              "sell",
              150,
              13,
              35,
              133,
              133,
              362,
              128,
              119,
              83,
              39,
              null
            ],
            [
              "DEN7PSRIFMQ0VQXZF8O8",
              "INE694N01015",
              "RIL 15 OCT 2023 FUT",
              "equity",
              50,
              1732761600000,
              615.35,
              "sell",
              99,
              59,
              84,
              104,
              322,
              159,
              92,
              122,
              136,
              15,
              null
            ],
            [
              "GAVL50RNZDGGQSMMLKOF",
              "INE576G01015",
              "INFY 30 OCT 2023 FUT",
              "equity",
              100,
              1732761600000,
              145,
              "sell",
              50,
              96,
              11,
              84,
              204,
              220,
              20,
              125,
              146,
              23,
              null
            ],
            [
              "BWQRBJTC2V55AFBIZPYW",
              "INE197R01010",
              "RIL 31 OCT 2023 FUT",
              "equity",
              250,
              1732761600000,
              199,
              "sell",
              89,
              57,
              49,
              235,
              303,
              147,
              23,
              114,
              11,
              24,
              null
            ]
          ]
        }
      ]
    },
    {
      "name": "option_sheet",
      "@entity": "sheet",
      "blocks": [
        {
          "name": "option_tradebook_table",
          "@entity": "table",
          "header": [
            "trade_id",
            "isin",
            "contract_name",
            "asset_class",
            "quantity",
            "date",
            "price",
            "transaction_type",
            "brokerage",
            "clearing_charges",
            "exchange_transaction_charges",
            "sebi_turnover_fees",
            "stt",
            "stamp_duty",
            "sgst",
            "cgst",
            "igst",
            "other_transfer_expenses",
            "label"
          ],
          "rows": [
            [
              "RJFWB5JYYDORFUEPK5DQ",
              "INE619I01012",
              "BANKNIFTY 01 Jun 2023 CE 44100",
              "equity",
              25,
              1711756800000,
              363.1,
              "buy",
              385,
              201,
              2235,
              795,
              1757,
              202,
              195,
              2060,
              2112,
              1622,
              null
            ],
            [
              "Y6W9FLHOVJ8TCHHNBYGF",
              "INE545C01013",
              "BANKNIFTY 01 Jun 2023 CE 44200",
              "equity",
              75,
              1714176000000,
              363.15,
              "buy",
              2479,
              304,
              1657,
              2282,
              1170,
              172,
              1307,
              1660,
              1130,
              1106,
              null
            ],
            [
              "DML3WXXE53PJOTGTEYKJ",
              "INE512D09106",
              "OPTFUT CRUDEOIL 16 OCT 2022 7000 PE",
              "commodity",
              100,
              1727731200000,
              415,
              "buy",
              107,
              8,
              114,
              111,
              90,
              43,
              36,
              48,
              119,
              21,
              null
            ],
            [
              "GYHVDLIIXVTLROOCLVYG",
              "INE579I01014",
              "OPTCUR USDINR 27 JAN 2023 83 PE",
              "currency",
              135,
              1728585600000,
              90.69,
              "buy",
              134,
              183,
              209,
              9,
              100,
              50,
              202,
              60,
              140,
              214,
              null
            ],
            [
              "ULDR4PE639LOMU4A4VCE",
              "INE512R02109",
              "NIFTY 23 JAN 2023 CE 15000",
              "equity",
              75,
              1728412800000,
              1570,
              "buy",
              2122,
              1793,
              1820,
              1893,
              560,
              1651,
              875,
              2161,
              32,
              1916,
              null
            ],
            [
              "VIHCPUEYSZUMQUVPSJ1P",
              "INE512R02109",
              "NIFTY 23 JAN 2023 CE 15000",
              "equity",
              125,
              1728979200000,
              1490,
              "buy",
              114,
              1074,
              1522,
              44,
              1158,
              535,
              2252,
              1115,
              1171,
              2449,
              null
            ],
            [
              "QOO5OYJLQBIRUMIGKCIQ",
              "INE769A01020",
              "FINNIFTY 25 JAN 2023 CE 12500",
              "equity",
              50,
              1729756800000,
              3450.67,
              "buy",
              831,
              1827,
              1117,
              1814,
              1230,
              499,
              1882,
              2344,
              457,
              1850,
              null
            ],
            [
              "2BOMU4R5WMEONKEI5YT6",
              "INE563D01013",
              "NIFTY 23 JAN 2023 CE 15600",
              "equity",
              250,
              1730620800000,
              168,
              "buy",
              1280,
              657,
              1291,
              1139,
              636,
              2397,
              795,
              1161,
              2236,
              1620,
              null
            ],
            [
              "PZUTEFRTRX9LFW9DPHAW",
              "INE118D01016",
              "NIFTY 23 JAN 2023 CE 15650",
              "equity",
              100,
              1729584000000,
              175.55,
              "buy",
              125,
              882,
              2432,
              2077,
              2189,
              2472,
              2156,
              1856,
              1068,
              2285,
              null
            ],
            [
              "DIQDEZH7K04QBDCJY0NV",
              "INE002A01018",
              "FINNIFTY 15 FEB 2023 CE 13400",
              "equity",
              50,
              1730707200000,
              194.9,
              "buy",
              1645,
              1807,
              1262,
              2482,
              829,
              782,
              540,
              1000,
              354,
              2491,
              null
            ],
            [
              "PGR2RDEZFVC2S3YBX1JF",
              "INE0C5901014",
              "NIFTY 23 FEB 2023 PE 17100",
              "equity",
              105,
              1730828800000,
              194.9,
              "buy",
              1760,
              1640,
              2143,
              905,
              1374,
              1714,
              842,
              1776,
              847,
              299,
              null
            ],
            [
              "TFCXQ3TKQRMOHU86MXO1",
              "INE082B0101",
              "BANKNIFTY 20 MAR 2023 PE 18900",
              "equity",
              155,
              1730950400000,
              1500,
              "buy",
              104,
              552,
              1064,
              2411,
              1835,
              2056,
              2421,
              2289,
              651,
              2315,
              null
            ],
            [
              "DUYJ4ZV7OKJA8CV8U1MT",
              "INE0C5901014",
              "NIFTY 17 APR 2023 PE 17800",
              "equity",
              55,
              1731260800000,
              457.89,
              "buy",
              1766,
              2139,
              1170,
              2017,
              723,
              2101,
              1756,
              2357,
              1517,
              2394,
              null
            ],
            [
              "2GFSS7XTAHUWHFZH0NBR",
              "INE322R01014",
              "FINNIFTY 25 MAY 2023 CE 14900",
              "equity",
              130,
              1731699200000,
              698.03,
              "buy",
              682,
              2191,
              400,
              1922,
              813,
              188,
              1323,
              188,
              880,
              1267,
              null
            ],
            [
              "4AGDXGEEJOUHI6G8ATOU",
              "INE694N01015",
              "RELIANCE OCT 1940 CE",
              "equity",
              50,
              1726963200000,
              559.39,
              "buy",
              1244,
              2104,
              102,
              1018,
              319,
              1497,
              1669,
              2059,
              1901,
              485,
              null
            ],
            [
              "AHVDFMGBCECY1IR0QDH9",
              "INE197R01010",
              "RELIANCE OCT 1960 CE",
              "equity",
              175,
              1728000000000,
              1000,
              "buy",
              2181,
              2407,
              104,
              398,
              1577,
              1341,
              55,
              1215,
              1616,
              879,
              null
            ],
            [
              "Q2DZQ1ITYAOXILWQLHDN",
              "INE576G01015",
              "INFOSYS OCT 2550 CE",
              "equity",
              150,
              1728518400000,
              175,
              "buy",
              444,
              1610,
              769,
              2289,
              1456,
              437,
              1601,
              620,
              810,
              1319,
              null
            ],
            [
              "FQQ96BPTGAPAQPLMABNU",
              "INE197R01010",
              "RELIANCE OCT 1920 CE",
              "equity",
              250,
              1728864000000,
              186,
              "buy",
              1158,
              1954,
              1513,
              2091,
              1622,
              1175,
              383,
              2049,
              191,
              1624,
              null
            ],
            [
              "RKW88OVAQVWZMCD9VLJL",
              "INE512R01010",
              "INFOSYS OCT 2590 CE",
              "equity",
              225,
              1729123200000,
              180,
              "buy",
              874,
              1430,
              2384,
              1648,
              1398,
              596,
              367,
              396,
              1897,
              1511,
              null
            ],
            [
              "TTGYOR1EOA3SUTMNCJ58",
              "INE512D09106",
              "OPTFUT CRUDEOIL 16 OCT 2022 7000 PE",
              "commodity",
              25,
              1727817600000,
              423,
              "sell",
              106,
              107,
              78,
              45,
              79,
              100,
              14,
              58,
              70,
              85,
              null
            ],
            [
              "MYOFOBCC5W0PCWHVBFPU",
              "INE512D09106",
              "OPTFUT CRUDEOIL 16 OCT 2022 7000 PE",
              "commodity",
              50,
              1728681600000,
              456,
              "buy",
              80,
              89,
              33,
              66,
              61,
              71,
              116,
              120,
              55,
              33,
              null
            ],
            [
              "VIX3TEN3GZKPVY2WZCEX",
              "INE512D09106",
              "OPTFUT CRUDEOIL 16 OCT 2022 7000 PE",
              "commodity",
              125,
              1729804800000,
              449,
              "sell",
              4,
              73,
              78,
              84,
              113,
              71,
              1,
              75,
              118,
              18,
              null
            ],
            [
              "Q5CUBQ2P6B7VKNHCKWD6",
              "INE573G07017",
              "OPTFUT SILVERM 21 Nov 2022 58000 PE",
              "commodity",
              50,
              1729632000000,
              135,
              "buy",
              237,
              56,
              15,
              18,
              104,
              15,
              22,
              76,
              89,
              112,
              null
            ],
            [
              "Q5CUBQ2P6B7VKNHCKWD6",
              "INE573G07017",
              "OPTFUT SILVERM 21 Nov 2022 58000 PE",
              "commodity",
              80,
              1729632000000,
              142,
              "buy",
              188,
              53,
              11,
              89,
              31,
              92,
              119,
              77,
              58,
              6,
              null
            ],
            [
              "DTXGC9I0ZVOI2FFSHIOL",
              "INE573G07017",
              "OPTFUT SILVERM 21 Nov 2022 58000 PE",
              "commodity",
              70,
              1729728000000,
              148,
              "sell",
              77,
              57,
              74,
              83,
              42,
              83,
              110,
              104,
              60,
              102,
              null
            ],
            [
              "DTXGC9I0ZVOI2FFSHIOL",
              "INE573G07017",
              "OPTFUT SILVERM 21 Nov 2022 58000 PE",
              "commodity",
              30,
              1729814400000,
              150,
              "sell",
              187,
              112,
              77,
              67,
              93,
              19,
              84,
              19,
              54,
              47,
              null
            ],
            [
              "IU0HYP6ZN9EOERPBEWYA",
              "INE573G07017",
              "OPTFUT SILVERM 21 Nov 2022 58000 PE",
              "commodity",
              140,
              1730419200000,
              137,
              "buy",
              234,
              97,
              29,
              100,
              39,
              72,
              49,
              115,
              110,
              93,
              null
            ],
            [
              "TAODZZPWWR9R5CO1QX0R",
              "INE573G07017",
              "OPTFUT SILVERM 21 Nov 2022 58000 PE",
              "commodity",
              80,
              1732060800000,
              154,
              "sell",
              136,
              76,
              35,
              49,
              98,
              56,
              75,
              2,
              15,
              75,
              null
            ],
            [
              "TAODZZPWWR9R5CO1QX0R",
              "INE573G07017",
              "OPTFUT SILVERM 21 Nov 2022 58000 PE",
              "commodity",
              20,
              1732060800000,
              153,
              "buy",
              211,
              31,
              34,
              6,
              18,
              105,
              104,
              41,
              67,
              52,
              null
            ],
            [
              "HVG5B4A45J9CL4CZ35TF",
              "INE573G07017",
              "OPTFUT SILVERM 21 Nov 2022 58000 PE",
              "commodity",
              130,
              1732492800000,
              156,
              "sell",
              110,
              41,
              105,
              57,
              47,
              64,
              63,
              34,
              46,
              26,
              null
            ],
            [
              "CJ7UKXJFK6WDVAUWGXGW",
              "INE113J07012",
              "OPTFUT GOLD 29 OCT 2023 60000 PE",
              "commodity",
              55,
              1726012800000,
              124.56,
              "sell",
              103,
              48,
              70,
              111,
              21,
              40,
              84,
              69,
              15,
              16,
              null
            ],
            [
              "EAU3BEIXICIMKLVWWU56",
              "INE113J07012",
              "OPTFUT GOLD 29 OCT 2023 60000 PE",
              "commodity",
              55,
              1726272000000,
              121,
              "buy",
              125,
              52,
              36,
              22,
              92,
              17,
              67,
              79,
              46,
              109,
              null
            ],
            [
              "OJDZI0SB29R3RMHWOG8P",
              "INE113J07012",
              "OPTFUT GOLD 29 NOV2023 61000 PE",
              "commodity",
              85,
              1728604800000,
              135,
              "buy",
              212,
              24,
              78,
              32,
              52,
              54,
              7,
              83,
              8,
              119,
              null
            ],
            [
              "DOHDNKFFITQRMFUYKQLE",
              "INE113J07012",
              "OPTFUT GOLD 29 NOV2023 61000 PE",
              "commodity",
              35,
              1729036800000,
              138,
              "buy",
              25,
              89,
              59,
              114,
              63,
              56,
              108,
              2,
              64,
              35,
              null
            ],
            [
              "CVWO1J0HIG9QEY5UVUDQ",
              "INE113J07012",
              "OPTFUT GOLD 29 NOV2023 61000 PE",
              "commodity",
              90,
              1731369600000,
              142,
              "sell",
              108,
              57,
              19,
              77,
              25,
              94,
              115,
              78,
              71,
              117,
              null
            ],
            [
              "R2K5E791EH5VAQZVOETW",
              "INE113J07012",
              "OPTFUT GOLD 29 NOV2023 61000 PE",
              "commodity",
              10,
              1731542400000,
              149,
              "sell",
              130,
              3,
              116,
              15,
              41,
              119,
              118,
              26,
              76,
              77,
              null
            ],
            [
              "GYHVDLIIXVTLROOCLVYG",
              "INE579I01014",
              "OPTCUR USDINR 27 JAN 2023 83 PE",
              "currency",
              145,
              1728585600000,
              87.45,
              "buy",
              212,
              202,
              223,
              125,
              116,
              48,
              71,
              75,
              100,
              24,
              null
            ],
            [
              "8VMAOKSBFKXAX1Z75UK5",
              "INE579I01014",
              "OPTCUR USDINR 27 JAN 2023 83 PE",
              "currency",
              165,
              1728240000000,
              94.78,
              "sell",
              177,
              48,
              234,
              38,
              176,
              182,
              159,
              80,
              200,
              136,
              null
            ],
            [
              "ZXORPEEJE7TVFBPXQ8LI",
              "INE579I01014",
              "OPTCUR USDINR 27 JAN 2023 83 PE",
              "currency",
              100,
              1729104000000,
              45.98,
              "sell",
              97,
              219,
              153,
              19,
              118,
              231,
              228,
              31,
              185,
              186,
              null
            ],
            [
              "ZXORPEEJE7TVFBPXQ8LI",
              "INE579I01014",
              "OPTCUR USDINR 27 JAN 2023 83 PE",
              "currency",
              15,
              1729756800000,
              78.3,
              "sell",
              94,
              93,
              127,
              162,
              79,
              232,
              149,
              211,
              83,
              6,
              null
            ],
            [
              "6MDVYEYUKHJXIQSGEOPU",
              "INE645F01015",
              "OPTCUR EURINR 13 MAY 2023 94 CE",
              "currency",
              50,
              1731174400000,
              245.78,
              "sell",
              46,
              228,
              186,
              237,
              75,
              6,
              46,
              97,
              203,
              34,
              null
            ],
            [
              "CPYBETZOWLDVTAYF3PRA",
              "INE645F01015",
              "OPTCUR EURINR 13 MAY 2023 94 CE",
              "currency",
              50,
              1731174400000,
              260.7,
              "buy",
              178,
              162,
              152,
              207,
              202,
              185,
              95,
              232,
              121,
              209,
              null
            ],
            [
              "MEHVXLLGPB5SODCHL5PT",
              "INE645F01015",
              "OPTCUR EURINR 13 MAY 2023 94 CE",
              "currency",
              145,
              1731347200000,
              278,
              "sell",
              20,
              164,
              152,
              121,
              98,
              148,
              35,
              194,
              110,
              34,
              null
            ],
            [
              "UQCTRKWJRKXVR7LSIBCN",
              "INE645F01015",
              "OPTCUR EURINR 13 MAY 2023 94 CE",
              "currency",
              145,
              1711756800000,
              289,
              "buy",
              25,
              85,
              159,
              60,
              145,
              36,
              46,
              146,
              237,
              157,
              null
            ],
            [
              "PIN8G2M1QKXY1FQZPRIF",
              "INE714H01019",
              "OPTCUR GBPINR 27 OCT 2023 115 PE",
              "currency",
              75,
              1725667200000,
              4500,
              "buy",
              21,
              179,
              65,
              29,
              21,
              92,
              124,
              178,
              153,
              12,
              null
            ],
            [
              "PIN8G2M1QKXY1FQZPRIF",
              "INE714H01019",
              "OPTCUR GBPINR 27 OCT 2023 115 PE",
              "currency",
              75,
              1725667200000,
              4509,
              "sell",
              15,
              93,
              151,
              111,
              104,
              103,
              55,
              238,
              153,
              97,
              null
            ],
            [
              "69WJ3BI70HPVKNLEK5TR",
              "INE714H01019",
              "OPTCUR GBPINR 27 OCT 2023 115 PE",
              "currency",
              113,
              1726185600000,
              4492.367,
              "buy",
              57,
              230,
              240,
              67,
              116,
              76,
              6,
              3,
              169,
              150,
              null
            ],
            [
              "P534DDQESQ6XNTI4NURV",
              "INE714H01019",
              "OPTCUR GBPINR 27 OCT 2023 115 PE",
              "currency",
              60,
              1726876800000,
              4499.876,
              "sell",
              145,
              184,
              130,
              50,
              35,
              17,
              90,
              146,
              149,
              199,
              null
            ],
            [
              "OXGR4W3D3MYYBURZOEJ5",
              "INE714H01019",
              "OPTCUR GBPINR 27 OCT 2023 115 PE",
              "currency",
              43,
              1728691200000,
              5008.596,
              "sell",
              47,
              22,
              47,
              31,
              24,
              32,
              128,
              195,
              47,
              87,
              null
            ],
            [
              "T6B8078DHAC9MGWPKR6B",
              "INE632P01025",
              "OPTCUR JPYINR 24 AUG 2023 45.6 CE",
              "currency",
              120,
              1731184000000,
              345.89,
              "sell",
              7,
              203,
              116,
              18,
              12,
              64,
              159,
              151,
              211,
              148,
              null
            ],
            [
              "OFAILEZLEAPD9SU5ZOMT",
              "INE632P01025",
              "OPTCUR JPYINR 24 AUG 2023 45.6 CE",
              "currency",
              80,
              1731788800000,
              325.67,
              "buy",
              44,
              87,
              14,
              179,
              169,
              178,
              97,
              26,
              72,
              170,
              null
            ],
            [
              "OFAILEZLHKPD8SU7ZOMT",
              "INE632P01025",
              "OPTCUR JPYINR 24 AUG 2023 45.6 CE",
              "currency",
              30,
              1731788800000,
              319.78,
              "buy",
              89,
              205,
              71,
              145,
              106,
              166,
              209,
              67,
              6,
              124,
              null
            ],
            [
              "FDIT8EQR2XJFQJU2JLIG",
              "INE632P01025",
              "OPTCUR JPYINR 24 AUG 2023 45.6 CE",
              "currency",
              40,
              1731961600000,
              329.587,
              "sell",
              59,
              42,
              140,
              65,
              52,
              47,
              80,
              128,
              39,
              105,
              null
            ],
            [
              "KLPAV9GOUCMPFH1WNKLV",
              "INE619I01012",
              "BANKNIFTY 01 Jun 2023 CE 44100",
              "equity",
              25,
              1730841600000,
              450.09,
              "sell",
              1657,
              1302,
              325,
              2118,
              2050,
              604,
              2148,
              626,
              1489,
              2090,
              null
            ],
            [
              "0WNSDPGK4LTXO38HPTLU",
              "INE545C01013",
              "BANKNIFTY 01 Jun 2023 CE 44200",
              "equity",
              25,
              1731100800000,
              469.22,
              "sell",
              1711,
              1948,
              2048,
              700,
              2360,
              120,
              2415,
              333,
              2231,
              736,
              null
            ],
            [
              "QS2KFCND5DJXRNDLLVHD",
              "INE545C01013",
              "BANKNIFTY 01 Jun 2023 CE 44200",
              "equity",
              50,
              1730403200000,
              425.3,
              "sell",
              320,
              375,
              82,
              1593,
              1653,
              620,
              1637,
              712,
              542,
              130,
              null
            ],
            [
              "0B3PIU4WMIPKUQEG34BO",
              "INE512R02109",
              "NIFTY 23 JAN 2023 CE 15000",
              "equity",
              25,
              1728153600000,
              1460,
              "sell",
              499,
              2262,
              2210,
              507,
              256,
              2293,
              1125,
              2345,
              1852,
              90,
              null
            ],
            [
              "S7XOLPIQ2V4R5L89ZEE1",
              "INE512R02109",
              "NIFTY 23 JAN 2023 CE 15000",
              "equity",
              45,
              1729104000000,
              1508,
              "sell",
              1784,
              825,
              2087,
              498,
              666,
              616,
              1994,
              763,
              157,
              2380,
              null
            ],
            [
              "HSZA8B3XH3JC2POXMSXJ",
              "INE512R02109",
              "NIFTY 23 JAN 2023 CE 15000",
              "equity",
              50,
              1730620800000,
              1585,
              "sell",
              335,
              1434,
              254,
              1609,
              999,
              1979,
              2229,
              127,
              389,
              1244,
              null
            ],
            [
              "ILKEYGKTOHFQI5UXMBOO",
              "INE512R02109",
              "NIFTY 23 JAN 2023 CE 15000",
              "equity",
              80,
              1730793600000,
              1635,
              "sell",
              208,
              535,
              279,
              401,
              2010,
              248,
              494,
              746,
              2399,
              1196,
              null
            ],
            [
              "A9HFP9X49AROF21K9KRY",
              "INE769A01020",
              "FINNIFTY 25 JAN 2023 CE 12500",
              "equity",
              50,
              1731139200000,
              2568.98,
              "sell",
              319,
              59,
              25,
              2409,
              2339,
              423,
              132,
              250,
              2137,
              2442,
              null
            ],
            [
              "GHQTIWHDAFE90NOAU6ZY",
              "INE563D01013",
              "NIFTY 23 JAN 2023 CE 15600",
              "equity",
              25,
              1729411200000,
              146,
              "sell",
              1525,
              678,
              749,
              379,
              277,
              1791,
              2288,
              545,
              1042,
              327,
              null
            ],
            [
              "GHQTIWHDAFE90NOAU6ZY",
              "INE563D01013",
              "NIFTY 23 JAN 2023 CE 15600",
              "equity",
              75,
              1729670400000,
              158,
              "sell",
              1761,
              2349,
              1082,
              2181,
              1054,
              1396,
              856,
              1220,
              1740,
              1791,
              null
            ],
            [
              "IXMBK9LENH6CSGULION2",
              "INE563D01013",
              "NIFTY 23 JAN 2023 CE 15600",
              "equity",
              150,
              1730707200000,
              255,
              "sell",
              2369,
              875,
              2202,
              2488,
              1574,
              404,
              532,
              779,
              2266,
              1396,
              null
            ],
            [
              "BEZ31FONIR1EQQI68F0Y",
              "INE118D01016",
              "NIFTY 23 JAN 2023 CE 15650",
              "equity",
              100,
              1730880000000,
              126.78,
              "sell",
              288,
              7,
              2495,
              1391,
              1859,
              28,
              1298,
              355,
              1234,
              1955,
              null
            ],
            [
              "HMC8SXGWGNGWUTFBYRHX",
              "INE002A01018",
              "FINNIFTY 15 FEB 2023 CE 13400",
              "equity",
              50,
              1731315200000,
              174.55,
              "sell",
              879,
              2335,
              1905,
              1798,
              456,
              1765,
              358,
              1368,
              1124,
              1040,
              null
            ],
            [
              "KQDQ54GEHLHTIUSPGAV6",
              "INE0C5901014",
              "NIFTY 23 FEB 2023 PE 17100",
              "equity",
              55,
              1731488000000,
              174.8,
              "sell",
              181,
              764,
              1349,
              1121,
              2195,
              2042,
              1398,
              1674,
              164,
              2244,
              null
            ],
            [
              "SLB3JNRIBXSZWLRWP8ZZ",
              "INE0C5901014",
              "NIFTY 23 FEB 2023 PE 17100",
              "equity",
              50,
              1732243200000,
              210.89,
              "sell",
              77,
              713,
              1563,
              1666,
              1745,
              20,
              528,
              2500,
              1068,
              2008,
              null
            ],
            [
              "LMQI22RLLZHQ5CWBGFYP",
              "INE082B0101",
              "BANKNIFTY 20 MAR 2023 PE 18900",
              "equity",
              155,
              1732329600000,
              615.89,
              "sell",
              1842,
              519,
              2150,
              997,
              536,
              1241,
              2437,
              765,
              2481,
              2126,
              null
            ],
            [
              "71ZRU28BNR9F5FMOZS8V",
              "INE0C5901014",
              "NIFTY 17 APR 2023 PE 17800",
              "equity",
              55,
              1732761600000,
              489.67,
              "sell",
              1519,
              340,
              2379,
              190,
              164,
              2420,
              662,
              226,
              1681,
              722,
              null
            ],
            [
              "PHGLBJWZZLIDKTTVLNQE",
              "INE322R01014",
              "FINNIFTY 25 MAY 2023 CE 14900",
              "equity",
              120,
              1732761600000,
              745.32,
              "sell",
              820,
              1114,
              2137,
              646,
              2399,
              2314,
              160,
              1817,
              2092,
              283,
              null
            ],
            [
              "SEZD4CXXIXJ79ZS0GUQ2",
              "INE694N01015",
              "RELIANCE OCT 1940 CE",
              "equity",
              50,
              1732761600000,
              615.35,
              "sell",
              1797,
              249,
              1653,
              2028,
              897,
              542,
              1158,
              2067,
              964,
              1393,
              null
            ],
            [
              "UESSXHU0UHWCRJ1Z7LJR",
              "INE576G01015",
              "INFOSYS OCT 2550 CE",
              "equity",
              150,
              1732761600000,
              145,
              "sell",
              1204,
              722,
              1103,
              2190,
              1165,
              1168,
              597,
              1485,
              1127,
              1175,
              null
            ],
            [
              "TVSWJDGSX7VFVHA2AUXG",
              "INE197R01010",
              "RELIANCE OCT 1920 CE",
              "equity",
              250,
              1732761600000,
              199,
              "sell",
              267,
              1371,
              436,
              2246,
              1747,
              765,
              1306,
              1279,
              1236,
              1962,
              null
            ]
          ]
        }
      ]
    },
    {
      "name": "mutual_fund_sheet",
      "@entity": "sheet",
      "blocks": [
          {
          "name": "dividend_table",
          "@entity": "table",
          "header": [
            "isin",
            "symbol",
            "quantity",
            "date",
            "dividend_per_share",
            "dividend_amount",
            "tax_withheld"
          ],
          "rows": [
            [
              "INE00E101023",
              "BIKAJI",
              5,
              1725062400000,
              2,
              10,
              null
            ],
            [
              "INE010B01019",
              "CADILAHC",
              1,
              1725062400000,
              5,
              5,
              null
            ]
          ]
        },
        {
          "name": "mutual_fund_tradebook_table",
          "@entity": "table",
          "header": [
            "trade_id",
            "isin",
            "scheme_name",
            "asset_class",
            "is_listed",
            "is_stt_paid",
            "quantity",
            "date",
            "price",
            "transaction_type",
            "fmv",
            "transfer_expenses",
            "label"
          ],
          "rows": [
            [
              "TGFCH72LKDQY9RRINTGH",
              "INE397D01024",
              "HDFC CREDIT RISK DEBT FUND - DIRECT PLAN",
              "debt",
              true,
              true,
              32.31,
              1525824000000,
              50,
              "buy",
              400,
              10,
              null
            ],
            [
              "BVNCH72LKDQY9RRINTGH",
              "INF251K01NO3",
              "BNP PARIBAS LIQUID FUND - DIRECT PLAN",
              "debt",
              true,
              true,
              37.216,
              1589414400000,
              10,
              "buy",
              0,
              98,
              null
            ],
            [
              "BNG57MYGKDQY9RRINTGH",
              "INF277K01YE6",
              "TATA LIQUID FUND - DIRECT PLAN",
              "debt",
              true,
              true,
              19.574,
              1515456000000,
              120,
              "buy",
              5,
              78,
              null
            ],
            [
              "GJK45MYGKDQY9RRINTGH",
              "INF278A06YE8",
              "Aditya Birla Sun Life Medium Term Direct Plan Growth",
              "debt",
              true,
              true,
              36.023,
              1493769600000,
              30,
              "buy",
              10,
              68,
              null
            ],
            [
              "GHL909MYGKDQY9RRINTGH",
              "INF200K01UT4",
              "SBI LIQUID FUND - DIRECT PLAN",
              "other",
              true,
              true,
              35.014,
              1437177600000,
              15,
              "buy",
              17,
              67,
              null
            ],
            [
              "BHMGP79GKDQY9RRINTGH",
              "INF200K01189",
              "SBI Gold Fund",
              "other",
              true,
              true,
              35.706,
              1626739200000,
              60,
              "buy",
              65,
              30,
              null
            ],
            [
              "BLKMN98HJNMDQY9RRINTGH",
              "INF200K01189",
              "SBI Gold Fund",
              "other",
              true,
              true,
              36.062,
              1563667200000,
              60,
              "buy",
              120,
              50,
              null
            ],
            [
              "MJK88MYGKDQY9RRINTGH",
              "INF109KB1GK2",
              "ICICI Prudential Commodity Fund",
              "other",
              true,
              true,
              35.039,
              1626912000000,
              400.784,
              "buy",
              200,
              20,
              null
            ],
            [
              "GMFCH72LKDQY9RRINTGH",
              "INF179KB1HP9",
              "HDFC LIQUID FUND - DIRECT PLAN",
              "equity",
              true,
              true,
              25.68,
              1556409600000,
              459,
              "buy",
              220,
              0.25,
              null
            ],
            [
              "GGFCHMYLKDQY9RRINTGH",
              "INF846K01DI2",
              "Axis Bluechip Fund",
              "equity",
              true,
              true,
              105.56,
              1491436800000,
              123,
              "buy",
              20,
              25,
              null
            ],
            [
              "GGFCHMYLKDQY9RRINTGH",
              "INF846K01DI2",
              "Axis Bluechip Fund",
              "equity",
              true,
              true,
              550.34,
              1491436800000,
              124.5,
              "buy",
              20,
              49,
              null
            ],
            [
              "DFGR59NOHJDQ751TINTJK",
              "INF179K01PT5",
              "HDFC Small Cap Fund",
              "equity",
              true,
              true,
              129,
              1733760000000,
              150,
              "buy",
              100,
              32,
              null
            ],
            [
              "DFGR59NOHJDQ751TINTJK",
              "INF179K01PT5",
              "HDFC Small Cap Fund",
              "equity",
              true,
              true,
              100,
              1733760000000,
              250,
              "buy",
              100,
              56,
              null
            ],
            [
              "GHNR59NOHJDQ901TINTLK",
              "INF200K01OR6",
              "SBI Magnum Multicap Fund",
              "equity",
              true,
              true,
              156.78,
              1481500800000,
              150,
              "buy",
              160,
              22,
              null
            ],
            [
              "KNT59NOGKDQY897TINFTR",
              "INF760K01FR2",
              "Canara Robeco Bluechip Equity Growth Direct Plan",
              "equity",
              true,
              true,
              155,
              1576022400000,
              23.78,
              "buy",
              25,
              2,
              null
            ],
            [
              "HJM98MYGKDQY9RRINGFB",
              "INF200K01189",
              "SBI Gold Fund",
              "other",
              true,
              true,
              35,
              1374624000000,
              200,
              "buy",
              180,
              589,
              null
            ],
            [
              "JMCU8MYGKDQY9RRINTGH",
              "INF200K01189",
              "SBI Gold Fund",
              "other",
              true,
              true,
              35,
              1585008000000,
              230,
              "buy",
              180,
              37,
              null
            ],
            [
              "GHN78NOGKDQY9YTINFGHY",
              "INF200K01190",
              "KOTAK SEC FUND",
              "equity",
              true,
              true,
              50,
              1633564800000,
              980,
              "buy",
              800,
              145,
              null
            ],
            [
              "XCT59NOGKDQY9YTINFGRN",
              "INF200K01190",
              "KOTAK SEC FUND",
              "equity",
              true,
              true,
              40,
              1639872000000,
              1000,
              "buy",
              800,
              198,
              null
            ],
            [
              "KGFCH72LKDQY9RRINTGH",
              "INE397D01024",
              "HDFC CREDIT RISK DEBT FUND - DIRECT PLAN",
              "debt",
              true,
              true,
              32.31,
              1710921600000,
              900,
              "sell",
              1000,
              89.658,
              null
            ],
            [
              "KHF78MYGKDQY9RRINTGH",
              "INF251K01NO3",
              "BNP PARIBAS LIQUID FUND - DIRECT PLAN",
              "debt",
              true,
              true,
              17.823,
              1733625600000,
              5,
              "sell",
              0,
              20,
              null
            ],
            [
              "GHN78MYGKDQY9RRINTGH",
              "INF277K01YE6",
              "TATA LIQUID FUND - DIRECT PLAN",
              "debt",
              true,
              true,
              36.711,
              1714358400000,
              160,
              "sell",
              5,
              33.24,
              null
            ],
            [
              "BHM88MYGKDQY9RRINTGH",
              "INF278A06YE8",
              "Aditya Birla Sun Life Medium Term Direct Plan Growth",
              "debt",
              true,
              true,
              36.023,
              1729036800000,
              60,
              "sell",
              10,
              100,
              null
            ],
            [
              "BHM88MTYH6QY9RRINTGH",
              "INF200K01UT4",
              "SBI LIQUID FUND - DIRECT PLAN",
              "other",
              true,
              true,
              19.88,
              1729209600000,
              60,
              "sell",
              17,
              10,
              null
            ],
            [
              "CVH78MYGKDQY9RRINTGH",
              "INF109KB1GK2",
              "ICICI Prudential Commodity Fund",
              "other",
              true,
              true,
              32.531,
              1721788800000,
              200,
              "sell",
              200,
              90,
              null
            ],
            [
              "GMFCH72LKDQY9RRINTGH",
              "INF179KB1HP9",
              "HDFC LIQUID FUND - DIRECT PLAN",
              "equity",
              true,
              true,
              25.68,
              1731542400000,
              500,
              "sell",
              220,
              50,
              null
            ],
            [
              "JHF78MYGKDQY9RRINTGH",
              "INF846K01DI2",
              "Axis Bluechip Fund",
              "equity",
              true,
              true,
              355.9,
              1727731200000,
              212.7,
              "sell",
              20,
              28,
              null
            ],
            [
              "JTR59NOGKDQY9YTINTGH",
              "INF846K01DI2",
              "Axis Bluechip Fund",
              "equity",
              true,
              true,
              250,
              1728585600000,
              209,
              "sell",
              20,
              75,
              null
            ],
            [
              "HNT59NOGKDQY897TINF4R",
              "INF200K01OR6",
              "SBI Magnum Multicap Fund",
              "equity",
              true,
              true,
              125,
              1728844800000,
              400,
              "sell",
              160,
              89.658,
              null
            ],
            [
              "HYT59NOGKDQY9YTINFGRN",
              "INF760K01FR2",
              "Canara Robeco Bluechip Equity Growth Direct Plan",
              "equity",
              true,
              true,
              155,
              1729891200000,
              56.9,
              "sell",
              45,
              2,
              null
            ],
            [
              "RTV678MYGKDQY9RRINTGH",
              "INF200K01189",
              "SBI Gold Fund",
              "other",
              true,
              true,
              55,
              1732147200000,
              210,
              "sell",
              180,
              56,
              null
            ],
            [
              "VBN59NOGKDQY9YTINFGRN",
              "INF200K01190",
              "KOTAK SEC FUND",
              "equity",
              true,
              true,
              40,
              1729977600000,
              1200,
              "sell",
              800,
              230,
              null
            ],
            [
              "67859NOGKDQY9YTINFGRN",
              "INF200K01190",
              "KOTAK SEC FUND",
              "equity",
              true,
              true,
              50,
              1730150400000,
              1300,
              "sell",
              800,
              245,
              null
            ]
          ]
        }
      ]
    },
    {
      "name": "etf_sheet",
      "@entity": "sheet",
      "blocks": [
        {
          "name": "dividend_table",
          "@entity": "table",
          "header": [
            "isin",
            "symbol",
            "quantity",
            "date",
            "dividend_per_share",
            "dividend_amount",
            "tax_withheld"
          ],
          "rows": [
            [
              "INE00E101023",
              "BIKAJI",
              5,
              1725062400000,
              2,
              10,
              null
            ],
            [
              "INE010B01019",
              "CADILAHC",
              1,
              1725062400000,
              5,
              5,
              null
            ]
          ]
        },
        {
          "name": "etf_tradebook_table",
          "@entity": "table",
          "header": [
            "trade_id",
            "isin",
            "scheme_name",
            "asset_class",
            "is_listed",
            "is_stt_paid",
            "quantity",
            "date",
            "price",
            "transaction_type",
            "fmv",
            "brokerage",
            "clearing_charges",
            "exchange_transaction_charges",
            "sebi_turnover_fees",
            "stt",
            "stamp_duty",
            "sgst",
            "cgst",
            "igst",
            "other_transfer_expenses",
            "label",
            "product_type"
          ],
          "rows": [
            [
              "TGFCH72LKDQY9RRINTGH",
              "INE397D01024",
              "HDFC CREDIT RISK DEBT FUND - DIRECT PLAN",
              "debt",
              true,
              true,
              250,
              1714521600000,
              650,
              "buy",
              400,
              115,
              74,
              130,
              137,
              144,
              113,
              122,
              132,
              69,
              76,
              null,
              "intraday"
            ],
            [
              "BVNCH72LKDQY9RRINTGH",
              "INF251K01NO3",
              "BNP PARIBAS LIQUID FUND - DIRECT PLAN",
              "debt",
              true,
              true,
              31.536,
              1723132800000,
              10,
              "buy",
              340,
              92,
              34,
              93,
              139,
              17,
              3,
              68,
              61,
              48,
              109,
              null,
              "delivery"
            ],
            [
              "BNG57MYGKDQY9RRINTGH",
              "INF277K01YE6",
              "TATA LIQUID FUND - DIRECT PLAN",
              "debt",
              true,
              true,
              80,
              1568160000000,
              120,
              "buy",
              250,
              127,
              17,
              108,
              1,
              26,
              75,
              33,
              126,
              113,
              56,
              null,
              "delivery"
            ],
            [
              "BHM88MYGKDQY9RRINTGH",
              "INF278A06YE8",
              "Aditya Birla Sun Life Medium Term Direct Plan Growth",
              "debt",
              true,
              true,
              100,
              1740336000000,
              60,
              "buy",
              10,
              88,
              62,
              132,
              43,
              111,
              35,
              4,
              113,
              61,
              3,
              null,
              "delivery"
            ],
            [
              "GHL909MYGKDQY9RRINTGH",
              "INF200K01UT4",
              "SBI LIQUID FUND - DIRECT PLAN",
              "other",
              true,
              true,
              20,
              1731196800000,
              15,
              "buy",
              17,
              37,
              7,
              47,
              38,
              9,
              43,
              25,
              78,
              72,
              16,
              null,
              "intraday"
            ],
            [
              "BLKMN98HJNMDQY9RRINTGH",
              "INF200K01189",
              "SBI Gold Fund",
              "other",
              true,
              true,
              50,
              1641427200000,
              120.5877,
              "buy",
              65,
              28,
              17,
              52,
              65,
              13,
              40,
              13,
              40,
              40,
              28,
              null,
              "delivery"
            ],
            [
              "MJK88MYGKDQY9RRINTGH",
              "INF109KB1GK2",
              "ICICI Prudential Commodity Fund",
              "other",
              true,
              true,
              150,
              1627862400000,
              400.784,
              "buy",
              200,
              77,
              59,
              77,
              12,
              5,
              2,
              7,
              10,
              5,
              30,
              null,
              "delivery"
            ],
            [
              "GMFCH72LKDQY9RRINTGH",
              "INF179KB1HP9",
              "HDFC LIQUID FUND - DIRECT PLAN",
              "equity",
              true,
              true,
              100,
              1715212800000,
              550,
              "buy",
              220,
              137,
              98,
              138,
              39,
              106,
              59,
              21,
              61,
              146,
              78,
              null,
              "intraday"
            ],
            [
              "JNV5CHMYLKDQY9RRINTG",
              "INF846K01DI2",
              "Axis Bluechip Fund",
              "equity",
              true,
              true,
              78,
              1589414400000,
              23,
              "buy",
              20,
              106,
              17,
              123,
              61,
              31,
              105,
              24,
              117,
              16,
              62,
              null,
              "delivery"
            ],
            [
              "PKF88MYGKDQY9RRINTGH",
              "INF179K01PT5",
              "HDFC Small Cap Fund",
              "equity",
              true,
              true,
              90,
              1515456000000,
              150,
              "buy",
              100,
              92,
              43,
              29,
              90,
              64,
              70,
              66,
              51,
              112,
              117,
              null,
              "delivery"
            ],
            [
              "DFGR59NOHJDQ751TINTJK",
              "INF200K01OR6",
              "SBI Magnum Multicap Fund",
              "equity",
              true,
              true,
              95,
              1493769600000,
              150,
              "buy",
              160,
              107,
              98,
              49,
              143,
              53,
              73,
              107,
              52,
              75,
              56,
              null,
              "delivery"
            ],
            [
              "DFGR59NOHJDQ751TINTJK",
              "INF200K01OR6",
              "SBI Magnum Multicap Fund",
              "equity",
              true,
              true,
              50,
              1493769600000,
              400,
              "buy",
              160,
              9,
              60,
              101,
              40,
              146,
              3,
              23,
              125,
              139,
              82,
              null,
              "delivery"
            ],
            [
              "HNM88JKGKDQY9RRINGFB",
              "INF179KB1QR7",
              "ICICI LIQUID FUND - DIRECT PLAN",
              "equity",
              true,
              true,
              75,
              1729987200000,
              125,
              "buy",
              300,
              19,
              128,
              126,
              28,
              70,
              59,
              130,
              1,
              113,
              31,
              null,
              "intraday"
            ],
            [
              "HJM98MYGKDQY9RRINGFB",
              "INF179KB1QR8",
              "ICICI LIQUID FUND - DIRECT PLAN",
              "equity",
              true,
              true,
              75,
              1721664000000,
              150,
              "buy",
              300,
              61,
              16,
              25,
              121,
              50,
              103,
              148,
              33,
              75,
              7,
              null,
              "delivery"
            ],
            [
              "KGFCH72LKDQY9RRINTGH",
              "INE397D01024",
              "HDFC CREDIT RISK DEBT FUND - DIRECT PLAN",
              "debt",
              true,
              true,
              250,
              1714521600000,
              600,
              "sell",
              400,
              19,
              9,
              111,
              62,
              121,
              45,
              71,
              74,
              44,
              24,
              null,
              "intraday"
            ],
            [
              "KHF78MYGKDQY9RRINTGH",
              "INF251K01NO3",
              "BNP PARIBAS LIQUID FUND - DIRECT PLAN",
              "debt",
              true,
              true,
              31.536,
              1740787200000,
              5,
              "sell",
              340,
              134,
              111,
              2,
              96,
              29,
              36,
              128,
              104,
              94,
              101,
              null,
              "delivery"
            ],
            [
              "GHN78MYGKDQY9RRINTGH",
              "INF277K01YE6",
              "TATA LIQUID FUND - DIRECT PLAN",
              "debt",
              true,
              true,
              60,
              1725667200000,
              160,
              "sell",
              250,
              60,
              140,
              15,
              119,
              139,
              13,
              18,
              106,
              10,
              58,
              null,
              "delivery"
            ],
            [
              "GJK45MYGKDQY9RRINTGH",
              "INF278A06YE8",
              "Aditya Birla Sun Life Medium Term Direct Plan Growth",
              "debt",
              true,
              true,
              100,
              1713571200000,
              30,
              "sell",
              10,
              123,
              38,
              8,
              101,
              111,
              99,
              103,
              89,
              43,
              11,
              null,
              "delivery"
            ],
            [
              "BHM88MTYH6QY9RRINTGH",
              "INF200K01UT4",
              "SBI LIQUID FUND - DIRECT PLAN",
              "other",
              true,
              true,
              20,
              1731196800000,
              60,
              "sell",
              17,
              43,
              50,
              48,
              1,
              7,
              57,
              9,
              64,
              73,
              7,
              null,
              "intraday"
            ],
            [
              "BHMGP79GKDQY9RRINTGH",
              "INF200K01189",
              "SBI Gold Fund",
              "other",
              true,
              true,
              50,
              1735516800000,
              60,
              "sell",
              65,
              43,
              59,
              55,
              9,
              45,
              50,
              10,
              17,
              39,
              22,
              null,
              "delivery"
            ],
            [
              "CVH78MYGKDQY9RRINTGH",
              "INF109KB1GK2",
              "ICICI Prudential Commodity Fund",
              "other",
              true,
              true,
              100,
              1716681600000,
              200,
              "sell",
              200,
              72,
              24,
              22,
              18,
              57,
              14,
              17,
              54,
              32,
              50,
              null,
              "delivery"
            ],
            [
              "FGN89H72LKDQY9RRINTKL",
              "INF179KB1HP9",
              "HDFC LIQUID FUND - DIRECT PLAN",
              "equity",
              true,
              true,
              100,
              1715212800000,
              500,
              "sell",
              220,
              17,
              117,
              133,
              9,
              132,
              83,
              69,
              1,
              73,
              27,
              null,
              "intraday"
            ],
            [
              "GGFCHMYLKDQY9RRINTGH",
              "INF846K01DI2",
              "Axis Bluechip Fund",
              "equity",
              true,
              true,
              78,
              1713830400000,
              88,
              "sell",
              20,
              79,
              35,
              65,
              99,
              120,
              146,
              115,
              90,
              100,
              93,
              null,
              "delivery"
            ],
            [
              "PKF88MYGKDQY9RRINTGH",
              "INF179K01PT5",
              "HDFC Small Cap Fund",
              "equity",
              true,
              true,
              90,
              1736294400000,
              250,
              "sell",
              100,
              95,
              105,
              55,
              104,
              39,
              74,
              23,
              26,
              42,
              142,
              null,
              "delivery"
            ],
            [
              "GHNR59NOHJDQ901TINTLK",
              "INF200K01OR6",
              "SBI Magnum Multicap Fund",
              "equity",
              true,
              true,
              30,
              1721174400000,
              450,
              "sell",
              160,
              4,
              82,
              120,
              71,
              34,
              38,
              45,
              2,
              67,
              98,
              null,
              "delivery"
            ],
            [
              "HNT59NOGKDQY897TINF4R",
              "INF200K01OR6",
              "SBI Magnum Multicap Fund",
              "equity",
              true,
              true,
              80,
              1725926400000,
              500,
              "sell",
              160,
              36,
              36,
              69,
              74,
              139,
              57,
              75,
              81,
              118,
              149,
              null,
              "delivery"
            ],
            [
              "KNT59NOGKDQY897TINFTR",
              "INF200K01OR6",
              "SBI Magnum Multicap Fund",
              "equity",
              true,
              true,
              10,
              1722297600000,
              10,
              "sell",
              160,
              57,
              141,
              136,
              4,
              44,
              47,
              7,
              119,
              105,
              138,
              null,
              "delivery"
            ],
            [
              "HYT59NOGKDQY9YTINFGRN",
              "INF200K01OR6",
              "SBI Magnum Multicap Fund",
              "equity",
              true,
              true,
              10,
              1721520000000,
              50,
              "sell",
              160,
              84,
              38,
              123,
              61,
              19,
              8,
              58,
              18,
              145,
              85,
              null,
              "delivery"
            ],
            [
              "GJK48MYGKDQY9RRINGFB",
              "INF179KB1QR6",
              "ICICI LIQUID FUND - DIRECT PLAN",
              "equity",
              true,
              true,
              75,
              1729987200000,
              45,
              "sell",
              300,
              39,
              95,
              149,
              59,
              12,
              133,
              149,
              109,
              98,
              66,
              null,
              "intraday"
            ]
          ]
        }
      ]
    },
    {
      "name": "bond_sheet",
      "@entity": "sheet",
      "blocks": [
        {
          "name": "bond_tradebook_table",
          "@entity": "table",
          "header": [
            "trade_id",
            "isin",
            "security_name",
            "is_listed",
            "quantity",
            "date",
            "price",
            "transaction_type",
            "brokerage",
            "clearing_charges",
            "exchange_transaction_charges",
            "sebi_turnover_fees",
            "stamp_duty",
            "sgst",
            "cgst",
            "igst",
            "other_transfer_expenses",
            "label"
          ],
          "rows": [
            [
              "TGFCH72LKDQY9RRINTGH",
              "INE261F07032",
              "07.64% NABARD TFB 2031",
              true,
              500,
              1738694400000,
              10,
              "buy",
              31,
              50,
              13,
              3,
              115,
              100,
              109,
              56,
              8,
              null
            ],
            [
              "KGFCH72LKDQY9RRINTGH",
              "INE261F07032",
              "07.64% NABARD TFB 2031",
              true,
              500,
              1741113600000,
              10,
              "buy",
              121,
              112,
              21,
              98,
              33,
              113,
              104,
              98,
              61,
              null
            ],
            [
              "BVNCH72LKDQY9RRINTGH",
              "INE272F07011",
              "Blue Dart Express",
              true,
              50,
              1730832000000,
              20,
              "buy",
              35,
              112,
              55,
              9,
              13,
              41,
              75,
              37,
              5,
              null
            ],
            [
              "BNG57MYGKDQY9RRINTGH",
              "INE112J07020",
              "IFCI",
              true,
              200,
              1733414400000,
              16.55,
              "buy",
              78,
              26,
              27,
              16,
              60,
              45,
              87,
              118,
              84,
              null
            ],
            [
              "GJK45MYGKDQY9RRINTGH",
              "INE130K08000",
              "SBOX",
              false,
              200,
              1735574400000,
              16.55,
              "buy",
              60,
              16,
              109,
              81,
              80,
              114,
              63,
              119,
              84,
              null
            ],
            [
              "GHL909MYGKDQY9RRINTGH",
              "INE130K08001",
              "QCK",
              false,
              200,
              1633996800000,
              16.55,
              "buy",
              43,
              127,
              37,
              52,
              86,
              116,
              46,
              118,
              84,
              null
            ],
            [
              "BHMGP79GKDQY9RRINTGH",
              "INE130K08012",
              "GGL",
              true,
              200,
              1585008000000,
              550,
              "buy",
              87,
              21,
              50,
              5,
              71,
              37,
              22,
              81,
              106,
              null
            ],
            [
              "MJK88MYGKDQY9RRINTGH",
              "INE130K08019",
              "APPL",
              false,
              200,
              1633564800000,
              350,
              "buy",
              114,
              12,
              100,
              114,
              51,
              15,
              37,
              44,
              108,
              null
            ],
            [
              "GGFCHMYLKDQY9RRINTGH",
              "INE261F07055",
              "SGB",
              true,
              500,
              1437177600000,
              488,
              "buy",
              95,
              69,
              57,
              104,
              77,
              41,
              38,
              28,
              101,
              null
            ],
            [
              "GGFCHMYLKDQY9RRINTGH",
              "INE261F07055",
              "SGB",
              true,
              500,
              1626652800000,
              322,
              "buy",
              22,
              51,
              38,
              76,
              101,
              87,
              53,
              77,
              4,
              null
            ],
            [
              "JHF78MYGKDQY9RRINTGH",
              "INE261F07055",
              "SGB",
              true,
              100,
              1626739200000,
              350,
              "buy",
              11,
              26,
              86,
              34,
              107,
              43,
              1,
              101,
              6,
              null
            ],
            [
              "KHF78MYGKDQY9RRINTGH",
              "INE272F07011",
              "Blue Dart Express",
              true,
              20,
              1733788800000,
              200,
              "sell",
              108,
              4,
              102,
              57,
              11,
              105,
              16,
              56,
              86,
              null
            ],
            [
              "GHN78MYGKDQY9RRINTGH",
              "INE112J07020",
              "IFCI",
              true,
              170,
              1734998400000,
              500,
              "sell",
              71,
              109,
              99,
              30,
              11,
              126,
              102,
              18,
              24,
              null
            ],
            [
              "BHM88MYGKDQY9RRINTGH",
              "INE130K08000",
              "SBOX",
              false,
              170,
              1733875200000,
              500,
              "sell",
              78,
              99,
              8,
              16,
              9,
              102,
              63,
              100,
              31,
              null
            ],
            [
              "BHM88MTYH6QY9RRINTGH",
              "INE130K08001",
              "QCK",
              false,
              200,
              1721779200000,
              500,
              "sell",
              48,
              128,
              1,
              120,
              112,
              20,
              79,
              115,
              74,
              null
            ],
            [
              "BLKMN98HJNMDQY9RRINTGH",
              "INE130K08015",
              "GGL",
              true,
              200,
              1712448000000,
              600,
              "sell",
              37,
              85,
              53,
              113,
              102,
              42,
              48,
              31,
              15,
              null
            ],
            [
              "CVH78MYGKDQY9RRINTGH",
              "INE130K08019",
              "APPL",
              false,
              180,
              1734566400000,
              310,
              "sell",
              112,
              109,
              45,
              32,
              49,
              53,
              47,
              124,
              111,
              null
            ],
            [
              "GMFCH72LKDQY9RRINTGH",
              "INE261F07032",
              "07.64% NABARD TFB 2031",
              true,
              500,
              1728864000000,
              125,
              "sell",
              15,
              26,
              86,
              64,
              56,
              26,
              30,
              21,
              125,
              null
            ],
            [
              "GMFCH72LKDQY9RRINTGH",
              "INE261F07032",
              "07.64% NABARD TFB 2031",
              true,
              500,
              1729036800000,
              125,
              "sell",
              76,
              101,
              104,
              28,
              127,
              21,
              26,
              88,
              70,
              null
            ],
            [
              "JTR59NOGKDQY9YTINTGH",
              "INE261F07055",
              "SGB",
              true,
              550,
              1721520000000,
              350,
              "sell",
              107,
              97,
              94,
              49,
              49,
              9,
              112,
              69,
              129,
              null
            ],
            [
              "DFGR59NOHJDQ751TINTJK",
              "INE261F07055",
              "SGB",
              true,
              50,
              1728432000000,
              400,
              "sell",
              80,
              10,
              130,
              58,
              5,
              46,
              108,
              40,
              106,
              null
            ]
          ]
        }
      ]
    },
    {
      "name": "debenture_sheet",
      "@entity": "sheet",
      "blocks": [
        {
          "name": "debenture_tradebook_table",
          "@entity": "table",
          "header": [
            "trade_id",
            "isin",
            "security_name",
            "is_listed",
            "quantity",
            "date",
            "price",
            "transaction_type",
            "brokerage",
            "clearing_charges",
            "exchange_transaction_charges",
            "sebi_turnover_fees",
            "stamp_duty",
            "sgst",
            "cgst",
            "igst",
            "other_transfer_expenses",
            "label"
          ],
          "rows": [
            [
              "RJFWB5JYYDORFUEPK5DQ",
              "INE261F07032",
              "07.64% NABARD TFB 2031",
              true,
              1000,
              1525824000000,
              10,
              "buy",
              177,
              180,
              238,
              105,
              243,
              101,
              131,
              187,
              104,
              null
            ],
            [
              "DML3WXXE53PJOTGTEYKJ",
              "INE272F07011",
              "Blue Dart Express",
              true,
              50,
              1589414400000,
              20,
              "buy",
              61,
              48,
              59,
              117,
              236,
              125,
              232,
              240,
              106,
              null
            ],
            [
              "ULDR4PE639LOMU4A4VCE",
              "INE112J07020",
              "IFCI",
              true,
              200,
              1515456000000,
              16.55,
              "buy",
              74,
              176,
              232,
              177,
              230,
              53,
              210,
              110,
              125,
              null
            ],
            [
              "QOO5OYJLQBIRUMIGKCIQ",
              "INE130K08000",
              "SBOX",
              false,
              200,
              1493769600000,
              16.55,
              "buy",
              108,
              88,
              142,
              17,
              130,
              214,
              66,
              207,
              179,
              null
            ],
            [
              "PZUTEFRTRX9LFW9DPHAW",
              "INE130K08001",
              "QCK",
              false,
              200,
              1437177600000,
              16.55,
              "buy",
              133,
              242,
              225,
              166,
              45,
              232,
              127,
              64,
              210,
              null
            ],
            [
              "PGR2RDEZFVC2S3YBX1JF",
              "INE130K08012",
              "GGL",
              true,
              200,
              1626739200000,
              550,
              "buy",
              157,
              86,
              208,
              79,
              180,
              94,
              158,
              38,
              191,
              null
            ],
            [
              "DUYJ4ZV7OKJA8CV8U1MT",
              "INE130K08019",
              "APPL",
              false,
              200,
              1626912000000,
              350,
              "buy",
              215,
              228,
              8,
              98,
              119,
              44,
              185,
              50,
              154,
              null
            ],
            [
              "4AGDXGEEJOUHI6G8ATOU",
              "INE261F07055",
              "SGB",
              true,
              500,
              1556409600000,
              600,
              "buy",
              220,
              239,
              134,
              180,
              58,
              131,
              160,
              117,
              207,
              null
            ],
            [
              "AHVDFMGBCECY1IR0QDH9",
              "INE261F07055",
              "SGB",
              true,
              500,
              1556409600000,
              764,
              "buy",
              159,
              38,
              58,
              8,
              34,
              12,
              202,
              103,
              31,
              null
            ],
            [
              "Q2DZQ1ITYAOXILWQLHDN",
              "INE261F07055",
              "SGB",
              true,
              100,
              1491436800000,
              890,
              "buy",
              189,
              118,
              196,
              90,
              161,
              199,
              36,
              138,
              50,
              null
            ],
            [
              "Y6W9FLHOVJ8TCHHNBYGF",
              "INE261F07032",
              "07.64% NABARD TFB 2031",
              true,
              1000,
              1735516800000,
              10,
              "sell",
              224,
              48,
              219,
              210,
              51,
              234,
              197,
              66,
              220,
              null
            ],
            [
              "GYHVDLIIXVTLROOCLVYG",
              "INE272F07011",
              "Blue Dart Express",
              true,
              20,
              1713830400000,
              200,
              "sell",
              151,
              188,
              89,
              94,
              45,
              54,
              58,
              220,
              6,
              null
            ],
            [
              "VIHCPUEYSZUMQUVPSJ1P",
              "INE112J07020",
              "IFCI",
              true,
              170,
              1714262400000,
              500,
              "sell",
              129,
              82,
              120,
              187,
              110,
              174,
              71,
              160,
              42,
              null
            ],
            [
              "2BOMU4R5WMEONKEI5YT6",
              "INE130K08000",
              "SBOX",
              false,
              170,
              1721174400000,
              500,
              "sell",
              97,
              118,
              33,
              9,
              151,
              6,
              38,
              52,
              40,
              null
            ],
            [
              "DIQDEZH7K04QBDCJY0NV",
              "INE130K08001",
              "QCK",
              false,
              200,
              1721347200000,
              500,
              "sell",
              78,
              112,
              194,
              9,
              128,
              114,
              154,
              68,
              207,
              null
            ],
            [
              "TFCXQ3TKQRMOHU86MXO1",
              "INE130K08015",
              "GGL",
              true,
              200,
              1721520000000,
              600,
              "sell",
              103,
              56,
              160,
              203,
              240,
              171,
              239,
              71,
              42,
              null
            ],
            [
              "2GFSS7XTAHUWHFZH0NBR",
              "INE130K08019",
              "APPL",
              false,
              180,
              1721692800000,
              310,
              "sell",
              12,
              204,
              93,
              133,
              63,
              206,
              65,
              13,
              167,
              null
            ],
            [
              "FQQ96BPTGAPAQPLMABNU",
              "INE261F07055",
              "SGB",
              true,
              550,
              1733875200000,
              789,
              "sell",
              52,
              8,
              14,
              119,
              231,
              1,
              246,
              128,
              155,
              null
            ],
            [
              "RKW88OVAQVWZMCD9VLJL",
              "INE261F07055",
              "SGB",
              true,
              50,
              1728691200000,
              890,
              "sell",
              139,
              196,
              103,
              96,
              207,
              102,
              68,
              229,
              5,
              null
            ]
          ]
        }
      ]
    },
    {
      "name": "other_charges_sheet",
      "@entity": "sheet",
      "blocks": [
        {
          "name": "other_charges_summary_list",
          "@entity": "list",
          "items": [
            { "dp_charges": 100 },
            { "amc": 100 },
            { "call_trade_charges": 100 },
            { "buyback_application_charges": 100 },
            { "pledging_charges": 100 },
            { "auto_square_off_charge": 100 },
            { "delayed_payment_charge": 100 },
            { "account_opening_charge": 100 },
            { "interest_charge": 100 },
            { "margin_shortfall_penalty": 100 },
            { "any_other": 100 }
          ]
        }
      ]
    }
  ]
}

Tradewise PnL

View Workbook

👍

Click here to learn more about this JSON Payload

{
    "name": "tradewise_settlement_workbook",
    "@entity": "workbook",
    "sheets": [
        {
            "name": "stock_sheet",
            "@entity": "sheet",
            "blocks": [
                {
                    "name": "stock_tradewise_settlement_table",
                    "@entity": "table",
                    "header": [
                        "isin",
                        "symbol",
                        "is_listed",
                        "is_stt_paid",
                        "quantity",
                        "buy_trade_id",
                        "buy_date",
                        "buy_price",
                        "sell_trade_id",
                        "sell_date",
                        "sell_price",
                        "fmv",
                        "brokerage",
                        "clearing_charges",
                        "exchange_transaction_charges",
                        "sebi_turnover_fee",
                        "stt",
                        "stamp_duty",
                        "sgst",
                        "cgst",
                        "igst",
                        "other_transfer_expenses",
                        "nature_of_settlement",
                        "product_type"
                    ],
                    "rows": [
                        [
                            "INE002A01018",
                            "AJANTAPHARMA",
                            true,
                            true,
                            5,
                            "CJ1CLC4YCBFEZ4CVDNMH",
                            1463356800000,
                            136,
                            "CYX9TQSTWUYK8C9Z7BCE",
                            1733810043000,
                            580,
                            438,
                            64.0981,
                            64.0981,
                            64.0981,
                            64.0981,
                            64.0981,
                            64.0981,
                            64.0981,
                            64.0981,
                            64.0981,
                            64.0981,
                            "trade",
                            "delivery"
                        ],
                        [
                            "INE010B01019",
                            "CADILAHC",
                            true,
                            true,
                            1,
                            "VQLDME6IOJZR95BDEKQ9",
                            1730440443000,
                            1290.98,
                            "VXFUFI5Q9HH7FEJPLV3B",
                            1733032443000,
                            1301.78,
                            120,
                            91.2,
                            91.2,
                            91.2,
                            91.2,
                            91.2,
                            91.2,
                            91.2,
                            91.2,
                            91.2,
                            91.2,
                            "trade",
                            "delivery"
                        ],
                        [
                            "INE010B01020",
                            "TATA",
                            true,
                            true,
                            10,
                            "VQLDME6IOJZR95BDEKQ4",
                            1730440443000,
                            100,
                            "VXFUFI5Q9HH7FEJPLV3C",
                            1730440443000,
                            150,
                            125,
                            5,
                            40,
                            60,
                            80,
                            1,
                            20,
                            30,
                            4,
                            2,
                            1,
                            "trade",
                            "intraday"
                        ]
                    ]
                },
                {
                    "name": "stock_tradewise_transfer_table",
                    "@entity": "table",
                    "header": [
                        "isin",
                        "symbol",
                        "quantity",
                        "transfer_date",
                        "price",
                        "transfer_type",
                        "nature_of_transfer",
                        "transfer_value",
                        "transfer_expense"
                    ],
                    "rows": []
                },
                {
                    "name": "stock_tradewise_holding_table",
                    "@entity": "table",
                    "header": [
                        "isin",
                        "symbol",
                        "quantity",
                        "buy_date",
                        "buy_price",
                        "transaction_type",
                        "label",
                        "last_traded_price"
                    ],
                    "rows": [
                        [
                            "INE01C001018",
                            "ADANIPORTS",
                            48,
                            1631145600000,
                            270,
                            "buy",
                            null,
                            null
                        ]
                    ]
                },
                {
                    "name": "stock_tradewise_open_sell_table",
                    "@entity": "table",
                    "header": [
                        "isin",
                        "symbol",
                        "quantity",
                        "sell_date",
                        "sell_price",
                        "transaction_type",
                        "label",
                        "last_traded_price"
                    ],
                    "rows": [
                        [
                            "INE00E101023",
                            "BIKAJI",
                            260,
                            1693440000000,
                            370,
                            "sell",
                            null,
                            null
                        ]
                    ]
                }
            ]
        },
        {
            "name": "mutual_fund_sheet",
            "@entity": "sheet",
            "blocks": [
                {
                    "name": "mutual_fund_tradewise_settlement_table",
                    "@entity": "table",
                    "header": [
                        "isin",
                        "scheme_name",
                        "asset_class",
                        "is_listed",
                        "is_stt_paid",
                        "quantity",
                        "buy_trade_id",
                        "buy_date",
                        "buy_price",
                        "sell_trade_id",
                        "sell_date",
                        "sell_price",
                        "fmv",
                        "transfer_expenses",
                        "nature_of_settlement"
                    ],
                    "rows": [
                        [
                            "INF846K01DI2",
                            "Axis Bluechip Fund",
                            "equity",
                            true,
                            true,
                            355.9,
                            "GGFCHMYLKDQY9RRINTGH",
                            1491436800000,
                            124.2586,
                            "JHF78MYGKDQY9RRINTGH",
                            1733810043000,
                            212.7,
                            20,
                            68.1534,
                            "trade"
                        ],
                        [
                            "INF846K01DI3",
                            "HDFC",
                            "debt",
                            true,
                            true,
                            4,
                            "GGFCHMYLKDQY9RRINTGA",
                            1730440443000,
                            40,
                            "JHF78MYGKDQY9RRINTGQ",
                            1733032443000,
                            20,
                            20,
                            50,
                            "trade"
                        ]
                    ]
                },
                {
                    "name": "mutual_fund_tradewise_transfer_table",
                    "@entity": "table",
                    "header": [
                        "isin",
                        "scheme_name",
                        "asset_class",
                        "quantity",
                        "transfer_date",
                        "price",
                        "transfer_type",
                        "nature_of_transfer",
                        "transfer_value",
                        "transfer_expense"
                    ],
                    "rows": []
                },
                {
                    "name": "mutual_fund_tradewise_holding_table",
                    "@entity": "table",
                    "header": [
                        "isin",
                        "scheme_name",
                        "asset_class",
                        "quantity",
                        "buy_date",
                        "buy_price",
                        "transaction_type",
                        "label",
                        "last_traded_price"
                    ],
                    "rows": [
                        [
                            "INF846K01DI2",
                            "Axis Bluechip Fund",
                            "equity",
                            50,
                            1491436800000,
                            124.2586,
                            "buy",
                            null,
                            null
                        ]
                    ]
                },
                {
                    "name": "mutual_fund_tradewise_open_sell_table",
                    "@entity": "table",
                    "header": [
                        "isin",
                        "scheme_name",
                        "asset_class",
                        "quantity",
                        "sell_date",
                        "sell_price",
                        "transaction_type",
                        "label",
                        "last_traded_price"
                    ],
                    "rows": [
                        [
                            "INF277K01YE6",
                            "TATA LIQUID FUND - DIRECT PLAN",
                            "debt",
                            17.137,
                            1682640000000,
                            160,
                            "sell",
                            null,
                            null
                        ]
                    ]
                }
            ]
        },
        {
            "name": "etf_sheet",
            "@entity": "sheet",
            "blocks": [
                {
                    "name": "etf_tradewise_settlement_table",
                    "@entity": "table",
                    "header": [
                        "isin",
                        "scheme_name",
                        "asset_class",
                        "is_listed",
                        "is_stt_paid",
                        "quantity",
                        "buy_trade_id",
                        "buy_date",
                        "buy_price",
                        "sell_trade_id",
                        "sell_date",
                        "sell_price",
                        "fmv",
                        "brokerage",
                        "clearing_charges",
                        "exchange_transaction_charges",
                        "sebi_turnover_fee",
                        "stt",
                        "stamp_duty",
                        "sgst",
                        "cgst",
                        "igst",
                        "other_transfer_expenses",
                        "nature_of_settlement",
                        "product_type"
                    ],
                    "rows": [
                        [
                            "INF179KB1QR6",
                            "ICICI LIQUID FUND - DIRECT PLAN",
                            "equity",
                            true,
                            true,
                            75,
                            "HNM88JKGKDQY9RRINGFB",
                            1491436800000,
                            124.2586,
                            "JHF78MYGKDQY9RRINTGH",
                            1733810043000,
                            45,
                            300,
                            58,
                            223,
                            275,
                            87,
                            82,
                            192,
                            279,
                            110,
                            211,
                            97,
                            "trade",
                            "delivery"
                        ],
                        [
                            "INF179KB1QR7",
                            "ABML",
                            "debt",
                            true,
                            true,
                            1,
                            "HNM88JKGKDQY9RRINGFL",
                            1730440443000,
                            40,
                            "JHF78MYGKDQY9RRINTGQ",
                            1733032443000,
                            45,
                            300,
                            58,
                            223,
                            275,
                            87,
                            82,
                            192,
                            279,
                            110,
                            211,
                            97,
                            "trade",
                            "delivery"
                        ]
                    ]
                },
                {
                    "name": "etf_tradewise_transfer_table",
                    "@entity": "table",
                    "header": [
                        "isin",
                        "scheme_name",
                        "asset_class",
                        "quantity",
                        "transfer_date",
                        "price",
                        "transfer_type",
                        "nature_of_transfer",
                        "transfer_value",
                        "transfer_expense"
                    ],
                    "rows": []
                },
                {
                    "name": "etf_tradewise_holding_table",
                    "@entity": "table",
                    "header": [
                        "isin",
                        "scheme_name",
                        "asset_class",
                        "quantity",
                        "buy_date",
                        "buy_price",
                        "transaction_type",
                        "label",
                        "last_traded_price"
                    ],
                    "rows": [
                        [
                            "INF179KB1QR8",
                            "ICICI LIQUID FUND - DIRECT PLAN",
                            "equity",
                            75,
                            1658620800000,
                            150,
                            "buy",
                            null,
                            null
                        ]
                    ]
                },
                {
                    "name": "etf_tradewise_open_sell_table",
                    "@entity": "table",
                    "header": [
                        "isin",
                        "scheme_name",
                        "asset_class",
                        "quantity",
                        "sell_date",
                        "sell_price",
                        "transaction_type",
                        "label",
                        "last_traded_price"
                    ],
                    "rows": [
                        [
                            "INF179KB1QR9",
                            "Parag parikh",
                            "equity",
                            50,
                            1658620800000,
                            150,
                            "sell",
                            null,
                            null
                        ]
                    ]
                }
            ]
        },
        {
            "name": "future_sheet",
            "@entity": "sheet",
            "blocks": [
                {
                    "name": "future_tradewise_settlement_table",
                    "@entity": "table",
                    "header": [
                        "isin",
                        "contract_name",
                        "asset_class",
                        "quantity",
                        "buy_trade_id",
                        "buy_date",
                        "buy_price",
                        "sell_trade_id",
                        "sell_date",
                        "sell_price",
                        "brokerage",
                        "clearing_charges",
                        "exchange_transaction_charges",
                        "sebi_turnover_fee",
                        "stt",
                        "stamp_duty",
                        "sgst",
                        "cgst",
                        "igst",
                        "other_transfer_expenses",
                        "nature_of_settlement"
                    ],
                    "rows": [
                        [
                            null,
                            "NIFTY 15 JAN 2023 FUT",
                            "equity",
                            25,
                            "Z0FCJBWODSL8GF3KKVPY",
                            1673481600000,
                            168,
                            "VLNYY0FTJTUGELL1TK8D",
                            1733810043000,
                            146,
                            107.7,
                            60.3,
                            3.8,
                            136.4,
                            221.4,
                            427.6,
                            12.2,
                            13.1,
                            58.5,
                            44.7,
                            "trade"
                        ],
                        [
                            null,
                            "NIFTY 15 JAN 2023 FUT",
                            "commodity",
                            75,
                            "Z0FCJBWODSL8GF3KKVPY",
                            1673481600000,
                            168,
                            "VLNYY0FTJTUGELL1TK8D",
                            1733032443000,
                            158,
                            62.1,
                            126.9,
                            30.4,
                            169.2,
                            96.2,
                            155.8,
                            53.6,
                            181.3,
                            144.5,
                            8.1,
                            "trade"
                        ]
                    ]
                },
                {
                    "name": "future_tradewise_open_position_table",
                    "@entity": "table",
                    "header": [
                        "isin",
                        "contract_name",
                        "asset_class",
                        "quantity",
                        "trade_date",
                        "trade_price",
                        "transaction_type",
                        "label",
                        "last_traded_price"
                    ],
                    "rows": [
                        [
                            null,
                            "FUTCUR JPYINR 24 AUG 2023",
                            "currency",
                            10,
                            1690848000000,
                            345.89,
                            "sell",
                            null,
                            null
                        ],
                        [
                            null,
                            "NIFTY 17 APR 2023 FUT",
                            "equity",
                            10,
                            1679616000000,
                            457.89,
                            "buy",
                            null,
                            null
                        ]
                    ]
                }
            ]
        },
        {
            "name": "option_sheet",
            "@entity": "sheet",
            "blocks": [
                {
                    "name": "option_tradewise_settlement_table",
                    "@entity": "table",
                    "header": [
                        "isin",
                        "contract_name",
                        "asset_class",
                        "quantity",
                        "buy_trade_id",
                        "buy_date",
                        "buy_price",
                        "sell_trade_id",
                        "sell_date",
                        "sell_price",
                        "brokerage",
                        "clearing_charges",
                        "exchange_transaction_charges",
                        "sebi_turnover_fee",
                        "stt",
                        "stamp_duty",
                        "sgst",
                        "cgst",
                        "igst",
                        "other_transfer_expenses",
                        "nature_of_settlement"
                    ],
                    "rows": [
                        [
                            null,
                            "NIFTY 23 JAN 2023 CE 15000",
                            "equity",
                            25,
                            "ULDR4PE639LOMU4A4VCE",
                            1670457600000,
                            1570,
                            "0B3PIU4WMIPKUQEG34BO",
                            1733810043000,
                            1460,
                            1206.3333,
                            2859.6667,
                            2816.6667,
                            1138,
                            442.6667,
                            2843.3333,
                            1416.6667,
                            3065.3333,
                            1862.6667,
                            728.6667,
                            "trade"
                        ],
                        [
                            null,
                            "OPTFUT SILVERM 21 Nov 2022 58000 PE",
                            "commodity",
                            70,
                            "Q5CUBQ2P6B7VKNHCKWD6",
                            1665446400000,
                            139.3077,
                            "DTXGC9I0ZVOI2FFSHIOL",
                            1733032443000,
                            148,
                            305.8462,
                            115.6923,
                            88,
                            140.6154,
                            114.6923,
                            140.6154,
                            185.9231,
                            186.3846,
                            139.1538,
                            165.5385,
                            "trade"
                        ]
                    ]
                },
                {
                    "name": "option_tradewise_open_position_table",
                    "@entity": "table",
                    "header": [
                        "isin",
                        "contract_name",
                        "asset_class",
                        "quantity",
                        "trade_date",
                        "trade_price",
                        "transaction_type",
                        "label",
                        "last_traded_price"
                    ],
                    "rows": [
                        [
                            null,
                            "OPTFUT SILVERM 21 Nov 2022 58000 PE",
                            "commodity",
                            20,
                            1668902400000,
                            156,
                            "sell",
                            null,
                            null
                        ],
                        [
                            null,
                            "FINNIFTY 25 MAY 2023 CE 14900",
                            "equity",
                            10,
                            1682726400000,
                            698.03,
                            "buy",
                            null,
                            null
                        ]
                    ]
                }
            ]
        },
        {
            "name": "bond_sheet",
            "@entity": "sheet",
            "blocks": [
                {
                    "name": "bond_tradewise_settlement_table",
                    "@entity": "table",
                    "header": [
                        "isin",
                        "security_name",
                        "is_listed",
                        "quantity",
                        "buy_trade_id",
                        "buy_date",
                        "buy_price",
                        "sell_trade_id",
                        "sell_date",
                        "sell_price",
                        "brokerage",
                        "clearing_charges",
                        "exchange_transaction_charges",
                        "sebi_turnover_fee",
                        "stamp_duty",
                        "sgst",
                        "cgst",
                        "igst",
                        "other_transfer_expenses",
                        "nature_of_settlement"
                    ],
                    "rows": [
                        [
                            "INE261F07055",
                            "SGB",
                            true,
                            500,
                            "GGFCHMYLKDQY9RRINTGH",
                            1437177600000,
                            488,
                            "JTR59NOGKDQY9YTINTGH",
                            1733810043000,
                            490,
                            192.2727,
                            157.1818,
                            142.4545,
                            148.5455,
                            121.5455,
                            49.1818,
                            139.8182,
                            90.7273,
                            218.2727,
                            "trade"
                        ]
                    ]
                },
                {
                    "name": "bond_tradewise_transfer_table",
                    "@entity": "table",
                    "header": [
                        "isin",
                        "security_name",
                        "quantity",
                        "transfer_date",
                        "price",
                        "transfer_type",
                        "nature_of_transfer",
                        "transfer_value",
                        "transfer_expense"
                    ],
                    "rows": []
                },
                {
                    "name": "bond_tradewise_holding_table",
                    "@entity": "table",
                    "header": [
                        "isin",
                        "security_name",
                        "quantity",
                        "buy_date",
                        "buy_price",
                        "transaction_type",
                        "label",
                        "last_traded_price"
                    ],
                    "rows": [
                        [
                            "INE261F07055",
                            "SGB",
                            400,
                            322,
                            null,
                            "buy",
                            null,
                            null
                        ]
                    ]
                },
                {
                    "name": "bond_tradewise_open_sell_table",
                    "@entity": "table",
                    "header": [
                        "isin",
                        "security_name",
                        "quantity",
                        "sell_date",
                        "sell_price",
                        "transaction_type",
                        "label",
                        "last_traded_price"
                    ],
                    "rows": []
                }
            ]
        },
        {
            "name": "debenture_sheet",
            "@entity": "sheet",
            "blocks": [
                {
                    "name": "debenture_tradewise_settlement_table",
                    "@entity": "table",
                    "header": [
                        "isin",
                        "security_name",
                        "is_listed",
                        "quantity",
                        "buy_trade_id",
                        "buy_date",
                        "buy_price",
                        "sell_trade_id",
                        "sell_date",
                        "sell_price",
                        "brokerage",
                        "clearing_charges",
                        "exchange_transaction_charges",
                        "sebi_turnover_fee",
                        "stamp_duty",
                        "sgst",
                        "cgst",
                        "igst",
                        "other_transfer_expenses",
                        "nature_of_settlement"
                    ],
                    "rows": [
                        [
                            "INE261F07032",
                            "07.64% NABARD TFB 2031",
                            true,
                            1000,
                            "RJFWB5JYYDORFUEPK5DQ",
                            1437177600000,
                            10,
                            "Y6W9FLHOVJ8TCHHNBYGF",
                            1733810043000,
                            10,
                            401,
                            228,
                            457,
                            315,
                            294,
                            335,
                            328,
                            253,
                            324,
                            "trade"
                        ]
                    ]
                },
                {
                    "name": "debenture_tradewise_transfer_table",
                    "@entity": "table",
                    "header": [
                        "isin",
                        "security_name",
                        "quantity",
                        "transfer_date",
                        "price",
                        "transfer_type",
                        "nature_of_transfer",
                        "transfer_value",
                        "transfer_expense"
                    ],
                    "rows": []
                },
                {
                    "name": "debenture_tradewise_holding_table",
                    "@entity": "table",
                    "header": [
                        "isin",
                        "security_name",
                        "quantity",
                        "buy_date",
                        "buy_price",
                        "transaction_type",
                        "label",
                        "last_traded_price"
                    ],
                    "rows": [
                        [
                            "INE112J07020",
                            "IFCI",
                            30,
                            1515456000000,
                            16.55,
                            "buy",
                            null,
                            null
                        ]
                    ]
                },
                {
                    "name": "debenture_tradewise_open_sell_table",
                    "@entity": "table",
                    "header": [
                        "isin",
                        "security_name",
                        "quantity",
                        "sell_date",
                        "sell_price",
                        "transaction_type",
                        "label",
                        "last_traded_price"
                    ],
                    "rows": []
                }
            ]
        }
    ]
}

Scripwise PnL

View Workbook

👍

Click here to learn more about this JSON Payload

{
    "@entity": "workbook",
    "name": "tradebook_workbook",
    "sheets": [
        {
            "name": "stock_tradebook_sheet",
            "@entity": "sheet",
            "blocks": [
                {
                    "name": "stock_tradebook_table",
                    "@entity": "table",
                    "header": ["trade_id", "isin", "symbol", "is_listed", "is_stt_paid", "quantity", "date", "price", "transaction_type", "fmv", "brokerage", "clearing_charges", "exchange_transaction_charges", "sebi_turnover_fees", "stt", "stamp_duty", "sgst", "cgst", "igst", "other_transfer_expenses", "label", "product_type"],
                    "rows": [
                        ["KZUG2ZMGMH4WFE2C9RMG", "INE03Q201024", "GLS", true, true, 50, 1499644800000, 5000, "buy", 5500, 21.5, 22.6, 23.5, 58, 67, 21.5, 21.5, 21.5, 21.5, 21.5, null, "delivery "],
                        ["ZVQAT2PZ1RSLYWWYZTXP", "INE767A01016", "ADANIENT", true, true, 57, 1658016000000, 1950, "buy", 1260, 45.6, 45.6, 45.6, 45.6, 45.6, 45.6, 45.6, 45.6, 45.6, 45.6, null, "delivery"],
                        ["VTHPFZ7KXVG5LMNZNBHT", "INE00E101023", "BIKAJI", true, true, 1540, 1592611200000, 189, "buy", 0, 45.6, 45.6, 45.6, 45.6, 45.6, 45.6, 45.6, 45.6, 45.6, 45.6, null, "delivery"],
                        ["SUNMAQYIBRDSM4Y2TVW9", "INE462A01022", "BAYERCROP", true, true, 25, 1436313600000, 4203.45, "buy", 4199.55, 45.6, 45.6, 45.6, 45.6, 45.6, 45.6, 45.6, 45.6, 45.6, 45.6, null, "delivery"],
                        ["CJ1CLC4YCBFEZ4CVDNMH", "INE002A01018", "AJANTAPHARMA", true, true, 1590, 1463356800000, 136, "buy", 438, 45.6, 45.6, 45.6, 45.6, 45.6, 45.6, 45.6, 45.6, 45.6, 45.6, null, "delivery"],
                        ["PEB6U5ERJBDTNFSLPOI2", "INE462A01022", "BAYERCROP", true, true, 37, 1482451200000, 4089, "buy", 4199.55, 45.6, 45.6, 45.6, 45.6, 45.6, 45.6, 45.6, 45.6, 45.6, 45.6, null, "delivery"],
                        ["8BARHLFV3FZVGYTSJ012", "INE03Q201024", "GLS", true, true, 50, 1689811200000, 5000, "sell", 5500, 45.6, 45.6, 45.6, 45.6, 45.6, 45.6, 45.6, 45.6, 45.6, 45.6, null, "delivery"],
                        ["CYX9TQSTWUYK8C9Z7BCE", "INE002A01018", "AJANTAPHARMA", true, true, 645, 1650412800000, 580, "sell", 438, 45.6, 45.6, 45.6, 45.6, 45.6, 45.6, 45.6, 45.6, 45.6, 45.6, null, "delivery"],
                        ["VQLDME6IOJZR95BDEKQ9", "INE010B01019", "CADILAHC", true, false, 254, 1692316800000, 1290.98, "buy", 120, 45.6, 45.6, 45.6, 45.6, 45.6, 45.6, 45.6, 45.6, 45.6, 45.6, null, "intraday"],
                        ["YKSLVQ6HJEUROPF8Z7TL", "INE00E101023", "BIKAJI", true, true, 435, 1602547200000, 209, "buy", 0, 45.6, 45.6, 45.6, 45.6, 45.6, 45.6, 45.6, 45.6, 45.6, 45.6, null, "delivery"],
                        ["VXFUFI5Q9HH7FEJPLV3B", "INE010B01019", "CADILAHC", true, true, 254, 1692403200000, 1301.78, "sell", 120, 45.6, 45.6, 45.6, 45.6, 45.6, 45.6, 45.6, 45.6, 45.6, 45.6, null, "intraday"],
                        ["JOVR7LN5HKWR3H7LR3LK", "INE364U01010", "ADANIGREEN", true, true, 15, 1680652800000, 250, "sell", 127, 45.6, 45.6, 45.6, 45.6, 45.6, 45.6, 45.6, 45.6, 45.6, 45.6, null, "intraday"],
                        ["KQN4SO7YRL1T1YKS8XSO", "INE01C001018", "ADANIPORTS", true, true, 348, 1631145600000, 270, "buy", 137, 45.6, 45.6, 45.6, 45.6, 45.6, 45.6, 45.6, 45.6, 45.6, 45.6, null, "delivery"],
                        ["OUYO53NES6HVEGSBXALX", "INE364U01010", "ADANIGREEN", true, false, 15, 1680652800000, 281, "buy", 127, 45.6, 45.6, 45.6, 45.6, 45.6, 45.6, 45.6, 45.6, 45.6, 45.6, null, "intraday"],
                        ["K0TMWRLU5HDBSNDITGWA", "INE01C001018", "ADANIPORTS", true, true, 256, 1682640000000, 409, "sell", 137, 45.6, 45.6, 45.6, 45.6, 45.6, 45.6, 45.6, 45.6, 45.6, 45.6, null, "delivery"],
                        ["NJK6VY186PT29EQOL5ZS", "INE767A01016", "ADANIENT", true, true, 60, 1695340800000, 2300, "sell", 1260, 45.6, 45.6, 45.6, 45.6, 45.6, 45.6, 45.6, 45.6, 45.6, 45.6, null, "delivery"],
                        ["YYUFIXODHUCNJPZL0TB1", "INE767A01016", "ADANIENT", true, true, 23, 1681948800000, 2016, "buy", 1260, 45.6, 45.6, 45.6, 45.6, 45.6, 45.6, 45.6, 45.6, 45.6, 45.6, null, "delivery"],
                        ["DPB5UCBWCTWCCZQZAECT", "INE767A01016", "ADANIENT", true, true, 20, 1695772800000, 2456, "sell", 1260, 45.6, 45.6, 45.6, 45.6, 45.6, 45.6, 45.6, 45.6, 45.6, 45.6, null, "delivery"],
                        ["ZDUUQFIZKFI1LPZJIGC1", "INE364U01010", "ADANIGREEN", true, true, 47, 1683763200000, 310, "buy", 127, 45.6, 45.6, 45.6, 45.6, 45.6, 45.6, 45.6, 45.6, 45.6, 45.6, null, "delivery"],
                        ["OCFAGNA9WLZOS2GPVEWY", "INE364U01010", "ADANIGREEN", true, true, 40, 1685059200000, 365, "sell", 127, 45.6, 45.6, 45.6, 45.6, 45.6, 45.6, 45.6, 45.6, 45.6, 45.6, null, "delivery"],
                        ["JOQYLFGNAJXEBBANLTJ9", "INE364U01010", "ADANIGREEN", true, true, 20, 1689206400000, 290, "buy", 127, 45.6, 45.6, 45.6, 45.6, 45.6, 45.6, 45.6, 45.6, 45.6, 45.6, null, "delivery"],
                        ["USTNCKBL23ZGYFBS1FWW", "INE01C001018", "ADANIPORTS", true, true, 44, 1682899200000, 418, "sell", 137, 45.6, 45.6, 45.6, 45.6, 45.6, 45.6, 45.6, 45.6, 45.6, 45.6, null, "delivery"],
                        ["AMLDHHSPBR225CYDH1G3", "INE01C001018", "ADANIPORTS", true, true, 20, 1689552000000, 436, "sell", 137, 45.6, 45.6, 45.6, 45.6, 45.6, 45.6, 45.6, 45.6, 45.6, 45.6, null, "intraday"],
                        ["RZ4TQQXBXGQZ4CIGW89W", "INE01C001018", "ADANIPORTS", true, false, 30, 1689638400000, 410, "buy", 137, 45.6, 45.6, 45.6, 45.6, 45.6, 45.6, 45.6, 45.6, 45.6, 45.6, null, "intraday"],
                        ["ABHV4GJO8FEWYZYYZXJ9", "INE01C001018", "ADANIPORTS", true, true, 20, 1692144000000, 429, "buy", 137, 45.6, 45.6, 45.6, 45.6, 45.6, 45.6, 45.6, 45.6, 45.6, 45.6, null, "delivery"],
                        ["G4FILRR9JSAWETX5BFEG", "INE01C001018", "ADANIPORTS", true, true, 58, 1695945600000, 447, "sell", 137, 45.6, 45.6, 45.6, 45.6, 45.6, 45.6, 45.6, 45.6, 45.6, 45.6, null, "delivery"],
                        ["3S1E2CVMTK3I115OG5IT", "INE002A01018", "AJANTAPHARMA", true, true, 900, 1672876800000, 618, "sell", 438, 45.6, 45.6, 45.6, 45.6, 45.6, 45.6, 45.6, 45.6, 45.6, 45.6, null, "delivery"],
                        ["J9SYLEPLST8YFGPUOFCG", "INE002A01018", "AJANTAPHARMA", true, true, 145, 1686182400000, 578, "buy", 438, 45.6, 45.6, 45.6, 45.6, 45.6, 45.6, 45.6, 45.6, 45.6, 45.6, null, "delivery"],
                        ["HJWC2DJPNJV7KBYAVLMP", "INE002A01018", "AJANTAPHARMA", true, true, 190, 1692921600000, 689, "sell", 438, 45.6, 45.6, 45.6, 45.6, 45.6, 45.6, 45.6, 45.6, 45.6, 45.6, null, "delivery"],
                        ["8LWK9OAGZ64HKNYHYX6H", "INE462A01022", "BAYERCROP", true, true, 31, 1681862400000, 4217.67, "sell", 4199.55, 45.6, 45.6, 45.6, 45.6, 45.6, 45.6, 45.6, 45.6, 45.6, 45.6, null, "delivery"],
                        ["ZR0GPABQCZJDEBAVL85E", "INE462A01022", "BAYERCROP", true, true, 29, 1682726400000, 4198.05, "buy", 4199.55, 45.6, 45.6, 45.6, 45.6, 45.6, 45.6, 45.6, 45.6, 45.6, 45.6, null, "delivery"],
                        ["ROJM9PXLTVRGADTWZXMX", "INE462A01022", "BAYERCROP", true, true, 10, 1684454400000, 4228, "sell", 4199.55, 45.6, 45.6, 45.6, 45.6, 45.6, 45.6, 45.6, 45.6, 45.6, 45.6, null, "delivery"],
                        ["ROJM9PXLTVRGADTWZXMX", "INE462A01022", "BAYERCROP", true, true, 9, 1684454400000, 4249, "sell", 4199.55, 45.6, 45.6, 45.6, 45.6, 45.6, 45.6, 45.6, 45.6, 45.6, 45.6, null, "delivery"],
                        ["RP9WLFA5LS29NBTKARXN", "INE462A01022", "BAYERCROP", true, false, 25, 1686960000000, 4254, "buy", 4199.55, 45.6, 45.6, 45.6, 45.6, 45.6, 45.6, 45.6, 45.6, 45.6, 45.6, null, "intraday"],
                        ["UCB2JO0JMYBFRYRHILMZ", "INE462A01022", "BAYERCROP", true, true, 25, 1686960000000, 4239, "sell", 4199.55, 45.6, 45.6, 45.6, 45.6, 45.6, 45.6, 45.6, 45.6, 45.6, 45.6, null, "intraday"],
                        ["G3NSSV7XHVFUJ8BTPBIR", "INE462A01022", "BAYERCROP", true, true, 29, 1689120000000, 4221, "buy", 4199.55, 45.6, 45.6, 45.6, 45.6, 45.6, 45.6, 45.6, 45.6, 45.6, 45.6, null, "delivery"],
                        ["1JQ2PDASHYXZCVH6IFTC", "INE462A01022", "BAYERCROP", true, true, 70, 1693440000000, 4278.08, "sell", 4199.55, 45.6, 45.6, 45.6, 45.6, 45.6, 45.6, 45.6, 45.6, 45.6, 45.6, null, "delivery"],
                        ["XAOZHKSKJV0S5IENATLG", "INE462A01022", "BAYERCROP", true, false, 28, 1695859200000, 4289, "buy", 4199.55, 45.6, 45.6, 45.6, 45.6, 45.6, 45.6, 45.6, 45.6, 45.6, 45.6, null, "intraday"],
                        ["AU2VBOKJGOGV82FMOSZL", "INE462A01022", "BAYERCROP", true, true, 28, 1695945600000, 4298, "sell", 4199.55, 45.6, 45.6, 45.6, 45.6, 45.6, 45.6, 45.6, 45.6, 45.6, 45.6, null, "intraday"],
                        ["XEPL8VAO3PWPBVZRBSCE", "INE00E101023", "BIKAJI", true, true, 200, 1631923200000, 221, "buy", 0, 45.6, 45.6, 45.6, 45.6, 45.6, 45.6, 45.6, 45.6, 45.6, 45.6, null, "delivery"],
                        ["XEPL8VAO3PWPBVZRBSCE", "INE00E101023", "BIKAJI", true, true, 85, 1632009600000, 225, "buy", 0, 45.6, 45.6, 45.6, 45.6, 45.6, 45.6, 45.6, 45.6, 45.6, 45.6, null, "delivery"],
                        ["IAVLRAW3OKLIHPD0DLKQ", "INE00E101023", "BIKAJI", true, true, 640, 1677283200000, 265, "sell", 0, 45.6, 45.6, 45.6, 45.6, 45.6, 45.6, 45.6, 45.6, 45.6, 45.6, null, "delivery"],
                        ["YHEZMWYMV85DIO52CY1B", "INE00E101023", "BIKAJI", true, true, 110, 1676332800000, 257, "sell", 0, 45.6, 45.6, 45.6, 45.6, 45.6, 45.6, 45.6, 45.6, 45.6, 45.6, null, "delivery"],
                        ["90VSCSRGLVSHW6FYHQDE", "INE00E101023", "BIKAJI", true, false, 85, 1678665600000, 269, "buy", 0, 45.6, 45.6, 45.6, 45.6, 45.6, 45.6, 45.6, 45.6, 45.6, 45.6, null, "intraday"],
                        ["DLQMNK7WJJEH6SZOCZO6", "INE00E101023", "BIKAJI", true, true, 85, 1678665600000, 273, "sell", 0, 45.6, 45.6, 45.6, 45.6, 45.6, 45.6, 45.6, 45.6, 45.6, 45.6, null, "intraday"],
                        ["7UBKDTDSUWJEWXI71MB5", "INE00E101023", "BIKAJI", true, true, 250, 1682640000000, 317, "sell", 0, 45.6, 45.6, 45.6, 45.6, 45.6, 45.6, 45.6, 45.6, 45.6, 45.6, null, "delivery"],
                        ["SVYLOESSMFAWL2P1V4YN", "INE00E101023", "BIKAJI", true, true, 260, 1684454400000, 334, "sell", 0, 45.6, 45.6, 45.6, 45.6, 45.6, 45.6, 45.6, 45.6, 45.6, 45.6, null, "delivery"],
                        ["KZ4XUMQL7O4OL1T0NWLW", "INE00E101023", "BIKAJI", true, true, 140, 1686787200000, 327, "buy", 0, 45.6, 45.6, 45.6, 45.6, 45.6, 45.6, 45.6, 45.6, 45.6, 45.6, null, "delivery"],
                        ["KZ4XUMQL7O4OL1T0NWLW", "INE00E101023", "BIKAJI", true, false, 267, 1686873600000, 329, "buy", 0, 45.6, 45.6, 45.6, 45.6, 45.6, 45.6, 45.6, 45.6, 45.6, 45.6, null, "intraday"],
                        ["UZB55NEDOEZEB81QTBOI", "INE00E101023", "BIKAJI", true, true, 267, 1686960000000, 321, "sell", 0, 45.6, 45.6, 45.6, 45.6, 45.6, 45.6, 45.6, 45.6, 45.6, 45.6, null, "intraday"],
                        ["T2D14C472FNCQD8A9SEL", "INE00E101023", "BIKAJI", true, true, 730, 1689897600000, 339, "sell", 0, 45.6, 45.6, 45.6, 45.6, 45.6, 45.6, 45.6, 45.6, 45.6, 45.6, null, "delivery"],
                        ["IHQR3WDABXX5LWECAVD4", "INE00E101023", "BIKAJI", true, true, 349, 1690675200000, 345, "sell", 0, 45.6, 45.6, 45.6, 45.6, 45.6, 45.6, 45.6, 45.6, 45.6, 45.6, null, "delivery"],
                        ["ZJZZOQLJZWYQRMSHK2E3", "INE00E101023", "BIKAJI", true, true, 321, 1693440000000, 370, "sell", 0, 45.6, 45.6, 45.6, 45.6, 45.6, 45.6, 45.6, 45.6, 45.6, 45.6, null, "delivery"]
                    ]
                }
            ]
        },
        {
            "name": "option_tradebook_sheet",
            "@entity": "sheet",
            "blocks": [
                {
                    "name": "option_tradebook_table",
                    "@entity": "table",
                    "header": ["trade_id", "isin", "contract_name", "asset_class", "quantity", "date", "price", "transaction_type", "brokerage", "clearing_charges", "exchange_transaction_charges", "sebi_turnover_fees", "stt", "stamp_duty", "sgst", "cgst", "igst", "other_transfer_expenses", "label"],
                    "rows": [
                        ["RJFWB5JYYDORFUEPK5DQ", "INE619I01012", "BANKNIFTY 01 Jun 2023 CE 44100", "equity", 25, 1680739200000, 363.1, "buy", 385, 201, 2235, 795, 1757, 202, 195, 2060, 2112, 1622, null],
                        ["Y6W9FLHOVJ8TCHHNBYGF", "INE545C01013", "BANKNIFTY 01 Jun 2023 CE 44200", "equity", 75, 1683158400000, 363.15, "buy", 2479, 304, 1657, 2282, 1170, 172, 1307, 1660, 1130, 1106, null],
                        ["DML3WXXE53PJOTGTEYKJ", "INE512D09106", "OPTFUT CRUDEOIL 16 OCT 2022 7000 PE", "commodity", 100, 1662940800000, 415, "buy", 107, 8, 114, 111, 90, 43, 36, 48, 119, 21, null],
                        ["GYHVDLIIXVTLROOCLVYG", "INE579I01014", "OPTCUR USDINR 27 JAN 2023 83 PE", "currency", 135, 1670630400000, 90.69, "buy", 134, 183, 209, 9, 100, 50, 202, 60, 140, 214, null],
                        ["ULDR4PE639LOMU4A4VCE", "INE512R02109", "NIFTY 23 JAN 2023 CE 15000", "equity", 75, 1670457600000, 1570, "buy", 2122, 1793, 1820, 1893, 560, 1651, 875, 2161, 32, 1916, null],
                        ["VIHCPUEYSZUMQUVPSJ1P", "INE512R02109", "NIFTY 23 JAN 2023 CE 15000", "equity", 125, 1671840000000, 1490, "buy", 114, 1074, 1522, 44, 1158, 535, 2252, 1115, 1171, 2449, null],
                        ["QOO5OYJLQBIRUMIGKCIQ", "INE769A01020", "FINNIFTY 25 JAN 2023 CE 12500", "equity", 50, 1672617600000, 3450.67, "buy", 831, 1827, 1117, 1814, 1230, 499, 1882, 2344, 457, 1850, null],
                        ["2BOMU4R5WMEONKEI5YT6", "INE563D01013", "NIFTY 23 JAN 2023 CE 15600", "equity", 250, 1673481600000, 168, "buy", 1280, 657, 1291, 1139, 636, 2397, 795, 1161, 2236, 1620, null],
                        ["PZUTEFRTRX9LFW9DPHAW", "INE118D01016", "NIFTY 23 JAN 2023 CE 15650", "equity", 100, 1672444800000, 175.55, "buy", 125, 882, 2432, 2077, 2189, 2472, 2156, 1856, 1068, 2285, null],
                        ["DIQDEZH7K04QBDCJY0NV", "INE002A01018", "FINNIFTY 15 FEB 2023 CE 13400", "equity", 50, 1674086400000, 194.9, "buy", 1645, 1807, 1262, 2482, 829, 782, 540, 1000, 354, 2491, null],
                        ["PGR2RDEZFVC2S3YBX1JF", "INE0C5901014", "NIFTY 23 FEB 2023 PE 17100", "equity", 105, 1675296000000, 194.9, "buy", 1760, 1640, 2143, 905, 1374, 1714, 842, 1776, 847, 299, null],
                        ["TFCXQ3TKQRMOHU86MXO1", "INE082B0101", "BANKNIFTY 20 MAR 2023 PE 18900", "equity", 155, 1676505600000, 1500, "buy", 104, 552, 1064, 2411, 1835, 2056, 2421, 2289, 651, 2315, null],
                        ["DUYJ4ZV7OKJA8CV8U1MT", "INE0C5901014", "NIFTY 17 APR 2023 PE 17800", "equity", 55, 1679616000000, 457.89, "buy", 1766, 2139, 1170, 2017, 723, 2101, 1756, 2357, 1517, 2394, null],
                        ["2GFSS7XTAHUWHFZH0NBR", "INE322R01014", "FINNIFTY 25 MAY 2023 CE 14900", "equity", 130, 1682726400000, 698.03, "buy", 682, 2191, 400, 1922, 813, 188, 1323, 188, 880, 1267, null],
                        ["4AGDXGEEJOUHI6G8ATOU", "INE694N01015", "RELIANCE OCT 1940 CE", "equity", 50, 1695945600000, 559.39, "buy", 1244, 2104, 102, 1018, 319, 1497, 1669, 2059, 1901, 485, null],
                        ["AHVDFMGBCECY1IR0QDH9", "INE197R01010", "RELIANCE OCT 1960 CE", "equity", 175, 1696982400000, 1000, "buy", 2181, 2407, 104, 398, 1577, 1341, 55, 1215, 1616, 879, null],
                        ["Q2DZQ1ITYAOXILWQLHDN", "INE576G01015", "INFOSYS OCT 2550 CE", "equity", 150, 1697500800000, 175, "buy", 444, 1610, 769, 2289, 1456, 437, 1601, 620, 810, 1319, null],
                        ["FQQ96BPTGAPAQPLMABNU", "INE197R01010", "RELIANCE OCT 1920 CE", "equity", 250, 1697846400000, 186, "buy", 1158, 1954, 1513, 2091, 1622, 1175, 383, 2049, 191, 1624, null],
                        ["RKW88OVAQVWZMCD9VLJL", "INE512R01010", "INFOSYS OCT 2590 CE", "equity", 225, 1698105600000, 180, "buy", 874, 1430, 2384, 1648, 1398, 596, 367, 396, 1897, 1511, null],
                        ["TTGYOR1EOA3SUTMNCJ58", "INE512D09106", "OPTFUT CRUDEOIL 16 OCT 2022 7000 PE", "commodity", 25, 1663632000000, 423, "sell", 106, 107, 78, 45, 79, 100, 14, 58, 70, 85, null],
                        ["MYOFOBCC5W0PCWHVBFPU", "INE512D09106", "OPTFUT CRUDEOIL 16 OCT 2022 7000 PE", "commodity", 50, 1664496000000, 456, "buy", 80, 89, 33, 66, 61, 71, 116, 120, 55, 33, null],
                        ["VIX3TEN3GZKPVY2WZCEX", "INE512D09106", "OPTFUT CRUDEOIL 16 OCT 2022 7000 PE", "commodity", 125, 1665619200000, 449, "sell", 4, 73, 78, 84, 113, 71, 1, 75, 118, 18, null],
                        ["Q5CUBQ2P6B7VKNHCKWD6", "INE573G07017", "OPTFUT SILVERM 21 Nov 2022 58000 PE", "commodity", 50, 1665446400000, 135, "buy", 237, 56, 15, 18, 104, 15, 22, 76, 89, 112, null],
                        ["Q5CUBQ2P6B7VKNHCKWD6", "INE573G07017", "OPTFUT SILVERM 21 Nov 2022 58000 PE", "commodity", 80, 1665446400000, 142, "buy", 188, 53, 11, 89, 31, 92, 119, 77, 58, 6, null],
                        ["DTXGC9I0ZVOI2FFSHIOL", "INE573G07017", "OPTFUT SILVERM 21 Nov 2022 58000 PE", "commodity", 70, 1666137600000, 148, "sell", 77, 57, 74, 83, 42, 83, 110, 104, 60, 102, null],
                        ["DTXGC9I0ZVOI2FFSHIOL", "INE573G07017", "OPTFUT SILVERM 21 Nov 2022 58000 PE", "commodity", 30, 1666224000000, 150, "sell", 187, 112, 77, 67, 93, 19, 84, 19, 54, 47, null],
                        ["IU0HYP6ZN9EOERPBEWYA", "INE573G07017", "OPTFUT SILVERM 21 Nov 2022 58000 PE", "commodity", 140, 1666828800000, 137, "buy", 234, 97, 29, 100, 39, 72, 49, 115, 110, 93, null],
                        ["TAODZZPWWR9R5CO1QX0R", "INE573G07017", "OPTFUT SILVERM 21 Nov 2022 58000 PE", "commodity", 80, 1668470400000, 154, "sell", 136, 76, 35, 49, 98, 56, 75, 2, 15, 75, null],
                        ["TAODZZPWWR9R5CO1QX0R", "INE573G07017", "OPTFUT SILVERM 21 Nov 2022 58000 PE", "commodity", 20, 1668470400000, 153, "buy", 211, 31, 34, 6, 18, 105, 104, 41, 67, 52, null],
                        ["HVG5B4A45J9CL4CZ35TF", "INE573G07017", "OPTFUT SILVERM 21 Nov 2022 58000 PE", "commodity", 130, 1668902400000, 156, "sell", 110, 41, 105, 57, 47, 64, 63, 34, 46, 26, null],
                        ["CJ7UKXJFK6WDVAUWGXGW", "INE113J07012", "OPTFUT GOLD 29 OCT 2023 60000 PE", "commodity", 55, 1694995200000, 124.56, "sell", 103, 48, 70, 111, 21, 40, 84, 69, 15, 16, null],
                        ["EAU3BEIXICIMKLVWWU56", "INE113J07012", "OPTFUT GOLD 29 OCT 2023 60000 PE", "commodity", 55, 1695254400000, 121, "buy", 125, 52, 36, 22, 92, 17, 67, 79, 46, 109, null],
                        ["OJDZI0SB29R3RMHWOG8P", "INE113J07012", "OPTFUT GOLD 29 NOV2023 61000 PE", "commodity", 85, 1697587200000, 135, "buy", 212, 24, 78, 32, 52, 54, 7, 83, 8, 119, null],
                        ["DOHDNKFFITQRMFUYKQLE", "INE113J07012", "OPTFUT GOLD 29 NOV2023 61000 PE", "commodity", 35, 1698019200000, 138, "buy", 25, 89, 59, 114, 63, 56, 108, 2, 64, 35, null],
                        ["CVWO1J0HIG9QEY5UVUDQ", "INE113J07012", "OPTFUT GOLD 29 NOV2023 61000 PE", "commodity", 90, 1700352000000, 142, "sell", 108, 57, 19, 77, 25, 94, 115, 78, 71, 117, null],
                        ["R2K5E791EH5VAQZVOETW", "INE113J07012", "OPTFUT GOLD 29 NOV2023 61000 PE", "commodity", 10, 1700524800000, 149, "sell", 130, 3, 116, 15, 41, 119, 118, 26, 76, 77, null],
                        ["GYHVDLIIXVTLROOCLVYG", "INE579I01014", "OPTCUR USDINR 27 JAN 2023 83 PE", "currency", 145, 1670630400000, 87.45, "buy", 212, 202, 223, 125, 116, 48, 71, 75, 100, 24, null],
                        ["8VMAOKSBFKXAX1Z75UK5", "INE579I01014", "OPTCUR USDINR 27 JAN 2023 83 PE", "currency", 165, 1671494400000, 94.78, "sell", 177, 48, 234, 38, 176, 182, 159, 80, 200, 136, null],
                        ["ZXORPEEJE7TVFBPXQ8LI", "INE579I01014", "OPTCUR USDINR 27 JAN 2023 83 PE", "currency", 100, 1672358400000, 45.98, "sell", 97, 219, 153, 19, 118, 231, 228, 31, 185, 186, null],
                        ["ZXORPEEJE7TVFBPXQ8LI", "INE579I01014", "OPTCUR USDINR 27 JAN 2023 83 PE", "currency", 15, 1672617600000, 78.3, "sell", 94, 93, 127, 162, 79, 232, 149, 211, 83, 6, null],
                        ["6MDVYEYUKHJXIQSGEOPU", "INE645F01015", "OPTCUR EURINR 13 MAY 2023 94 CE", "currency", 50, 1680134400000, 245.78, "sell", 46, 228, 186, 237, 75, 6, 46, 97, 203, 34, null],
                        ["CPYBETZOWLDVTAYF3PRA", "INE645F01015", "OPTCUR EURINR 13 MAY 2023 94 CE", "currency", 50, 1680134400000, 260.7, "buy", 178, 162, 152, 207, 202, 185, 95, 232, 121, 209, null],
                        ["MEHVXLLGPB5SODCHL5PT", "INE645F01015", "OPTCUR EURINR 13 MAY 2023 94 CE", "currency", 145, 1680307200000, 278, "sell", 20, 164, 152, 121, 98, 148, 35, 194, 110, 34, null],
                        ["UQCTRKWJRKXVR7LSIBCN", "INE645F01015", "OPTCUR EURINR 13 MAY 2023 94 CE", "currency", 145, 1680739200000, 289, "buy", 25, 85, 159, 60, 145, 36, 46, 146, 237, 157, null],
                        ["PIN8G2M1QKXY1FQZPRIF", "INE714H01019", "OPTCUR GBPINR 27 OCT 2023 115 PE", "currency", 75, 1694649600000, 4500, "buy", 21, 179, 65, 29, 21, 92, 124, 178, 153, 12, null],
                        ["PIN8G2M1QKXY1FQZPRIF", "INE714H01019", "OPTCUR GBPINR 27 OCT 2023 115 PE", "currency", 75, 1694649600000, 4509, "sell", 15, 93, 151, 111, 104, 103, 55, 238, 153, 97, null],
                        ["69WJ3BI70HPVKNLEK5TR", "INE714H01019", "OPTCUR GBPINR 27 OCT 2023 115 PE", "currency", 113, 1695168000000, 4492.367, "buy", 57, 230, 240, 67, 116, 76, 6, 3, 169, 150, null],
                        ["P534DDQESQ6XNTI4NURV", "INE714H01019", "OPTCUR GBPINR 27 OCT 2023 115 PE", "currency", 60, 1695859200000, 4499.876, "sell", 145, 184, 130, 50, 35, 17, 90, 146, 149, 199, null],
                        ["OXGR4W3D3MYYBURZOEJ5", "INE714H01019", "OPTCUR GBPINR 27 OCT 2023 115 PE", "currency", 43, 1697673600000, 5008.596, "sell", 47, 22, 47, 31, 24, 32, 128, 195, 47, 87, null],
                        ["T6B8078DHAC9MGWPKR6B", "INE632P01025", "OPTCUR JPYINR 24 AUG 2023 45.6 CE", "currency", 120, 1690848000000, 345.89, "sell", 7, 203, 116, 18, 12, 64, 159, 151, 211, 148, null],
                        ["OFAILEZLEAPD9SU5ZOMT", "INE632P01025", "OPTCUR JPYINR 24 AUG 2023 45.6 CE", "currency", 80, 1691452800000, 325.67, "buy", 44, 87, 14, 179, 169, 178, 97, 26, 72, 170, null],
                        ["OFAILEZLHKPD8SU7ZOMT", "INE632P01025", "OPTCUR JPYINR 24 AUG 2023 45.6 CE", "currency", 30, 1691452800000, 319.78, "buy", 89, 205, 71, 145, 106, 166, 209, 67, 6, 124, null],
                        ["FDIT8EQR2XJFQJU2JLIG", "INE632P01025", "OPTCUR JPYINR 24 AUG 2023 45.6 CE", "currency", 40, 1692230400000, 329.587, "sell", 59, 42, 140, 65, 52, 47, 80, 128, 39, 105, null],
                        ["KLPAV9GOUCMPFH1WNKLV", "INE619I01012", "BANKNIFTY 01 Jun 2023 CE 44100", "equity", 25, 1685318400000, 450.09, "sell", 1657, 1302, 325, 2118, 2050, 604, 2148, 626, 1489, 2090, null],
                        ["0WNSDPGK4LTXO38HPTLU", "INE545C01013", "BANKNIFTY 01 Jun 2023 CE 44200", "equity", 25, 1685577600000, 469.22, "sell", 1711, 1948, 2048, 700, 2360, 120, 2415, 333, 2231, 736, null],
                        ["QS2KFCND5DJXRNDLLVHD", "INE545C01013", "BANKNIFTY 01 Jun 2023 CE 44200", "equity", 50, 1684886400000, 425.3, "sell", 320, 375, 82, 1593, 1653, 620, 1637, 712, 542, 130, null],
                        ["0B3PIU4WMIPKUQEG34BO", "INE512R02109", "NIFTY 23 JAN 2023 CE 15000", "equity", 25, 1671408000000, 1460, "sell", 499, 2262, 2210, 507, 256, 2293, 1125, 2345, 1852, 90, null],
                        ["S7XOLPIQ2V4R5L89ZEE1", "INE512R02109", "NIFTY 23 JAN 2023 CE 15000", "equity", 45, 1672358400000, 1508, "sell", 1784, 825, 2087, 498, 666, 616, 1994, 763, 157, 2380, null],
                        ["HSZA8B3XH3JC2POXMSXJ", "INE512R02109", "NIFTY 23 JAN 2023 CE 15000", "equity", 50, 1673568000000, 1585, "sell", 335, 1434, 254, 1609, 999, 1979, 2229, 127, 389, 1244, null],
                        ["ILKEYGKTOHFQI5UXMBOO", "INE512R02109", "NIFTY 23 JAN 2023 CE 15000", "equity", 80, 1674172800000, 1635, "sell", 208, 535, 279, 401, 2010, 248, 494, 746, 2399, 1196, null],
                        ["A9HFP9X49AROF21K9KRY", "INE769A01020", "FINNIFTY 25 JAN 2023 CE 12500", "equity", 50, 1674518400000, 2568.98, "sell", 319, 59, 25, 2409, 2339, 423, 132, 250, 2137, 2442, null],
                        ["GHQTIWHDAFE90NOAU6ZY", "INE563D01013", "NIFTY 23 JAN 2023 CE 15600", "equity", 25, 1672185600000, 146, "sell", 1525, 678, 749, 379, 277, 1791, 2288, 545, 1042, 327, null],
                        ["GHQTIWHDAFE90NOAU6ZY", "INE563D01013", "NIFTY 23 JAN 2023 CE 15600", "equity", 75, 1672531200000, 158, "sell", 1761, 2349, 1082, 2181, 1054, 1396, 856, 1220, 1740, 1791, null],
                        ["IXMBK9LENH6CSGULION2", "INE563D01013", "NIFTY 23 JAN 2023 CE 15600", "equity", 150, 1674259200000, 255, "sell", 2369, 875, 2202, 2488, 1574, 404, 532, 779, 2266, 1396, null],
                        ["BEZ31FONIR1EQQI68F0Y", "INE118D01016", "NIFTY 23 JAN 2023 CE 15650", "equity", 100, 1674432000000, 126.78, "sell", 288, 7, 2495, 1391, 1859, 28, 1298, 355, 1234, 1955, null],
                        ["HMC8SXGWGNGWUTFBYRHX", "INE002A01018", "FINNIFTY 15 FEB 2023 CE 13400", "equity", 50, 1675814400000, 174.55, "sell", 879, 2335, 1905, 1798, 456, 1765, 358, 1368, 1124, 1040, null],
                        ["KQDQ54GEHLHTIUSPGAV6", "INE0C5901014", "NIFTY 23 FEB 2023 PE 17100", "equity", 55, 1675987200000, 174.8, "sell", 181, 764, 1349, 1121, 2195, 2042, 1398, 1674, 164, 2244, null],
                        ["SLB3JNRIBXSZWLRWP8ZZ", "INE0C5901014", "NIFTY 23 FEB 2023 PE 17100", "equity", 50, 1676764800000, 210.89, "sell", 77, 713, 1563, 1666, 1745, 20, 528, 2500, 1068, 2008, null],
                        ["LMQI22RLLZHQ5CWBGFYP", "INE082B0101", "BANKNIFTY 20 MAR 2023 PE 18900", "equity", 155, 1679097600000, 615.89, "sell", 1842, 519, 2150, 997, 536, 1241, 2437, 765, 2481, 2126, null],
                        ["71ZRU28BNR9F5FMOZS8V", "INE0C5901014", "NIFTY 17 APR 2023 PE 17800", "equity", 55, 1681084800000, 489.67, "sell", 1519, 340, 2379, 190, 164, 2420, 662, 226, 1681, 722, null],
                        ["PHGLBJWZZLIDKTTVLNQE", "INE322R01014", "FINNIFTY 25 MAY 2023 CE 14900", "equity", 120, 1684368000000, 745.32, "sell", 820, 1114, 2137, 646, 2399, 2314, 160, 1817, 2092, 283, null],
                        ["SEZD4CXXIXJ79ZS0GUQ2", "INE694N01015", "RELIANCE OCT 1940 CE", "equity", 50, 1697328000000, 615.35, "sell", 1797, 249, 1653, 2028, 897, 542, 1158, 2067, 964, 1393, null],
                        ["UESSXHU0UHWCRJ1Z7LJR", "INE576G01015", "INFOSYS OCT 2550 CE", "equity", 150, 1698192000000, 145, "sell", 1204, 722, 1103, 2190, 1165, 1168, 597, 1485, 1127, 1175, null],
                        ["TVSWJDGSX7VFVHA2AUXG", "INE197R01010", "RELIANCE OCT 1920 CE", "equity", 250, 1698624000000, 199, "sell", 267, 1371, 436, 2246, 1747, 765, 1306, 1279, 1236, 1962, null]
                    ]
                }
            ]
        },
        {
            "name": "future_tradebook_sheet",
            "@entity": "sheet",
            "blocks": [
                {
                    "name": "future_tradebook_table",
                    "@entity": "table",
                    "header": ["trade_id", "isin", "contract_name", "asset_class", "quantity", "date", "price", "transaction_type", "brokerage", "clearing_charges", "exchange_transaction_charges", "sebi_turnover_fees", "stt", "stamp_duty", "sgst", "cgst", "igst", "other_transfer_expenses", "label"],
                    "rows": [
                        ["GGFCHMYLKDQYZRRINTEE", "INE914J01012", "BANKNIFTY 01 Jun 2023 FUT", "equity", 45, 1680739200000, 363.1, "buy", 51, 98, 75, 55, 32, 219, 11, 142, 55, 36, null],
                        ["AUGUWEK01EI4YOIMH7RK", "INE519I01013", "BANKNIFTY 15 Jun 2023 FUT", "equity", 50, 1683158400000, 363.15, "buy", 7, 56, 55, 223, 245, 330, 106, 144, 103, 9, null],
                        ["55MCNYCUWJO7C3ZAXWIX", "INE512D09106", "FUTCOM CRUDEOIL 16 OCT 2022", "commodity", 100, 1662940800000, 415, "buy", 107, 8, 114, 111, 90, 43, 36, 48, 119, 21, null],
                        ["JDNI9UJFKN2PGFJZ5U9O", "INE579I01014", "FUTCUR USDINR 27 JAN 2023 ", "currency", 135, 1670630400000, 90.69, "buy", 134, 183, 209, 9, 100, 50, 202, 60, 140, 214, null],
                        ["5NGIOMFGDRBG5Q8XTNBP", "INE512R02109", "NIFTY 23 JAN 2023 FUT", "equity", 75, 1670457600000, 147.89, "buy", 143, 44, 39, 61, 130, 216, 102, 90, 158, 37, null],
                        ["ANH3LZISNL7R8DPFNHJ0", "INE512R02109", "NIFTY 23 JAN 2023 FUT", "equity", 125, 1671840000000, 153.89, "buy", 84, 60, 3, 129, 221, 239, 11, 42, 160, 8, null],
                        ["S4LOWQJP4P6SFB42C460", "INE769A01020", "FINNIFTY 25 JAN 2023 FUT", "equity", 35, 1672617600000, 3450.67, "buy", 23, 98, 64, 214, 268, 161, 118, 116, 9, 21, null],
                        ["Z0FCJBWODSL8GF3KKVPY", "INE563D01013", "NIFTY 15 JAN 2023 FUT", "equity", 250, 1673481600000, 168, "buy", 27, 73, 8, 224, 284, 306, 42, 111, 5, 17, null],
                        ["CIKTMLOWJQLROEGJXMFF", "INE118D01016", "NIFTY 25 JAN 2023 FUT", "equity", 100, 1672444800000, 175.55, "buy", 65, 76, 54, 192, 58, 74, 149, 50, 17, 20, null],
                        ["NKN2PS2TJZWDA9CDP1RA", "INE002A01018", "FINNIFTY 15 FEB 2023 FUT", "equity", 155, 1674086400000, 194.9, "buy", 39, 85, 72, 144, 40, 15, 16, 39, 66, 47, null],
                        ["TWF45MCZTDWEWSJXU3EF", "INE0C5901014", "NIFTY 23 FEB 2023 FUT", "equity", 175, 1675296000000, 194.9, "buy", 50, 107, 81, 244, 314, 247, 91, 42, 72, 44, null],
                        ["8LEGU2BN0HXVHXYBIIRZ", "INE435D01014", "BANKNIFTY 20 MAR 2023 FUT", "equity", 125, 1676505600000, 1500, "buy", 62, 53, 28, 146, 85, 446, 149, 77, 165, 22, null],
                        ["GB8MD1GQRMB7M3KIPYBT", "INE0C5901014", "NIFTY 17 APR 2023 FUT", "equity", 145, 1679616000000, 457.89, "buy", 131, 77, 80, 49, 161, 373, 17, 130, 77, 16, null],
                        ["GUEQKVCN1OGWGMPXO1WQ", "INE322R01014", "FINNIFTY 20 MAY 2023 FUT", "equity", 130, 1682726400000, 698.03, "buy", 85, 110, 89, 148, 121, 426, 32, 65, 22, 31, null],
                        ["JG3ZELDXI8SYG4HLXSCG", "INE694N01015", "RIL 15 OCT 2023 FUT", "equity", 50, 1695945600000, 559.39, "buy", 111, 42, 44, 189, 145, 307, 57, 64, 43, 28, null],
                        ["1HLEP1MBFH5JINCYGEJB", "INE197R01010", "RIL 01 NOV 2023 FUT", "equity", 175, 1696982400000, 1000, "buy", 72, 52, 33, 117, 71, 327, 39, 67, 132, 3, null],
                        ["YFVS53SUIXO1FBXICSP8", "INE576G01015", "INFY 30 OCT 2023 FUT", "equity", 100, 1697500800000, 175, "buy", 40, 81, 12, 197, 124, 314, 159, 79, 166, 3, null],
                        ["EGTDOZWR9NJKLHJDXYSO", "INE197R01010", "RIL 31 OCT 2023 FUT", "equity", 250, 1697846400000, 186, "buy", 150, 2, 17, 244, 29, 366, 100, 41, 15, 36, null],
                        ["JBJYWGG6VA3VFF3J7OWZ", "INE512R01010", "INFY 25 OCT FUT", "equity", 225, 1698105600000, 180, "buy", 69, 65, 61, 243, 278, 69, 18, 109, 55, 17, null],
                        ["52VUZC1SJ5MW4IKAJPIA", "INE512D09106", "FUTCOM CRUDEOIL 16 OCT 2022", "commodity", 25, 1663632000000, 423, "sell", 106, 107, 78, 45, 79, 100, 14, 58, 70, 85, null],
                        ["2FPD4QFGHO2ICG3SK0KG", "INE512D09106", "FUTCOM CRUDEOIL 16 OCT 2022", "commodity", 50, 1664496000000, 456, "buy", 80, 89, 33, 66, 61, 71, 116, 120, 55, 33, null],
                        ["XPDDDCPTROUOHFWCQH7O", "INE512D09106", "FUTCOM CRUDEOIL 16 OCT 2022", "commodity", 125, 1665619200000, 449, "sell", 4, 73, 78, 84, 113, 71, 1, 75, 118, 18, null],
                        ["KMY2EC1UMISH0BUMIEGT", "INE573G07017", "FUTCOM SILVERM 21 Nov 2022 ", "commodity", 50, 1665446400000, 135, "buy", 237, 56, 15, 18, 104, 15, 22, 76, 89, 112, null],
                        ["KMY2EC1UMISH0BUMIEGT", "INE573G07017", "FUTCOM SILVERM 21 Nov 2022 ", "commodity", 80, 1665446400000, 142, "buy", 188, 53, 11, 89, 31, 92, 119, 77, 58, 6, null],
                        ["JAWOZXSLWYKHKUWGWS6L", "INE573G07017", "FUTCOM SILVERM 21 Nov 2022 ", "commodity", 70, 1666137600000, 148, "sell", 77, 57, 74, 83, 42, 83, 110, 104, 60, 102, null],
                        ["JAWOZXSLWYKHKUWGWS6L", "INE573G07017", "FUTCOM SILVERM 21 Nov 2022 ", "commodity", 30, 1666224000000, 150, "sell", 187, 112, 77, 67, 93, 19, 84, 19, 54, 47, null],
                        ["1AW8BG2NTK1BPSLMR0TV", "INE573G07017", "FUTCOM SILVERM 21 Nov 2022 ", "commodity", 140, 1666828800000, 137, "buy", 234, 97, 29, 100, 39, 72, 49, 115, 110, 93, null],
                        ["XOUZUWMHBDCRPKRGDD1Q", "INE573G07017", "FUTCOM SILVERM 21 Nov 2022 ", "commodity", 80, 1668470400000, 154, "sell", 136, 76, 35, 49, 98, 56, 75, 2, 15, 75, null],
                        ["XOUZUWMHBDCRPKRGDD1Q", "INE573G07017", "FUTCOM SILVERM 21 Nov 2022 ", "commodity", 20, 1668470400000, 153, "buy", 211, 31, 34, 6, 18, 105, 104, 41, 67, 52, null],
                        ["LAGBHUZEYUH1K2OMGP49", "INE573G07017", "FUTCOM SILVERM 21 Nov 2022 ", "commodity", 130, 1668902400000, 156, "sell", 110, 41, 105, 57, 47, 64, 63, 34, 46, 26, null],
                        ["GR4XEL9XWBSYPARPT0EF", "INE113J07012", "FUTCOM GOLD 29 OCT 2023", "commodity", 55, 1694995200000, 124.56, "sell", 103, 48, 70, 111, 21, 40, 84, 69, 15, 16, null],
                        ["M5ZXEWJZFFR9DR1ECYIE", "INE113J07012", "FUTCOM GOLD 29 OCT 2023", "commodity", 55, 1695254400000, 121, "buy", 125, 52, 36, 22, 92, 17, 67, 79, 46, 109, null],
                        ["FUWODRFMJFABB1VZGX5D", "INE113J07012", "FUTCOM GOLD 29 NOV 2023", "commodity", 85, 1697587200000, 135, "buy", 212, 24, 78, 32, 52, 54, 7, 83, 8, 119, null],
                        ["XVFHRXHI6QWNJUUKBJ0J", "INE113J07012", "FUTCOM GOLD 29 NOV 2023", "commodity", 35, 1698019200000, 138, "buy", 25, 89, 59, 114, 63, 56, 108, 2, 64, 35, null],
                        ["OHNNDTMWFFACP6JQ82GM", "INE113J07012", "FUTCOM GOLD 29 NOV 2023", "commodity", 90, 1700352000000, 142, "sell", 108, 57, 19, 77, 25, 94, 115, 78, 71, 117, null],
                        ["RRCAFBZWEKTPVLYJCRB4", "INE113J07012", "FUTCOM GOLD 29 NOV 2023", "commodity", 10, 1700524800000, 149, "sell", 130, 3, 116, 15, 41, 119, 118, 26, 76, 77, null],
                        ["JDNI9UJFKN2PGFJZ5U9O", "INE579I01014", "FUTCUR USDINR 27 JAN 2023 ", "currency", 145, 1670630400000, 87.45, "buy", 212, 202, 223, 125, 116, 48, 71, 75, 100, 24, null],
                        ["4TXSMROXNCO4YKN01YBF", "INE579I01014", "FUTCUR USDINR 27 JAN 2023 ", "currency", 165, 1671494400000, 94.78, "sell", 177, 48, 234, 38, 176, 182, 159, 80, 200, 136, null],
                        ["D1VHUJNJ1WGO9JVCK2AZ", "INE579I01014", "FUTCUR USDINR 27 JAN 2023 ", "currency", 100, 1672358400000, 45.98, "sell", 97, 219, 153, 19, 118, 231, 228, 31, 185, 186, null],
                        ["D1VHUJNJ1WGO9JVCK2AZ", "INE579I01014", "FUTCUR USDINR 27 JAN 2023 ", "currency", 15, 1672617600000, 78.3, "sell", 94, 93, 127, 162, 79, 232, 149, 211, 83, 6, null],
                        ["UVSIUTXLTZHDRHICW9C0", "INE645F01015", "FUTCUR EURINR 13 MAY 2023", "currency", 50, 1680134400000, 245.78, "sell", 46, 228, 186, 237, 75, 6, 46, 97, 203, 34, null],
                        ["V7L7EV2WB1F06YIJSHQS", "INE645F01015", "FUTCUR EURINR 13 MAY 2023", "currency", 50, 1680134400000, 260.7, "buy", 178, 162, 152, 207, 202, 185, 95, 232, 121, 209, null],
                        ["8GTJ7JADP09KTKDPFWQJ", "INE645F01015", "FUTCUR EURINR 13 MAY 2023", "currency", 145, 1680307200000, 278, "sell", 20, 164, 152, 121, 98, 148, 35, 194, 110, 34, null],
                        ["XNAQJZ3OTJFDZ2FEGVVQ", "INE645F01015", "FUTCUR EURINR 13 MAY 2023", "currency", 145, 1680739200000, 289, "buy", 25, 85, 159, 60, 145, 36, 46, 146, 237, 157, null],
                        ["NU9Y7DKWYXX1B8HUGX0G", "INE714H01019", "FUTCUR GBPINR 27 OCT 2023", "currency", 75, 1694649600000, 4500, "buy", 21, 179, 65, 29, 21, 92, 124, 178, 153, 12, null],
                        ["NU9Y7DKWYXX1B8HUGX0G", "INE714H01019", "FUTCUR GBPINR 27 OCT 2023", "currency", 75, 1694649600000, 4509, "sell", 15, 93, 151, 111, 104, 103, 55, 238, 153, 97, null],
                        ["7BN92HT8TUYNDOW29YPQ", "INE714H01019", "FUTCUR GBPINR 27 OCT 2023", "currency", 113, 1695168000000, 4492.367, "buy", 57, 230, 240, 67, 116, 76, 6, 3, 169, 150, null],
                        ["QRJDSFMYL79ULAWADZ4C", "INE714H01019", "FUTCUR GBPINR 27 OCT 2023", "currency", 60, 1695859200000, 4499.876, "sell", 145, 184, 130, 50, 35, 17, 90, 146, 149, 199, null],
                        ["FZJQJNQWOJE78OSAKILB", "INE714H01019", "FUTCUR GBPINR 27 OCT 2023", "currency", 43, 1697673600000, 5008.596, "sell", 47, 22, 47, 31, 24, 32, 128, 195, 47, 87, null],
                        ["BZAB3NIFLVXCEWLNXF0C", "INE632P01025", "FUTCUR JPYINR 24 AUG 2023", "currency", 120, 1690848000000, 345.89, "sell", 7, 203, 116, 18, 12, 64, 159, 151, 211, 148, null],
                        ["EUCWBOWYUQF5LLS2MG9P", "INE632P01025", "FUTCUR JPYINR 24 AUG 2023", "currency", 80, 1691452800000, 325.67, "buy", 44, 87, 14, 179, 169, 178, 97, 26, 72, 170, null],
                        ["EUCWBOWYUQF5LLS2MG9P", "INE632P01025", "FUTCUR JPYINR 24 AUG 2023", "currency", 30, 1691452800000, 319.78, "buy", 89, 205, 71, 145, 106, 166, 209, 67, 6, 124, null],
                        ["MUYD0KEIED2TJLMOBKEM", "INE632P01025", "FUTCUR JPYINR 24 AUG 2023", "currency", 40, 1692230400000, 329.587, "sell", 59, 42, 140, 65, 52, 47, 80, 128, 39, 105, null],
                        ["DROFW5LAACDWOCFKDQET", "INE914J01012", "BANKNIFTY 01 Jun 2023 FUT", "equity", 45, 1685318400000, 450.09, "sell", 111, 55, 14, 84, 291, 436, 146, 24, 168, 39, null],
                        ["Y9V66LWUBLF8P2I8FDAR", "INE519I01013", "BANKNIFTY 15 Jun 2023 FUT", "equity", 25, 1685577600000, 469.22, "sell", 78, 91, 80, 41, 123, 291, 83, 151, 115, 11, null],
                        ["2C7BGL8DLAEX6DMFGRTF", "INE519I01013", "BANKNIFTY 15 Jun 2023 FUT", "equity", 25, 1684886400000, 425.3, "sell", 22, 107, 62, 188, 249, 158, 117, 82, 21, 18, null],
                        ["CJLNLY40ORWJXUKGVC8E", "INE894N01016", "NIFTY 23 JAN 2023 FUT", "equity", 25, 1671408000000, 135.67, "sell", 69, 101, 25, 74, 90, 300, 128, 21, 56, 3, null],
                        ["GFHNW8Q8GH4F408UZQ0M", "INE894N01017", "NIFTY 23 JAN 2023 FUT", "equity", 45, 1672358400000, 129.89, "sell", 132, 88, 37, 24, 279, 212, 148, 43, 116, 26, null],
                        ["LL4ESNCPAINCWUTVOYKX", "INE894N01018", "NIFTY 23 JAN 2023 FUT", "equity", 50, 1673568000000, 147.89, "sell", 53, 67, 8, 87, 63, 171, 86, 89, 83, 9, null],
                        ["WI62KWVR0MYO0WXLDQ4J", "INE694C01015", "NIFTY 23 JAN 2023 FUT", "equity", 80, 1674172800000, 150, "sell", 10, 50, 68, 204, 60, 36, 24, 6, 43, 16, null],
                        ["IJPDDNJO9BNNH0TB9NPJ", "INE769A01020", "FINNIFTY 25 JAN 2023 FUT", "equity", 35, 1674518400000, 2568.98, "sell", 132, 85, 15, 82, 101, 10, 152, 75, 46, 11, null],
                        ["VLNYY0FTJTUGELL1TK8D", "INE563D01013", "NIFTY 15 JAN 2023 FUT", "equity", 25, 1672185600000, 146, "sell", 105, 53, 3, 114, 193, 397, 8, 2, 58, 43, null],
                        ["VLNYY0FTJTUGELL1TK8D", "INE563D01013", "NIFTY 15 JAN 2023 FUT", "equity", 75, 1672531200000, 158, "sell", 54, 105, 28, 102, 11, 64, 41, 148, 143, 3, null],
                        ["VY3TYTSPMWLYJQAEMGTZ", "INE563D01013", "NIFTY 15 JAN 2023 FUT", "equity", 150, 1674259200000, 255, "sell", 138, 32, 42, 214, 44, 13, 146, 43, 52, 35, null],
                        ["YQT2WZWDNZPPCRDSQFR9", "INE118D01016", "NIFTY 25 JAN 2023 FUT", "equity", 100, 1674432000000, 126.78, "sell", 18, 23, 81, 239, 107, 183, 158, 64, 137, 50, null],
                        ["9ZLDZGRMJBSSAIJTBTHN", "INE002A01018", "FINNIFTY 15 FEB 2023 FUT", "equity", 155, 1675814400000, 174.55, "sell", 130, 33, 69, 197, 298, 266, 24, 142, 9, 19, null],
                        ["RHSYRUIXEC7M4HJBK46H", "INE0C5901014", "NIFTY 23 FEB 2023 FUT", "equity", 55, 1675987200000, 174.8, "sell", 111, 86, 26, 17, 303, 388, 149, 16, 53, 20, null],
                        ["I3RI1TXUYSFLFU4N8IWZ", "INE0C5901014", "NIFTY 23 FEB 2023 FUT", "equity", 120, 1676764800000, 210.89, "sell", 115, 42, 78, 151, 292, 262, 98, 151, 37, 30, null],
                        ["BYSC5G1EPZIWIJJ6BAUB", "INE435D01014", "BANKNIFTY 20 MAR 2023 FUT", "equity", 125, 1679097600000, 615.89, "sell", 101, 83, 15, 219, 125, 349, 140, 154, 129, 6, null],
                        ["MWLF0LTSOJNEXKVXSGWN", "INE0C5901014", "NIFTY 17 APR 2023 FUT", "equity", 135, 1681084800000, 489.67, "sell", 132, 94, 74, 184, 190, 173, 30, 72, 61, 48, null],
                        ["B67GMDMHCZAHJBXKDGL0", "INE322R01014", "FINNIFTY 20 MAY 2023 FUT", "equity", 120, 1684368000000, 745.32, "sell", 150, 13, 35, 133, 133, 362, 128, 119, 83, 39, null],
                        ["DEN7PSRIFMQ0VQXZF8O8", "INE694N01015", "RIL 15 OCT 2023 FUT", "equity", 50, 1697328000000, 615.35, "sell", 99, 59, 84, 104, 322, 159, 92, 122, 136, 15, null],
                        ["GAVL50RNZDGGQSMMLKOF", "INE576G01015", "INFY 30 OCT 2023 FUT", "equity", 100, 1698192000000, 145, "sell", 50, 96, 11, 84, 204, 220, 20, 125, 146, 23, null],
                        ["BWQRBJTC2V55AFBIZPYW", "INE197R01010", "RIL 31 OCT 2023 FUT", "equity", 250, 1698624000000, 199, "sell", 89, 57, 49, 235, 303, 147, 23, 114, 11, 24, null]
                    ]
                }
            ]
        },
        {
            "name": "mutual_fund_tradebook_sheet",
            "@entity": "sheet",
            "blocks": [
                {
                    "name": "mutual_fund_tradebook_table",
                    "@entity": "table",
                    "header": ["trade_id", "isin", "scheme_name", "asset_class", "is_listed", "is_stt_paid", "quantity", "date", "price", "transaction_type", "fmv", "transfer_expenses", "label"],
                    "rows": [
                        ["TGFCH72LKDQY9RRINTGH", "INE397D01024", "HDFC CREDIT RISK DEBT FUND - DIRECT PLAN", "debt", true, true, 32.31, 1525824000000, 50, "buy", 400, 10, null],
                        ["KGFCH72LKDQY9RRINTGH", "INE397D01024", "HDFC CREDIT RISK DEBT FUND - DIRECT PLAN", "debt", true, true, 32.31, 1577664000000, 900, "sell", 1000, 89.658, null],
                        ["BVNCH72LKDQY9RRINTGH", "INF251K01NO3", "BNP PARIBAS LIQUID FUND - DIRECT PLAN", "debt", true, true, 37.216, 1589414400000, 10, "buy", 0, 98, null],
                        ["KHF78MYGKDQY9RRINTGH", "INF251K01NO3", "BNP PARIBAS LIQUID FUND - DIRECT PLAN", "debt", true, true, 17.823, 1650672000000, 5, "sell", 0, 20, null],
                        ["BNG57MYGKDQY9RRINTGH", "INF277K01YE6", "TATA LIQUID FUND - DIRECT PLAN", "debt", true, true, 19.574, 1515456000000, 120, "buy", 5, 78, null],
                        ["GHN78MYGKDQY9RRINTGH", "INF277K01YE6", "TATA LIQUID FUND - DIRECT PLAN", "debt", true, true, 36.711, 1682640000000, 160, "sell", 5, 33.24, null],
                        ["GJK45MYGKDQY9RRINTGH", "INF278A06YE8", "Aditya Birla Sun Life Medium Term Direct Plan Growth", "debt", true, true, 36.023, 1493769600000, 30, "buy", 10, 68, null],
                        ["BHM88MYGKDQY9RRINTGH", "INF278A06YE8", "Aditya Birla Sun Life Medium Term Direct Plan Growth", "debt", true, true, 36.023, 1626480000000, 60, "sell", 10, 100, null],
                        ["GHL909MYGKDQY9RRINTGH", "INF200K01UT4", "SBI LIQUID FUND - DIRECT PLAN", "other", true, true, 35.014, 1437177600000, 15, "buy", 17, 67, null],
                        ["BHM88MTYH6QY9RRINTGH", "INF200K01UT4", "SBI LIQUID FUND - DIRECT PLAN", "other", true, true, 19.88, 1626652800000, 60, "sell", 17, 10, null],
                        ["BHMGP79GKDQY9RRINTGH", "INF200K01189", "SBI Gold Fund", "other", true, true, 35.706, 1626739200000, 60, "buy", 65, 30, null],
                        ["BLKMN98HJNMDQY9RRINTGH", "INF200K01189", "SBI Gold Fund", "other", true, true, 36.062, 1563667200000, 60, "buy", 120, 50, null],
                        ["MJK88MYGKDQY9RRINTGH", "INF109KB1GK2", "ICICI Prudential Commodity Fund", "other", true, true, 35.039, 1626912000000, 400.784, "buy", 200, 20, null],
                        ["CVH78MYGKDQY9RRINTGH", "INF109KB1GK2", "ICICI Prudential Commodity Fund", "other", true, true, 32.531, 1690070400000, 200, "sell", 200, 90, null],
                        ["GMFCH72LKDQY9RRINTGH", "INF179KB1HP9", "HDFC LIQUID FUND - DIRECT PLAN", "equity", true, true, 25.68, 1556409600000, 459, "buy", 220, 0.25, null],
                        ["GMFCH72LKDQY9RRINTGH", "INF179KB1HP9", "HDFC LIQUID FUND - DIRECT PLAN", "equity", true, true, 25.68, 1556409600000, 500, "sell", 220, 50, null],
                        ["GGFCHMYLKDQY9RRINTGH", "INF846K01DI2", "Axis Bluechip Fund", "equity", true, true, 105.56, 1491436800000, 123, "buy", 20, 25, null],
                        ["GGFCHMYLKDQY9RRINTGH", "INF846K01DI2", "Axis Bluechip Fund", "equity", true, true, 550.34, 1491436800000, 124.5, "buy", 20, 49, null],
                        ["JHF78MYGKDQY9RRINTGH", "INF846K01DI2", "Axis Bluechip Fund", "equity", true, true, 355.9, 1662940800000, 212.7, "sell", 20, 28, null],
                        ["JTR59NOGKDQY9YTINTGH", "INF846K01DI2", "Axis Bluechip Fund", "equity", true, true, 250, 1670630400000, 209, "sell", 20, 75, null],
                        ["DFGR59NOHJDQ751TINTJK", "INF179K01PT5", "HDFC Small Cap Fund", "equity", true, true, 129, 1670716800000, 150, "buy", 100, 32, null],
                        ["DFGR59NOHJDQ751TINTJK", "INF179K01PT5", "HDFC Small Cap Fund", "equity", true, true, 100, 1670716800000, 250, "buy", 100, 56, null],
                        ["GHNR59NOHJDQ901TINTLK", "INF200K01OR6", "SBI Magnum Multicap Fund", "equity", true, true, 156.78, 1481500800000, 150, "buy", 160, 22, null],
                        ["HNT59NOGKDQY897TINF4R", "INF200K01OR6", "SBI Magnum Multicap Fund", "equity", true, true, 125, 1670889600000, 400, "sell", 160, 89.658, null],
                        ["KNT59NOGKDQY897TINFTR", "INF760K01FR2", "Canara Robeco Bluechip Equity Growth Direct Plan", "equity", true, true, 155, 1576022400000, 23.78, "buy", 25, 2, null],
                        ["HYT59NOGKDQY9YTINFGRN", "INF760K01FR2", "Canara Robeco Bluechip Equity Growth Direct Plan", "equity", true, true, 155, 1633996800000, 56.9, "sell", 45, 2, null],
                        ["HJM98MYGKDQY9RRINGFB", "INF200K01189", "SBI Gold Fund", "other", true, true, 35, 1374624000000, 200, "buy", 180, 589, null],
                        ["JMCU8MYGKDQY9RRINTGH", "INF200K01189", "SBI Gold Fund", "other", true, true, 35, 1585008000000, 230, "buy", 180, 37, null],
                        ["RTV678MYGKDQY9RRINTGH", "INF200K01189", "SBI Gold Fund", "other", true, true, 55, 1649289600000, 210, "sell", 180, 56, null],
                        ["GHN78NOGKDQY9YTINFGHY", "INF200K01190", "KOTAK SEC FUND", "equity", true, true, 50, 1633564800000, 980, "buy", 800, 145, null],
                        ["XCT59NOGKDQY9YTINFGRN", "INF200K01190", "KOTAK SEC FUND", "equity", true, true, 40, 1639872000000, 1000, "buy", 800, 198, null],
                        ["VBN59NOGKDQY9YTINFGRN", "INF200K01190", "KOTAK SEC FUND", "equity", true, true, 40, 1634169600000, 1200, "sell", 800, 230, null],
                        ["67859NOGKDQY9YTINFGRN", "INF200K01190", "KOTAK SEC FUND", "equity", true, true, 50, 1634342400000, 1300, "sell", 800, 245, null]
                    ]
                }
            ]
        },
        {
            "name": "etf_tradebook_sheet",
            "@entity": "sheet",
            "blocks": [
                {
                    "name": "etf_tradebook_table",
                    "@entity": "table",
                    "header": ["trade_id", "isin", "scheme_name", "asset_class", "is_listed", "is_stt_paid", "quantity", "date", "price", "transaction_type", "fmv", "brokerage", "clearing_charges", "exchange_transaction_charges", "sebi_turnover_fees", "stt", "stamp_duty", "sgst", "cgst", "igst", "other_transfer_expenses", "label", "product_type"],
                    "rows": [
                        ["TGFCH72LKDQY9RRINTGH", "INE397D01024", "HDFC CREDIT RISK DEBT FUND - DIRECT PLAN", "debt", true, true, 250, 1651363200000, 650, "buy", 400, 115, 74, 130, 137, 144, 113, 122, 132, 69, 76, null, "intraday"],
                        ["KGFCH72LKDQY9RRINTGH", "INE397D01024", "HDFC CREDIT RISK DEBT FUND - DIRECT PLAN", "debt", true, true, 250, 1651363200000, 600, "sell", 400, 19, 9, 111, 62, 121, 45, 71, 74, 44, 24, null, "intraday"],
                        ["BVNCH72LKDQY9RRINTGH", "INF251K01NO3", "BNP PARIBAS LIQUID FUND - DIRECT PLAN", "debt", true, true, 31.536, 1660089600000, 10, "buy", 340, 92, 34, 93, 139, 17, 3, 68, 61, 48, 109, null, "delivery"],
                        ["KHF78MYGKDQY9RRINTGH", "INF251K01NO3", "BNP PARIBAS LIQUID FUND - DIRECT PLAN", "debt", true, true, 31.536, 1677628800000, 5, "sell", 340, 134, 111, 2, 96, 29, 36, 128, 104, 94, 101, null, "delivery"],
                        ["BNG57MYGKDQY9RRINTGH", "INF277K01YE6", "TATA LIQUID FUND - DIRECT PLAN", "debt", true, true, 80, 1568160000000, 120, "buy", 250, 127, 17, 108, 1, 26, 75, 33, 126, 113, 56, null, "delivery"],
                        ["GHN78MYGKDQY9RRINTGH", "INF277K01YE6", "TATA LIQUID FUND - DIRECT PLAN", "debt", true, true, 60, 1694044800000, 160, "sell", 250, 60, 140, 15, 119, 139, 13, 18, 106, 10, 58, null, "delivery"],
                        ["GJK45MYGKDQY9RRINTGH", "INF278A06YE8", "Aditya Birla Sun Life Medium Term Direct Plan Growth", "debt", true, true, 100, 1681948800000, 30, "sell", 10, 123, 38, 8, 101, 111, 99, 103, 89, 43, 11, null, "delivery"],
                        ["BHM88MYGKDQY9RRINTGH", "INF278A06YE8", "Aditya Birla Sun Life Medium Term Direct Plan Growth", "debt", true, true, 100, 1682380800000, 60, "buy", 10, 88, 62, 132, 43, 111, 35, 4, 113, 61, 3, null, "delivery"],
                        ["GHL909MYGKDQY9RRINTGH", "INF200K01UT4", "SBI LIQUID FUND - DIRECT PLAN", "other", true, true, 20, 1668038400000, 15, "buy", 17, 37, 7, 47, 38, 9, 43, 25, 78, 72, 16, null, "intraday"],
                        ["BHM88MTYH6QY9RRINTGH", "INF200K01UT4", "SBI LIQUID FUND - DIRECT PLAN", "other", true, true, 20, 1668038400000, 60, "sell", 17, 43, 50, 48, 1, 7, 57, 9, 64, 73, 7, null, "intraday"],
                        ["BHMGP79GKDQY9RRINTGH", "INF200K01189", "SBI Gold Fund", "other", true, true, 50, 1640822400000, 60, "sell", 65, 43, 59, 55, 9, 45, 50, 10, 17, 39, 22, null, "delivery"],
                        ["BLKMN98HJNMDQY9RRINTGH", "INF200K01189", "SBI Gold Fund", "other", true, true, 50, 1641427200000, 120.5877, "buy", 65, 28, 17, 52, 65, 13, 40, 13, 40, 40, 28, null, "delivery"],
                        ["MJK88MYGKDQY9RRINTGH", "INF109KB1GK2", "ICICI Prudential Commodity Fund", "other", true, true, 150, 1627862400000, 400.784, "buy", 200, 77, 59, 77, 12, 5, 2, 7, 10, 5, 30, null, "delivery"],
                        ["CVH78MYGKDQY9RRINTGH", "INF109KB1GK2", "ICICI Prudential Commodity Fund", "other", true, true, 100, 1685059200000, 200, "sell", 200, 72, 24, 22, 18, 57, 14, 17, 54, 32, 50, null, "delivery"],
                        ["GMFCH72LKDQY9RRINTGH", "INF179KB1HP9", "HDFC LIQUID FUND - DIRECT PLAN", "equity", true, true, 100, 1683590400000, 550, "buy", 220, 137, 98, 138, 39, 106, 59, 21, 61, 146, 78, null, "intraday"],
                        ["FGN89H72LKDQY9RRINTKL", "INF179KB1HP9", "HDFC LIQUID FUND - DIRECT PLAN", "equity", true, true, 100, 1683590400000, 500, "sell", 220, 17, 117, 133, 9, 132, 83, 69, 1, 73, 27, null, "intraday"],
                        ["JNV5CHMYLKDQY9RRINTG", "INF846K01DI2", "Axis Bluechip Fund", "equity", true, true, 78, 1589414400000, 23, "buy", 20, 106, 17, 123, 61, 31, 105, 24, 117, 16, 62, null, "delivery"],
                        ["GGFCHMYLKDQY9RRINTGH", "INF846K01DI2", "Axis Bluechip Fund", "equity", true, true, 78, 1650672000000, 88, "sell", 20, 79, 35, 65, 99, 120, 146, 115, 90, 100, 93, null, "delivery"],
                        ["PKF88MYGKDQY9RRINTGH", "INF179K01PT5", "HDFC Small Cap Fund", "equity", true, true, 90, 1515456000000, 150, "buy", 100, 92, 43, 29, 90, 64, 70, 66, 51, 112, 117, null, "delivery"],
                        ["PKF88MYGKDQY9RRINTGH", "INF179K01PT5", "HDFC Small Cap Fund", "equity", true, true, 90, 1515369600000, 250, "sell", 100, 95, 105, 55, 104, 39, 74, 23, 26, 42, 142, null, "delivery"],
                        ["DFGR59NOHJDQ751TINTJK", "INF200K01OR6", "SBI Magnum Multicap Fund", "equity", true, true, 95, 1493769600000, 150, "buy", 160, 107, 98, 49, 143, 53, 73, 107, 52, 75, 56, null, "delivery"],
                        ["DFGR59NOHJDQ751TINTJK", "INF200K01OR6", "SBI Magnum Multicap Fund", "equity", true, true, 50, 1493769600000, 400, "buy", 160, 9, 60, 101, 40, 146, 3, 23, 125, 139, 82, null, "delivery"],
                        ["GHNR59NOHJDQ901TINTLK", "INF200K01OR6", "SBI Magnum Multicap Fund", "equity", true, true, 30, 1563321600000, 450, "sell", 160, 4, 82, 120, 71, 34, 38, 45, 2, 67, 98, null, "delivery"],
                        ["HNT59NOGKDQY897TINF4R", "INF200K01OR6", "SBI Magnum Multicap Fund", "equity", true, true, 80, 1599696000000, 500, "sell", 160, 36, 36, 69, 74, 139, 57, 75, 81, 118, 149, null, "delivery"],
                        ["KNT59NOGKDQY897TINFTR", "INF200K01OR6", "SBI Magnum Multicap Fund", "equity", true, true, 10, 1627603200000, 10, "sell", 160, 57, 141, 136, 4, 44, 47, 7, 119, 105, 138, null, "delivery"],
                        ["HYT59NOGKDQY9YTINFGRN", "INF200K01OR6", "SBI Magnum Multicap Fund", "equity", true, true, 10, 1658361600000, 50, "sell", 160, 84, 38, 123, 61, 19, 8, 58, 18, 145, 85, null, "delivery"],
                        ["GJK48MYGKDQY9RRINGFB", "INF179KB1QR6", "ICICI LIQUID FUND - DIRECT PLAN", "equity", true, true, 75, 1666828800000, 45, "sell", 300, 39, 95, 149, 59, 12, 133, 149, 109, 98, 66, null, "intraday"],
                        ["HNM88JKGKDQY9RRINGFB", "INF179KB1QR7", "ICICI LIQUID FUND - DIRECT PLAN", "equity", true, true, 75, 1666828800000, 125, "buy", 300, 19, 128, 126, 28, 70, 59, 130, 1, 113, 31, null, "intraday"],
                        ["HJM98MYGKDQY9RRINGFB", "INF179KB1QR8", "ICICI LIQUID FUND - DIRECT PLAN", "equity", true, true, 75, 1658620800000, 150, "buy", 300, 61, 16, 25, 121, 50, 103, 148, 33, 75, 7, null, "delivery"]
                    ]
                }
            ]
        },
        {
            "name": "bond_tradebook_sheet",
            "@entity": "sheet",
            "blocks": [
                {
                    "name": "bond_tradebook_table",
                    "@entity": "table",
                    "header": ["trade_id", "isin", "security_name", "is_listed", "quantity", "date", "price", "transaction_type", "brokerage", "clearing_charges", "exchange_transaction_charges", "sebi_turnover_fees", "stamp_duty", "sgst", "cgst", "igst", "other_transfer_expenses", "label"],
                    "rows": [
                        ["TGFCH72LKDQY9RRINTGH", "INE261F07032", "07.64% NABARD TFB 2031", true, 500, 1680739200000, 10, "buy", 31, 50, 13, 3, 115, 100, 109, 56, 8, null],
                        ["KGFCH72LKDQY9RRINTGH", "INE261F07032", "07.64% NABARD TFB 2031", true, 500, 1683158400000, 10, "buy", 121, 112, 21, 98, 33, 113, 104, 98, 61, null],
                        ["BVNCH72LKDQY9RRINTGH", "INE272F07011", "Blue Dart Express", true, 50, 1662940800000, 20, "buy", 35, 112, 55, 9, 13, 41, 75, 37, 5, null],
                        ["KHF78MYGKDQY9RRINTGH", "INE272F07011", "Blue Dart Express", true, 20, 1670630400000, 200, "sell", 108, 4, 102, 57, 11, 105, 16, 56, 86, null],
                        ["BNG57MYGKDQY9RRINTGH", "INE112J07020", "IFCI", true, 200, 1670457600000, 16.55, "buy", 78, 26, 27, 16, 60, 45, 87, 118, 84, null],
                        ["GHN78MYGKDQY9RRINTGH", "INE112J07020", "IFCI", true, 170, 1671840000000, 500, "sell", 71, 109, 99, 30, 11, 126, 102, 18, 24, null],
                        ["GJK45MYGKDQY9RRINTGH", "INE130K08000", "SBOX", false, 200, 1672617600000, 16.55, "buy", 60, 16, 109, 81, 80, 114, 63, 119, 84, null],
                        ["BHM88MYGKDQY9RRINTGH", "INE130K08000", "SBOX", false, 170, 1576022400000, 500, "sell", 78, 99, 8, 16, 9, 102, 63, 100, 31, null],
                        ["GHL909MYGKDQY9RRINTGH", "INE130K08001", "QCK", false, 200, 1633996800000, 16.55, "buy", 43, 127, 37, 52, 86, 116, 46, 118, 84, null],
                        ["BHM88MTYH6QY9RRINTGH", "INE130K08001", "QCK", false, 200, 1374624000000, 500, "sell", 48, 128, 1, 120, 112, 20, 79, 115, 74, null],
                        ["BHMGP79GKDQY9RRINTGH", "INE130K08012", "GGL", true, 200, 1585008000000, 550, "buy", 87, 21, 50, 5, 71, 37, 22, 81, 106, null],
                        ["BLKMN98HJNMDQY9RRINTGH", "INE130K08015", "GGL", true, 200, 1649289600000, 600, "sell", 37, 85, 53, 113, 102, 42, 48, 31, 15, null],
                        ["MJK88MYGKDQY9RRINTGH", "INE130K08019", "APPL", false, 200, 1633564800000, 350, "buy", 114, 12, 100, 114, 51, 15, 37, 44, 108, null],
                        ["CVH78MYGKDQY9RRINTGH", "INE130K08019", "APPL", false, 180, 1639872000000, 310, "sell", 112, 109, 45, 32, 49, 53, 47, 124, 111, null],
                        ["GMFCH72LKDQY9RRINTGH", "INE261F07032", "07.64% NABARD TFB 2031", true, 500, 1634169600000, 125, "sell", 15, 26, 86, 64, 56, 26, 30, 21, 125, null],
                        ["GMFCH72LKDQY9RRINTGH", "INE261F07032", "07.64% NABARD TFB 2031", true, 500, 1634342400000, 125, "sell", 76, 101, 104, 28, 127, 21, 26, 88, 70, null],
                        ["GGFCHMYLKDQY9RRINTGH", "INE261F07055", "SGB", true, 500, 1437177600000, 488, "buy", 95, 69, 57, 104, 77, 41, 38, 28, 101, null],
                        ["GGFCHMYLKDQY9RRINTGH", "INE261F07055", "SGB", true, 500, 1626652800000, 322, "buy", 22, 51, 38, 76, 101, 87, 53, 77, 4, null],
                        ["JHF78MYGKDQY9RRINTGH", "INE261F07055", "SGB", true, 100, 1626739200000, 350, "buy", 11, 26, 86, 34, 107, 43, 1, 101, 6, null],
                        ["JTR59NOGKDQY9YTINTGH", "INE261F07055", "SGB", true, 550, 1563667200000, 350, "sell", 107, 97, 94, 49, 49, 9, 112, 69, 129, null],
                        ["DFGR59NOHJDQ751TINTJK", "INE261F07055", "SGB", true, 50, 1570579200000, 400, "sell", 80, 10, 130, 58, 5, 46, 108, 40, 106, null]
                    ]
                }
            ]
        },
        {
            "name": "debenture_tradebook_sheet",
            "@entity": "sheet",
            "blocks": [
                {
                    "name": "debenture_tradebook_table",
                    "@entity": "table",
                    "header": ["trade_id", "isin", "security_name", "is_listed", "quantity", "date", "price", "transaction_type", "brokerage", "clearing_charges", "exchange_transaction_charges", "sebi_turnover_fees", "stamp_duty", "sgst", "cgst", "igst", "other_transfer_expenses", "label"],
                    "rows": [
                        ["RJFWB5JYYDORFUEPK5DQ", "INE261F07032", "07.64% NABARD TFB 2031", true, 1000, 1525824000000, 10, "buy", 177, 180, 238, 105, 243, 101, 131, 187, 104, null],
                        ["Y6W9FLHOVJ8TCHHNBYGF", "INE261F07032", "07.64% NABARD TFB 2031", true, 1000, 1577664000000, 10, "sell", 224, 48, 219, 210, 51, 234, 197, 66, 220, null],
                        ["DML3WXXE53PJOTGTEYKJ", "INE272F07011", "Blue Dart Express", true, 50, 1589414400000, 20, "buy", 61, 48, 59, 117, 236, 125, 232, 240, 106, null],
                        ["GYHVDLIIXVTLROOCLVYG", "INE272F07011", "Blue Dart Express", true, 20, 1650672000000, 200, "sell", 151, 188, 89, 94, 45, 54, 58, 220, 6, null],
                        ["ULDR4PE639LOMU4A4VCE", "INE112J07020", "IFCI", true, 200, 1515456000000, 16.55, "buy", 74, 176, 232, 177, 230, 53, 210, 110, 125, null],
                        ["VIHCPUEYSZUMQUVPSJ1P", "INE112J07020", "IFCI", true, 170, 1682640000000, 500, "sell", 129, 82, 120, 187, 110, 174, 71, 160, 42, null],
                        ["QOO5OYJLQBIRUMIGKCIQ", "INE130K08000", "SBOX", false, 200, 1493769600000, 16.55, "buy", 108, 88, 142, 17, 130, 214, 66, 207, 179, null],
                        ["2BOMU4R5WMEONKEI5YT6", "INE130K08000", "SBOX", false, 170, 1626480000000, 500, "sell", 97, 118, 33, 9, 151, 6, 38, 52, 40, null],
                        ["PZUTEFRTRX9LFW9DPHAW", "INE130K08001", "QCK", false, 200, 1437177600000, 16.55, "buy", 133, 242, 225, 166, 45, 232, 127, 64, 210, null],
                        ["DIQDEZH7K04QBDCJY0NV", "INE130K08001", "QCK", false, 200, 1626652800000, 500, "sell", 78, 112, 194, 9, 128, 114, 154, 68, 207, null],
                        ["PGR2RDEZFVC2S3YBX1JF", "INE130K08012", "GGL", true, 200, 1626739200000, 550, "buy", 157, 86, 208, 79, 180, 94, 158, 38, 191, null],
                        ["TFCXQ3TKQRMOHU86MXO1", "INE130K08015", "GGL", true, 200, 1563667200000, 600, "sell", 103, 56, 160, 203, 240, 171, 239, 71, 42, null],
                        ["DUYJ4ZV7OKJA8CV8U1MT", "INE130K08019", "APPL", false, 200, 1626912000000, 350, "buy", 215, 228, 8, 98, 119, 44, 185, 50, 154, null],
                        ["2GFSS7XTAHUWHFZH0NBR", "INE130K08019", "APPL", false, 180, 1690070400000, 310, "sell", 12, 204, 93, 133, 63, 206, 65, 13, 167, null],
                        ["4AGDXGEEJOUHI6G8ATOU", "INE261F07055", "SGB", true, 500, 1556409600000, 600, "buy", 220, 239, 134, 180, 58, 131, 160, 117, 207, null],
                        ["AHVDFMGBCECY1IR0QDH9", "INE261F07055", "SGB", true, 500, 1556409600000, 764, "buy", 159, 38, 58, 8, 34, 12, 202, 103, 31, null],
                        ["Q2DZQ1ITYAOXILWQLHDN", "INE261F07055", "SGB", true, 100, 1491436800000, 890, "buy", 189, 118, 196, 90, 161, 199, 36, 138, 50, null],
                        ["FQQ96BPTGAPAQPLMABNU", "INE261F07055", "SGB", true, 550, 1576022400000, 789, "sell", 52, 8, 14, 119, 231, 1, 246, 128, 155, null],
                        ["RKW88OVAQVWZMCD9VLJL", "INE261F07055", "SGB", true, 50, 1633996800000, 890, "sell", 139, 196, 103, 96, 207, 102, 68, 229, 5, null]
                    ]
                }
            ]
        }
    ]
}