get_conditions() lists the condition filters you can apply in get_timesales(). Build it step by step:
Step 1 — Import the library
import icepython as iceStep 2 — Fetch the available conditions:
conditions = ice.get_conditions()
print(conditions)
Step 3 — Use a condition to filter a Time & Sales request:
import pandas as pd
data = ice.get_timesales('HNG 1!-IUS', ['Price', 'Conditions'],
'2023-10-10', '2023-10-11',
conditions=['BlockTrde'], conditionslogic='AND')
print(pd.DataFrame(list(data)))
Output:
('ABloxBlock', 'AccInt', 'Acqstn', 'Actual', 'Adjusted', 'AfterHrBasket', 'AfterHrBlock', 'AfterHrKBloxBlock', 'AfterMarket', 'AgstActual', 'Allocation', 'ALP', 'AmendCond', 'Amended', 'AmendGvUpIn', 'Amendment', 'AmendTech', 'AoD', 'AON', 'Application', 'ApplSettle', 'AsOfTrade', 'AssetAlloc', 'AssetAllocate', 'AtLimit', 'ATS', 'Auction', 'Auctions', 'AuctionTradeBulk', 'AuctPrice', 'AuctTrade', 'Authorized', 'Auto', 'AutoElig', 'AutoQte', 'AvgPrice', 'B/S', 'Backward', 'BalOfClsg', 'BalOfIntday', 'BalOfOpn', 'BandReport', 'BasisCross', 'BasisTrde', 'Basket', 'BB', 'BBCross', 'BBDeriv', 'BBTrade', 'BClear', 'BegBlkX', 'Benchmark', 'BeneOwner', 'BenMrkCross', 'BestOffer', 'BestPrice', 'BestPurchSale+/-10', 'BestPurchSale+/-5', 'BestValPrce', 'BetweenMbrs', 'BiasedQuote', 'BidOfferSpreadChg', 'Bind', 'BISO', 'BlkCrackLeg', 'BlkSysLeg', 'BlkXing', 'BlockSettle', 'BlockTrde', 'BnchdSold', 'BnchdTrde', 'BnchMrkCond', 'BnchMrkGvUpIn', 'BnchMrkTech', 'BNMT', 'BookBuild', 'BookEmpty', 'Broker', 'BrokerBuy', 'BrokerPref', 'BrokerSell', 'BtwnCont', 'BurstBskt', 'BuyAuto', 'BuyIn', 'BuySell', 'BuyWhite', 'BuyWrite', 'BuyWrteTrde', 'ByPass', 'CabPrice', 'Calc', 'Cancld', 'CancldCorr', 'CanclPrice', 'CanclTrde', 'CAPElection', 'CapPool', 'CashOnly', 'CashTrde', 'CBMO', 'CCPRelated', 'ChgInBenchmark', 'ChgTrans', 'ChgTransCab', 'Clear', 'ClearOnly', 'Closing', 'ClsdQte', 'ClseStckCanWar', 'ClseStckWar', 'ClsgVWAPcross', 'ClsOrder', 'ClsRefIndex', 'CntrPtCross', 'CntrPtTrade', 'CntrPtUCross', 'Combined', 'ComboTrde', 'CommitBlk', 'CommitBlock', 'CommitBTF', 'CommitCross', 'Committed', 'Communicated', 'Conditional', 'Consol', 'Contango', 'ContAuct', 'Contracts', 'ContTrd', 'ContTrde', 'Coordinated', 'CorpAction', 'CorpFinance', 'Corr', 'CounterTrd', 'Crack', 'CrossCond', 'Crossed', 'CrossGvUpIn', 'CrossTech', 'CrossTradeMod', 'CrossTrd', 'Custom', 'Dark', 'DarkDark', 'DarkMid', 'DarkPool', 'DarkTrns', 'DelayOpening', 'DelaySingle', 'DelDeliv', 'Delta', 'DeltaNeutral', 'DepthOfRound', 'Derivative', 'DerivPriced', 'DervCross', 'Diffrntl', 'Dirty', 'Distribution', 'DivendCond', 'DivendGvUpIn', 'DivendTech', 'Dlyd', 'DlyOffBook', 'DlySpecial', 'DownLimit', 'DpthAsk', 'DpthBid', 'DpthBidAsk', 'DrkDrkMatch', 'DrkTrnsMatch', 'EFM', 'EFP', 'EFP/EFS', 'EFPCross', 'EFR', 'EFS', 'EG1', 'EG2', 'EndBlkCross', 'EndOfMonth', 'EndTrdg', 'EnLight', 'EODauction', 'EOO', 'Est', 'EstSize', 'ETF', 'ExchgForRisk', 'ExchgGen', 'ExchGrnt', 'ExchRisk', 'ExDivend', 'ExgForFM', 'EXHT', 'ExtHours', 'ExtHoursOOS', 'FastMkt', 'Final', 'FinalFinal', 'FinalSettle', 'Firm', 'Fixing', 'Flexible', 'Floor', 'Forced', 'ForeignBrd', 'Forwards', 'Fund', 'FundCrossDelayed', 'FundSvcTrade', 'FutExercise', 'GBCls', 'GenAuction', 'GiveUp', 'GiveUpIn', 'Hidden', 'HiddenIns', 'HiFromTFA', 'Hit', 'HltNonFrmQte', 'HoustonClse', 'HoustonMidday', 'Impl', 'ImplAtOpen', 'Implied', 'InactBrd', 'InactIss', 'INavAftCls', 'INavAtCls', 'Index', 'Indicative', 'IngtyRule', 'IngtyRuleOff', 'Insignificant', 'IntAsk', 'IntBid', 'IntBoth', 'IntBTF', 'IntdayCont', 'Intentional', 'Internal', 'InternalCross', 'InternalTrd', 'International', 'InternCross', 'InterOffice', 'Interrptn', 'InterSpread', 'IntMktSwp', 'IntOffcTotal', 'IntraDaySettl', 'IntraSpread', 'IntTrdChg', 'InvestFund', 'IPO', 'IPOPrice', 'ISOI', 'JNetTrd', 'JPCls', 'Kassa', 'KBloxBlock', 'Kerb1', 'Kerb2', 'Large', 'LargeCond', 'LargeGvUpIn', 'LargeTech', 'LastIneligible', 'LastTradedPrice+/6%', 'LastTransPrice', 'LastTransPrice+/-3%', 'Late', 'LateOpn', 'LateOpnXSeq', 'LatePortf', 'LateTrade', 'LateXSeq', 'Leg', 'LegOutside', 'Letter', 'Leveling', 'LgeOrder', 'LifetimeHi', 'LifetimeLo', 'LimitDn', 'LimitUp', 'Linked', 'Liquidnet', 'LIS', 'LISCross', 'LISPack', 'LISStrategy', 'ListOffer', 'Lit', 'LockdMkt', 'LoFromTFA', 'LondonClse', 'LondonMidday', 'LondonMidnight', 'LondonOpn', 'LstSamePrevCrsTrd', 'LstSamePrevTrd', 'M-ELO', 'MainBrd', 'ManAuction', 'ManReference', 'Manual', 'MarkUpDn', 'Married', 'MarriedCrs', 'MASL', 'MatchCross', 'MBCntl', 'MCTP', 'MESL', 'MFSL', 'MidCont', 'MidTrade', 'MktCntrClse', 'MktCntrOpn', 'MktCntrReOpn', 'MktColorApplied', 'MktDataApplied', 'MktDpth', 'MktOrder', 'MktShrNoTrdRpt', 'MktShrWhlsle', 'MktSwpOutsdeTSI', 'MLAT', 'MLCT', 'MLET', 'MLFT', 'MmbrContr', 'MmbrContrAvg', 'MmbrsBuyWar', 'MmbrsSellWar', 'MocTrde', 'Money', 'MoscowClse', 'MtchgRange', 'MtchTrdes', 'MthAvgSttle', 'MthMovAvgSttle', 'Nambia', 'NAV', 'NBBO', 'NegoCondition', 'NegoDelayed', 'NegoGvUpIn', 'NegoTech', 'Negotiated', 'NetOffs', 'NextDay', 'NGEFS/EFP', 'NgEfsEfp', 'NoCommission', 'NomCab', 'Nominal', 'NonBrdLot', 'NonResident', 'NonRptIss', 'NonStandard', 'NonStd', 'NonStruct', 'NonVoting', 'NoOpnNoResme', 'NoOutrOrginator', 'NoOutrOrgTaker', 'NoOutrTaker', 'NoPrcVol', 'NoPriceInfo', 'NoPricingInfo', 'NoQual', 'Normal', 'NoSecondMod', 'NotCrossTrd', 'NotExecutable', 'NotnlAvgPrce', 'NoTurnover', 'NoUpdate', 'NoVolInfo', 'NxtDayOnly', 'NYLON', 'NymexClse', 'OddLot', 'OffBook', 'Offcl', 'OffclClse', 'OffclClsePrice', 'OffclOpnPrice', 'OffExchg', 'OffMkt', 'OffRpt', 'OneOnly', 'OnMktCrsNeg', 'OnMktNeg', 'Opened', 'Opening', 'OpnAuction', 'OpnOrdrBook', 'OptExercise', 'OptExpiration', 'Option', 'OptNegotiated', 'OptSpread', 'OrderBalance', 'OrderImb', 'OrderInflux', 'Ordinary', 'OrdinaryTrade', 'OTC', 'OTCCorrection', 'OTCDelayed', 'OTCNonStd', 'OTCorMkt', 'OTCStd', 'OTCTrade', 'Other', 'OutOfHour', 'OutsideIPL', 'OutsideSpread', 'Package', 'Paid', 'PaidLetter', 'PaidMoney', 'PartDistr', 'PartlPrice', 'PenaltyBid', 'PhaseClsng', 'PhaseIntday', 'PhaseOpn', 'Plus50K', 'Points', 'PolishClse', 'Portfolio', 'PortfolioCross', 'PositTrde', 'PostContra', 'PotIntrupt', 'PotnlPrice', 'PotVolIntrpt', 'Prctage', 'PreBalClsg', 'PreBalIntday', 'PreBalOpn', 'PreCall', 'PrelimSettle', 'PrelimSpec', 'PreOpenABloxBlock', 'PreOpenBasket', 'PreOpenBlock', 'PreOpening', 'PreOpenning', 'PreOpenXBloxBlock', 'PreOpn', 'PrevDayPrice', 'PrevDayPrimQual', 'PriceVar', 'PriceWtd', 'Principal', 'PriorDay', 'PriorRef', 'ProfTrade', 'ProvValue', 'PutThrough', 'PutThru', 'PutThruCross', 'QualContTrd', 'QuoExe', 'RatndLetter', 'RatndMoney', 'RatndPrice', 'RefDataApplied', 'Reference', 'RefPrice', 'ReOpnAfterHlt', 'REPO', 'Repo', 'RepoAppl', 'RepoApplSt', 'RepoBlock', 'RepoBlockSt', 'Reported', 'Represntve', 'RestrVot', 'RetLiqTrd', 'RevREPO', 'RFCCross', 'RFQ', 'Ring1', 'Ring2', 'Ring3', 'Ring4', 'Riskless', 'Roll', 'Rollover', 'Rotation', 'Routed', 'RTIndex', 'Rule 127', 'Rule 127-155', 'SamePrevCrsTrd', 'SamePrevTrd', 'SCLI', 'SCOSeries', 'Secondary', 'SELC', 'SellAuto', 'Seller', 'SellOut', 'SetByAsk', 'SetByBid', 'SetByMid', 'SetByTrde', 'SetLast', 'SetOpn', 'SetsDailyHi', 'SetsDailyLo', 'SGCls', 'ShortSale', 'SI', 'SICorrection', 'SIDelayed', 'Significant', 'SingaporeClse', 'SingleIss', 'SinglePrice', 'SinglePriced', 'SinglePricePost', 'SingleQuote', 'SINonStd', 'SITrade', 'SLAI', 'SLAN', 'SLCN', 'SLFT', 'SlowQte', 'SmallAutoTrd', 'SmallCrsPT', 'SmallPT', 'SmNoSales', 'SmOrder', 'Sold-OOS', 'SoldLast', 'SpcDividend', 'Special', 'SpecPrice', 'SpecTerms', 'SpecTermTrdg', 'SpecTrdgSess', 'SPIM', 'Split', 'SprdUnderlying', 'SpreadTrde', 'SqueezeOut', 'Standard', 'StckChge', 'StckIn', 'StckOut', 'StckReport', 'StckToday', 'StockOption', 'StoppedTrde', 'StopStckLast', 'StopStckOOS', 'Strategy', 'StrlgEquiv', 'Struct', 'SubBook', 'SubordVoting', 'Subscription', 'SubTrade', 'suspect', 'Sweeping', 'SyndBid', 'SysPriceLeg', 'Take', 'TAL', 'TAM/SBK', 'TAPO', 'TASL', 'Tax', 'TenderOffer', 'TESL', 'TFSL', 'TheorPrice', 'TLAT', 'TLCT', 'TLET', 'TLFT', 'TMCSeries', 'TMDeriv', 'TocomClse', 'TOM', 'TOMClear', 'TOMEG1', 'TotWrnts', 'TradeAtLast', 'TrdAtClose', 'TrdAtClpse', 'TrdPublication', 'TrdQuoImpactPrice', 'TrdQuoImpactSpread', 'TrdRpt', 'TrdTrd', 'TrdWghAve', 'TrflesPaid', 'Turnover', 'TWAP', 'TypeRound', 'Uncrossing', 'UnderInvest', 'UnitTrade', 'UnOffcl', 'UnOffclClose', 'UnOffclOpen', 'Unsol', 'UnVerified', 'UpLimit', 'USCls', 'USDollar', 'USOptionClse', 'Validation', 'Valuation', 'Variable', 'VertNoOutrOrgTaker', 'VertNoOutrTaker', 'VoiceOver', 'VolAdjusted', 'VolInterrupt', 'VolMatch', 'VolMatchSame', 'VolTrde', 'VolumeOnly', 'VWAP', 'VWAPTrade', 'WarHldgs', 'Warrant', 'WashingtonClse', 'WeightedAvg', 'WithoutCCP', 'WkdTrde', 'WoConcertation', 'XchgeClrd', 'XchgeForOpts', 'XchgeForSwps', 'XchgGranted', 'XchgTrd', 'XMPT', 'Xseq', 'YellowFlag', 'Yld', 'YldTypChg')
0 1 2
0 Time HNG 1!-IUS.Price HNG 1!-IUS.Conditions