> ## Documentation Index > Fetch the complete documentation index at: https://developer.sandbox.co.in/llms.txt > Use this file to discover all available pages before exploring further. # Job > Check the processing status of a domestic securities P&L job. ## OpenAPI ````yaml api-reference/it/calculator/openapi.json POST /it/calculator/pnl/securities/domestic openapi: 3.1.0 info: title: Sandbox API [Prod] version: '1.0' servers: - url: https://test-api.sandbox.co.in description: test - url: https://api.sandbox.co.in description: prod security: - {} paths: /it/calculator/pnl/securities/domestic: post: tags: - pnl - securities - domestic summary: Submit P&L Job parameters: - name: from in: query required: true description: >- Start timestamp (inclusive) for the P&L calculation period, expressed as Unix epoch time in milliseconds. deprecated: false schema: type: number minimum: 0 example: '1705682801000' - name: to in: query required: true description: >- End timestamp (inclusive) for the P&L calculation period, expressed as Unix epoch time in milliseconds. deprecated: false schema: type: number example: '1750881909973' - name: input in: query required: true description: >- Type of input file. Allowed values: tradewise_settlement or tradebook. deprecated: false schema: type: string enum: - tradebook example: tradebook - name: output in: query required: true description: 'Type of output file. Allowed values: tradewise_pnl or scripwise_pnl' deprecated: false schema: type: string default: tradewise_pnl enum: - tradewise_pnl - ' scripwise_pnl' example: tradewise_pnl - name: x-accept-type in: header required: true description: application/json or application/xlsx deprecated: false schema: type: string example: application/json - name: x-api-key in: header required: true description: Your API key used to authenticate and authorize the request. deprecated: false schema: type: string example: '{{api_key}}' - name: x-api-version in: header required: false description: >- Indicates the version of the API you want to use. Ensures backward-compatible behavior. deprecated: false schema: {} example: '{{version}}' - name: Authorization in: header required: false description: 'Token for user-level authorization. ' deprecated: false schema: {} example: '{{access_token}}' requestBody: content: application/json: schema: type: object properties: name: type: string '@entity': type: string sheets: type: array items: type: object properties: name: type: string '@entity': type: string blocks: type: array items: type: object properties: name: type: string '@entity': type: string header: type: array items: type: string rows: type: array items: type: array items: type: string example: 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 - - 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 - - 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 - - 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 - - 8BARHLFV3FZVGYTSJ012 - INE03Q201024 - GLS - true - true - 50 - 1752312475956 - 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 - 1769642020179 - 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 - - K0TMWRLU5HDBSNDITGWA - INE01C001018 - ADANIPORTS - true - true - 256 - 1748898675819 - 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 - 1773604877992 - 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 - 1773830433667 - 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 - 1763130929850 - 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 - 1774199712397 - 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 - - G4FILRR9JSAWETX5BFEG - INE01C001018 - ADANIPORTS - true - true - 58 - 1773283556238 - 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 - 1758080507721 - 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 - 1747474320748 - 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 - 1758132355304 - 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 - 1761069806897 - 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 - 1752202262858 - 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 - - 1JQ2PDASHYXZCVH6IFTC - INE462A01022 - BAYERCROP - true - true - 70 - 1774247525697 - 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 - - IAVLRAW3OKLIHPD0DLKQ - INE00E101023 - BIKAJI - true - true - 640 - 1751356488905 - 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 - 1768648883439 - 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 - - 7UBKDTDSUWJEWXI71MB5 - INE00E101023 - BIKAJI - true - true - 250 - 1744248500579 - 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 - 1773069853789 - 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 - - T2D14C472FNCQD8A9SEL - INE00E101023 - BIKAJI - true - true - 730 - 1758219413841 - 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 - 1768900564083 - 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 - 1756389295773 - 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: 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 - BANKNIFTY01Jun2023FUT - equity - 45 - 1711756800000 - 363.1 - buy - 51 - 98 - 75 - 55 - 32 - 219 - 11 - 142 - 55 - 36 - null - - AUGUWEK01EI4YOIMH7RK - INE519I01013 - BANKNIFTY15Jun2023FUT - equity - 50 - 1714176000000 - 363.15 - buy - 7 - 56 - 55 - 223 - 245 - 330 - 106 - 144 - 103 - 9 - null - - 55MCNYCUWJO7C3ZAXWIX - INE512D09106 - FUTCOMCRUDEOIL16OCT2022 - commodity - 100 - 1727731200000 - 415 - buy - 107 - 8 - 114 - 111 - 90 - 43 - 36 - 48 - 119 - 21 - null - - JDNI9UJFKN2PGFJZ5U9O - INE579I01014 - FUTCURUSDINR27JAN2023 - currency - 135 - 1728585600000 - 90.69 - buy - 134 - 183 - 209 - 9 - 100 - 50 - 202 - 60 - 140 - 214 - null - - 5NGIOMFGDRBG5Q8XTNBP - INE512R02109 - NIFTY23JAN2023FUT - equity - 75 - 1728412800000 - 147.89 - buy - 143 - 44 - 39 - 61 - 130 - 216 - 102 - 90 - 158 - 37 - null - - ANH3LZISNL7R8DPFNHJ0 - INE512R02109 - NIFTY23JAN2023FUT - equity - 125 - 1728979200000 - 153.89 - buy - 84 - 60 - 3 - 129 - 221 - 239 - 11 - 42 - 160 - 8 - null - - S4LOWQJP4P6SFB42C460 - INE769A01020 - FINNIFTY25JAN2023FUT - equity - 35 - 1729756800000 - 3450.67 - buy - 23 - 98 - 64 - 214 - 268 - 161 - 118 - 116 - 9 - 21 - null - - Z0FCJBWODSL8GF3KKVPY - INE563D01013 - NIFTY15JAN2023FUT - equity - 250 - 1730620800000 - 168 - buy - 27 - 73 - 8 - 224 - 284 - 306 - 42 - 111 - 5 - 17 - null - - CIKTMLOWJQLROEGJXMFF - INE118D01016 - NIFTY25JAN2023FUT - equity - 100 - 1729584000000 - 175.55 - buy - 65 - 76 - 54 - 192 - 58 - 74 - 149 - 50 - 17 - 20 - null - - NKN2PS2TJZWDA9CDP1RA - INE002A01018 - FINNIFTY15FEB2023FUT - equity - 155 - 1730707200000 - 194.9 - buy - 39 - 85 - 72 - 144 - 40 - 15 - 16 - 39 - 66 - 47 - null - - TWF45MCZTDWEWSJXU3EF - INE0C5901014 - NIFTY23FEB2023FUT - equity - 175 - 1730828800000 - 194.9 - buy - 50 - 107 - 81 - 244 - 314 - 247 - 91 - 42 - 72 - 44 - null - - 8LEGU2BN0HXVHXYBIIRZ - INE435D01014 - BANKNIFTY20MAR2023FUT - equity - 125 - 1730950400000 - 1500 - buy - 62 - 53 - 28 - 146 - 85 - 446 - 149 - 77 - 165 - 22 - null - - GB8MD1GQRMB7M3KIPYBT - INE0C5901014 - NIFTY17APR2023FUT - equity - 145 - 1731260800000 - 457.89 - buy - 131 - 77 - 80 - 49 - 161 - 373 - 17 - 130 - 77 - 16 - null - - GUEQKVCN1OGWGMPXO1WQ - INE322R01014 - FINNIFTY20MAY2023FUT - equity - 130 - 1731699200000 - 698.03 - buy - 85 - 110 - 89 - 148 - 121 - 426 - 32 - 65 - 22 - 31 - null - - JG3ZELDXI8SYG4HLXSCG - INE694N01015 - RIL15OCT2023FUT - equity - 50 - 1726963200000 - 559.39 - buy - 111 - 42 - 44 - 189 - 145 - 307 - 57 - 64 - 43 - 28 - null - - 1HLEP1MBFH5JINCYGEJB - INE197R01010 - RIL01NOV2023FUT - equity - 175 - 1728000000000 - 1000 - buy - 72 - 52 - 33 - 117 - 71 - 327 - 39 - 67 - 132 - 3 - null - - YFVS53SUIXO1FBXICSP8 - INE576G01015 - INFY30OCT2023FUT - equity - 100 - 1728518400000 - 175 - buy - 40 - 81 - 12 - 197 - 124 - 314 - 159 - 79 - 166 - 3 - null - - EGTDOZWR9NJKLHJDXYSO - INE197R01010 - RIL31OCT2023FUT - equity - 250 - 1728864000000 - 186 - buy - 150 - 2 - 17 - 244 - 29 - 366 - 100 - 41 - 15 - 36 - null - - JBJYWGG6VA3VFF3J7OWZ - INE512R01010 - INFY25OCTFUT - equity - 225 - 1729123200000 - 180 - buy - 69 - 65 - 61 - 243 - 278 - 69 - 18 - 109 - 55 - 17 - null - - 52VUZC1SJ5MW4IKAJPIA - INE512D09106 - FUTCOMCRUDEOIL16OCT2022 - commodity - 25 - 1744467694986 - 423 - sell - 106 - 107 - 78 - 45 - 79 - 100 - 14 - 58 - 70 - 85 - null - - 2FPD4QFGHO2ICG3SK0KG - INE512D09106 - FUTCOMCRUDEOIL16OCT2022 - commodity - 50 - 1728681600000 - 456 - buy - 80 - 89 - 33 - 66 - 61 - 71 - 116 - 120 - 55 - 33 - null - - XPDDDCPTROUOHFWCQH7O - INE512D09106 - FUTCOMCRUDEOIL16OCT2022 - commodity - 125 - 1768596734295 - 449 - sell - 4 - 73 - 78 - 84 - 113 - 71 - 1 - 75 - 118 - 18 - null - - KMY2EC1UMISH0BUMIEGT - INE573G07017 - FUTCOMSILVERM21Nov2022 - commodity - 50 - 1729632000000 - 135 - buy - 237 - 56 - 15 - 18 - 104 - 15 - 22 - 76 - 89 - 112 - null - - KMY2EC1UMISH0BUMIEGT - INE573G07017 - FUTCOMSILVERM21Nov2022 - commodity - 80 - 1729632000000 - 142 - buy - 188 - 53 - 11 - 89 - 31 - 92 - 119 - 77 - 58 - 6 - null - - JAWOZXSLWYKHKUWGWS6L - INE573G07017 - FUTCOMSILVERM21Nov2022 - commodity - 70 - 1771205810599 - 148 - sell - 77 - 57 - 74 - 83 - 42 - 83 - 110 - 104 - 60 - 102 - null - - JAWOZXSLWYKHKUWGWS6L - INE573G07017 - FUTCOMSILVERM21Nov2022 - commodity - 30 - 1762268156139 - 150 - sell - 187 - 112 - 77 - 67 - 93 - 19 - 84 - 19 - 54 - 47 - null - - 1AW8BG2NTK1BPSLMR0TV - INE573G07017 - FUTCOMSILVERM21Nov2022 - commodity - 140 - 1730419200000 - 137 - buy - 234 - 97 - 29 - 100 - 39 - 72 - 49 - 115 - 110 - 93 - null - - XOUZUWMHBDCRPKRGDD1Q - INE573G07017 - FUTCOMSILVERM21Nov2022 - commodity - 80 - 1751059490639 - 154 - sell - 136 - 76 - 35 - 49 - 98 - 56 - 75 - 2 - 15 - 75 - null - - XOUZUWMHBDCRPKRGDD1Q - INE573G07017 - FUTCOMSILVERM21Nov2022 - commodity - 20 - 1732060800000 - 153 - buy - 211 - 31 - 34 - 6 - 18 - 105 - 104 - 41 - 67 - 52 - null - - LAGBHUZEYUH1K2OMGP49 - INE573G07017 - FUTCOMSILVERM21Nov2022 - commodity - 130 - 1746751858366 - 156 - sell - 110 - 41 - 105 - 57 - 47 - 64 - 63 - 34 - 46 - 26 - null - - GR4XEL9XWBSYPARPT0EF - INE113J07012 - FUTCOMGOLD29OCT2023 - commodity - 55 - 1752075290423 - 124.56 - sell - 103 - 48 - 70 - 111 - 21 - 40 - 84 - 69 - 15 - 16 - null - - M5ZXEWJZFFR9DR1ECYIE - INE113J07012 - FUTCOMGOLD29OCT2023 - commodity - 55 - 1726272000000 - 121 - buy - 125 - 52 - 36 - 22 - 92 - 17 - 67 - 79 - 46 - 109 - null - - FUWODRFMJFABB1VZGX5D - INE113J07012 - FUTCOMGOLD29NOV2023 - commodity - 85 - 1728604800000 - 135 - buy - 212 - 24 - 78 - 32 - 52 - 54 - 7 - 83 - 8 - 119 - null - - XVFHRXHI6QWNJUUKBJ0J - INE113J07012 - FUTCOMGOLD29NOV2023 - commodity - 35 - 1729036800000 - 138 - buy - 25 - 89 - 59 - 114 - 63 - 56 - 108 - 2 - 64 - 35 - null - - OHNNDTMWFFACP6JQ82GM - INE113J07012 - FUTCOMGOLD29NOV2023 - commodity - 90 - 1766545293127 - 142 - sell - 108 - 57 - 19 - 77 - 25 - 94 - 115 - 78 - 71 - 117 - null - - RRCAFBZWEKTPVLYJCRB4 - INE113J07012 - FUTCOMGOLD29NOV2023 - commodity - 10 - 1767533278432 - 149 - sell - 130 - 3 - 116 - 15 - 41 - 119 - 118 - 26 - 76 - 77 - null - - JDNI9UJFKN2PGFJZ5U9O - INE579I01014 - FUTCURUSDINR27JAN2023 - currency - 145 - 1728585600000 - 87.45 - buy - 212 - 202 - 223 - 125 - 116 - 48 - 71 - 75 - 100 - 24 - null - - 4TXSMROXNCO4YKN01YBF - INE579I01014 - FUTCURUSDINR27JAN2023 - currency - 165 - 1771973461682 - 94.78 - sell - 177 - 48 - 234 - 38 - 176 - 182 - 159 - 80 - 200 - 136 - null - - D1VHUJNJ1WGO9JVCK2AZ - INE579I01014 - FUTCURUSDINR27JAN2023 - currency - 100 - 1753820344176 - 45.98 - sell - 97 - 219 - 153 - 19 - 118 - 231 - 228 - 31 - 185 - 186 - null - - D1VHUJNJ1WGO9JVCK2AZ - INE579I01014 - FUTCURUSDINR27JAN2023 - currency - 15 - 1771795091847 - 78.3 - sell - 94 - 93 - 127 - 162 - 79 - 232 - 149 - 211 - 83 - 6 - null - - UVSIUTXLTZHDRHICW9C0 - INE645F01015 - FUTCUREURINR13MAY2023 - currency - 50 - 1763676835290 - 245.78 - sell - 46 - 228 - 186 - 237 - 75 - 6 - 46 - 97 - 203 - 34 - null - - V7L7EV2WB1F06YIJSHQS - INE645F01015 - FUTCUREURINR13MAY2023 - currency - 50 - 1731174400000 - 260.7 - buy - 178 - 162 - 152 - 207 - 202 - 185 - 95 - 232 - 121 - 209 - null - - 8GTJ7JADP09KTKDPFWQJ - INE645F01015 - FUTCUREURINR13MAY2023 - currency - 145 - 1750492920896 - 278 - sell - 20 - 164 - 152 - 121 - 98 - 148 - 35 - 194 - 110 - 34 - null - - XNAQJZ3OTJFDZ2FEGVVQ - INE645F01015 - FUTCUREURINR13MAY2023 - currency - 145 - 1711756800000 - 289 - buy - 25 - 85 - 159 - 60 - 145 - 36 - 46 - 146 - 237 - 157 - null - - NU9Y7DKWYXX1B8HUGX0G - INE714H01019 - FUTCURGBPINR27OCT2023 - currency - 75 - 1725667200000 - 4500 - buy - 21 - 179 - 65 - 29 - 21 - 92 - 124 - 178 - 153 - 12 - null - - NU9Y7DKWYXX1B8HUGX0G - INE714H01019 - FUTCURGBPINR27OCT2023 - currency - 75 - 1774239395461 - 4509 - sell - 15 - 93 - 151 - 111 - 104 - 103 - 55 - 238 - 153 - 97 - null - - 7BN92HT8TUYNDOW29YPQ - INE714H01019 - FUTCURGBPINR27OCT2023 - currency - 113 - 1726185600000 - 4492.367 - buy - 57 - 230 - 240 - 67 - 116 - 76 - 6 - 3 - 169 - 150 - null - - QRJDSFMYL79ULAWADZ4C - INE714H01019 - FUTCURGBPINR27OCT2023 - currency - 60 - 1750448250099 - 4499.876 - sell - 145 - 184 - 130 - 50 - 35 - 17 - 90 - 146 - 149 - 199 - null - - FZJQJNQWOJE78OSAKILB - INE714H01019 - FUTCURGBPINR27OCT2023 - currency - 43 - 1770416893638 - 5008.596 - sell - 47 - 22 - 47 - 31 - 24 - 32 - 128 - 195 - 47 - 87 - null - - BZAB3NIFLVXCEWLNXF0C - INE632P01025 - FUTCURJPYINR24AUG2023 - currency - 120 - 1761818827953 - 345.89 - sell - 7 - 203 - 116 - 18 - 12 - 64 - 159 - 151 - 211 - 148 - null - - EUCWBOWYUQF5LLS2MG9P - INE632P01025 - FUTCURJPYINR24AUG2023 - currency - 80 - 1731788800000 - 325.67 - buy - 44 - 87 - 14 - 179 - 169 - 178 - 97 - 26 - 72 - 170 - null - - EUCWBOWYUQF5LLS2MG9P - INE632P01025 - FUTCURJPYINR24AUG2023 - currency - 30 - 1731788800000 - 319.78 - buy - 89 - 205 - 71 - 145 - 106 - 166 - 209 - 67 - 6 - 124 - null - - MUYD0KEIED2TJLMOBKEM - INE632P01025 - FUTCURJPYINR24AUG2023 - currency - 40 - 1746531637884 - 329.587 - sell - 59 - 42 - 140 - 65 - 52 - 47 - 80 - 128 - 39 - 105 - null - - DROFW5LAACDWOCFKDQET - INE914J01012 - BANKNIFTY01Jun2023FUT - equity - 45 - 1758650011897 - 450.09 - sell - 111 - 55 - 14 - 84 - 291 - 436 - 146 - 24 - 168 - 39 - null - - Y9V66LWUBLF8P2I8FDAR - INE519I01013 - BANKNIFTY15Jun2023FUT - equity - 25 - 1754476743732 - 469.22 - sell - 78 - 91 - 80 - 41 - 123 - 291 - 83 - 151 - 115 - 11 - null - - 2C7BGL8DLAEX6DMFGRTF - INE519I01013 - BANKNIFTY15Jun2023FUT - equity - 25 - 1768028851878 - 425.3 - sell - 22 - 107 - 62 - 188 - 249 - 158 - 117 - 82 - 21 - 18 - null - - CJLNLY40ORWJXUKGVC8E - INE894N01016 - NIFTY23JAN2023FUT - equity - 25 - 1770550676537 - 135.67 - sell - 69 - 101 - 25 - 74 - 90 - 300 - 128 - 21 - 56 - 3 - null - - GFHNW8Q8GH4F408UZQ0M - INE894N01017 - NIFTY23JAN2023FUT - equity - 45 - 1758588641252 - 129.89 - sell - 132 - 88 - 37 - 24 - 279 - 212 - 148 - 43 - 116 - 26 - null - - LL4ESNCPAINCWUTVOYKX - INE894N01018 - NIFTY23JAN2023FUT - equity - 50 - 1760677372383 - 147.89 - sell - 53 - 67 - 8 - 87 - 63 - 171 - 86 - 89 - 83 - 9 - null - - WI62KWVR0MYO0WXLDQ4J - INE694C01015 - NIFTY23JAN2023FUT - equity - 80 - 1764217116229 - 150 - sell - 10 - 50 - 68 - 204 - 60 - 36 - 24 - 6 - 43 - 16 - null - - IJPDDNJO9BNNH0TB9NPJ - INE769A01020 - FINNIFTY25JAN2023FUT - equity - 35 - 1769566147929 - 2568.98 - sell - 132 - 85 - 15 - 82 - 101 - 10 - 152 - 75 - 46 - 11 - null - - VLNYY0FTJTUGELL1TK8D - INE563D01013 - NIFTY15JAN2023FUT - equity - 25 - 1745530642634 - 146 - sell - 105 - 53 - 3 - 114 - 193 - 397 - 8 - 2 - 58 - 43 - null - - VLNYY0FTJTUGELL1TK8D - INE563D01013 - NIFTY15JAN2023FUT - equity - 75 - 1746317962485 - 158 - sell - 54 - 105 - 28 - 102 - 11 - 64 - 41 - 148 - 143 - 3 - null - - VY3TYTSPMWLYJQAEMGTZ - INE563D01013 - NIFTY15JAN2023FUT - equity - 150 - 1751020662630 - 255 - sell - 138 - 32 - 42 - 214 - 44 - 13 - 146 - 43 - 52 - 35 - null - - YQT2WZWDNZPPCRDSQFR9 - INE118D01016 - NIFTY25JAN2023FUT - equity - 100 - 1766329920870 - 126.78 - sell - 18 - 23 - 81 - 239 - 107 - 183 - 158 - 64 - 137 - 50 - null - - 9ZLDZGRMJBSSAIJTBTHN - INE002A01018 - FINNIFTY15FEB2023FUT - equity - 155 - 1766443698204 - 174.55 - sell - 130 - 33 - 69 - 197 - 298 - 266 - 24 - 142 - 9 - 19 - null - - RHSYRUIXEC7M4HJBK46H - INE0C5901014 - NIFTY23FEB2023FUT - equity - 55 - 1755563901129 - 174.8 - sell - 111 - 86 - 26 - 17 - 303 - 388 - 149 - 16 - 53 - 20 - null - - I3RI1TXUYSFLFU4N8IWZ - INE0C5901014 - NIFTY23FEB2023FUT - equity - 120 - 1770417584742 - 210.89 - sell - 115 - 42 - 78 - 151 - 292 - 262 - 98 - 151 - 37 - 30 - null - - BYSC5G1EPZIWIJJ6BAUB - INE435D01014 - BANKNIFTY20MAR2023FUT - equity - 125 - 1749233214203 - 615.89 - sell - 101 - 83 - 15 - 219 - 125 - 349 - 140 - 154 - 129 - 6 - null - - MWLF0LTSOJNEXKVXSGWN - INE0C5901014 - NIFTY17APR2023FUT - equity - 135 - 1762034908837 - 489.67 - sell - 132 - 94 - 74 - 184 - 190 - 173 - 30 - 72 - 61 - 48 - null - - B67GMDMHCZAHJBXKDGL0 - INE322R01014 - FINNIFTY20MAY2023FUT - equity - 120 - 1764485109621 - 745.32 - sell - 150 - 13 - 35 - 133 - 133 - 362 - 128 - 119 - 83 - 39 - null - - DEN7PSRIFMQ0VQXZF8O8 - INE694N01015 - RIL15OCT2023FUT - equity - 50 - 1764079239262 - 615.35 - sell - 99 - 59 - 84 - 104 - 322 - 159 - 92 - 122 - 136 - 15 - null - - GAVL50RNZDGGQSMMLKOF - INE576G01015 - INFY30OCT2023FUT - equity - 100 - 1749645989739 - 145 - sell - 50 - 96 - 11 - 84 - 204 - 220 - 20 - 125 - 146 - 23 - null - - BWQRBJTC2V55AFBIZPYW - INE197R01010 - RIL31OCT2023FUT - equity - 250 - 1749297629088 - 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 - BANKNIFTY01Jun2023CE44100 - equity - 25 - 1711756800000 - 363.1 - buy - 385 - 201 - 2235 - 795 - 1757 - 202 - 195 - 2060 - 2112 - 1622 - null - - Y6W9FLHOVJ8TCHHNBYGF - INE545C01013 - BANKNIFTY01Jun2023CE44200 - equity - 75 - 1714176000000 - 363.15 - buy - 2479 - 304 - 1657 - 2282 - 1170 - 172 - 1307 - 1660 - 1130 - 1106 - null - - DML3WXXE53PJOTGTEYKJ - INE512D09106 - OPTFUTCRUDEOIL16OCT20227000PE - commodity - 100 - 1727731200000 - 415 - buy - 107 - 8 - 114 - 111 - 90 - 43 - 36 - 48 - 119 - 21 - null - - GYHVDLIIXVTLROOCLVYG - INE579I01014 - OPTCURUSDINR27JAN202383PE - currency - 135 - 1728585600000 - 90.69 - buy - 134 - 183 - 209 - 9 - 100 - 50 - 202 - 60 - 140 - 214 - null - - ULDR4PE639LOMU4A4VCE - INE512R02109 - NIFTY23JAN2023CE15000 - equity - 75 - 1728412800000 - 1570 - buy - 2122 - 1793 - 1820 - 1893 - 560 - 1651 - 875 - 2161 - 32 - 1916 - null - - VIHCPUEYSZUMQUVPSJ1P - INE512R02109 - NIFTY23JAN2023CE15000 - equity - 125 - 1728979200000 - 1490 - buy - 114 - 1074 - 1522 - 44 - 1158 - 535 - 2252 - 1115 - 1171 - 2449 - null - - QOO5OYJLQBIRUMIGKCIQ - INE769A01020 - FINNIFTY25JAN2023CE12500 - equity - 50 - 1729756800000 - 3450.67 - buy - 831 - 1827 - 1117 - 1814 - 1230 - 499 - 1882 - 2344 - 457 - 1850 - null - - 2BOMU4R5WMEONKEI5YT6 - INE563D01013 - NIFTY23JAN2023CE15600 - equity - 250 - 1730620800000 - 168 - buy - 1280 - 657 - 1291 - 1139 - 636 - 2397 - 795 - 1161 - 2236 - 1620 - null - - PZUTEFRTRX9LFW9DPHAW - INE118D01016 - NIFTY23JAN2023CE15650 - equity - 100 - 1729584000000 - 175.55 - buy - 125 - 882 - 2432 - 2077 - 2189 - 2472 - 2156 - 1856 - 1068 - 2285 - null - - DIQDEZH7K04QBDCJY0NV - INE002A01018 - FINNIFTY15FEB2023CE13400 - equity - 50 - 1730707200000 - 194.9 - buy - 1645 - 1807 - 1262 - 2482 - 829 - 782 - 540 - 1000 - 354 - 2491 - null - - PGR2RDEZFVC2S3YBX1JF - INE0C5901014 - NIFTY23FEB2023PE17100 - equity - 105 - 1730828800000 - 194.9 - buy - 1760 - 1640 - 2143 - 905 - 1374 - 1714 - 842 - 1776 - 847 - 299 - null - - TFCXQ3TKQRMOHU86MXO1 - INE082B0101 - BANKNIFTY20MAR2023PE18900 - equity - 155 - 1730950400000 - 1500 - buy - 104 - 552 - 1064 - 2411 - 1835 - 2056 - 2421 - 2289 - 651 - 2315 - null - - DUYJ4ZV7OKJA8CV8U1MT - INE0C5901014 - NIFTY17APR2023PE17800 - equity - 55 - 1731260800000 - 457.89 - buy - 1766 - 2139 - 1170 - 2017 - 723 - 2101 - 1756 - 2357 - 1517 - 2394 - null - - 2GFSS7XTAHUWHFZH0NBR - INE322R01014 - FINNIFTY25MAY2023CE14900 - equity - 130 - 1731699200000 - 698.03 - buy - 682 - 2191 - 400 - 1922 - 813 - 188 - 1323 - 188 - 880 - 1267 - null - - 4AGDXGEEJOUHI6G8ATOU - INE694N01015 - RELIANCEOCT1940CE - equity - 50 - 1726963200000 - 559.39 - buy - 1244 - 2104 - 102 - 1018 - 319 - 1497 - 1669 - 2059 - 1901 - 485 - null - - AHVDFMGBCECY1IR0QDH9 - INE197R01010 - RELIANCEOCT1960CE - equity - 175 - 1728000000000 - 1000 - buy - 2181 - 2407 - 104 - 398 - 1577 - 1341 - 55 - 1215 - 1616 - 879 - null - - Q2DZQ1ITYAOXILWQLHDN - INE576G01015 - INFOSYSOCT2550CE - equity - 150 - 1728518400000 - 175 - buy - 444 - 1610 - 769 - 2289 - 1456 - 437 - 1601 - 620 - 810 - 1319 - null - - FQQ96BPTGAPAQPLMABNU - INE197R01010 - RELIANCEOCT1920CE - equity - 250 - 1728864000000 - 186 - buy - 1158 - 1954 - 1513 - 2091 - 1622 - 1175 - 383 - 2049 - 191 - 1624 - null - - RKW88OVAQVWZMCD9VLJL - INE512R01010 - INFOSYSOCT2590CE - equity - 225 - 1729123200000 - 180 - buy - 874 - 1430 - 2384 - 1648 - 1398 - 596 - 367 - 396 - 1897 - 1511 - null - - TTGYOR1EOA3SUTMNCJ58 - INE512D09106 - OPTFUTCRUDEOIL16OCT20227000PE - commodity - 25 - 1772190392277 - 423 - sell - 106 - 107 - 78 - 45 - 79 - 100 - 14 - 58 - 70 - 85 - null - - MYOFOBCC5W0PCWHVBFPU - INE512D09106 - OPTFUTCRUDEOIL16OCT20227000PE - commodity - 50 - 1728681600000 - 456 - buy - 80 - 89 - 33 - 66 - 61 - 71 - 116 - 120 - 55 - 33 - null - - VIX3TEN3GZKPVY2WZCEX - INE512D09106 - OPTFUTCRUDEOIL16OCT20227000PE - commodity - 125 - 1753322058310 - 449 - sell - 4 - 73 - 78 - 84 - 113 - 71 - 1 - 75 - 118 - 18 - null - - Q5CUBQ2P6B7VKNHCKWD6 - INE573G07017 - OPTFUTSILVERM21Nov202258000PE - commodity - 50 - 1729632000000 - 135 - buy - 237 - 56 - 15 - 18 - 104 - 15 - 22 - 76 - 89 - 112 - null - - Q5CUBQ2P6B7VKNHCKWD6 - INE573G07017 - OPTFUTSILVERM21Nov202258000PE - commodity - 80 - 1729632000000 - 142 - buy - 188 - 53 - 11 - 89 - 31 - 92 - 119 - 77 - 58 - 6 - null - - DTXGC9I0ZVOI2FFSHIOL - INE573G07017 - OPTFUTSILVERM21Nov202258000PE - commodity - 70 - 1749669372484 - 148 - sell - 77 - 57 - 74 - 83 - 42 - 83 - 110 - 104 - 60 - 102 - null - - DTXGC9I0ZVOI2FFSHIOL - INE573G07017 - OPTFUTSILVERM21Nov202258000PE - commodity - 30 - 1754867768752 - 150 - sell - 187 - 112 - 77 - 67 - 93 - 19 - 84 - 19 - 54 - 47 - null - - IU0HYP6ZN9EOERPBEWYA - INE573G07017 - OPTFUTSILVERM21Nov202258000PE - commodity - 140 - 1730419200000 - 137 - buy - 234 - 97 - 29 - 100 - 39 - 72 - 49 - 115 - 110 - 93 - null - - TAODZZPWWR9R5CO1QX0R - INE573G07017 - OPTFUTSILVERM21Nov202258000PE - commodity - 80 - 1760702830207 - 154 - sell - 136 - 76 - 35 - 49 - 98 - 56 - 75 - 2 - 15 - 75 - null - - TAODZZPWWR9R5CO1QX0R - INE573G07017 - OPTFUTSILVERM21Nov202258000PE - commodity - 20 - 1732060800000 - 153 - buy - 211 - 31 - 34 - 6 - 18 - 105 - 104 - 41 - 67 - 52 - null - - HVG5B4A45J9CL4CZ35TF - INE573G07017 - OPTFUTSILVERM21Nov202258000PE - commodity - 130 - 1747648985500 - 156 - sell - 110 - 41 - 105 - 57 - 47 - 64 - 63 - 34 - 46 - 26 - null - - CJ7UKXJFK6WDVAUWGXGW - INE113J07012 - OPTFUTGOLD29OCT202360000PE - commodity - 55 - 1755112457295 - 124.56 - sell - 103 - 48 - 70 - 111 - 21 - 40 - 84 - 69 - 15 - 16 - null - - EAU3BEIXICIMKLVWWU56 - INE113J07012 - OPTFUTGOLD29OCT202360000PE - commodity - 55 - 1726272000000 - 121 - buy - 125 - 52 - 36 - 22 - 92 - 17 - 67 - 79 - 46 - 109 - null - - OJDZI0SB29R3RMHWOG8P - INE113J07012 - OPTFUTGOLD29NOV202361000PE - commodity - 85 - 1728604800000 - 135 - buy - 212 - 24 - 78 - 32 - 52 - 54 - 7 - 83 - 8 - 119 - null - - DOHDNKFFITQRMFUYKQLE - INE113J07012 - OPTFUTGOLD29NOV202361000PE - commodity - 35 - 1729036800000 - 138 - buy - 25 - 89 - 59 - 114 - 63 - 56 - 108 - 2 - 64 - 35 - null - - CVWO1J0HIG9QEY5UVUDQ - INE113J07012 - OPTFUTGOLD29NOV202361000PE - commodity - 90 - 1767082414482 - 142 - sell - 108 - 57 - 19 - 77 - 25 - 94 - 115 - 78 - 71 - 117 - null - - R2K5E791EH5VAQZVOETW - INE113J07012 - OPTFUTGOLD29NOV202361000PE - commodity - 10 - 1756305421265 - 149 - sell - 130 - 3 - 116 - 15 - 41 - 119 - 118 - 26 - 76 - 77 - null - - GYHVDLIIXVTLROOCLVYG - INE579I01014 - OPTCURUSDINR27JAN202383PE - currency - 145 - 1728585600000 - 87.45 - buy - 212 - 202 - 223 - 125 - 116 - 48 - 71 - 75 - 100 - 24 - null - - 8VMAOKSBFKXAX1Z75UK5 - INE579I01014 - OPTCURUSDINR27JAN202383PE - currency - 165 - 1744956653918 - 94.78 - sell - 177 - 48 - 234 - 38 - 176 - 182 - 159 - 80 - 200 - 136 - null - - ZXORPEEJE7TVFBPXQ8LI - INE579I01014 - OPTCURUSDINR27JAN202383PE - currency - 100 - 1756783227749 - 45.98 - sell - 97 - 219 - 153 - 19 - 118 - 231 - 228 - 31 - 185 - 186 - null - - ZXORPEEJE7TVFBPXQ8LI - INE579I01014 - OPTCURUSDINR27JAN202383PE - currency - 15 - 1745656580011 - 78.3 - sell - 94 - 93 - 127 - 162 - 79 - 232 - 149 - 211 - 83 - 6 - null - - 6MDVYEYUKHJXIQSGEOPU - INE645F01015 - OPTCUREURINR13MAY202394CE - currency - 50 - 1773690786760 - 245.78 - sell - 46 - 228 - 186 - 237 - 75 - 6 - 46 - 97 - 203 - 34 - null - - CPYBETZOWLDVTAYF3PRA - INE645F01015 - OPTCUREURINR13MAY202394CE - currency - 50 - 1731174400000 - 260.7 - buy - 178 - 162 - 152 - 207 - 202 - 185 - 95 - 232 - 121 - 209 - null - - MEHVXLLGPB5SODCHL5PT - INE645F01015 - OPTCUREURINR13MAY202394CE - currency - 145 - 1767623346855 - 278 - sell - 20 - 164 - 152 - 121 - 98 - 148 - 35 - 194 - 110 - 34 - null - - UQCTRKWJRKXVR7LSIBCN - INE645F01015 - OPTCUREURINR13MAY202394CE - currency - 145 - 1711756800000 - 289 - buy - 25 - 85 - 159 - 60 - 145 - 36 - 46 - 146 - 237 - 157 - null - - PIN8G2M1QKXY1FQZPRIF - INE714H01019 - OPTCURGBPINR27OCT2023115PE - currency - 75 - 1725667200000 - 4500 - buy - 21 - 179 - 65 - 29 - 21 - 92 - 124 - 178 - 153 - 12 - null - - PIN8G2M1QKXY1FQZPRIF - INE714H01019 - OPTCURGBPINR27OCT2023115PE - currency - 75 - 1761192677238 - 4509 - sell - 15 - 93 - 151 - 111 - 104 - 103 - 55 - 238 - 153 - 97 - null - - 69WJ3BI70HPVKNLEK5TR - INE714H01019 - OPTCURGBPINR27OCT2023115PE - currency - 113 - 1726185600000 - 4492.367 - buy - 57 - 230 - 240 - 67 - 116 - 76 - 6 - 3 - 169 - 150 - null - - P534DDQESQ6XNTI4NURV - INE714H01019 - OPTCURGBPINR27OCT2023115PE - currency - 60 - 1769948168912 - 4499.876 - sell - 145 - 184 - 130 - 50 - 35 - 17 - 90 - 146 - 149 - 199 - null - - OXGR4W3D3MYYBURZOEJ5 - INE714H01019 - OPTCURGBPINR27OCT2023115PE - currency - 43 - 1746712233880 - 5008.596 - sell - 47 - 22 - 47 - 31 - 24 - 32 - 128 - 195 - 47 - 87 - null - - T6B8078DHAC9MGWPKR6B - INE632P01025 - OPTCURJPYINR24AUG202345.6CE - currency - 120 - 1756408554558 - 345.89 - sell - 7 - 203 - 116 - 18 - 12 - 64 - 159 - 151 - 211 - 148 - null - - OFAILEZLEAPD9SU5ZOMT - INE632P01025 - OPTCURJPYINR24AUG202345.6CE - currency - 80 - 1731788800000 - 325.67 - buy - 44 - 87 - 14 - 179 - 169 - 178 - 97 - 26 - 72 - 170 - null - - OFAILEZLHKPD8SU7ZOMT - INE632P01025 - OPTCURJPYINR24AUG202345.6CE - currency - 30 - 1731788800000 - 319.78 - buy - 89 - 205 - 71 - 145 - 106 - 166 - 209 - 67 - 6 - 124 - null - - FDIT8EQR2XJFQJU2JLIG - INE632P01025 - OPTCURJPYINR24AUG202345.6CE - currency - 40 - 1745008531011 - 329.587 - sell - 59 - 42 - 140 - 65 - 52 - 47 - 80 - 128 - 39 - 105 - null - - KLPAV9GOUCMPFH1WNKLV - INE619I01012 - BANKNIFTY01Jun2023CE44100 - equity - 25 - 1743718310553 - 450.09 - sell - 1657 - 1302 - 325 - 2118 - 2050 - 604 - 2148 - 626 - 1489 - 2090 - null - - 0WNSDPGK4LTXO38HPTLU - INE545C01013 - BANKNIFTY01Jun2023CE44200 - equity - 25 - 1751163508968 - 469.22 - sell - 1711 - 1948 - 2048 - 700 - 2360 - 120 - 2415 - 333 - 2231 - 736 - null - - QS2KFCND5DJXRNDLLVHD - INE545C01013 - BANKNIFTY01Jun2023CE44200 - equity - 50 - 1761590934853 - 425.3 - sell - 320 - 375 - 82 - 1593 - 1653 - 620 - 1637 - 712 - 542 - 130 - null - - 0B3PIU4WMIPKUQEG34BO - INE512R02109 - NIFTY23JAN2023CE15000 - equity - 25 - 1744864470570 - 1460 - sell - 499 - 2262 - 2210 - 507 - 256 - 2293 - 1125 - 2345 - 1852 - 90 - null - - S7XOLPIQ2V4R5L89ZEE1 - INE512R02109 - NIFTY23JAN2023CE15000 - equity - 45 - 1771172357246 - 1508 - sell - 1784 - 825 - 2087 - 498 - 666 - 616 - 1994 - 763 - 157 - 2380 - null - - HSZA8B3XH3JC2POXMSXJ - INE512R02109 - NIFTY23JAN2023CE15000 - equity - 50 - 1749700715623 - 1585 - sell - 335 - 1434 - 254 - 1609 - 999 - 1979 - 2229 - 127 - 389 - 1244 - null - - ILKEYGKTOHFQI5UXMBOO - INE512R02109 - NIFTY23JAN2023CE15000 - equity - 80 - 1764221232709 - 1635 - sell - 208 - 535 - 279 - 401 - 2010 - 248 - 494 - 746 - 2399 - 1196 - null - - A9HFP9X49AROF21K9KRY - INE769A01020 - FINNIFTY25JAN2023CE12500 - equity - 50 - 1763440981795 - 2568.98 - sell - 319 - 59 - 25 - 2409 - 2339 - 423 - 132 - 250 - 2137 - 2442 - null - - GHQTIWHDAFE90NOAU6ZY - INE563D01013 - NIFTY23JAN2023CE15600 - equity - 25 - 1771143409491 - 146 - sell - 1525 - 678 - 749 - 379 - 277 - 1791 - 2288 - 545 - 1042 - 327 - null - - GHQTIWHDAFE90NOAU6ZY - INE563D01013 - NIFTY23JAN2023CE15600 - equity - 75 - 1774573228486 - 158 - sell - 1761 - 2349 - 1082 - 2181 - 1054 - 1396 - 856 - 1220 - 1740 - 1791 - null - - IXMBK9LENH6CSGULION2 - INE563D01013 - NIFTY23JAN2023CE15600 - equity - 150 - 1761215243037 - 255 - sell - 2369 - 875 - 2202 - 2488 - 1574 - 404 - 532 - 779 - 2266 - 1396 - null - - BEZ31FONIR1EQQI68F0Y - INE118D01016 - NIFTY23JAN2023CE15650 - equity - 100 - 1744194826996 - 126.78 - sell - 288 - 7 - 2495 - 1391 - 1859 - 28 - 1298 - 355 - 1234 - 1955 - null - - HMC8SXGWGNGWUTFBYRHX - INE002A01018 - FINNIFTY15FEB2023CE13400 - equity - 50 - 1772245765781 - 174.55 - sell - 879 - 2335 - 1905 - 1798 - 456 - 1765 - 358 - 1368 - 1124 - 1040 - null - - KQDQ54GEHLHTIUSPGAV6 - INE0C5901014 - NIFTY23FEB2023PE17100 - equity - 55 - 1750835577853 - 174.8 - sell - 181 - 764 - 1349 - 1121 - 2195 - 2042 - 1398 - 1674 - 164 - 2244 - null - - SLB3JNRIBXSZWLRWP8ZZ - INE0C5901014 - NIFTY23FEB2023PE17100 - equity - 50 - 1773265720214 - 210.89 - sell - 77 - 713 - 1563 - 1666 - 1745 - 20 - 528 - 2500 - 1068 - 2008 - null - - LMQI22RLLZHQ5CWBGFYP - INE082B0101 - BANKNIFTY20MAR2023PE18900 - equity - 155 - 1744940811350 - 615.89 - sell - 1842 - 519 - 2150 - 997 - 536 - 1241 - 2437 - 765 - 2481 - 2126 - null - - 71ZRU28BNR9F5FMOZS8V - INE0C5901014 - NIFTY17APR2023PE17800 - equity - 55 - 1746783362527 - 489.67 - sell - 1519 - 340 - 2379 - 190 - 164 - 2420 - 662 - 226 - 1681 - 722 - null - - PHGLBJWZZLIDKTTVLNQE - INE322R01014 - FINNIFTY25MAY2023CE14900 - equity - 120 - 1759417387455 - 745.32 - sell - 820 - 1114 - 2137 - 646 - 2399 - 2314 - 160 - 1817 - 2092 - 283 - null - - SEZD4CXXIXJ79ZS0GUQ2 - INE694N01015 - RELIANCEOCT1940CE - equity - 50 - 1770860977415 - 615.35 - sell - 1797 - 249 - 1653 - 2028 - 897 - 542 - 1158 - 2067 - 964 - 1393 - null - - UESSXHU0UHWCRJ1Z7LJR - INE576G01015 - INFOSYSOCT2550CE - equity - 150 - 1773024954910 - 145 - sell - 1204 - 722 - 1103 - 2190 - 1165 - 1168 - 597 - 1485 - 1127 - 1175 - null - - TVSWJDGSX7VFVHA2AUXG - INE197R01010 - RELIANCEOCT1920CE - equity - 250 - 1752759372785 - 199 - sell - 267 - 1371 - 436 - 2246 - 1747 - 765 - 1306 - 1279 - 1236 - 1962 - null - name: mutual_fund_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 - HDFCCREDITRISKDEBTFUND-DIRECTPLAN - debt - true - true - 32.31 - 1525824000000 - 50 - buy - 400 - 10 - null - - BVNCH72LKDQY9RRINTGH - INF251K01NO3 - BNPPARIBASLIQUIDFUND-DIRECTPLAN - debt - true - true - 37.216 - 1589414400000 - 10 - buy - 0 - 98 - null - - BNG57MYGKDQY9RRINTGH - INF277K01YE6 - TATALIQUIDFUND-DIRECTPLAN - debt - true - true - 19.574 - 1515456000000 - 120 - buy - 5 - 78 - null - - GJK45MYGKDQY9RRINTGH - INF278A06YE8 - AdityaBirlaSunLifeMediumTermDirectPlanGrowth - debt - true - true - 36.023 - 1493769600000 - 30 - buy - 10 - 68 - null - - GHL909MYGKDQY9RRINTGH - INF200K01UT4 - SBILIQUIDFUND-DIRECTPLAN - other - true - true - 35.014 - 1437177600000 - 15 - buy - 17 - 67 - null - - BHMGP79GKDQY9RRINTGH - INF200K01189 - SBIGoldFund - other - true - true - 35.706 - 1626739200000 - 60 - buy - 65 - 30 - null - - BLKMN98HJNMDQY9RRINTGH - INF200K01189 - SBIGoldFund - other - true - true - 36.062 - 1563667200000 - 60 - buy - 120 - 50 - null - - MJK88MYGKDQY9RRINTGH - INF109KB1GK2 - ICICIPrudentialCommodityFund - other - true - true - 35.039 - 1626912000000 - 400.784 - buy - 200 - 20 - null - - GMFCH72LKDQY9RRINTGH - INF179KB1HP9 - HDFCLIQUIDFUND-DIRECTPLAN - equity - true - true - 25.68 - 1556409600000 - 459 - buy - 220 - 0.25 - null - - GGFCHMYLKDQY9RRINTGH - INF846K01DI2 - AxisBluechipFund - equity - true - true - 105.56 - 1491436800000 - 123 - buy - 20 - 25 - null - - GGFCHMYLKDQY9RRINTGH - INF846K01DI2 - AxisBluechipFund - equity - true - true - 550.34 - 1491436800000 - 124.5 - buy - 20 - 49 - null - - DFGR59NOHJDQ751TINTJK - INF179K01PT5 - HDFCSmallCapFund - equity - true - true - 129 - 1733760000000 - 150 - buy - 100 - 32 - null - - DFGR59NOHJDQ751TINTJK - INF179K01PT5 - HDFCSmallCapFund - equity - true - true - 100 - 1733760000000 - 250 - buy - 100 - 56 - null - - GHNR59NOHJDQ901TINTLK - INF200K01OR6 - SBIMagnumMulticapFund - equity - true - true - 156.78 - 1481500800000 - 150 - buy - 160 - 22 - null - - KNT59NOGKDQY897TINFTR - INF760K01FR2 - CanaraRobecoBluechipEquityGrowthDirectPlan - equity - true - true - 155 - 1576022400000 - 23.78 - buy - 25 - 2 - null - - HJM98MYGKDQY9RRINGFB - INF200K01189 - SBIGoldFund - other - true - true - 35 - 1374624000000 - 200 - buy - 180 - 589 - null - - JMCU8MYGKDQY9RRINTGH - INF200K01189 - SBIGoldFund - other - true - true - 35 - 1585008000000 - 230 - buy - 180 - 37 - null - - GHN78NOGKDQY9YTINFGHY - INF200K01190 - KOTAKSECFUND - equity - true - true - 50 - 1633564800000 - 980 - buy - 800 - 145 - null - - XCT59NOGKDQY9YTINFGRN - INF200K01190 - KOTAKSECFUND - equity - true - true - 40 - 1639872000000 - 1000 - buy - 800 - 198 - null - - KGFCH72LKDQY9RRINTGH - INE397D01024 - HDFCCREDITRISKDEBTFUND-DIRECTPLAN - debt - true - true - 32.31 - 1758159468004 - 900 - sell - 1000 - 89.658 - null - - KHF78MYGKDQY9RRINTGH - INF251K01NO3 - BNPPARIBASLIQUIDFUND-DIRECTPLAN - debt - true - true - 17.823 - 1766811844423 - 5 - sell - 0 - 20 - null - - GHN78MYGKDQY9RRINTGH - INF277K01YE6 - TATALIQUIDFUND-DIRECTPLAN - debt - true - true - 36.711 - 1758442592259 - 160 - sell - 5 - 33.24 - null - - BHM88MYGKDQY9RRINTGH - INF278A06YE8 - AdityaBirlaSunLifeMediumTermDirectPlanGrowth - debt - true - true - 36.023 - 1761533937248 - 60 - sell - 10 - 100 - null - - BHM88MTYH6QY9RRINTGH - INF200K01UT4 - SBILIQUIDFUND-DIRECTPLAN - other - true - true - 19.88 - 1768826225992 - 60 - sell - 17 - 10 - null - - CVH78MYGKDQY9RRINTGH - INF109KB1GK2 - ICICIPrudentialCommodityFund - other - true - true - 32.531 - 1771469391914 - 200 - sell - 200 - 90 - null - - GMFCH72LKDQY9RRINTGH - INF179KB1HP9 - HDFCLIQUIDFUND-DIRECTPLAN - equity - true - true - 25.68 - 1774298905737 - 500 - sell - 220 - 50 - null - - JHF78MYGKDQY9RRINTGH - INF846K01DI2 - AxisBluechipFund - equity - true - true - 355.9 - 1747475787479 - 212.7 - sell - 20 - 28 - null - - JTR59NOGKDQY9YTINTGH - INF846K01DI2 - AxisBluechipFund - equity - true - true - 250 - 1749834306150 - 209 - sell - 20 - 75 - null - - HNT59NOGKDQY897TINF4R - INF200K01OR6 - SBIMagnumMulticapFund - equity - true - true - 125 - 1750955038501 - 400 - sell - 160 - 89.658 - null - - HYT59NOGKDQY9YTINFGRN - INF760K01FR2 - CanaraRobecoBluechipEquityGrowthDirectPlan - equity - true - true - 155 - 1774141921111 - 56.9 - sell - 45 - 2 - null - - RTV678MYGKDQY9RRINTGH - INF200K01189 - SBIGoldFund - other - true - true - 55 - 1744528138656 - 210 - sell - 180 - 56 - null - - VBN59NOGKDQY9YTINFGRN - INF200K01190 - KOTAKSECFUND - equity - true - true - 40 - 1763070425482 - 1200 - sell - 800 - 230 - null - - 67859NOGKDQY9YTINFGRN - INF200K01190 - KOTAKSECFUND - equity - true - true - 50 - 1763186904766 - 1300 - sell - 800 - 245 - null - name: etf_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: - - BVNCH72LKDQY9RRINTGH - INF251K01NO3 - BNPPARIBASLIQUIDFUND-DIRECTPLAN - debt - true - true - 31.536 - 1723132800000 - 10 - buy - 340 - 92 - 34 - 93 - 139 - 17 - 3 - 68 - 61 - 48 - 109 - null - delivery - - BNG57MYGKDQY9RRINTGH - INF277K01YE6 - TATALIQUIDFUND-DIRECTPLAN - debt - true - true - 80 - 1568160000000 - 120 - buy - 250 - 127 - 17 - 108 - 1 - 26 - 75 - 33 - 126 - 113 - 56 - null - delivery - - BHM88MYGKDQY9RRINTGH - INF278A06YE8 - AdityaBirlaSunLifeMediumTermDirectPlanGrowth - debt - true - true - 100 - 1740336000000 - 60 - buy - 10 - 88 - 62 - 132 - 43 - 111 - 35 - 4 - 113 - 61 - 3 - null - delivery - - BLKMN98HJNMDQY9RRINTGH - INF200K01189 - SBIGoldFund - other - true - true - 50 - 1641427200000 - 120.5877 - buy - 65 - 28 - 17 - 52 - 65 - 13 - 40 - 13 - 40 - 40 - 28 - null - delivery - - MJK88MYGKDQY9RRINTGH - INF109KB1GK2 - ICICIPrudentialCommodityFund - other - true - true - 150 - 1627862400000 - 400.784 - buy - 200 - 77 - 59 - 77 - 12 - 5 - 2 - 7 - 10 - 5 - 30 - null - delivery - - JNV5CHMYLKDQY9RRINTG - INF846K01DI2 - AxisBluechipFund - equity - true - true - 78 - 1589414400000 - 23 - buy - 20 - 106 - 17 - 123 - 61 - 31 - 105 - 24 - 117 - 16 - 62 - null - delivery - - PKF88MYGKDQY9RRINTGH - INF179K01PT5 - HDFCSmallCapFund - equity - true - true - 90 - 1515456000000 - 150 - buy - 100 - 92 - 43 - 29 - 90 - 64 - 70 - 66 - 51 - 112 - 117 - null - delivery - - DFGR59NOHJDQ751TINTJK - INF200K01OR6 - SBIMagnumMulticapFund - equity - true - true - 95 - 1493769600000 - 150 - buy - 160 - 107 - 98 - 49 - 143 - 53 - 73 - 107 - 52 - 75 - 56 - null - delivery - - DFGR59NOHJDQ751TINTJK - INF200K01OR6 - SBIMagnumMulticapFund - equity - true - true - 50 - 1493769600000 - 400 - buy - 160 - 9 - 60 - 101 - 40 - 146 - 3 - 23 - 125 - 139 - 82 - null - delivery - - HJM98MYGKDQY9RRINGFB - INF179KB1QR8 - ICICILIQUIDFUND-DIRECTPLAN - equity - true - true - 75 - 1721664000000 - 150 - buy - 300 - 61 - 16 - 25 - 121 - 50 - 103 - 148 - 33 - 75 - 7 - null - delivery - - KHF78MYGKDQY9RRINTGH - INF251K01NO3 - BNPPARIBASLIQUIDFUND-DIRECTPLAN - debt - true - true - 31.536 - 1748590909274 - 5 - sell - 340 - 134 - 111 - 2 - 96 - 29 - 36 - 128 - 104 - 94 - 101 - null - delivery - - GHN78MYGKDQY9RRINTGH - INF277K01YE6 - TATALIQUIDFUND-DIRECTPLAN - debt - true - true - 60 - 1756246804345 - 160 - sell - 250 - 60 - 140 - 15 - 119 - 139 - 13 - 18 - 106 - 10 - 58 - null - delivery - - GJK45MYGKDQY9RRINTGH - INF278A06YE8 - AdityaBirlaSunLifeMediumTermDirectPlanGrowth - debt - true - true - 100 - 1774372623141 - 30 - sell - 10 - 123 - 38 - 8 - 101 - 111 - 99 - 103 - 89 - 43 - 11 - null - delivery - - BHMGP79GKDQY9RRINTGH - INF200K01189 - SBIGoldFund - other - true - true - 50 - 1756191021653 - 60 - sell - 65 - 43 - 59 - 55 - 9 - 45 - 50 - 10 - 17 - 39 - 22 - null - delivery - - CVH78MYGKDQY9RRINTGH - INF109KB1GK2 - ICICIPrudentialCommodityFund - other - true - true - 100 - 1760828890202 - 200 - sell - 200 - 72 - 24 - 22 - 18 - 57 - 14 - 17 - 54 - 32 - 50 - null - delivery - - GGFCHMYLKDQY9RRINTGH - INF846K01DI2 - AxisBluechipFund - equity - true - true - 78 - 1754178413427 - 88 - sell - 20 - 79 - 35 - 65 - 99 - 120 - 146 - 115 - 90 - 100 - 93 - null - delivery - - PKF88MYGKDQY9RRINTGH - INF179K01PT5 - HDFCSmallCapFund - equity - true - true - 90 - 1769189188159 - 250 - sell - 100 - 95 - 105 - 55 - 104 - 39 - 74 - 23 - 26 - 42 - 142 - null - delivery - - GHNR59NOHJDQ901TINTLK - INF200K01OR6 - SBIMagnumMulticapFund - equity - true - true - 30 - 1771331886011 - 450 - sell - 160 - 4 - 82 - 120 - 71 - 34 - 38 - 45 - 2 - 67 - 98 - null - delivery - - HNT59NOGKDQY897TINF4R - INF200K01OR6 - SBIMagnumMulticapFund - equity - true - true - 80 - 1767442617551 - 500 - sell - 160 - 36 - 36 - 69 - 74 - 139 - 57 - 75 - 81 - 118 - 149 - null - delivery - - KNT59NOGKDQY897TINFTR - INF200K01OR6 - SBIMagnumMulticapFund - equity - true - true - 10 - 1757525424323 - 10 - sell - 160 - 57 - 141 - 136 - 4 - 44 - 47 - 7 - 119 - 105 - 138 - null - delivery - - HYT59NOGKDQY9YTINFGRN - INF200K01OR6 - SBIMagnumMulticapFund - equity - true - true - 10 - 1757470844896 - 50 - sell - 160 - 84 - 38 - 123 - 61 - 19 - 8 - 58 - 18 - 145 - 85 - null - delivery - name: bond_sheet '@entity': sheet blocks: - name: bond_tradebook_table '@entity': table header: - trade_id - isin - security_name - is_listed - is_stt_paid - 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: - - TGFCH72LKDQY9RRINTGH - INE261F07032 - 07.64%NABARDTFB2031 - true - true - 500 - 1738694400000 - 10 - buy - 31 - 50 - 13 - 3 - 23 - 115 - 100 - 109 - 56 - 8 - null - - KGFCH72LKDQY9RRINTGH - INE261F07032 - 07.64%NABARDTFB2031 - true - true - 500 - 1741113600000 - 10 - buy - 121 - 112 - 21 - 98 - 33 - 33 - 113 - 104 - 98 - 61 - null - - BVNCH72LKDQY9RRINTGH - INE272F07011 - BlueDartExpress - true - true - 50 - 1730832000000 - 20 - buy - 35 - 112 - 55 - 9 - 67 - 13 - 41 - 75 - 37 - 5 - null - - BNG57MYGKDQY9RRINTGH - INE112J07020 - IFCI - true - true - 200 - 1733414400000 - 16.55 - buy - 78 - 26 - 27 - 16 - 23 - 60 - 45 - 87 - 118 - 84 - null - - GJK45MYGKDQY9RRINTGH - INE130K08000 - SBOX - false - false - 200 - 1735574400000 - 16.55 - buy - 60 - 16 - 109 - 81 - 0 - 80 - 114 - 63 - 119 - 84 - null - - GHL909MYGKDQY9RRINTGH - INE130K08001 - QCK - false - false - 200 - 1633996800000 - 16.55 - buy - 43 - 127 - 37 - 52 - 0 - 86 - 116 - 46 - 118 - 84 - null - - BHMGP79GKDQY9RRINTGH - INE130K08012 - GGL - true - true - 200 - 1585008000000 - 550 - buy - 87 - 21 - 50 - 5 - 23 - 71 - 37 - 22 - 81 - 106 - null - - MJK88MYGKDQY9RRINTGH - INE130K08019 - APPL - false - false - 200 - 1633564800000 - 350 - buy - 114 - 12 - 100 - 114 - 0 - 51 - 15 - 37 - 44 - 108 - null - - GGFCHMYLKDQY9RRINTGH - INE261F07055 - SGB - true - true - 500 - 1437177600000 - 488 - buy - 95 - 69 - 57 - 104 - 67 - 77 - 41 - 38 - 28 - 101 - null - - GGFCHMYLKDQY9RRINTGH - INE261F07055 - SGB - true - true - 500 - 1626652800000 - 322 - buy - 22 - 51 - 38 - 76 - 12 - 101 - 87 - 53 - 77 - 4 - null - - JHF78MYGKDQY9RRINTGH - INE261F07055 - SGB - true - true - 100 - 1626739200000 - 350 - buy - 11 - 26 - 86 - 34 - 23 - 107 - 43 - 1 - 101 - 6 - null - - KHF78MYGKDQY9RRINTGH - INE272F07011 - BlueDartExpress - true - true - 20 - 1772737689039 - 200 - sell - 108 - 4 - 102 - 57 - 33 - 11 - 105 - 16 - 56 - 86 - null - - GHN78MYGKDQY9RRINTGH - INE112J07020 - IFCI - true - true - 170 - 1768142143586 - 500 - sell - 71 - 109 - 99 - 30 - 67 - 11 - 126 - 102 - 18 - 24 - null - - BHM88MYGKDQY9RRINTGH - INE130K08000 - SBOX - false - false - 170 - 1747811650141 - 500 - sell - 78 - 99 - 8 - 16 - 0 - 9 - 102 - 63 - 100 - 31 - null - - BHM88MTYH6QY9RRINTGH - INE130K08001 - QCK - false - false - 200 - 1772784887881 - 500 - sell - 48 - 128 - 1 - 120 - 0 - 112 - 20 - 79 - 115 - 74 - null - - BLKMN98HJNMDQY9RRINTGH - INE130K08015 - GGL - true - true - 200 - 1760544844289 - 600 - sell - 37 - 85 - 53 - 113 - 67 - 102 - 42 - 48 - 31 - 15 - null - - CVH78MYGKDQY9RRINTGH - INE130K08019 - APPL - false - false - 180 - 1772665028030 - 310 - sell - 112 - 109 - 45 - 32 - 0 - 49 - 53 - 47 - 124 - 111 - null - - GMFCH72LKDQY9RRINTGH - INE261F07032 - 07.64%NABARDTFB2031 - true - true - 500 - 1748478931773 - 125 - sell - 15 - 26 - 86 - 64 - 33 - 56 - 26 - 30 - 21 - 125 - null - - GMFCH72LKDQY9RRINTGH - INE261F07032 - 07.64%NABARDTFB2031 - true - true - 500 - 1750415876039 - 125 - sell - 76 - 101 - 104 - 28 - 67 - 127 - 21 - 26 - 88 - 70 - null - - JTR59NOGKDQY9YTINTGH - INE261F07055 - SGB - true - true - 550 - 1761741616537 - 350 - sell - 107 - 97 - 94 - 49 - 12 - 49 - 9 - 112 - 69 - 129 - null - - DFGR59NOHJDQ751TINTJK - INE261F07055 - SGB - true - true - 50 - 1762949787971 - 400 - sell - 80 - 10 - 130 - 58 - 44 - 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 - is_stt_paid - 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 - INE261F07032 - 07.64%NABARDTFB2031 - true - true - 1000 - 1525824000000 - 10 - buy - 177 - 180 - 238 - 105 - 105 - 243 - 101 - 131 - 187 - 104 - null - - DML3WXXE53PJOTGTEYKJ - INE272F07011 - BlueDartExpress - true - true - 50 - 1589414400000 - 20 - buy - 61 - 48 - 59 - 117 - 117 - 236 - 125 - 232 - 240 - 106 - null - - ULDR4PE639LOMU4A4VCE - INE112J07020 - IFCI - true - true - 200 - 1515456000000 - 16.55 - buy - 74 - 176 - 232 - 177 - 177 - 230 - 53 - 210 - 110 - 125 - null - - QOO5OYJLQBIRUMIGKCIQ - INE130K08000 - SBOX - false - false - 200 - 1493769600000 - 16.55 - buy - 108 - 88 - 142 - 17 - 0 - 130 - 214 - 66 - 207 - 179 - null - - PZUTEFRTRX9LFW9DPHAW - INE130K08001 - QCK - false - false - 200 - 1437177600000 - 16.55 - buy - 133 - 242 - 225 - 166 - 0 - 45 - 232 - 127 - 64 - 210 - null - - PGR2RDEZFVC2S3YBX1JF - INE130K08012 - GGL - true - true - 200 - 1626739200000 - 550 - buy - 157 - 86 - 208 - 79 - 79 - 180 - 94 - 158 - 38 - 191 - null - - DUYJ4ZV7OKJA8CV8U1MT - INE130K08019 - APPL - false - false - 200 - 1626912000000 - 350 - buy - 215 - 228 - 8 - 98 - 0 - 119 - 44 - 185 - 50 - 154 - null - - 4AGDXGEEJOUHI6G8ATOU - INE261F07055 - SGB - true - true - 500 - 1556409600000 - 600 - buy - 220 - 239 - 134 - 180 - 180 - 58 - 131 - 160 - 117 - 207 - null - - AHVDFMGBCECY1IR0QDH9 - INE261F07055 - SGB - true - true - 500 - 1556409600000 - 764 - buy - 159 - 38 - 58 - 8 - 8 - 34 - 12 - 202 - 103 - 31 - null - - Q2DZQ1ITYAOXILWQLHDN - INE261F07055 - SGB - true - true - 100 - 1491436800000 - 890 - buy - 189 - 118 - 196 - 90 - 90 - 161 - 199 - 36 - 138 - 50 - null - - Y6W9FLHOVJ8TCHHNBYGF - INE261F07032 - 07.64%NABARDTFB2031 - true - true - 1000 - 1764583887544 - 10 - sell - 224 - 48 - 219 - 210 - 210 - 51 - 234 - 197 - 66 - 220 - null - - GYHVDLIIXVTLROOCLVYG - INE272F07011 - BlueDartExpress - true - true - 20 - 1759301230685 - 200 - sell - 151 - 188 - 89 - 94 - 94 - 45 - 54 - 58 - 220 - 6 - null - - VIHCPUEYSZUMQUVPSJ1P - INE112J07020 - IFCI - true - true - 170 - 1751520034430 - 500 - sell - 129 - 82 - 120 - 187 - 187 - 110 - 174 - 71 - 160 - 42 - null - - 2BOMU4R5WMEONKEI5YT6 - INE130K08000 - SBOX - false - false - 170 - 1746115966803 - 500 - sell - 97 - 118 - 33 - 9 - 0 - 151 - 6 - 38 - 52 - 40 - null - - DIQDEZH7K04QBDCJY0NV - INE130K08001 - QCK - false - false - 200 - 1748304011006 - 500 - sell - 78 - 112 - 194 - 9 - 0 - 128 - 114 - 154 - 68 - 207 - null - - TFCXQ3TKQRMOHU86MXO1 - INE130K08015 - GGL - true - true - 200 - 1772120698642 - 600 - sell - 103 - 56 - 160 - 203 - 203 - 240 - 171 - 239 - 71 - 42 - null - - 2GFSS7XTAHUWHFZH0NBR - INE130K08019 - APPL - false - false - 180 - 1771070135804 - 310 - sell - 12 - 204 - 93 - 133 - 0 - 63 - 206 - 65 - 13 - 167 - null - - FQQ96BPTGAPAQPLMABNU - INE261F07055 - SGB - true - true - 550 - 1743557101246 - 789 - sell - 52 - 8 - 14 - 119 - 119 - 231 - 1 - 246 - 128 - 155 - null - - RKW88OVAQVWZMCD9VLJL - INE261F07055 - SGB - true - true - 50 - 1758463330011 - 890 - sell - 139 - 196 - 103 - 96 - 96 - 207 - 102 - 68 - 229 - 5 - null responses: '200': description: 200 OK content: application/json: schema: type: object properties: code: type: integer data: type: object properties: '@entity': type: string job_id: type: string url: type: string format: uri type: type: string created_at: type: integer updated_at: type: integer transaction_id: type: string timestamp: type: integer example: code: 200 data: '@entity': in.co.sandbox.it.calculator.pnl.securities.job job_id: 0d931fe5-5a9f-4e6d-bde7-c28d95e00706 url: >- https://in-co-sandbox-it-calculator-pnl-securities-dev.s3.ap-south-1.amazonaws.com/domestic/0d931fe5-5a9f-4e6d-bde7-c28d95e00706/workbook.input?X-Amz-Algorithm=AWS4-HMAC-SHA256&X-Amz-Content-Sha256=UNSIGNED-PAYLOAD&X-Amz-Credential=EXAMPLEACCESSKEY%2F20250121%2Fap-south-1%2Fs3%2Faws4_request&X-Amz-Date=20250121T074117Z&X-Amz-Expires=86400&X-Amz-Security-Token=EXAMPLE_SECURITY_TOKEN&X-Amz-Signature=EXAMPLE_SIGNATURE&X-Amz-SignedHeaders=host&x-id=PutObject type: pnl created_at: 1737445277235 updated_at: 1737445277235 transaction_id: 0d931fe5-5a9f-4e6d-bde7-c28d95e00706 timestamp: 1737445277097 ````