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:symbol = XLE×
| 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|
| XLE | 2026-09-10 05:55 | 0.3977 | 3.2323 | 3900000 | SS ENERGY SELECT SECTOR | uw_borrow_rates | /api/shorts/XLE/data | {} | 2026-09-10 | 2026-09-10 17:00 | 2026-09-10 17:00 |
| XLE | 2026-09-10 05:24 | 0.3977 | 3.2323 | 3200000 | SS ENERGY SELECT SECTOR | uw_borrow_rates | /api/shorts/XLE/data | {} | 2026-09-10 | 2026-09-10 17:00 | 2026-09-10 17:00 |
| XLE | 2026-09-09 11:23 | 0.3977 | 3.2323 | 4100000 | SS ENERGY SELECT SECTOR | uw_borrow_rates | /api/shorts/XLE/data | {} | 2026-09-09 | 2026-09-09 17:00 | 2026-09-09 17:00 |
| XLE | 2026-09-09 10:52 | 0.3977 | 3.2323 | 4100000 | SS ENERGY SELECT SECTOR | uw_borrow_rates | /api/shorts/XLE/data | {} | 2026-09-09 | 2026-09-09 17:00 | 2026-09-09 17:00 |
| XLE | 2026-09-09 10:21 | 0.3977 | 3.2323 | 4100000 | SS ENERGY SELECT SECTOR | uw_borrow_rates | /api/shorts/XLE/data | {} | 2026-09-09 | 2026-09-09 17:00 | 2026-09-09 17:00 |
| XLE | 2026-09-09 09:49 | 0.3977 | 3.2323 | 4100000 | SS ENERGY SELECT SECTOR | uw_borrow_rates | /api/shorts/XLE/data | {} | 2026-09-09 | 2026-09-09 17:00 | 2026-09-09 17:00 |
| XLE | 2026-09-09 09:18 | 0.3977 | 3.2323 | 4100000 | SS ENERGY SELECT SECTOR | uw_borrow_rates | /api/shorts/XLE/data | {} | 2026-09-09 | 2026-09-09 17:00 | 2026-09-09 17:00 |
| XLE | 2026-09-09 08:47 | 0.3977 | 3.2323 | 4200000 | SS ENERGY SELECT SECTOR | uw_borrow_rates | /api/shorts/XLE/data | {} | 2026-09-09 | 2026-09-09 17:00 | 2026-09-09 17:00 |
| XLE | 2026-09-09 08:16 | 0.3819 | 3.2481 | 4100000 | SS ENERGY SELECT SECTOR | uw_borrow_rates | /api/shorts/XLE/data | {} | 2026-09-09 | 2026-09-09 17:00 | 2026-09-09 17:00 |
| XLE | 2026-09-09 07:44 | 0.3819 | 3.2481 | 3900000 | SS ENERGY SELECT SECTOR | uw_borrow_rates | /api/shorts/XLE/data | {} | 2026-09-09 | 2026-09-09 17:00 | 2026-09-09 17:00 |
| XLE | 2026-09-09 07:29 | 0.3819 | 3.2481 | 3900000 | SS ENERGY SELECT SECTOR | uw_borrow_rates | /api/shorts/XLE/data | {} | 2026-09-09 | 2026-09-09 17:00 | 2026-09-09 17:00 |
| XLE | 2026-09-09 06:57 | 0.3819 | 3.2481 | 3900000 | SS ENERGY SELECT SECTOR | uw_borrow_rates | /api/shorts/XLE/data | {} | 2026-09-09 | 2026-09-09 17:00 | 2026-09-09 17:00 |
| XLE | 2026-09-09 06:26 | 0.3819 | 3.2481 | 3200000 | SS ENERGY SELECT SECTOR | uw_borrow_rates | /api/shorts/XLE/data | {} | 2026-09-09 | 2026-09-09 17:00 | 2026-09-09 17:00 |
| XLE | 2026-09-09 05:55 | 0.3819 | 3.2481 | 3400000 | SS ENERGY SELECT SECTOR | uw_borrow_rates | /api/shorts/XLE/data | {} | 2026-09-09 | 2026-09-09 17:00 | 2026-09-09 17:00 |
| XLE | 2026-09-09 05:39 | 0.3819 | 3.2481 | 3500000 | SS ENERGY SELECT SECTOR | uw_borrow_rates | /api/shorts/XLE/data | {} | 2026-09-09 | 2026-09-09 17:00 | 2026-09-09 17:00 |
| XLE | 2026-09-08 11:23 | 0.3819 | 3.2481 | 4200000 | SS ENERGY SELECT SECTOR | uw_borrow_rates | /api/shorts/XLE/data | {} | 2026-09-08 | 2026-09-08 17:00 | 2026-09-08 17:00 |
| XLE | 2026-09-08 10:52 | 0.3819 | 3.2481 | 4200000 | SS ENERGY SELECT SECTOR | uw_borrow_rates | /api/shorts/XLE/data | {} | 2026-09-08 | 2026-09-08 17:00 | 2026-09-08 17:00 |
| XLE | 2026-09-08 10:21 | 0.3819 | 3.2481 | 4200000 | SS ENERGY SELECT SECTOR | uw_borrow_rates | /api/shorts/XLE/data | {} | 2026-09-08 | 2026-09-08 17:00 | 2026-09-08 17:00 |
| XLE | 2026-09-08 09:50 | 0.3819 | 3.2481 | 4200000 | SS ENERGY SELECT SECTOR | uw_borrow_rates | /api/shorts/XLE/data | {} | 2026-09-08 | 2026-09-08 17:00 | 2026-09-08 17:00 |
| XLE | 2026-09-08 09:18 | 0.4067 | 3.2233 | 4400000 | SS ENERGY SELECT SECTOR | uw_borrow_rates | /api/shorts/XLE/data | {} | 2026-09-08 | 2026-09-08 17:00 | 2026-09-08 17:00 |
| XLE | 2026-09-08 08:47 | 0.4067 | 3.2233 | 4400000 | SS ENERGY SELECT SECTOR | uw_borrow_rates | /api/shorts/XLE/data | {} | 2026-09-08 | 2026-09-08 17:00 | 2026-09-08 17:00 |
| XLE | 2026-09-08 08:16 | 0.4067 | 3.2233 | 4400000 | SS ENERGY SELECT SECTOR | uw_borrow_rates | /api/shorts/XLE/data | {} | 2026-09-08 | 2026-09-08 17:00 | 2026-09-08 17:00 |
| XLE | 2026-09-08 07:44 | 0.4067 | 3.2233 | 4500000 | SS ENERGY SELECT SECTOR | uw_borrow_rates | /api/shorts/XLE/data | {} | 2026-09-08 | 2026-09-08 17:00 | 2026-09-08 17:00 |
| XLE | 2026-09-08 07:29 | 0.4067 | 3.2233 | 4500000 | SS ENERGY SELECT SECTOR | uw_borrow_rates | /api/shorts/XLE/data | {} | 2026-09-08 | 2026-09-08 17:00 | 2026-09-08 17:00 |
| XLE | 2026-09-08 06:58 | 0.4067 | 3.2233 | 4400000 | SS ENERGY SELECT SECTOR | uw_borrow_rates | /api/shorts/XLE/data | {} | 2026-09-08 | 2026-09-08 17:00 | 2026-09-08 17:00 |
| XLE | 2026-09-08 06:26 | 0.4067 | 3.2233 | 4900000 | SS ENERGY SELECT SECTOR | uw_borrow_rates | /api/shorts/XLE/data | {} | 2026-09-08 | 2026-09-08 17:00 | 2026-09-08 17:00 |
| XLE | 2026-09-08 05:55 | 0.4067 | 3.2233 | 4900000 | SS ENERGY SELECT SECTOR | uw_borrow_rates | /api/shorts/XLE/data | {} | 2026-09-08 | 2026-09-08 17:00 | 2026-09-08 17:00 |
| XLE | 2026-09-08 05:24 | 0.4067 | 3.2233 | 4000000 | SS ENERGY SELECT SECTOR | uw_borrow_rates | /api/shorts/XLE/data | {} | 2026-09-08 | 2026-09-08 17:00 | 2026-09-08 17:00 |
| XLE | 2026-09-04 11:23 | 0.4067 | 3.2233 | 4600000 | SS ENERGY SELECT SECTOR | uw_borrow_rates | /api/shorts/XLE/data | {} | 2026-09-04 | 2026-09-07 00:35 | 2026-09-07 00:35 |
| XLE | 2026-09-04 10:52 | 0.4067 | 3.2233 | 4700000 | SS ENERGY SELECT SECTOR | uw_borrow_rates | /api/shorts/XLE/data | {} | 2026-09-04 | 2026-09-07 00:35 | 2026-09-07 00:35 |
| XLE | 2026-09-04 10:21 | 0.4067 | 3.2233 | 4700000 | SS ENERGY SELECT SECTOR | uw_borrow_rates | /api/shorts/XLE/data | {} | 2026-09-04 | 2026-09-07 00:35 | 2026-09-07 00:35 |
| XLE | 2026-09-04 09:49 | 0.4067 | 3.2233 | 4700000 | SS ENERGY SELECT SECTOR | uw_borrow_rates | /api/shorts/XLE/data | {} | 2026-09-04 | 2026-09-07 00:35 | 2026-09-07 00:35 |
| XLE | 2026-09-04 09:18 | 0.4067 | 3.2233 | 4800000 | SS ENERGY SELECT SECTOR | uw_borrow_rates | /api/shorts/XLE/data | {} | 2026-09-04 | 2026-09-07 00:35 | 2026-09-07 00:35 |
| XLE | 2026-09-04 08:47 | 0.4067 | 3.2233 | 4800000 | SS ENERGY SELECT SECTOR | uw_borrow_rates | /api/shorts/XLE/data | {} | 2026-09-04 | 2026-09-07 00:35 | 2026-09-07 00:35 |
| XLE | 2026-09-04 08:16 | 0.4070 | 3.2230 | 4800000 | SS ENERGY SELECT SECTOR | uw_borrow_rates | /api/shorts/XLE/data | {} | 2026-09-04 | 2026-09-07 00:35 | 2026-09-07 00:35 |
| XLE | 2026-09-04 07:44 | 0.4070 | 3.2230 | 4700000 | SS ENERGY SELECT SECTOR | uw_borrow_rates | /api/shorts/XLE/data | {} | 2026-09-04 | 2026-09-07 00:35 | 2026-09-07 00:35 |
| XLE | 2026-09-04 07:29 | 0.4070 | 3.2230 | 4700000 | SS ENERGY SELECT SECTOR | uw_borrow_rates | /api/shorts/XLE/data | {} | 2026-09-04 | 2026-09-07 00:35 | 2026-09-07 00:35 |
| XLE | 2026-09-04 05:55 | 0.4070 | 3.2230 | 4500000 | SS ENERGY SELECT SECTOR | uw_borrow_rates | /api/shorts/XLE/data | {} | 2026-09-04 | 2026-09-07 00:35 | 2026-09-07 00:35 |
| XLE | 2026-09-04 05:23 | 0.4070 | 3.2230 | 4500000 | SS ENERGY SELECT SECTOR | uw_borrow_rates | /api/shorts/XLE/data | {} | 2026-09-04 | 2026-09-07 00:35 | 2026-09-07 00:35 |
| XLE | 2026-09-03 11:23 | 0.4070 | 3.2230 | 5900000 | SS ENERGY SELECT SECTOR | uw_borrow_rates | /api/shorts/XLE/data | {} | 2026-09-04 | 2026-09-07 00:35 | 2026-09-07 00:35 |
| XLE | 2026-09-03 10:52 | 0.4070 | 3.2230 | 5900000 | SS ENERGY SELECT SECTOR | uw_borrow_rates | /api/shorts/XLE/data | {} | 2026-09-04 | 2026-09-07 00:35 | 2026-09-07 00:35 |
| XLE | 2026-09-03 10:20 | 0.4070 | 3.2230 | 5900000 | SS ENERGY SELECT SECTOR | uw_borrow_rates | /api/shorts/XLE/data | {} | 2026-09-04 | 2026-09-07 00:35 | 2026-09-07 00:35 |
| XLE | 2026-09-03 09:49 | 0.4070 | 3.2230 | 6000000 | SS ENERGY SELECT SECTOR | uw_borrow_rates | /api/shorts/XLE/data | {} | 2026-09-04 | 2026-09-07 00:35 | 2026-09-07 00:35 |
| XLE | 2026-09-03 09:18 | 0.4070 | 3.2230 | 6000000 | SS ENERGY SELECT SECTOR | uw_borrow_rates | /api/shorts/XLE/data | {} | 2026-09-04 | 2026-09-07 00:35 | 2026-09-07 00:35 |
| XLE | 2026-09-03 08:47 | 0.4070 | 3.2230 | 6000000 | SS ENERGY SELECT SECTOR | uw_borrow_rates | /api/shorts/XLE/data | {} | 2026-09-04 | 2026-09-07 00:35 | 2026-09-07 00:35 |
| XLE | 2026-09-03 08:16 | 0.4070 | 3.2230 | 6000000 | SS ENERGY SELECT SECTOR | uw_borrow_rates | /api/shorts/XLE/data | {} | 2026-09-04 | 2026-09-07 00:35 | 2026-09-07 00:35 |
| XLE | 2026-09-03 07:44 | 0.4070 | 3.2230 | 6100000 | SS ENERGY SELECT SECTOR | uw_borrow_rates | /api/shorts/XLE/data | {} | 2026-09-04 | 2026-09-07 00:35 | 2026-09-07 00:35 |
| XLE | 2026-09-03 07:29 | 0.4070 | 3.2230 | 6100000 | SS ENERGY SELECT SECTOR | uw_borrow_rates | /api/shorts/XLE/data | {} | 2026-09-04 | 2026-09-07 00:35 | 2026-09-07 00:35 |
| XLE | 2026-09-03 06:58 | 0.4075 | 3.2225 | 6100000 | SS ENERGY SELECT SECTOR | uw_borrow_rates | /api/shorts/XLE/data | {} | 2026-09-04 | 2026-09-07 00:35 | 2026-09-07 00:35 |
| XLE | 2026-09-03 06:26 | 0.4075 | 3.2225 | 6400000 | SS ENERGY SELECT SECTOR | uw_borrow_rates | /api/shorts/XLE/data | {} | 2026-09-04 | 2026-09-07 00:35 | 2026-09-07 00:35 |