detected_proxy_pattern -
bytecode_duplicates -
| Idx | Column Name | Definition | Description |
|---|---|---|---|
| * | id | integer DEFAULT nextval('contract_vulnerabilities_id_seq'::regclass) | |
| * | contract_security_audit_id | integer | |
| vulnerability_id | integer | FLUIDEFI® unique vulnerability id | |
| swc | integer | Smart Contract Weakness (SWC) classification | |
| vulnerability_name | varchar(60) | Vulnerability name (taken from SWC naming standards) | |
| vulnerability_severity | varchar(10) | Severity of the vulnerability | |
| vulnerability_category | varchar(20) | Category of vulnerability | |
| scanner | varchar(30) | Scanner that found the vulnerability | |
| scanner_version | varchar(12) | Version of the scanner | |
| num_incidents | integer | Number of incidents found of this vulnerability | |
| Indexes | |||
| pk_token_vulnerabilities | Primary Key ON id | ||
| unq_contract_vulnerabilities_contract_security_audit_id | Unique Key ON contract_security_audit_id | ||
| Foreign Key | |||
| fk_token_vulnerabilities_token_security_audit_kansa | contract_security_audit_id ↗ ❏ contract_security_audit_kansa(id) | ||
| fk_contract_vulnerabilities_tbl_bq_eth_token_performance | contract_security_audit_id ↗ ❏ tbl_bq_eth_token_performance | ||
| fk_contract_vulnerabilities_tbl_bq_eth_lp_risk | contract_security_audit_id ↗ ❏ tbl_bq_eth_lp_risk(security_audit_0_id) | ||
| fk_contract_vulnerabilities_tbl_bq_eth_lp_risk_0 | contract_security_audit_id ↗ ❏ tbl_bq_eth_lp_risk(security_audit_1_id) | ||
| Idx | Column Name | Data Type |
|---|---|---|
| * | id | integer DEFAULT nextval('summary_type_id_seq'::regclass) |
| summary_description | varchar(100) | |
| data_frequency | varchar(3) | |
| general_description | varchar(100) | |
| Indexes | ||
| pk_summary_type_id | Primary Key ON id | |
| unq_summary_type_df | Unique Index ON data_frequency | |
| Referring Foreign Key | ||
| fk_bot_settings_summary_type | id ↙ ❏ bot_settings(data_frequency_id) | |
| fk_cmc_temp_summary_summary_type | id ↙ ❏ cmc_temp_summary(summary_type) | |
| fk_lp_summary_summary_type_0 | id ↙ ❏ lp_latest(summary_type) | |
| fk_lp_summary2_summary_type_0 | id ↙ ❏ lp_latest_day(summary_type) | |
| fk_lp_summary2_summary_type_1 | id ↙ ❏ lp_latest_week(summary_type) | |
| fk_lp_summary2_summary_type_2 | id ↙ ❏ lp_snapshot(summary_type) | |
| fk_lp_summary_summary_type | id ↙ ❏ lp_summary(summary_type) | |
| fk_lp_summary2_summary_type | id ↙ ❏ lp_summary2(summary_type) | |
| fk_lp_summary3_summary_type | id ↙ ❏ lp_summary3(summary_type) | |
| fk_lp_summary3_summary_type_1 | id ↙ ❏ lp_summary3_delta(summary_type) | |
| fk_lp_summary3_summary_type_0 | id ↙ ❏ lp_summary3_latest(summary_type) | |
| fk_market_metrics_summary_type | id ↙ ❏ market_metrics(summary_type_id) | |
| fk_predictions_summary_type | id ↙ ❏ predictions(summary_type) | |
| fk_price_summary_summary_type | id ↙ ❏ price_summary(summary_type) | |
| fk_tbl_bq_eth_lp_asset_performance_summary_type | id ↙ ❏ tbl_bq_eth_lp_asset_performance(summary_type) | |
| fk_tbl_bq_eth_lp_performance_summary_type | id ↙ ❏ tbl_bq_eth_lp_performance(summary_type) | |
| fk_tbl_bq_eth_lp_reserves_summary_type | id ↙ ❏ tbl_bq_eth_lp_reserves(summary_type) | |
| fk_tbl_bq_eth_lp_risk_summary_type | id ↙ ❏ tbl_bq_eth_lp_risk(summary_type) | |
| fk_tbl_bq_eth_lp_volume_summary_type | id ↙ ❏ tbl_bq_eth_lp_volume(summary_type) | |
| fk_tbl_bq_eth_token_performance_summary_type | id ↙ ❏ tbl_bq_eth_token_performance(summary_type) | |
| fk_token_summary_summary_type | id ↙ ❏ token_summary(summary_type) | |
| fk_token_summary_summary_type_0 | id ↙ ❏ token_summary_delta(summary_type) | |
| Idx | Column Name | Definition | Description |
|---|---|---|---|
| lp_id | integer | FLUIDEFI® unique id of the liquidity pool (LP). (Use for joins with other tables.) | |
| contract_address | varchar(100) | Blockchain contract address of the erc-20 token. | |
| summary_type | integer | FLUIDEFI® unique id of the summary type. (Use for joins with summary_type table.) | |
| summary_description | varchar(100) | Description of time period this summary data represents. | |
| open_timestamp_utc | timestamptz | Starting timestamp (UTC) for this summary data. | |
| close_timestamp_utc | timestamptz | Ending timestamp (UTC) for this summary data. | |
| open_price_0 | double precision | Price of the first token (USD) at the beginning of the period. | |
| open_price_0_delta | double precision | Change in price of the first token from the previous period. | |
| open_price_1 | double precision | Price of the second token (USD) at the beginning of the period. | |
| open_price_1_delta | double precision | Change in price of the second token from the previous period. | |
| high_price_0 | double precision | Highest price of the first token (USD) during the period. | |
| high_price_0_delta | double precision | Change in the highest price of the first token from the previous period. | |
| high_price_1 | double precision | Highest price of the second token (USD) during the period. | |
| high_price_1_delta | double precision | Change in the highest price of the second token from the previous period. | |
| low_price_0 | double precision | Lowest price of the first token (USD) during the period. | |
| low_price_0_delta | double precision | Change in the lowest price of the first token from the previous period. | |
| low_price_1 | double precision | Lowest price of the second token (USD) during the period. | |
| low_price_1_delta | double precision | Change in the lowest price of the second token from the previous period. | |
| close_price_0 | double precision | Price of the first token (USD) at the end of the period. | |
| close_price_0_delta | double precision | Change in the closing price of the first token from the previous period. | |
| close_price_1 | double precision | Price of the second token (USD) at the end of the period. | |
| close_price_1_delta | double precision | Change in the closing price of the second token from the previous period. | |
| token_0_price_return | double precision | Return from prices changes of the first token during this period. | |
| token_0_price_return_delta | double precision | Change in price-based returns of the first token from the previous period. | |
| token_1_price_return | double precision | Return from prices changes of the second token during this period. | |
| token_1_price_return_delta | double precision | Change in price-based returns of the second token from the previous period | |
| all_time_high_0 | double precision | Highest price recorded ever recorded for the first token. | |
| all_time_high_0_delta | double precision | Change in all time high of the first token from the previous period. | |
| all_time_high_1 | double precision | Highest price recorded ever recorded for the second token. | |
| all_time_high_1_delta | double precision | Change in all time high of the second token from the previous period. | |
| hours_since_ath_0 | double precision | Number of hours since the first tokens all-time high price to the end of this period. | |
| hours_since_ath_0_delta | double precision | Change in hours since the first tokens all-time high price from the previous period. | |
| hours_since_ath_1 | double precision | Number of hours since the second tokens all-time high price to the end of this period. | |
| hours_since_ath_1_delta | double precision | Change in hours since the second tokens all-time high price from the previous period. | |
| processed_timestamp_utc | timestamptz | Timestamp (UTC) when this data was last updated. | |
| Indexes | |||
| unq_tbl_bq_eth_lp_asset_performance | Unique Key ON lp_id, summary_type, close_timestamp_utc | ||
| Foreign Key | |||
| fk_tbl_bq_eth_lp_asset_performance_summary_type | summary_type ↗ ❏ summary_type(id) | ||
| fk_tbl_bq_eth_lp_asset_performance_tbl_bq_eth_lp_overview | lp_id ↗ ❏ tbl_bq_eth_lp_overview | ||
| Idx | Column Name | Definition | Description |
|---|---|---|---|
| * | id | integer DEFAULT nextval('tbl_bq_eth_lp_overview_id_seq'::regclass) | FLUIDEFI® unique id of the liquidity pool (LP). |
| lp_id | integer | FLUIDEFI® unique id of the liquidity pool. | |
| contract_address | varchar(100) | Blockchain contract address of the liquidity pool. | |
| lp_name | varchar(100) | Hyphenated symbols of the erc-20 tokens the liquidity pool is comprised of. Example: WETH-USDT | |
| full_name | varchar(100) | Hyphenated full name of erc-20 tokens the liquidity pool is comprised of. Example: Wrapped Ether - Tether USD | |
| platform_id | integer | FLUIDEFI® unique id of the platform/decentralized exchange the liquidity pool was created by. | |
| platform_name | varchar(100) | Name of the platform/decentralized exchange the liquidity pool was created by. | |
| created_at_block_number | integer | Block number when this liquidity pool was minted. | |
| created_at_timestamp_utc | timestamptz | Timestamp (UTC) of the block when this liquidity pool was minted. | |
| url | varchar(255) | Provides URL to the liquidity pool on the source platform. | |
| fee_taken | double precision | Fee taken by Platform/decentralized exchange on each swap. Decimal representing the percentage of the total swap. | |
| fee_earned | double precision | Fee paid by platform/decentralized exchange to stakeholders on each swap. Decimal representing the percentage of the total swap. | |
| token0_symbol | varchar(12) | Symbol name of the first erc-20 token. | |
| token1_symbol | varchar(12) | Symbol name of the second erc-20 token. | |
| token0_address | varchar(100) | Blockchain contract address of the first erc-20 token. | |
| token1_address | varchar(100) | Blockchain contract address of the second erc-20 token. | |
| processed_timestamp_utc | timestamptz | Timestamp (UTC) when this data was last updated. | |
| Indexes | |||
| tbl_bq_eth_lp_overview_pkey | Primary Key ON id | ||
| unq_tbl_bq_eth_lp_overview | Unique Key ON lp_id | ||
| Foreign Key | |||
| fk_tbl_bq_eth_lp_overview_tbl_bq_eth_token_overview | token0_address ↗ ❏ tbl_bq_eth_token_overview(contract_address) | ||
| fk_tbl_bq_eth_lp_overview_tbl_bq_eth_token_overview_0 | token1_address ↗ ❏ tbl_bq_eth_token_overview(contract_address) | ||
| Referring Foreign Key | |||
| fk_tbl_bq_eth_lp_asset_performance_tbl_bq_eth_lp_overview | lp_id ↙ ❏ tbl_bq_eth_lp_asset_performance | ||
| fk_tbl_bq_eth_lp_performance_tbl_bq_eth_lp_overview | lp_id ↙ ❏ tbl_bq_eth_lp_performance | ||
| fk_tbl_bq_eth_lp_reserves_tbl_bq_eth_lp_overview | lp_id ↙ ❏ tbl_bq_eth_lp_reserves | ||
| fk_tbl_bq_eth_lp_risk_tbl_bq_eth_lp_overview | lp_id ↙ ❏ tbl_bq_eth_lp_risk | ||
| fk_tbl_bq_eth_lp_volume_tbl_bq_eth_lp_overview | lp_id ↙ ❏ tbl_bq_eth_lp_volume | ||
| Idx | Column Name | Definition | Description |
|---|---|---|---|
| lp_id | integer | FLUIDEFI® unique id of the liquidity pool (LP). (Use for joins with other tables.) | |
| contract_address | varchar(100) | Blockchain contract address of the erc-20 token. | |
| summary_type | integer | FLUIDEFI® unique id of the summary type. (Use for joins with summary_type table.) | |
| summary_description | varchar(100) | Description of time period this summary data represents. | |
| open_timestamp_utc | timestamptz | Starting timestamp (UTC) for this summary data. | |
| close_timestamp_utc | timestamptz | Ending timestamp (UTC) for this summary data. | |
| total_period_return | double precision | Return from fees & variances in tokens values. | |
| total_period_return_delta | double precision | Change in return from fees & variances in tokens values from previous period. | |
| yield_on_lp_fees | double precision | Return only from fees. | |
| yield_on_lp_fees_delta | double precision | Change in return from fees from previous period. | |
| price_change_ret | double precision | Return excluding fees. | |
| price_change_ret_delta | double precision | Change in return excluding fees from previous period. | |
| hodl_return | double precision | Average price change of the two underlying tokens. | |
| hodl_return_delta | double precision | Change in the average price of the two underlying tokens from the previous period. | |
| open_lp_token_price | double precision | Liquidity Pool token price at the beginning of the period. (Null for v3 pools.) | |
| close_lp_token_price | double precision | Liquidity Pool token price at the close of the period. (Null for v3 pools.) | |
| lp_token_price_delta_cur_period | double precision | Change in Liquidity Pool token price this period. | |
| lp_token_price_delta_prev_period | double precision | Change in Liquidity Pool token price during the previous period. | |
| processed_timestamp_utc | timestamptz | Timestamp (UTC) when this data was last updated. | |
| Indexes | |||
| unq_tbl_bq_eth_lp_performance | Unique Key ON lp_id, summary_type, close_timestamp_utc | ||
| Foreign Key | |||
| fk_tbl_bq_eth_lp_performance_tbl_bq_eth_lp_overview | lp_id ↗ ❏ tbl_bq_eth_lp_overview | ||
| fk_tbl_bq_eth_lp_performance_summary_type | summary_type ↗ ❏ summary_type(id) | ||
| Idx | Column Name | Definition | Description |
|---|---|---|---|
| lp_id | integer | FLUIDEFI® unique id of the liquidity pool (LP). (Use for joins with other tables.) | |
| contract_address | varchar(100) | Blockchain contract address of the erc-20 token. | |
| summary_type | integer | FLUIDEFI® unique id of the summary type. (Use for joins with summary_type table.) | |
| summary_description | varchar(100) | Description of time period this summary data represents. | |
| open_timestamp_utc | timestamptz | Starting timestamp (UTC) for this summary data. | |
| close_timestamp_utc | timestamptz | Ending timestamp (UTC) for this summary data. | |
| open_poolsize | double precision | Pool size (USD) at the first transaction in the period. | |
| poolsize_delta_prev_period | double precision | Change in the pool size during the previous period. | |
| close_poolsize | double precision | Pool size (USD) at the last transaction in the period. | |
| poolsize_delta_cur_period | double precision | Change in the pool size during the current period. | |
| open_reserve_0 | double precision | Reserves of the first token at the first transaction during the current period. | |
| open_reserve_0_delta | double precision | ||
| open_reserve_1 | double precision | Reserves of the second token at the first transaction during the current period. | |
| open_reserve_1_delta | double precision | ||
| close_reserve_0 | double precision | Reserves of the first token at the last transaction during the current period. | |
| close_reserve_0_delta | double precision | ||
| close_reserve_1 | double precision | Reserves of the second token at the last transaction during the current period. | |
| close_reserve_1_delta | double precision | ||
| open_reserve_0_base_cur | double precision | Reserves of the first token (USD) at the first transaction during the current period. | |
| open_reserve_0_base_cur_delta | double precision | ||
| open_reserve_1_base_cur | double precision | Reserves of the second token (USD) at the first transaction during the current period. | |
| open_reserve_1_base_cur_delta | double precision | ||
| close_reserve_0_base_cur | double precision | Reserves of the first token (USD) at the last transaction during the current period. | |
| close_reserve_0_base_cur_delta | double precision | ||
| close_reserve_1_base_cur | double precision | Reserves of the second token (USD) at the last transaction during the current period. | |
| close_reserve_1_base_cur_delta | double precision | ||
| open_reserve_ratio | double precision | The first token reserves divided by second tokens reserves at the beginning of the period. Only available for v3 pools. | |
| open_reserve_ratio_delta | double precision | ||
| close_reserve_ratio | double precision | The first token reserves divided by second tokens reserves at the end of the period. Only available for v3 pools. | |
| close_reserve_ratio_delta | double precision | ||
| processed_timestamp_utc | timestamptz | Timestamp (UTC) when this data was last updated. | |
| Indexes | |||
| unq_tbl_bq_eth_lp_reserves | Unique Key ON lp_id, summary_type, close_timestamp_utc | ||
| Foreign Key | |||
| fk_tbl_bq_eth_lp_reserves_tbl_bq_eth_lp_overview | lp_id ↗ ❏ tbl_bq_eth_lp_overview | ||
| fk_tbl_bq_eth_lp_reserves_summary_type | summary_type ↗ ❏ summary_type(id) | ||
| Idx | Column Name | Definition | Description |
|---|---|---|---|
| lp_id | integer | FLUIDEFI® unique id of the liquidity pool (LP). (Use for joins with other tables.) | |
| contract_address | varchar(100) | Blockchain contract address of the erc-20 token. | |
| summary_type | integer | FLUIDEFI® unique id of the summary type. (Use for joins with summary_type table.) | |
| summary_description | varchar(100) | Description of time period this summary data represents. | |
| open_timestamp_utc | timestamptz | Starting timestamp (UTC) for this summary data. | |
| close_timestamp_utc | timestamptz | Ending timestamp (UTC) for this summary data. | |
| impermanent_loss_level | double precision | The percentage difference in portfolio value between staking tokens in an AMM and holding tokens in a wallet. Fees are not taken into account in this calculation. | |
| impermanent_loss_level_delta | double precision | Change in impermanent loss level from previous period. | |
| impermanent_loss_impact | double precision | The percentage difference in ROI between staking tokens in an AMM and holding tokens in a wallet. Fees are not taken into account in this calculation. | |
| impermanent_loss_impact_delta | double precision | Change in impermanent loss impact from previous period. | |
| avg_position_size | double precision | The average size of the liquidity pools positions. | |
| avg_position_size_delta | double precision | Change in avg position size from previous period. | |
| avg_wallet_inv_size | double precision | The average amount of investment in the pool by wallet(s). | |
| avg_wallet_inv_size_delta | double precision | Change in from previous period. | |
| active_positions | integer | Number of active positions in the liquidity pool. | |
| active_positions_delta | integer | Change in the number of active positions in the liquidity pool from previous period. | |
| active_wallets | integer | Number of wallets investing in the liquidity pool. | |
| active_wallets_delta | integer | Change in the number of wallets investing in the liquidity pool from previous period. | |
| sharpe_ratio | double precision | Annualized excess total return divided by annualized standard deviation of total returns. | |
| sharpe_ratio_delta | double precision | Change in sharpe ratio from previous period. | |
| annual_vol | double precision | Standard deviation of hourly total returns, annualized. | |
| annual_vol_delta | double precision | Change in annual volatility from previous period. | |
| value_at_risk | double precision | Value-at-risk (VAR) is a statistical measure of the riskiness of the liquidity pool. | |
| expected_shortfall | double precision | Expected shortfall is a risk measure calculated by averaging all of the returns in the liquidity pool that are worse than the VAR. | |
| max_drawdown | double precision | Maximum draw down in liquidity pool since LP mint date. | |
| max_drawdown_delta | double precision | Change in maximum draw down from previous period. | |
| max_drawdown_duration | double precision | Duration of maximum draw down. | |
| max_drawdown_duration_delta | double precision | Change in maximum draw down duration from previous period. | |
| security_audit_0_id | integer | FLUIDEFI® unique id of the security audit for the first token. (Use for joins with contract_vulnerabilities table.) | |
| security_audit_1_id | integer | FLUIDEFI® unique id of the security audit for the second token. (Use for joins with contract_vulnerabilities table.) | |
| vulnerability_score_lp | numeric | Liquidity Pool vulnerability score based on token vulnerabilities. (See documentation for details.) | |
| vulnerability_score_0 | numeric | Number of smart contract vulnerabilities found in the first token. (Not all vulnerabilities are exploitable.) | |
| vulnerability_score_0_delta | numeric | Change in number of vulnerabilities found in the first token from previous period. | |
| vulnerability_score_1 | numeric | Number of smart contract vulnerabilities found in the second token. (Not all vulnerabilities are exploitable.) | |
| vulnerability_score_1_delta | numeric | Change in number of vulnerabilities found in the second token from previous period. | |
| news_sentiment_score_avg_lp | double precision | Total weighted average sentiment score for news related to the tokens in this liquidity pool during this period. | |
| news_sentiment_score_avg_0 | double precision | Average sentiment score for news related to the first token in this LP during this period. | |
| news_sentiment_score_avg_0_delta | double precision | Change in average sentiment score for news related to the first token in this LP from the previous period. | |
| news_sentiment_score_avg_1 | double precision | Average sentiment score for news related to the second token in this LP during this period. | |
| news_sentiment_score_avg_1_delta | double precision | Change in average sentiment score for news related to the second token in this LP from the previous period. | |
| news_positive_sentiment_score_avg_lp | double precision | Average positive sentiment score for news related to the first token in this LP during this period. | |
| news_negative_sentiment_score_avg_lp | double precision | Average negitive sentiment score for news related to the first token in this LP during this period. | |
| news_neutral_sentiment_score_avg_lp | double precision | Average neutral sentiment score for news related to the first token in this LP during this period. | |
| news_positive_sentiment_score_avg_0 | double precision | Average positive sentiment score for news related to the first token in this LP during this period | |
| news_negative_sentiment_score_avg_0 | double precision | Average negative sentiment score for news related to the first token in this LP during this period | |
| news_neutral_sentiment_score_avg_0 | double precision | Average neutral sentiment score for news related to the first token in this LP during this period | |
| news_positive_sentiment_score_avg_0_delta | double precision | Change in average positive sentiment score for news related to the first token in this LP from the previous period. | |
| news_negative_sentiment_score_avg_0_delta | double precision | Change in average negative sentiment score for news related to the first token in this LP from the previous period. | |
| news_neutral_sentiment_score_avg_0_delta | double precision | Change in average neutral sentiment score for news related to the first token in this LP from the previous period. | |
| news_positive_sentiment_score_avg_1 | double precision | Average positive sentiment score for news related to the second token in this LP during this period. | |
| news_negative_sentiment_score_avg_1 | double precision | Average negative sentiment score for news related to the second token in this LP during this period. | |
| news_neutral_sentiment_score_avg_1 | double precision | Average neutral sentiment score for news related to the second token in this LP during this period. | |
| news_positive_sentiment_score_avg_1_delta | double precision | Change in average positive sentiment score for news related to the second token in this LP from the previous period. | |
| news_negative_sentiment_score_avg_1_delta | double precision | Change in average negative sentiment score for news related to the second token in this LP from the previous period. | |
| news_neutral_sentiment_score_avg_1_delta | double precision | Change in average neutral sentiment score for news related to the second token in this LP from the previous period. | |
| processed_timestamp_utc | timestamptz | Timestamp (UTC) when this data was last updated. | |
| Indexes | |||
| unq_tbl_bq_eth_lp_risk | Unique Key ON lp_id, summary_type, close_timestamp_utc | ||
| unq_tbl_bq_eth_lp_risk_security_audit_0_id | Unique Key ON security_audit_0_id | ||
| unq_tbl_bq_eth_lp_risk_security_audit_1_id | Unique Key ON security_audit_1_id | ||
| Foreign Key | |||
| fk_tbl_bq_eth_lp_risk_tbl_bq_eth_lp_overview | lp_id ↗ ❏ tbl_bq_eth_lp_overview | ||
| fk_tbl_bq_eth_lp_risk_summary_type | summary_type ↗ ❏ summary_type(id) | ||
| Referring Foreign Key | |||
| fk_contract_vulnerabilities_tbl_bq_eth_lp_risk | security_audit_0_id ↙ ❏ contract_vulnerabilities(contract_security_audit_id) | ||
| fk_contract_vulnerabilities_tbl_bq_eth_lp_risk_0 | security_audit_1_id ↙ ❏ contract_vulnerabilities(contract_security_audit_id) | ||
| Idx | Column Name | Definition | Description |
|---|---|---|---|
| lp_id | integer | FLUIDEFI® unique id of the liquidity pool (LP). (Use for joins with other tables.) | |
| contract_address | varchar(100) | Blockchain contract address of the erc-20 token. | |
| summary_type | integer | FLUIDEFI® unique id of the summary type. (Use for joins with summary_type table.) | |
| summary_description | varchar(100) | Description of time period this summary data represents. | |
| open_timestamp_utc | timestamptz | Starting timestamp (UTC) for this summary data. | |
| close_timestamp_utc | timestamptz | Ending timestamp (UTC) for this summary data. | |
| volume_0 | double precision | Number of first tokens traded in the liquidity pool this period. | |
| volume_0_delta | double precision | Change in the first tokens volume from the previous period. | |
| volume_1 | double precision | Number of second tokens traded in the liquidity pool this period. | |
| volume_1_delta | double precision | Change in the second tokens volume from the previous period. | |
| volume_0_base_cur | double precision | First tokens volume in base_currency (USD) this period. | |
| volume_0_base_cur_delta | double precision | Change in first tokens volume in base_currency (USD) from the previous period. | |
| volume_1_base_cur | double precision | Second tokens volume in base_currency (USD) this period. | |
| volume_1_base_cur_delta | double precision | Change in second tokens volume in base_currency (USD) from the previous period. | |
| volume | double precision | Volume in USD this period. | |
| volume_delta | double precision | Change in volume from the previous period. | |
| avg_daily_tvl | double precision | Average total value locked per day this period. | |
| avg_daily_tvl_delta | double precision | Change in average total value from the previous period. | |
| avg_daily_vol | double precision | Average volume per day this period. | |
| avg_daily_vol_delta | double precision | Change in average daily volume from the previous period. | |
| avg_daily_vol_tvl_ratio | double precision | Average ratio of volume and total value locked (TVL) per day this period. | |
| avg_daily_vol_tvl_ratio_delta | double precision | Change in ratio of volume and TVL from the previous period. | |
| transactions_period | integer | Number of transactions related to this liquidity pool this period. | |
| transactions_period_delta | integer | Change in number of transactions from the previous period. | |
| num_liquidity_events | integer | Number of liquidity events related to this liquidity pool during this period. | |
| num_liquidity_events_delta | integer | Change in the number of liquidity events from the previous period. | |
| num_swaps | integer | Number of swaps in this liquidity pool during this period. | |
| num_swaps_delta | integer | Change in number of swaps from the previous period. | |
| avg_swap_size | double precision | Average swap size in this liquidity pool during this period. | |
| avg_swap_size_delta | double precision | Change in the average swap size from the previous period. | |
| num_swaps_0 | integer | Number of swaps of the first token in this liquidity pool during this period. | |
| num_swaps_0_delta | integer | Change in the number of swaps of the first token from the previous period. | |
| num_swaps_1 | integer | Number of swaps of the second token in this liquidity pool during this period. | |
| num_swaps_1_delta | integer | Change in the number of swaps of the second token from the previous period. | |
| num_mints | integer | Number of mint events related to this liquidity pool during this period. | |
| num_mints_delta | integer | Change in the number of mint events from the previous period. | |
| num_burns | integer | Number of burn events related to this liquidity pool during this period. | |
| num_burns_delta | integer | Change in the number of burn events from the previous period. | |
| processed_timestamp_utc | timestamptz | Timestamp (UTC) when this data was last updated. | |
| Indexes | |||
| unq_tbl_bq_eth_lp_volume | Unique Key ON lp_id, summary_type, close_timestamp_utc | ||
| Foreign Key | |||
| fk_tbl_bq_eth_lp_volume_tbl_bq_eth_lp_overview | lp_id ↗ ❏ tbl_bq_eth_lp_overview | ||
| fk_tbl_bq_eth_lp_volume_summary_type | summary_type ↗ ❏ summary_type(id) | ||
| Idx | Column Name | Definition | Description |
|---|---|---|---|
| * | id | integer DEFAULT nextval('tbl_bq_eth_token_overview_id_seq'::regclass) | FLUIDEFI® unique id of the token. |
| contract_address | varchar(100) | Blockchain contract address of the token. | |
| symbol | varchar(15) | Symbol of the token. | |
| full_name | varchar(100) | Full name of the token. | |
| token_type | varchar(50) | Type of token. | |
| token_launch_date | timestamptz | Timestamp (UTC) of when this token launched. | |
| total_supply | double precision | Total supply of tokens minted. | |
| token_web_site_url | varchar(255) | Token web site URL. | |
| varchar(100) | Support email address for the token. | ||
| blog | varchar(256) | Official blog of the token. | |
| varchar(256) | Reddit page of the token. | ||
| slack | varchar(256) | Slack channel for the token. | |
| varchar(256) | Facebook page for the token. | ||
| varchar(256) | X, formerly Twitter handle for the token. | ||
| bitcointalk | varchar(256) | Bitcointalk page for the token. | |
| github | varchar(256) | Github repository URL | |
| telegram | varchar(256) | Telegram channel for the token. | |
| varchar(256) | WeChat address for the token. | ||
| varchar(256) | LinkedIn page for the token. | ||
| discord | varchar(256) | Discord channel for the token. | |
| description | text | A brief overview description of the token. | |
| Indexes | |||
| tbl_bq_eth_token_overview_pkey | Primary Key ON id | ||
| unq_tbl_bq_eth_token_overview_contract_address | Unique Key ON contract_address | ||
| Referring Foreign Key | |||
| fk_tbl_bq_eth_lp_overview_tbl_bq_eth_token_overview | contract_address ↙ ❏ tbl_bq_eth_lp_overview(token0_address) | ||
| fk_tbl_bq_eth_lp_overview_tbl_bq_eth_token_overview_0 | contract_address ↙ ❏ tbl_bq_eth_lp_overview(token1_address) | ||
| fk_tbl_bq_eth_token_performance_tbl_bq_eth_token_overview | id ↙ ❏ tbl_bq_eth_token_performance(token_id) | ||
| Idx | Column Name | Definition | Description |
|---|---|---|---|
| token_id | integer | FLUIDEFI® unique id of the token. (Use for joins with other tables.) | |
| platform_id | integer | FLUIDEFI® unique id of the platform/decentralized exchange the liquidity pool was created by. | |
| platform_name | varchar(100) | Name of the platform/decentralized exchange the liquidity pool was created by. | |
| contract_address | varchar(100) | Blockchain contract address of the erc-20 token. | |
| summary_type | integer | FLUIDEFI® unique id of the summary type. (Use for joins with summary_type table.) | |
| summary_description | varchar(100) | Description of time period this summary data represents. | |
| open_timestamp_utc | timestamptz | Starting timestamp (UTC) for this summary data. | |
| close_timestamp_utc | timestamptz | Ending timestamp (UTC) for this summary data. | |
| token_price_usd | double precision | Token index price. (See documentation for calculation.) | |
| token_price_usd_delta | double precision | Change in token index price from previous period. | |
| tvl | double precision | Trading volume (USD) across all liquidity pools during this period. | |
| tvl_delta | double precision | Change in TVL across all liquidity pools from the period. | |
| token_volume_period | double precision | Trading volume (USD) across all liquidity pools during this period. | |
| token_volume_period_delta | double precision | Change in trading volume (USD) across all liquidity pools from the period. | |
| lp_count | integer | Number of liquidity pools found that contain this token. | |
| lp_count_delta | integer | Change in the number of liquidity pools found that contain this token from the previous period. | |
| num_swaps | integer | Number of swaps of this token across all liquidity pools during this period. | |
| num_swaps_delta | integer | Change in the number of swaps of this token across all liquidity pools from the previous period. | |
| news_sentiment_score_avg | double precision | Average sentiment score for news related to this token during this period. | |
| news_sentiment_score_avg_delta | double precision | Change in average sentiment score for news related to this token from the previous period. | |
| vulnerability_score | numeric | Score based on number of smart contract vulnerabilities found & severity of vulnerabilities. (See documentation for details.) | |
| vulnerability_score_delta | numeric | Change in vulnerability score from previous period. | |
| vulnerability_count | integer | Number of smart contract vulnerabilities found. (Not all vulnerabilities are exploitable.) | |
| manual_audits | integer | Number of known manual audits performed on the underlying smart contract for this token | |
| bytecode_duplicates | integer | The number of deployed contracts that have the exact bytecode of the requested contract. | |
| detected_proxy_pattern | varchar(50) | Supports eight proxy patterns: - 'eip-1167', - 'eip-1967-direct', - 'eip-1967-beacon', - 'openzeppelin', - 'eip-1822', - 'eip-897', - 'gnosis-safe', and - 'compound-comptroller'. |
|
| contract_security_audit_id | integer | FLUIDEFI® unique id of the security audit. (Use for joins with contract_vulnerabilities table.) | |
| processed_timestamp_utc | timestamptz | Timestamp (UTC) when this data was last updated. | |
| news_positive_sentiment_score_avg | double precision | Average positive sentiment score for news related to this token during this period. | |
| news_negative_sentiment_score_avg | double precision | Average negative sentiment score for news related to this token during this period. | |
| news_neutral_sentiment_score_avg | double precision | Average neutral sentiment score for news related to this token during this period. | |
| news_positive_sentiment_score_avg_delta | double precision | Change in average positive sentiment score for news related to this token from the previous period. | |
| news_negative_sentiment_score_avg_delta | double precision | Change in average negative sentiment score for news related to this token from the previous period. | |
| news_neutral_sentiment_score_avg_delta | double precision | Change in average neutral sentiment score for news related to this token from the previous period. | |
| Indexes | |||
| unq_tbl_bq_eth_token_performance | Unique Key ON token_id, platform_id, summary_type, close_timestamp_utc | ||
| unq_tbl_bq_eth_token_performance_contract_security_audit_id | Unique Key ON contract_security_audit_id | ||
| Foreign Key | |||
| fk_tbl_bq_eth_token_performance_summary_type | summary_type ↗ ❏ summary_type(id) | ||
| fk_tbl_bq_eth_token_performance_tbl_bq_eth_token_overview | token_id ↗ ❏ tbl_bq_eth_token_overview(id) | ||
| Referring Foreign Key | |||
| fk_contract_vulnerabilities_tbl_bq_eth_token_performance | contract_security_audit_id ↙ ❏ contract_vulnerabilities | ||