Simplify Analytics
← Data Explorer

Options flow alerts (market-wide)

core.flow_alerts

Every UW flow alert, on every ticker - untracked ones included, which is the point. Keyed on the vendor's alert id. `ticker` is verbatim (SPX weeklies arrive as SPXW). Not exportable: each alert carries the contract's bid and ask.

231,528 rowsexport restricted — no row in this table may be redistributed

Sources in this table

created_at (ET days)to
column equals (exact text)
sort
chart against created_at
reset
active:alert_rule = FloorTradeMidCap×ticker = EWZ×
iduuidcreated_attimestamp with time zonestart_timetimestamp with time zoneend_timetimestamp with time zonetickertextoption_symboltextoption_typetextstrikenumericexpirydatepricenumericbidnumericasknumericunderlying_pricenumerictotal_premiumnumerictotal_ask_side_premnumerictotal_bid_side_premnumerictotal_sizebiginttrade_countintegervolumebigintopen_interestbigintvolume_oi_rationumericiv_startnumericiv_endnumerichas_sweepbooleanhas_floorbooleanhas_multilegbooleanhas_singlelegbooleanall_opening_tradesbooleanalert_ruletextrule_iduuidexpiry_countintegerissue_typetextsectortextmarketcapnumericnext_earnings_datedateer_timetextmissing_periscopebooleansourcetextendpointtextrequest_paramsjsonbas_ofdatevintage_tstimestamp with time zoneretrieved_attimestamp with time zone
50fa5ccf-cac7-450d-82af-55ef56445dee2026-09-18 14:162026-09-18 14:162026-09-18 14:16EWZEWZ261016P00032000put32.00002026-10-160.20000.19000.220037.480020000.000.0020000.00100011041165120.06304505813953490.4502861031211320.450286103121132falsetruefalsetruefalseFloorTradeMidCapd9769fb4-003b-49e4-9181-c78c9cc101f51ETF8637878076.00uw_flow_alerts/api/option-trades/flow-alerts{"limit":500,"older_than":"2026-09-18T18:22:45.408265Z"}2026-09-182026-09-18 21:152026-09-18 21:15
a621df64-b1f6-4efc-b276-2f0a99e8954a2026-09-18 13:292026-09-18 13:282026-09-18 13:28EWZEWZ261016C00039000call39.00002026-10-161.21001.18001.220037.4400363000.00363000.000.00300023060822040.03722446596272690.4375854976556960.437585497655696falsetruetruefalsefalseFloorTradeMidCapd9769fb4-003b-49e4-9181-c78c9cc101f51ETF8637878076.00uw_flow_alerts/api/option-trades/flow-alerts{"limit":500,"older_than":"2026-09-18T17:36:08.685771Z"}2026-09-182026-09-18 21:152026-09-18 21:15
547c0982-3a47-42cd-8296-c84e5b9708a32026-09-16 15:332026-09-16 15:332026-09-16 15:33EWZEWZ261120C00041000call41.00002026-11-201.57001.55001.560037.4000266900.00266900.000.0017002130742189600.05970953598830840.4465083573692420.446508357369242falsetruetruefalsefalseFloorTradeMidCapd9769fb4-003b-49e4-9181-c78c9cc101f51ETF8662096023.00uw_flow_alerts/api/option-trades/flow-alerts{"limit":500,"older_than":"2026-09-16T19:45:47.974261Z"}2026-09-162026-09-16 21:152026-09-16 21:15
91e3a68c-dfe9-4dd6-a420-328a8acb12952026-09-15 11:212026-09-15 11:212026-09-15 11:21EWZEWZ261120C00046000call46.00002026-11-200.88000.64000.660037.87001056000.001056000.000.0012000212119976270.1241357411371850.4919327785142940.491932778514294falsetruetruefalsefalseFloorTradeMidCapd9769fb4-003b-49e4-9181-c78c9cc101f51ETF8633146199.00uw_flow_alerts/api/option-trades/flow-alerts{"limit":500,"older_than":"2026-09-15T15:29:06.202071Z"}2026-09-152026-09-15 21:152026-09-15 21:15
82a26d91-9edc-40f1-98f8-9f0596c51b152026-09-15 11:212026-09-15 11:212026-09-15 11:21EWZEWZ261120C00041000call41.00002026-11-201.78001.79001.800037.8700890000.000.00890000.005000254142201810.02458886098255530.4484285328605330.448428532860533falsetruetruefalsefalseFloorTradeMidCapd9769fb4-003b-49e4-9181-c78c9cc101f51ETF8633146199.00uw_flow_alerts/api/option-trades/flow-alerts{"limit":500,"older_than":"2026-09-15T15:29:06.202071Z"}2026-09-152026-09-15 21:152026-09-15 21:15
c66c28ff-e630-440d-8aeb-011161df23292026-09-14 11:532026-09-14 11:532026-09-14 11:53EWZEWZ261002C00041000call41.00002026-10-020.21000.19000.220037.6550420000.00420000.000.0020000220041655620.3056801195814650.344045294800640.34404529480064falsetruetruefalsefalseFloorTradeMidCapd9769fb4-003b-49e4-9181-c78c9cc101f51ETF8686956917.00uw_flow_alerts/api/option-trades/flow-alerts{"limit":500,"older_than":"2026-09-14T16:02:31.142849Z"}2026-09-152026-09-15 08:452026-09-15 08:45
edb17c8d-773d-4c0c-8e85-0553ecc8b48f2026-09-14 11:442026-09-14 11:442026-09-14 11:44EWZEWZ261120C00044000call44.00002026-11-200.94000.94000.950037.73004961414.000.004961414.0052781153151410971.293306080735820.4377513365373370.437751336537337falsetruefalsetruetrueFloorTradeMidCapd9769fb4-003b-49e4-9181-c78c9cc101f51ETF8686956917.00uw_flow_alerts/api/option-trades/flow-alerts{"limit":500,"older_than":"2026-09-14T16:02:31.142849Z"}2026-09-152026-09-15 08:452026-09-15 08:45
d45f7e6d-8cfc-4d0d-ae47-ef7d447f65f02026-09-11 14:052026-09-11 14:052026-09-11 14:05EWZEWZ261120C00050000call50.00002026-11-200.29000.26000.290038.0500137750.00137750.000.00475015110991000.05156407669021190.4290043300261690.429004330026169falsetruefalsetruefalseFloorTradeMidCapd9769fb4-003b-49e4-9181-c78c9cc101f51ETF8686956917.00uw_flow_alerts/api/option-trades/flow-alerts{"limit":500,"older_than":"2026-09-11T18:33:12.425630Z"}2026-09-152026-09-15 08:452026-09-15 08:45
971235f0-356b-448b-a914-7b5db88e837e2026-09-09 13:362026-09-09 13:352026-09-09 13:35EWZEWZ270617P00034000put34.00002027-06-172.41002.34002.430038.14501205000.001205000.000.00500025000101010.4950004950004950.3679865430142060.367986543014206falsetruetruefalsefalseFloorTradeMidCapd9769fb4-003b-49e4-9181-c78c9cc101f51ETF8686956917.00uw_flow_alerts/api/option-trades/flow-alerts{"limit":500,"older_than":"2026-09-09T17:50:47.676652Z"}2026-09-152026-09-15 08:452026-09-15 08:45
7fe07515-6809-49bc-a460-746c9273aeeb2026-09-09 13:362026-09-09 13:352026-09-09 13:35EWZEWZ261218P00034000put34.00002026-12-181.50001.50001.530038.14501500000.000.001500000.0010000210000281380.3553912858056720.4385758623522310.438575862352231falsetruetruefalsefalseFloorTradeMidCapd9769fb4-003b-49e4-9181-c78c9cc101f51ETF8686956917.00uw_flow_alerts/api/option-trades/flow-alerts{"limit":500,"older_than":"2026-09-09T17:50:47.676652Z"}2026-09-152026-09-15 08:452026-09-15 08:45
dad159f0-63aa-4938-b6aa-0672dbdfb9bd2026-09-04 14:202026-09-04 14:202026-09-04 14:20EWZEWZ261120C00050000call50.00002026-11-200.32000.29000.320037.9400320000.00320000.000.0010000122136178171.242408935286520.4220474484874410.422047448487441falsetruefalsetruefalseFloorTradeMidCapd9769fb4-003b-49e4-9181-c78c9cc101f51ETF8633146199.00uw_flow_alerts/api/option-trades/flow-alerts{"limit":500,"older_than":"2026-09-04T18:34:11.376593Z"}2026-09-152026-09-15 08:452026-09-15 08:45
bc1d83c2-8ecb-4bc0-aff4-d3bab68af11c2026-09-03 15:012026-09-03 15:012026-09-03 15:01EWZEWZ261016C00040000call40.00002026-10-161.27001.25001.280038.0500254000.00254000.000.0020004151791139450.1332133924261710.381588034280980.38158803428098falsetruetruefalsefalseFloorTradeMidCapd9769fb4-003b-49e4-9181-c78c9cc101f51ETF8633146199.00uw_flow_alerts/api/option-trades/flow-alerts{"limit":500,"older_than":"2026-09-03T19:09:41.417490Z"}2026-09-152026-09-15 08:452026-09-15 08:45
bd35f3bb-4260-45d8-9d62-5e2ee839ef6c2026-09-03 11:382026-09-03 11:382026-09-03 11:38EWZEWZ270319P00032000put32.00002027-03-191.21001.17001.240038.1650378125.00378125.000.0031252312678910.3961475098213150.3587730812460220.358773081246022falsetruetruefalsefalseFloorTradeMidCapd9769fb4-003b-49e4-9181-c78c9cc101f52ETF8633146199.00uw_flow_alerts/api/option-trades/flow-alerts{"limit":500,"older_than":"2026-09-03T15:43:05.796155Z"}2026-09-152026-09-15 08:452026-09-15 08:45
dc26e887-6da0-4f17-934f-62aa77c2f4042026-09-03 10:272026-09-03 10:272026-09-03 10:27EWZEWZ260918C00037000call37.00002026-09-181.79001.76001.870038.3750209430.000.00209430.00117023224343600.09383003492433060.2946472563802550.294647256380255falsetruetruefalsefalseFloorTradeMidCapd9769fb4-003b-49e4-9181-c78c9cc101f51ETF8633146199.00uw_flow_alerts/api/option-trades/flow-alerts{"limit":500,"older_than":"2026-09-03T14:40:26.963433Z"}2026-09-152026-09-15 08:452026-09-15 08:45
52e261e8-ed87-48e4-9c2f-6b4c920daac72026-09-03 10:012026-09-03 10:012026-09-03 10:01EWZEWZ261016C00038000call38.00002026-10-162.55002.52002.580038.6800306000.000.000.00120021237352410.03510116058000620.4003909837396640.400390983739664falsetruetruefalsefalseFloorTradeMidCapd9769fb4-003b-49e4-9181-c78c9cc101f51ETF8633146199.00uw_flow_alerts/api/option-trades/flow-alerts{"limit":500,"older_than":"2026-09-03T14:10:05.195539Z"}2026-09-152026-09-15 08:452026-09-15 08:45
0c16a6b2-b52e-465b-8ccd-11c6765885bc2026-09-03 10:012026-09-03 10:012026-09-03 10:01EWZEWZ261016C00040000call40.00002026-10-161.61001.61001.630038.6800289800.000.00289800.001800248261139450.04235376716837070.3967467663944730.396746766394473falsetruetruefalsefalseFloorTradeMidCapd9769fb4-003b-49e4-9181-c78c9cc101f51ETF8633146199.00uw_flow_alerts/api/option-trades/flow-alerts{"limit":500,"older_than":"2026-09-03T14:10:05.195539Z"}2026-09-152026-09-15 08:452026-09-15 08:45
82f3cca9-827f-4edb-80ea-656fffbcd4132026-09-02 13:162026-09-02 13:162026-09-02 13:16EWZEWZ260918P00036000put36.00002026-09-180.29000.27000.290037.9100145000.00145000.000.00500025491101310.5419998025861220.3160351284805320.316035128480532falsetruetruefalsefalseFloorTradeMidCapd9769fb4-003b-49e4-9181-c78c9cc101f51ETF8633146199.00uw_flow_alerts/api/option-trades/flow-alerts{"limit":500,"older_than":"2026-09-02T17:36:40.694178Z"}2026-09-152026-09-15 08:452026-09-15 08:45
051cf654-3b47-407f-9ec3-1dcbfdb3facb2026-09-02 10:432026-09-02 10:432026-09-02 10:43EWZEWZ261120C00042000call42.00002026-11-201.74001.71001.750038.0200174000.00174000.000.001000253651025010.05234095277119250.4385812293236380.438581229323638falsetruetruefalsefalseFloorTradeMidCapd9769fb4-003b-49e4-9181-c78c9cc101f52ETF8633146199.00uw_flow_alerts/api/option-trades/flow-alerts{"limit":500,"older_than":"2026-09-02T14:46:18.296261Z"}2026-09-152026-09-15 08:452026-09-15 08:45
5e311c9c-73ec-4998-8bf6-a6b9f73b32762026-09-02 09:552026-09-02 09:552026-09-02 09:55EWZEWZ261120C00046000call46.00002026-11-200.68000.67000.690037.4150102000.000.000.00150021689960460.01758532369906090.4258554706553960.425855470655396falsetruetruefalsefalseFloorTradeMidCapd9769fb4-003b-49e4-9181-c78c9cc101f51ETF8633146199.00uw_flow_alerts/api/option-trades/flow-alerts{"limit":500,"older_than":"2026-09-02T13:56:06.315925Z"}2026-09-152026-09-15 08:452026-09-15 08:45
4ed66e16-2435-470d-a01f-6b7cde3794aa2026-09-02 09:552026-09-02 09:552026-09-02 09:55EWZEWZ261218C00046000call46.00002026-12-180.83000.81000.860037.4150166000.000.00166000.002000220001149290.01740204822107560.3890810561690490.389081056169049falsetruetruefalsefalseFloorTradeMidCapd9769fb4-003b-49e4-9181-c78c9cc101f51ETF8633146199.00uw_flow_alerts/api/option-trades/flow-alerts{"limit":500,"older_than":"2026-09-02T13:56:06.315925Z"}2026-09-152026-09-15 08:452026-09-15 08:45
810ae3da-9212-4436-a2a3-8a84d8b00a852026-09-01 11:402026-09-01 11:402026-09-01 11:40EWZEWZ261016C00038000call38.00002026-10-161.54001.51001.550036.72501155000.001155000.000.007500210229320890.3187696718501670.3911360733823510.391136073382351falsetruetruefalsefalseFloorTradeMidCapd9769fb4-003b-49e4-9181-c78c9cc101f51ETF8633146199.00uw_flow_alerts/api/option-trades/flow-alerts{"limit":500,"older_than":"2026-09-01T15:45:30.323966Z"}2026-09-152026-09-15 08:452026-09-15 08:45
17dc55d2-9669-43e0-a84d-ae3d13b2a28d2026-08-27 12:552026-08-27 12:552026-08-27 12:55EWZEWZ261120C00045000call45.00002026-11-200.50000.47000.500035.63501050000.001050000.000.00210002320316887540.04650571902304740.4089517722000680.408951772200068falsetruetruefalsefalseFloorTradeMidCapd9769fb4-003b-49e4-9181-c78c9cc101f51ETF8633146199.00uw_flow_alerts/api/option-trades/flow-alerts{"limit":500,"older_than":"2026-08-27T16:57:23.365599Z"}2026-09-152026-09-15 08:452026-09-15 08:45
161bcd44-4308-441c-95a2-f7ba22bc6f282026-08-25 13:312026-08-25 13:312026-08-25 13:31EWZEWZ261120C00043000call43.00002026-11-200.63000.60000.640035.430031500000.0031500000.000.005000002516020558749.235422557898130.3852439522215830.385243952221583falsetruetruefalsetrueFloorTradeMidCapd9769fb4-003b-49e4-9181-c78c9cc101f51ETF8633146199.00uw_flow_alerts/api/option-trades/flow-alerts{"limit":500,"older_than":"2026-08-25T17:59:30.582778Z"}2026-09-152026-09-15 08:452026-09-15 08:45
03bc033d-985a-43f1-9bda-40f3ea4e3e682026-08-25 11:282026-08-25 11:282026-08-25 11:28EWZEWZ260911C00036000call36.00002026-09-110.57000.47000.620035.3250108300.00108300.000.0019001234647470.494206867495260.2740630609412870.274063060941287falsetruefalsetruefalseFloorTradeMidCapd9769fb4-003b-49e4-9181-c78c9cc101f51ETF8633146199.00uw_flow_alerts/api/option-trades/flow-alerts{"limit":500,"older_than":"2026-08-25T15:37:01.391907Z"}2026-09-152026-09-15 08:452026-09-15 08:45
6d8087df-023d-4aea-b5d1-149463232c882026-08-24 12:122026-08-24 12:122026-08-24 12:12EWZEWZ260918C00036000call36.00002026-09-180.82000.80000.820035.37001222500.00615000.000.0015000415199366000.4152732240437160.2840370250589430.284037025058943falsetruetruefalsefalseFloorTradeMidCapd9769fb4-003b-49e4-9181-c78c9cc101f51ETF8633146199.00uw_flow_alerts/api/option-trades/flow-alerts{"limit":500,"older_than":"2026-08-24T16:14:40.561585Z"}2026-09-152026-09-15 08:452026-09-15 08:45
d53ef949-b88f-4e1e-8add-a149c9d999292026-08-24 10:002026-08-24 10:002026-08-24 10:00EWZEWZ261016C00036000call36.00002026-10-161.74001.72001.760035.2500469800.000.000.0027002275192270.2981467432534950.3713581563740560.371358156374056falsetruetruefalsefalseFloorTradeMidCapd9769fb4-003b-49e4-9181-c78c9cc101f51ETF8633146199.00uw_flow_alerts/api/option-trades/flow-alerts{"limit":500,"older_than":"2026-08-24T14:08:32.927735Z"}2026-09-152026-09-15 08:452026-09-15 08:45
f21793b9-f840-41f8-b43a-e66db46747cf2026-08-21 10:332026-08-21 10:322026-08-21 10:32EWZEWZ261218C00042000call42.00002026-12-180.81000.77000.910035.0950405000.000.00405000.00500015150811880.06343301965807750.3420618051500740.342061805150074falsetruefalsetruefalseFloorTradeMidCapd9769fb4-003b-49e4-9181-c78c9cc101f51ETF8633146199.00uw_flow_alerts/api/option-trades/flow-alerts{"limit":500,"older_than":"2026-08-21T14:36:46.143381Z"}2026-09-152026-09-15 08:452026-09-15 08:45
cb2bd7fc-2549-49fb-a693-1777c1149e762026-08-19 10:272026-08-19 10:262026-08-19 10:26EWZEWZ261120C00037000call37.00002026-11-201.74001.69001.750034.7700957000.00957000.000.00550025502400180.1374881303413460.3574329773306090.357432977330609falsetruetruefalsefalseFloorTradeMidCapd9769fb4-003b-49e4-9181-c78c9cc101f51ETF8633146199.00uw_flow_alerts/api/option-trades/flow-alerts{"limit":500,"older_than":"2026-08-19T14:37:39.751673Z"}2026-09-152026-09-15 08:452026-09-15 08:45