hyperliquid.raw.register_referrer table records when users register a new referral code on Hyperliquid. It contains the referral code registered (e.g. PURS) and the address of the registering user, filtered from hyperliquid.raw.transactions.
Table Columns
| Column Name | Description |
|---|---|
| referral_code | The referral code registered (e.g. PURS). |
| user | The address of the user registering the code. |
| error | Error message if the registration failed. |
| block_timestamp | The timestamp of the block. |
| block_height | The height of the block. |
| hash | Transaction hash. |
| _ingested_at | Timestamp when the record was ingested. |
| _created_at | Row creation timestamp. |
| _updated_at | Row last update timestamp. |