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 = CAT×
| 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|
| CAT | 2026-09-10 05:55 | 0.4081 | 3.2219 | 2100000 | CATERPILLAR INC | uw_borrow_rates | /api/shorts/CAT/data | {} | 2026-09-10 | 2026-09-10 17:00 | 2026-09-10 17:00 |
| CAT | 2026-09-10 05:24 | 0.4081 | 3.2219 | 2100000 | CATERPILLAR INC | uw_borrow_rates | /api/shorts/CAT/data | {} | 2026-09-10 | 2026-09-10 17:00 | 2026-09-10 17:00 |
| CAT | 2026-09-09 11:23 | 0.4081 | 3.2219 | 2100000 | CATERPILLAR INC | uw_borrow_rates | /api/shorts/CAT/data | {} | 2026-09-09 | 2026-09-09 17:00 | 2026-09-09 17:00 |
| CAT | 2026-09-09 10:52 | 0.4081 | 3.2219 | 2100000 | CATERPILLAR INC | uw_borrow_rates | /api/shorts/CAT/data | {} | 2026-09-09 | 2026-09-09 17:00 | 2026-09-09 17:00 |
| CAT | 2026-09-09 10:21 | 0.4081 | 3.2219 | 2100000 | CATERPILLAR INC | uw_borrow_rates | /api/shorts/CAT/data | {} | 2026-09-09 | 2026-09-09 17:00 | 2026-09-09 17:00 |
| CAT | 2026-09-09 09:49 | 0.4081 | 3.2219 | 2100000 | CATERPILLAR INC | uw_borrow_rates | /api/shorts/CAT/data | {} | 2026-09-09 | 2026-09-09 17:00 | 2026-09-09 17:00 |
| CAT | 2026-09-09 09:18 | 0.4081 | 3.2219 | 2100000 | CATERPILLAR INC | uw_borrow_rates | /api/shorts/CAT/data | {} | 2026-09-09 | 2026-09-09 17:00 | 2026-09-09 17:00 |
| CAT | 2026-09-09 08:47 | 0.4081 | 3.2219 | 2100000 | CATERPILLAR INC | uw_borrow_rates | /api/shorts/CAT/data | {} | 2026-09-09 | 2026-09-09 17:00 | 2026-09-09 17:00 |
| CAT | 2026-09-09 08:16 | 0.4081 | 3.2219 | 2100000 | CATERPILLAR INC | uw_borrow_rates | /api/shorts/CAT/data | {} | 2026-09-09 | 2026-09-09 17:00 | 2026-09-09 17:00 |
| CAT | 2026-09-09 07:44 | 0.4081 | 3.2219 | 2100000 | CATERPILLAR INC | uw_borrow_rates | /api/shorts/CAT/data | {} | 2026-09-09 | 2026-09-09 17:00 | 2026-09-09 17:00 |
| CAT | 2026-09-09 07:29 | 0.4081 | 3.2219 | 2100000 | CATERPILLAR INC | uw_borrow_rates | /api/shorts/CAT/data | {} | 2026-09-09 | 2026-09-09 17:00 | 2026-09-09 17:00 |
| CAT | 2026-09-09 06:57 | 0.4081 | 3.2219 | 2100000 | CATERPILLAR INC | uw_borrow_rates | /api/shorts/CAT/data | {} | 2026-09-09 | 2026-09-09 17:00 | 2026-09-09 17:00 |
| CAT | 2026-09-09 06:26 | 0.4081 | 3.2219 | 2100000 | CATERPILLAR INC | uw_borrow_rates | /api/shorts/CAT/data | {} | 2026-09-09 | 2026-09-09 17:00 | 2026-09-09 17:00 |
| CAT | 2026-09-09 05:55 | 0.4081 | 3.2219 | 2100000 | CATERPILLAR INC | uw_borrow_rates | /api/shorts/CAT/data | {} | 2026-09-09 | 2026-09-09 17:00 | 2026-09-09 17:00 |
| CAT | 2026-09-09 05:39 | 0.4081 | 3.2219 | 2100000 | CATERPILLAR INC | uw_borrow_rates | /api/shorts/CAT/data | {} | 2026-09-09 | 2026-09-09 17:00 | 2026-09-09 17:00 |
| CAT | 2026-09-08 11:23 | 0.4081 | 3.2219 | 2500000 | CATERPILLAR INC | uw_borrow_rates | /api/shorts/CAT/data | {} | 2026-09-08 | 2026-09-08 17:00 | 2026-09-08 17:00 |
| CAT | 2026-09-08 10:52 | 0.4081 | 3.2219 | 2500000 | CATERPILLAR INC | uw_borrow_rates | /api/shorts/CAT/data | {} | 2026-09-08 | 2026-09-08 17:00 | 2026-09-08 17:00 |
| CAT | 2026-09-08 10:21 | 0.4081 | 3.2219 | 2500000 | CATERPILLAR INC | uw_borrow_rates | /api/shorts/CAT/data | {} | 2026-09-08 | 2026-09-08 17:00 | 2026-09-08 17:00 |
| CAT | 2026-09-08 09:50 | 0.4081 | 3.2219 | 2500000 | CATERPILLAR INC | uw_borrow_rates | /api/shorts/CAT/data | {} | 2026-09-08 | 2026-09-08 17:00 | 2026-09-08 17:00 |
| CAT | 2026-09-08 09:18 | 0.4081 | 3.2219 | 2500000 | CATERPILLAR INC | uw_borrow_rates | /api/shorts/CAT/data | {} | 2026-09-08 | 2026-09-08 17:00 | 2026-09-08 17:00 |
| CAT | 2026-09-08 08:47 | 0.4081 | 3.2219 | 2500000 | CATERPILLAR INC | uw_borrow_rates | /api/shorts/CAT/data | {} | 2026-09-08 | 2026-09-08 17:00 | 2026-09-08 17:00 |
| CAT | 2026-09-08 08:16 | 0.4081 | 3.2219 | 2500000 | CATERPILLAR INC | uw_borrow_rates | /api/shorts/CAT/data | {} | 2026-09-08 | 2026-09-08 17:00 | 2026-09-08 17:00 |
| CAT | 2026-09-08 07:44 | 0.4081 | 3.2219 | 2600000 | CATERPILLAR INC | uw_borrow_rates | /api/shorts/CAT/data | {} | 2026-09-08 | 2026-09-08 17:00 | 2026-09-08 17:00 |
| CAT | 2026-09-08 07:29 | 0.4081 | 3.2219 | 2600000 | CATERPILLAR INC | uw_borrow_rates | /api/shorts/CAT/data | {} | 2026-09-08 | 2026-09-08 17:00 | 2026-09-08 17:00 |
| CAT | 2026-09-08 06:58 | 0.4081 | 3.2219 | 2600000 | CATERPILLAR INC | uw_borrow_rates | /api/shorts/CAT/data | {} | 2026-09-08 | 2026-09-08 17:00 | 2026-09-08 17:00 |
| CAT | 2026-09-08 06:26 | 0.4081 | 3.2219 | 2600000 | CATERPILLAR INC | uw_borrow_rates | /api/shorts/CAT/data | {} | 2026-09-08 | 2026-09-08 17:00 | 2026-09-08 17:00 |
| CAT | 2026-09-08 05:55 | 0.4081 | 3.2219 | 2600000 | CATERPILLAR INC | uw_borrow_rates | /api/shorts/CAT/data | {} | 2026-09-08 | 2026-09-08 17:00 | 2026-09-08 17:00 |
| CAT | 2026-09-08 05:24 | 0.4081 | 3.2219 | 2600000 | CATERPILLAR INC | uw_borrow_rates | /api/shorts/CAT/data | {} | 2026-09-08 | 2026-09-08 17:00 | 2026-09-08 17:00 |
| CAT | 2026-09-04 11:23 | 0.4081 | 3.2219 | 2500000 | CATERPILLAR INC | uw_borrow_rates | /api/shorts/CAT/data | {} | 2026-09-04 | 2026-09-07 00:35 | 2026-09-07 00:35 |
| CAT | 2026-09-04 10:52 | 0.4081 | 3.2219 | 2500000 | CATERPILLAR INC | uw_borrow_rates | /api/shorts/CAT/data | {} | 2026-09-04 | 2026-09-07 00:35 | 2026-09-07 00:35 |
| CAT | 2026-09-04 10:21 | 0.4081 | 3.2219 | 2500000 | CATERPILLAR INC | uw_borrow_rates | /api/shorts/CAT/data | {} | 2026-09-04 | 2026-09-07 00:35 | 2026-09-07 00:35 |
| CAT | 2026-09-04 09:49 | 0.4081 | 3.2219 | 2500000 | CATERPILLAR INC | uw_borrow_rates | /api/shorts/CAT/data | {} | 2026-09-04 | 2026-09-07 00:35 | 2026-09-07 00:35 |
| CAT | 2026-09-04 09:18 | 0.4081 | 3.2219 | 2600000 | CATERPILLAR INC | uw_borrow_rates | /api/shorts/CAT/data | {} | 2026-09-04 | 2026-09-07 00:35 | 2026-09-07 00:35 |
| CAT | 2026-09-04 08:47 | 0.4081 | 3.2219 | 2600000 | CATERPILLAR INC | uw_borrow_rates | /api/shorts/CAT/data | {} | 2026-09-04 | 2026-09-07 00:35 | 2026-09-07 00:35 |
| CAT | 2026-09-04 08:16 | 0.4081 | 3.2219 | 2600000 | CATERPILLAR INC | uw_borrow_rates | /api/shorts/CAT/data | {} | 2026-09-04 | 2026-09-07 00:35 | 2026-09-07 00:35 |
| CAT | 2026-09-04 07:44 | 0.4081 | 3.2219 | 2600000 | CATERPILLAR INC | uw_borrow_rates | /api/shorts/CAT/data | {} | 2026-09-04 | 2026-09-07 00:35 | 2026-09-07 00:35 |
| CAT | 2026-09-04 07:29 | 0.4081 | 3.2219 | 2600000 | CATERPILLAR INC | uw_borrow_rates | /api/shorts/CAT/data | {} | 2026-09-04 | 2026-09-07 00:35 | 2026-09-07 00:35 |
| CAT | 2026-09-04 05:55 | 0.4081 | 3.2219 | 2600000 | CATERPILLAR INC | uw_borrow_rates | /api/shorts/CAT/data | {} | 2026-09-04 | 2026-09-07 00:35 | 2026-09-07 00:35 |
| CAT | 2026-09-04 05:23 | 0.4081 | 3.2219 | 2600000 | CATERPILLAR INC | uw_borrow_rates | /api/shorts/CAT/data | {} | 2026-09-04 | 2026-09-07 00:35 | 2026-09-07 00:35 |
| CAT | 2026-09-03 11:23 | 0.4081 | 3.2219 | 2500000 | CATERPILLAR INC | uw_borrow_rates | /api/shorts/CAT/data | {} | 2026-09-04 | 2026-09-07 00:35 | 2026-09-07 00:35 |
| CAT | 2026-09-03 10:52 | 0.4081 | 3.2219 | 2500000 | CATERPILLAR INC | uw_borrow_rates | /api/shorts/CAT/data | {} | 2026-09-04 | 2026-09-07 00:35 | 2026-09-07 00:35 |
| CAT | 2026-09-03 10:20 | 0.4081 | 3.2219 | 2600000 | CATERPILLAR INC | uw_borrow_rates | /api/shorts/CAT/data | {} | 2026-09-04 | 2026-09-07 00:35 | 2026-09-07 00:35 |
| CAT | 2026-09-03 09:49 | 0.4081 | 3.2219 | 2600000 | CATERPILLAR INC | uw_borrow_rates | /api/shorts/CAT/data | {} | 2026-09-04 | 2026-09-07 00:35 | 2026-09-07 00:35 |
| CAT | 2026-09-03 09:18 | 0.4081 | 3.2219 | 2600000 | CATERPILLAR INC | uw_borrow_rates | /api/shorts/CAT/data | {} | 2026-09-04 | 2026-09-07 00:35 | 2026-09-07 00:35 |
| CAT | 2026-09-03 08:47 | 0.4081 | 3.2219 | 2600000 | CATERPILLAR INC | uw_borrow_rates | /api/shorts/CAT/data | {} | 2026-09-04 | 2026-09-07 00:35 | 2026-09-07 00:35 |
| CAT | 2026-09-03 08:16 | 0.4081 | 3.2219 | 2600000 | CATERPILLAR INC | uw_borrow_rates | /api/shorts/CAT/data | {} | 2026-09-04 | 2026-09-07 00:35 | 2026-09-07 00:35 |
| CAT | 2026-09-03 07:44 | 0.4081 | 3.2219 | 2600000 | CATERPILLAR INC | uw_borrow_rates | /api/shorts/CAT/data | {} | 2026-09-04 | 2026-09-07 00:35 | 2026-09-07 00:35 |
| CAT | 2026-09-03 07:29 | 0.4081 | 3.2219 | 2600000 | CATERPILLAR INC | uw_borrow_rates | /api/shorts/CAT/data | {} | 2026-09-04 | 2026-09-07 00:35 | 2026-09-07 00:35 |
| CAT | 2026-09-03 06:58 | 0.4081 | 3.2219 | 2600000 | CATERPILLAR INC | uw_borrow_rates | /api/shorts/CAT/data | {} | 2026-09-04 | 2026-09-07 00:35 | 2026-09-07 00:35 |
| CAT | 2026-09-03 06:26 | 0.4081 | 3.2219 | 2600000 | CATERPILLAR INC | uw_borrow_rates | /api/shorts/CAT/data | {} | 2026-09-04 | 2026-09-07 00:35 | 2026-09-07 00:35 |