Simplify AnalyticsShort borrow rates
core.borrow_rates
Class E accrual - no date parameter upstream, so a day not captured is gone.
45,044 rowsCSV — whole table, not this view
Sources in this table
uw_borrow_rates45,044 rowsexportable
active:endpoint = /api/shorts/XLI/data×
| symboltext | observed_at ↓timestamp with time zone | fee_ratenumeric | rebate_ratenumeric | short_shares_availablebigint | security_nametext | sourcetext | endpointtext | request_paramsjsonb | as_ofdate | vintage_tstimestamp with time zone | retrieved_attimestamp with time zone |
|---|---|---|---|---|---|---|---|---|---|---|---|
| XLI | 2026-09-15 11:20 | 0.4244 | 3.2056 | 250000 | SS INDUSTRIAL SELECT SECTOR | uw_borrow_rates | /api/shorts/XLI/data | {} | 2026-09-15 | 2026-09-15 17:00 | 2026-09-15 17:00 |
| XLI | 2026-09-15 10:48 | 0.4244 | 3.2056 | 250000 | SS INDUSTRIAL SELECT SECTOR | uw_borrow_rates | /api/shorts/XLI/data | {} | 2026-09-15 | 2026-09-15 17:00 | 2026-09-15 17:00 |
| XLI | 2026-09-15 10:17 | 0.4244 | 3.2056 | 250000 | SS INDUSTRIAL SELECT SECTOR | uw_borrow_rates | /api/shorts/XLI/data | {} | 2026-09-15 | 2026-09-15 17:00 | 2026-09-15 17:00 |
| XLI | 2026-09-15 09:46 | 0.4244 | 3.2056 | 250000 | SS INDUSTRIAL SELECT SECTOR | uw_borrow_rates | /api/shorts/XLI/data | {} | 2026-09-15 | 2026-09-15 17:00 | 2026-09-15 17:00 |
| XLI | 2026-09-15 09:14 | 0.4244 | 3.2056 | 200000 | SS INDUSTRIAL SELECT SECTOR | uw_borrow_rates | /api/shorts/XLI/data | {} | 2026-09-15 | 2026-09-15 17:00 | 2026-09-15 17:00 |
| XLI | 2026-09-15 08:58 | 0.4244 | 3.2056 | 200000 | SS INDUSTRIAL SELECT SECTOR | uw_borrow_rates | /api/shorts/XLI/data | {} | 2026-09-15 | 2026-09-15 17:00 | 2026-09-15 17:00 |
| XLI | 2026-09-15 08:27 | 0.4244 | 3.2056 | 200000 | SS INDUSTRIAL SELECT SECTOR | uw_borrow_rates | /api/shorts/XLI/data | {} | 2026-09-15 | 2026-09-15 17:00 | 2026-09-15 17:00 |
| XLI | 2026-09-15 07:55 | 0.4244 | 3.2056 | 200000 | SS INDUSTRIAL SELECT SECTOR | uw_borrow_rates | /api/shorts/XLI/data | {} | 2026-09-15 | 2026-09-15 17:00 | 2026-09-15 17:00 |
| XLI | 2026-09-15 07:23 | 0.4244 | 3.2056 | 100000 | SS INDUSTRIAL SELECT SECTOR | uw_borrow_rates | /api/shorts/XLI/data | {} | 2026-09-15 | 2026-09-15 17:00 | 2026-09-15 17:00 |
| XLI | 2026-09-15 06:51 | 0.4244 | 3.2056 | 100000 | SS INDUSTRIAL SELECT SECTOR | uw_borrow_rates | /api/shorts/XLI/data | {} | 2026-09-15 | 2026-09-15 17:00 | 2026-09-15 17:00 |
| XLI | 2026-09-15 06:19 | 0.4244 | 3.2056 | 100000 | SS INDUSTRIAL SELECT SECTOR | uw_borrow_rates | /api/shorts/XLI/data | {} | 2026-09-15 | 2026-09-15 17:00 | 2026-09-15 17:00 |
| XLI | 2026-09-15 05:47 | 0.4244 | 3.2056 | 100000 | SS INDUSTRIAL SELECT SECTOR | uw_borrow_rates | /api/shorts/XLI/data | {} | 2026-09-15 | 2026-09-15 17:00 | 2026-09-15 17:00 |
| XLI | 2026-09-15 05:15 | 0.4680 | 3.1620 | 100000 | SS INDUSTRIAL SELECT SECTOR | uw_borrow_rates | /api/shorts/XLI/data | {} | 2026-09-15 | 2026-09-15 17:00 | 2026-09-15 17:00 |
| XLI | 2026-09-14 11:27 | 0.4697 | 3.1603 | 250000 | SS INDUSTRIAL SELECT SECTOR | uw_borrow_rates | /api/shorts/XLI/data | {} | 2026-09-14 | 2026-09-14 17:00 | 2026-09-14 17:00 |
| XLI | 2026-09-14 10:55 | 0.4664 | 3.1636 | 250000 | SS INDUSTRIAL SELECT SECTOR | uw_borrow_rates | /api/shorts/XLI/data | {} | 2026-09-14 | 2026-09-14 17:00 | 2026-09-14 17:00 |
| XLI | 2026-09-14 10:24 | 0.4664 | 3.1636 | 250000 | SS INDUSTRIAL SELECT SECTOR | uw_borrow_rates | /api/shorts/XLI/data | {} | 2026-09-14 | 2026-09-14 17:00 | 2026-09-14 17:00 |
| XLI | 2026-09-14 09:52 | 0.4648 | 3.1652 | 250000 | SS INDUSTRIAL SELECT SECTOR | uw_borrow_rates | /api/shorts/XLI/data | {} | 2026-09-14 | 2026-09-14 17:00 | 2026-09-14 17:00 |
| XLI | 2026-09-14 09:21 | 0.4648 | 3.1652 | 250000 | SS INDUSTRIAL SELECT SECTOR | uw_borrow_rates | /api/shorts/XLI/data | {} | 2026-09-14 | 2026-09-14 17:00 | 2026-09-14 17:00 |
| XLI | 2026-09-14 08:50 | 0.4788 | 3.1512 | 250000 | SS INDUSTRIAL SELECT SECTOR | uw_borrow_rates | /api/shorts/XLI/data | {} | 2026-09-14 | 2026-09-14 17:00 | 2026-09-14 17:00 |
| XLI | 2026-09-14 08:18 | 0.5320 | 3.0980 | 250000 | SS INDUSTRIAL SELECT SECTOR | uw_borrow_rates | /api/shorts/XLI/data | {} | 2026-09-14 | 2026-09-14 17:00 | 2026-09-14 17:00 |
| XLI | 2026-09-14 07:47 | 0.5320 | 3.0980 | 250000 | SS INDUSTRIAL SELECT SECTOR | uw_borrow_rates | /api/shorts/XLI/data | {} | 2026-09-14 | 2026-09-14 17:00 | 2026-09-14 17:00 |
| XLI | 2026-09-14 07:15 | 0.5230 | 3.1070 | 250000 | SS INDUSTRIAL SELECT SECTOR | uw_borrow_rates | /api/shorts/XLI/data | {} | 2026-09-14 | 2026-09-14 17:00 | 2026-09-14 17:00 |
| XLI | 2026-09-14 06:42 | 0.5230 | 3.1070 | 250000 | SS INDUSTRIAL SELECT SECTOR | uw_borrow_rates | /api/shorts/XLI/data | {} | 2026-09-14 | 2026-09-14 17:00 | 2026-09-14 17:00 |
| XLI | 2026-09-14 06:26 | 0.5230 | 3.1070 | 250000 | SS INDUSTRIAL SELECT SECTOR | uw_borrow_rates | /api/shorts/XLI/data | {} | 2026-09-14 | 2026-09-14 17:00 | 2026-09-14 17:00 |
| XLI | 2026-09-14 05:54 | 0.5230 | 3.1070 | 250000 | SS INDUSTRIAL SELECT SECTOR | uw_borrow_rates | /api/shorts/XLI/data | {} | 2026-09-14 | 2026-09-14 17:00 | 2026-09-14 17:00 |
| XLI | 2026-09-14 05:23 | 0.5230 | 3.1070 | 250000 | SS INDUSTRIAL SELECT SECTOR | uw_borrow_rates | /api/shorts/XLI/data | {} | 2026-09-14 | 2026-09-14 17:00 | 2026-09-14 17:00 |
| XLI | 2026-09-11 11:24 | 0.4236 | 3.2064 | 700000 | SS INDUSTRIAL SELECT SECTOR | uw_borrow_rates | /api/shorts/XLI/data | {} | 2026-09-11 | 2026-09-11 17:00 | 2026-09-11 17:00 |
| XLI | 2026-09-11 10:53 | 0.4236 | 3.2064 | 700000 | SS INDUSTRIAL SELECT SECTOR | uw_borrow_rates | /api/shorts/XLI/data | {} | 2026-09-11 | 2026-09-11 17:00 | 2026-09-11 17:00 |
| XLI | 2026-09-11 10:21 | 0.4239 | 3.2061 | 700000 | SS INDUSTRIAL SELECT SECTOR | uw_borrow_rates | /api/shorts/XLI/data | {} | 2026-09-11 | 2026-09-11 17:00 | 2026-09-11 17:00 |
| XLI | 2026-09-11 09:50 | 0.4239 | 3.2061 | 700000 | SS INDUSTRIAL SELECT SECTOR | uw_borrow_rates | /api/shorts/XLI/data | {} | 2026-09-11 | 2026-09-11 17:00 | 2026-09-11 17:00 |
| XLI | 2026-09-11 09:19 | 0.4248 | 3.2052 | 700000 | SS INDUSTRIAL SELECT SECTOR | uw_borrow_rates | /api/shorts/XLI/data | {} | 2026-09-11 | 2026-09-11 17:00 | 2026-09-11 17:00 |
| XLI | 2026-09-11 08:47 | 0.4248 | 3.2052 | 700000 | SS INDUSTRIAL SELECT SECTOR | uw_borrow_rates | /api/shorts/XLI/data | {} | 2026-09-11 | 2026-09-11 17:00 | 2026-09-11 17:00 |
| XLI | 2026-09-11 08:16 | 0.4248 | 3.2052 | 750000 | SS INDUSTRIAL SELECT SECTOR | uw_borrow_rates | /api/shorts/XLI/data | {} | 2026-09-11 | 2026-09-11 17:00 | 2026-09-11 17:00 |
| XLI | 2026-09-11 07:45 | 0.4248 | 3.2052 | 700000 | SS INDUSTRIAL SELECT SECTOR | uw_borrow_rates | /api/shorts/XLI/data | {} | 2026-09-11 | 2026-09-11 17:00 | 2026-09-11 17:00 |
| XLI | 2026-09-11 07:14 | 0.4220 | 3.2080 | 550000 | SS INDUSTRIAL SELECT SECTOR | uw_borrow_rates | /api/shorts/XLI/data | {} | 2026-09-11 | 2026-09-11 17:00 | 2026-09-11 17:00 |
| XLI | 2026-09-11 06:58 | 0.4220 | 3.2080 | 550000 | SS INDUSTRIAL SELECT SECTOR | uw_borrow_rates | /api/shorts/XLI/data | {} | 2026-09-11 | 2026-09-11 17:00 | 2026-09-11 17:00 |
| XLI | 2026-09-11 06:27 | 0.4220 | 3.2080 | 250000 | SS INDUSTRIAL SELECT SECTOR | uw_borrow_rates | /api/shorts/XLI/data | {} | 2026-09-11 | 2026-09-11 17:00 | 2026-09-11 17:00 |
| XLI | 2026-09-11 05:55 | 0.4220 | 3.2080 | 400000 | SS INDUSTRIAL SELECT SECTOR | uw_borrow_rates | /api/shorts/XLI/data | {} | 2026-09-11 | 2026-09-11 17:00 | 2026-09-11 17:00 |
| XLI | 2026-09-11 05:24 | 0.4220 | 3.2080 | 400000 | SS INDUSTRIAL SELECT SECTOR | uw_borrow_rates | /api/shorts/XLI/data | {} | 2026-09-11 | 2026-09-11 17:00 | 2026-09-11 17:00 |
| XLI | 2026-09-10 11:23 | 0.4203 | 3.2097 | 550000 | SS INDUSTRIAL SELECT SECTOR | uw_borrow_rates | /api/shorts/XLI/data | {} | 2026-09-10 | 2026-09-10 17:00 | 2026-09-10 17:00 |
| XLI | 2026-09-10 10:52 | 0.4203 | 3.2097 | 550000 | SS INDUSTRIAL SELECT SECTOR | uw_borrow_rates | /api/shorts/XLI/data | {} | 2026-09-10 | 2026-09-10 17:00 | 2026-09-10 17:00 |
| XLI | 2026-09-10 10:20 | 0.4203 | 3.2097 | 550000 | SS INDUSTRIAL SELECT SECTOR | uw_borrow_rates | /api/shorts/XLI/data | {} | 2026-09-10 | 2026-09-10 17:00 | 2026-09-10 17:00 |
| XLI | 2026-09-10 09:49 | 0.4203 | 3.2097 | 550000 | SS INDUSTRIAL SELECT SECTOR | uw_borrow_rates | /api/shorts/XLI/data | {} | 2026-09-10 | 2026-09-10 17:00 | 2026-09-10 17:00 |
| XLI | 2026-09-10 09:18 | 0.4203 | 3.2097 | 550000 | SS INDUSTRIAL SELECT SECTOR | uw_borrow_rates | /api/shorts/XLI/data | {} | 2026-09-10 | 2026-09-10 17:00 | 2026-09-10 17:00 |
| XLI | 2026-09-10 08:47 | 0.4203 | 3.2097 | 550000 | SS INDUSTRIAL SELECT SECTOR | uw_borrow_rates | /api/shorts/XLI/data | {} | 2026-09-10 | 2026-09-10 17:00 | 2026-09-10 17:00 |
| XLI | 2026-09-10 08:16 | 0.4236 | 3.2064 | 550000 | SS INDUSTRIAL SELECT SECTOR | uw_borrow_rates | /api/shorts/XLI/data | {} | 2026-09-10 | 2026-09-10 17:00 | 2026-09-10 17:00 |
| XLI | 2026-09-10 07:44 | 0.4236 | 3.2064 | 550000 | SS INDUSTRIAL SELECT SECTOR | uw_borrow_rates | /api/shorts/XLI/data | {} | 2026-09-10 | 2026-09-10 17:00 | 2026-09-10 17:00 |
| XLI | 2026-09-10 07:29 | 0.4236 | 3.2064 | 550000 | SS INDUSTRIAL SELECT SECTOR | uw_borrow_rates | /api/shorts/XLI/data | {} | 2026-09-10 | 2026-09-10 17:00 | 2026-09-10 17:00 |
| XLI | 2026-09-10 06:57 | 0.4227 | 3.2073 | 450000 | SS INDUSTRIAL SELECT SECTOR | uw_borrow_rates | /api/shorts/XLI/data | {} | 2026-09-10 | 2026-09-10 17:00 | 2026-09-10 17:00 |
| XLI | 2026-09-10 06:26 | 0.4227 | 3.2073 | 450000 | SS INDUSTRIAL SELECT SECTOR | uw_borrow_rates | /api/shorts/XLI/data | {} | 2026-09-10 | 2026-09-10 17:00 | 2026-09-10 17:00 |