HOUR | SYMBOL | FUNDING_RATE | RATE_ANNUALIZED | |
|---|---|---|---|---|
1 | 2025-01-01 00:00:00.000 | BCH-PERP | 0.0004183954928 | 3.665144517 |
2 | 2025-01-01 00:00:00.000 | BTC-PERP | 0.0005928373583 | 5.193255259 |
3 | 2025-01-01 00:00:00.000 | DOGE-PERP | 0.001332153042 | 11.669660645 |
4 | 2025-01-01 00:00:00.000 | ETH-PERP | 0.000650842474 | 5.701380072 |
5 | 2025-01-01 00:00:00.000 | LTC-PERP | 0.000480224962 | 4.206770667 |
6 | 2025-01-01 00:00:00.000 | MKR-PERP | 0.0002303951729 | 2.018261714 |
7 | 2025-01-01 00:00:00.000 | SOL-PERP | 0.0003056577779 | 2.677562135 |
8 | 2025-01-01 00:00:00.000 | WIF-PERP | 0.001026098217 | 8.988620385 |
9 | 2025-01-01 00:00:00.000 | XRP-PERP | 0.0006799152769 | 5.956057825 |
10 | 2025-01-01 06:00:00.000 | BCH-PERP | 0.000345061028 | 3.022734605 |
11 | 2025-01-01 06:00:00.000 | BTC-PERP | 0.0006031382939 | 5.283491455 |
12 | 2025-01-01 06:00:00.000 | DOGE-PERP | 0.0013607218 | 11.919922968 |
13 | 2025-01-01 06:00:00.000 | ETH-PERP | 0.0006691175907 | 5.861470094 |
14 | 2025-01-01 06:00:00.000 | LTC-PERP | 0.0003729353929 | 3.266914042 |
15 | 2025-01-01 06:00:00.000 | MKR-PERP | 0.000222454798 | 1.948704031 |
16 | 2025-01-01 06:00:00.000 | SOL-PERP | 0.0004261574016 | 3.733138838 |
17 | 2025-01-01 06:00:00.000 | WIF-PERP | 0.0009520204066 | 8.339698762 |
18 | 2025-01-01 06:00:00.000 | XRP-PERP | 0.0007416684908 | 6.497015979 |
19 | 2025-01-01 12:00:00.000 | BCH-PERP | 0.0004167002921 | 3.650294558 |
20 | 2025-01-01 12:00:00.000 | BTC-PERP | 0.0004141831638 | 3.628244515 |
TheLaughingManTop Pairs - FRates
Updated 2025-04-11
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
›
⌄
with merge as (
---arbitrum
SELECT * EXCLUDE version, 'arbitrum' as label from arbitrum.vertex.ez_perp_trades
WHERE 1=1
AND block_timestamp::date BETWEEN '{{start_date}}' AND '{{end_date}}'
AND trader != '0x0000000000000000000000000000000000000000'
AND subaccount!='0x0000000000000000000000000000000000000000000000000000000000000001'
UNION ALL
---base
SELECT *, 'base' as label from base.vertex.ez_perp_trades
WHERE 1=1
AND block_timestamp::date BETWEEN '{{start_date}}' AND '{{end_date}}'
AND trader != '0x0000000000000000000000000000000000000000'
AND subaccount!='0x0000000000000000000000000000000000000000000000000000000000000001'
UNION ALL
---blitz
SELECT * , 'blitz' as label from blast.blitz.ez_perp_trades
WHERE 1=1
AND block_timestamp::date BETWEEN '{{start_date}}' AND '{{end_date}}'
AND trader != '0x0000000000000000000000000000000000000000'
AND subaccount!='0x0000000000000000000000000000000000000000000000000000000000000001'
UNION ALL
---mantle
SELECT * , 'mantle' as label from mantle.vertex.ez_perp_trades
WHERE 1=1
AND block_timestamp::date BETWEEN '{{start_date}}' AND '{{end_date}}'
AND trader != '0x0000000000000000000000000000000000000000'
AND subaccount!='0x0000000000000000000000000000000000000000000000000000000000000001'
Last run: 15 days ago
...
3258
218KB
3s