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-15 11:20 | 0.2903 | 3.3397 | 4000000 | SS ENERGY SELECT SECTOR | uw_borrow_rates | /api/shorts/XLE/data | {} | 2026-09-15 | 2026-09-15 17:00 | 2026-09-15 17:00 |
| XLE | 2026-09-15 10:48 | 0.2903 | 3.3397 | 4200000 | SS ENERGY SELECT SECTOR | uw_borrow_rates | /api/shorts/XLE/data | {} | 2026-09-15 | 2026-09-15 17:00 | 2026-09-15 17:00 |
| XLE | 2026-09-15 10:17 | 0.2903 | 3.3397 | 4200000 | SS ENERGY SELECT SECTOR | uw_borrow_rates | /api/shorts/XLE/data | {} | 2026-09-15 | 2026-09-15 17:00 | 2026-09-15 17:00 |
| XLE | 2026-09-15 09:46 | 0.2903 | 3.3397 | 4200000 | SS ENERGY SELECT SECTOR | uw_borrow_rates | /api/shorts/XLE/data | {} | 2026-09-15 | 2026-09-15 17:00 | 2026-09-15 17:00 |
| XLE | 2026-09-15 09:14 | 0.2903 | 3.3397 | 4200000 | SS ENERGY SELECT SECTOR | uw_borrow_rates | /api/shorts/XLE/data | {} | 2026-09-15 | 2026-09-15 17:00 | 2026-09-15 17:00 |
| XLE | 2026-09-15 08:58 | 0.2903 | 3.3397 | 4200000 | SS ENERGY SELECT SECTOR | uw_borrow_rates | /api/shorts/XLE/data | {} | 2026-09-15 | 2026-09-15 17:00 | 2026-09-15 17:00 |
| XLE | 2026-09-15 08:27 | 0.2903 | 3.3397 | 4200000 | SS ENERGY SELECT SECTOR | uw_borrow_rates | /api/shorts/XLE/data | {} | 2026-09-15 | 2026-09-15 17:00 | 2026-09-15 17:00 |
| XLE | 2026-09-15 07:55 | 0.2903 | 3.3397 | 4200000 | SS ENERGY SELECT SECTOR | uw_borrow_rates | /api/shorts/XLE/data | {} | 2026-09-15 | 2026-09-15 17:00 | 2026-09-15 17:00 |
| XLE | 2026-09-15 07:23 | 0.2903 | 3.3397 | 4100000 | SS ENERGY SELECT SECTOR | uw_borrow_rates | /api/shorts/XLE/data | {} | 2026-09-15 | 2026-09-15 17:00 | 2026-09-15 17:00 |
| XLE | 2026-09-15 06:51 | 0.2903 | 3.3397 | 4000000 | SS ENERGY SELECT SECTOR | uw_borrow_rates | /api/shorts/XLE/data | {} | 2026-09-15 | 2026-09-15 17:00 | 2026-09-15 17:00 |
| XLE | 2026-09-15 06:19 | 0.2903 | 3.3397 | 3900000 | SS ENERGY SELECT SECTOR | uw_borrow_rates | /api/shorts/XLE/data | {} | 2026-09-15 | 2026-09-15 17:00 | 2026-09-15 17:00 |
| XLE | 2026-09-15 05:47 | 0.2903 | 3.3397 | 3800000 | SS ENERGY SELECT SECTOR | uw_borrow_rates | /api/shorts/XLE/data | {} | 2026-09-15 | 2026-09-15 17:00 | 2026-09-15 17:00 |
| XLE | 2026-09-15 05:15 | 0.2916 | 3.3384 | 3600000 | SS ENERGY SELECT SECTOR | uw_borrow_rates | /api/shorts/XLE/data | {} | 2026-09-15 | 2026-09-15 17:00 | 2026-09-15 17:00 |
| XLE | 2026-09-14 11:27 | 0.2916 | 3.3384 | 3200000 | SS ENERGY SELECT SECTOR | uw_borrow_rates | /api/shorts/XLE/data | {} | 2026-09-14 | 2026-09-14 17:00 | 2026-09-14 17:00 |
| XLE | 2026-09-14 10:55 | 0.2916 | 3.3384 | 3200000 | SS ENERGY SELECT SECTOR | uw_borrow_rates | /api/shorts/XLE/data | {} | 2026-09-14 | 2026-09-14 17:00 | 2026-09-14 17:00 |
| XLE | 2026-09-14 10:24 | 0.2916 | 3.3384 | 3200000 | SS ENERGY SELECT SECTOR | uw_borrow_rates | /api/shorts/XLE/data | {} | 2026-09-14 | 2026-09-14 17:00 | 2026-09-14 17:00 |
| XLE | 2026-09-14 09:52 | 0.2916 | 3.3384 | 3200000 | SS ENERGY SELECT SECTOR | uw_borrow_rates | /api/shorts/XLE/data | {} | 2026-09-14 | 2026-09-14 17:00 | 2026-09-14 17:00 |
| XLE | 2026-09-14 09:21 | 0.2916 | 3.3384 | 3300000 | SS ENERGY SELECT SECTOR | uw_borrow_rates | /api/shorts/XLE/data | {} | 2026-09-14 | 2026-09-14 17:00 | 2026-09-14 17:00 |
| XLE | 2026-09-14 08:50 | 0.2916 | 3.3384 | 3300000 | SS ENERGY SELECT SECTOR | uw_borrow_rates | /api/shorts/XLE/data | {} | 2026-09-14 | 2026-09-14 17:00 | 2026-09-14 17:00 |
| XLE | 2026-09-14 08:18 | 0.2990 | 3.3310 | 3300000 | SS ENERGY SELECT SECTOR | uw_borrow_rates | /api/shorts/XLE/data | {} | 2026-09-14 | 2026-09-14 17:00 | 2026-09-14 17:00 |
| XLE | 2026-09-14 07:47 | 0.2990 | 3.3310 | 3200000 | SS ENERGY SELECT SECTOR | uw_borrow_rates | /api/shorts/XLE/data | {} | 2026-09-14 | 2026-09-14 17:00 | 2026-09-14 17:00 |
| XLE | 2026-09-14 07:15 | 0.2990 | 3.3310 | 3400000 | SS ENERGY SELECT SECTOR | uw_borrow_rates | /api/shorts/XLE/data | {} | 2026-09-14 | 2026-09-14 17:00 | 2026-09-14 17:00 |
| XLE | 2026-09-14 06:42 | 0.2990 | 3.3310 | 3400000 | SS ENERGY SELECT SECTOR | uw_borrow_rates | /api/shorts/XLE/data | {} | 2026-09-14 | 2026-09-14 17:00 | 2026-09-14 17:00 |
| XLE | 2026-09-14 06:26 | 0.2990 | 3.3310 | 3300000 | SS ENERGY SELECT SECTOR | uw_borrow_rates | /api/shorts/XLE/data | {} | 2026-09-14 | 2026-09-14 17:00 | 2026-09-14 17:00 |
| XLE | 2026-09-14 05:54 | 0.2990 | 3.3310 | 3300000 | SS ENERGY SELECT SECTOR | uw_borrow_rates | /api/shorts/XLE/data | {} | 2026-09-14 | 2026-09-14 17:00 | 2026-09-14 17:00 |
| XLE | 2026-09-14 05:23 | 0.2990 | 3.3310 | 3800000 | SS ENERGY SELECT SECTOR | uw_borrow_rates | /api/shorts/XLE/data | {} | 2026-09-14 | 2026-09-14 17:00 | 2026-09-14 17:00 |
| XLE | 2026-09-11 11:24 | 0.3830 | 3.2470 | 4500000 | SS ENERGY SELECT SECTOR | uw_borrow_rates | /api/shorts/XLE/data | {} | 2026-09-11 | 2026-09-11 17:00 | 2026-09-11 17:00 |
| XLE | 2026-09-11 10:53 | 0.3830 | 3.2470 | 4500000 | SS ENERGY SELECT SECTOR | uw_borrow_rates | /api/shorts/XLE/data | {} | 2026-09-11 | 2026-09-11 17:00 | 2026-09-11 17:00 |
| XLE | 2026-09-11 10:21 | 0.3830 | 3.2470 | 4700000 | SS ENERGY SELECT SECTOR | uw_borrow_rates | /api/shorts/XLE/data | {} | 2026-09-11 | 2026-09-11 17:00 | 2026-09-11 17:00 |
| XLE | 2026-09-11 09:50 | 0.3830 | 3.2470 | 4700000 | SS ENERGY SELECT SECTOR | uw_borrow_rates | /api/shorts/XLE/data | {} | 2026-09-11 | 2026-09-11 17:00 | 2026-09-11 17:00 |
| XLE | 2026-09-11 09:19 | 0.3830 | 3.2470 | 4700000 | SS ENERGY SELECT SECTOR | uw_borrow_rates | /api/shorts/XLE/data | {} | 2026-09-11 | 2026-09-11 17:00 | 2026-09-11 17:00 |
| XLE | 2026-09-11 08:47 | 0.3830 | 3.2470 | 4700000 | SS ENERGY SELECT SECTOR | uw_borrow_rates | /api/shorts/XLE/data | {} | 2026-09-11 | 2026-09-11 17:00 | 2026-09-11 17:00 |
| XLE | 2026-09-11 08:16 | 0.3834 | 3.2466 | 4700000 | SS ENERGY SELECT SECTOR | uw_borrow_rates | /api/shorts/XLE/data | {} | 2026-09-11 | 2026-09-11 17:00 | 2026-09-11 17:00 |
| XLE | 2026-09-11 07:45 | 0.3834 | 3.2466 | 4500000 | SS ENERGY SELECT SECTOR | uw_borrow_rates | /api/shorts/XLE/data | {} | 2026-09-11 | 2026-09-11 17:00 | 2026-09-11 17:00 |
| XLE | 2026-09-11 07:14 | 0.3810 | 3.2490 | 4500000 | SS ENERGY SELECT SECTOR | uw_borrow_rates | /api/shorts/XLE/data | {} | 2026-09-11 | 2026-09-11 17:00 | 2026-09-11 17:00 |
| XLE | 2026-09-11 06:58 | 0.3810 | 3.2490 | 4500000 | SS ENERGY SELECT SECTOR | uw_borrow_rates | /api/shorts/XLE/data | {} | 2026-09-11 | 2026-09-11 17:00 | 2026-09-11 17:00 |
| XLE | 2026-09-11 06:27 | 0.3810 | 3.2490 | 4400000 | SS ENERGY SELECT SECTOR | uw_borrow_rates | /api/shorts/XLE/data | {} | 2026-09-11 | 2026-09-11 17:00 | 2026-09-11 17:00 |
| XLE | 2026-09-11 05:55 | 0.3810 | 3.2490 | 4500000 | SS ENERGY SELECT SECTOR | uw_borrow_rates | /api/shorts/XLE/data | {} | 2026-09-11 | 2026-09-11 17:00 | 2026-09-11 17:00 |
| XLE | 2026-09-11 05:24 | 0.3810 | 3.2490 | 3600000 | SS ENERGY SELECT SECTOR | uw_borrow_rates | /api/shorts/XLE/data | {} | 2026-09-11 | 2026-09-11 17:00 | 2026-09-11 17:00 |
| XLE | 2026-09-10 11:23 | 0.3819 | 3.2481 | 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 10:52 | 0.3819 | 3.2481 | 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 10:20 | 0.4015 | 3.2285 | 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 09:49 | 0.4015 | 3.2285 | 3800000 | 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 09:18 | 0.4015 | 3.2285 | 3800000 | 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 08:47 | 0.4015 | 3.2285 | 3800000 | 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 08:16 | 0.3988 | 3.2312 | 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 07:44 | 0.3988 | 3.2312 | 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 07:29 | 0.3988 | 3.2312 | 3800000 | 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 06:57 | 0.3977 | 3.2323 | 3800000 | 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 06:26 | 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 |