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-15 11:20 | 0.4081 | 3.2219 | 4600000 | CATERPILLAR INC | uw_borrow_rates | /api/shorts/CAT/data | {} | 2026-09-15 | 2026-09-15 17:00 | 2026-09-15 17:00 |
| CAT | 2026-09-15 10:48 | 0.4081 | 3.2219 | 4600000 | CATERPILLAR INC | uw_borrow_rates | /api/shorts/CAT/data | {} | 2026-09-15 | 2026-09-15 17:00 | 2026-09-15 17:00 |
| CAT | 2026-09-15 10:17 | 0.4081 | 3.2219 | 4600000 | CATERPILLAR INC | uw_borrow_rates | /api/shorts/CAT/data | {} | 2026-09-15 | 2026-09-15 17:00 | 2026-09-15 17:00 |
| CAT | 2026-09-15 09:46 | 0.4081 | 3.2219 | 4600000 | CATERPILLAR INC | uw_borrow_rates | /api/shorts/CAT/data | {} | 2026-09-15 | 2026-09-15 17:00 | 2026-09-15 17:00 |
| CAT | 2026-09-15 09:14 | 0.4081 | 3.2219 | 4600000 | CATERPILLAR INC | uw_borrow_rates | /api/shorts/CAT/data | {} | 2026-09-15 | 2026-09-15 17:00 | 2026-09-15 17:00 |
| CAT | 2026-09-15 08:58 | 0.4081 | 3.2219 | 4600000 | CATERPILLAR INC | uw_borrow_rates | /api/shorts/CAT/data | {} | 2026-09-15 | 2026-09-15 17:00 | 2026-09-15 17:00 |
| CAT | 2026-09-15 08:27 | 0.4081 | 3.2219 | 4500000 | CATERPILLAR INC | uw_borrow_rates | /api/shorts/CAT/data | {} | 2026-09-15 | 2026-09-15 17:00 | 2026-09-15 17:00 |
| CAT | 2026-09-15 07:55 | 0.4081 | 3.2219 | 4500000 | CATERPILLAR INC | uw_borrow_rates | /api/shorts/CAT/data | {} | 2026-09-15 | 2026-09-15 17:00 | 2026-09-15 17:00 |
| CAT | 2026-09-15 07:23 | 0.4081 | 3.2219 | 4500000 | CATERPILLAR INC | uw_borrow_rates | /api/shorts/CAT/data | {} | 2026-09-15 | 2026-09-15 17:00 | 2026-09-15 17:00 |
| CAT | 2026-09-15 06:51 | 0.4081 | 3.2219 | 4500000 | CATERPILLAR INC | uw_borrow_rates | /api/shorts/CAT/data | {} | 2026-09-15 | 2026-09-15 17:00 | 2026-09-15 17:00 |
| CAT | 2026-09-15 06:19 | 0.4081 | 3.2219 | 4500000 | CATERPILLAR INC | uw_borrow_rates | /api/shorts/CAT/data | {} | 2026-09-15 | 2026-09-15 17:00 | 2026-09-15 17:00 |
| CAT | 2026-09-15 05:47 | 0.4081 | 3.2219 | 4500000 | CATERPILLAR INC | uw_borrow_rates | /api/shorts/CAT/data | {} | 2026-09-15 | 2026-09-15 17:00 | 2026-09-15 17:00 |
| CAT | 2026-09-15 05:15 | 0.4081 | 3.2219 | 4500000 | CATERPILLAR INC | uw_borrow_rates | /api/shorts/CAT/data | {} | 2026-09-15 | 2026-09-15 17:00 | 2026-09-15 17:00 |
| CAT | 2026-09-14 11:27 | 0.4081 | 3.2219 | 4800000 | CATERPILLAR INC | uw_borrow_rates | /api/shorts/CAT/data | {} | 2026-09-14 | 2026-09-14 17:00 | 2026-09-14 17:00 |
| CAT | 2026-09-14 10:55 | 0.4081 | 3.2219 | 4800000 | CATERPILLAR INC | uw_borrow_rates | /api/shorts/CAT/data | {} | 2026-09-14 | 2026-09-14 17:00 | 2026-09-14 17:00 |
| CAT | 2026-09-14 10:24 | 0.4081 | 3.2219 | 4800000 | CATERPILLAR INC | uw_borrow_rates | /api/shorts/CAT/data | {} | 2026-09-14 | 2026-09-14 17:00 | 2026-09-14 17:00 |
| CAT | 2026-09-14 09:52 | 0.4081 | 3.2219 | 4800000 | CATERPILLAR INC | uw_borrow_rates | /api/shorts/CAT/data | {} | 2026-09-14 | 2026-09-14 17:00 | 2026-09-14 17:00 |
| CAT | 2026-09-14 09:21 | 0.4081 | 3.2219 | 4800000 | CATERPILLAR INC | uw_borrow_rates | /api/shorts/CAT/data | {} | 2026-09-14 | 2026-09-14 17:00 | 2026-09-14 17:00 |
| CAT | 2026-09-14 08:50 | 0.4081 | 3.2219 | 4800000 | CATERPILLAR INC | uw_borrow_rates | /api/shorts/CAT/data | {} | 2026-09-14 | 2026-09-14 17:00 | 2026-09-14 17:00 |
| CAT | 2026-09-14 08:18 | 0.4081 | 3.2219 | 4700000 | CATERPILLAR INC | uw_borrow_rates | /api/shorts/CAT/data | {} | 2026-09-14 | 2026-09-14 17:00 | 2026-09-14 17:00 |
| CAT | 2026-09-14 07:47 | 0.4081 | 3.2219 | 4700000 | CATERPILLAR INC | uw_borrow_rates | /api/shorts/CAT/data | {} | 2026-09-14 | 2026-09-14 17:00 | 2026-09-14 17:00 |
| CAT | 2026-09-14 07:15 | 0.4081 | 3.2219 | 4700000 | CATERPILLAR INC | uw_borrow_rates | /api/shorts/CAT/data | {} | 2026-09-14 | 2026-09-14 17:00 | 2026-09-14 17:00 |
| CAT | 2026-09-14 06:42 | 0.4081 | 3.2219 | 4700000 | CATERPILLAR INC | uw_borrow_rates | /api/shorts/CAT/data | {} | 2026-09-14 | 2026-09-14 17:00 | 2026-09-14 17:00 |
| CAT | 2026-09-14 06:26 | 0.4081 | 3.2219 | 4700000 | CATERPILLAR INC | uw_borrow_rates | /api/shorts/CAT/data | {} | 2026-09-14 | 2026-09-14 17:00 | 2026-09-14 17:00 |
| CAT | 2026-09-14 05:54 | 0.4081 | 3.2219 | 4700000 | CATERPILLAR INC | uw_borrow_rates | /api/shorts/CAT/data | {} | 2026-09-14 | 2026-09-14 17:00 | 2026-09-14 17:00 |
| CAT | 2026-09-14 05:23 | 0.4081 | 3.2219 | 4700000 | CATERPILLAR INC | uw_borrow_rates | /api/shorts/CAT/data | {} | 2026-09-14 | 2026-09-14 17:00 | 2026-09-14 17:00 |
| CAT | 2026-09-11 11:24 | 0.4081 | 3.2219 | 2200000 | CATERPILLAR INC | uw_borrow_rates | /api/shorts/CAT/data | {} | 2026-09-11 | 2026-09-11 17:00 | 2026-09-11 17:00 |
| CAT | 2026-09-11 10:53 | 0.4081 | 3.2219 | 2200000 | CATERPILLAR INC | uw_borrow_rates | /api/shorts/CAT/data | {} | 2026-09-11 | 2026-09-11 17:00 | 2026-09-11 17:00 |
| CAT | 2026-09-11 10:21 | 0.4081 | 3.2219 | 2200000 | CATERPILLAR INC | uw_borrow_rates | /api/shorts/CAT/data | {} | 2026-09-11 | 2026-09-11 17:00 | 2026-09-11 17:00 |
| CAT | 2026-09-11 09:50 | 0.4081 | 3.2219 | 2200000 | CATERPILLAR INC | uw_borrow_rates | /api/shorts/CAT/data | {} | 2026-09-11 | 2026-09-11 17:00 | 2026-09-11 17:00 |
| CAT | 2026-09-11 09:19 | 0.4081 | 3.2219 | 2200000 | CATERPILLAR INC | uw_borrow_rates | /api/shorts/CAT/data | {} | 2026-09-11 | 2026-09-11 17:00 | 2026-09-11 17:00 |
| CAT | 2026-09-11 08:47 | 0.4081 | 3.2219 | 2200000 | CATERPILLAR INC | uw_borrow_rates | /api/shorts/CAT/data | {} | 2026-09-11 | 2026-09-11 17:00 | 2026-09-11 17:00 |
| CAT | 2026-09-11 08:16 | 0.4081 | 3.2219 | 2200000 | CATERPILLAR INC | uw_borrow_rates | /api/shorts/CAT/data | {} | 2026-09-11 | 2026-09-11 17:00 | 2026-09-11 17:00 |
| CAT | 2026-09-11 07:45 | 0.4081 | 3.2219 | 2200000 | CATERPILLAR INC | uw_borrow_rates | /api/shorts/CAT/data | {} | 2026-09-11 | 2026-09-11 17:00 | 2026-09-11 17:00 |
| CAT | 2026-09-11 07:14 | 0.4081 | 3.2219 | 2300000 | CATERPILLAR INC | uw_borrow_rates | /api/shorts/CAT/data | {} | 2026-09-11 | 2026-09-11 17:00 | 2026-09-11 17:00 |
| CAT | 2026-09-11 06:58 | 0.4081 | 3.2219 | 2300000 | CATERPILLAR INC | uw_borrow_rates | /api/shorts/CAT/data | {} | 2026-09-11 | 2026-09-11 17:00 | 2026-09-11 17:00 |
| CAT | 2026-09-11 06:27 | 0.4081 | 3.2219 | 2300000 | CATERPILLAR INC | uw_borrow_rates | /api/shorts/CAT/data | {} | 2026-09-11 | 2026-09-11 17:00 | 2026-09-11 17:00 |
| CAT | 2026-09-11 05:55 | 0.4081 | 3.2219 | 2300000 | CATERPILLAR INC | uw_borrow_rates | /api/shorts/CAT/data | {} | 2026-09-11 | 2026-09-11 17:00 | 2026-09-11 17:00 |
| CAT | 2026-09-11 05:24 | 0.4081 | 3.2219 | 2300000 | CATERPILLAR INC | uw_borrow_rates | /api/shorts/CAT/data | {} | 2026-09-11 | 2026-09-11 17:00 | 2026-09-11 17:00 |
| CAT | 2026-09-10 11:23 | 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 10:52 | 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 10:20 | 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 09:49 | 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 09:18 | 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 08:47 | 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 08:16 | 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 07:44 | 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 07:29 | 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 06:57 | 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 06:26 | 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 |