| day_agg | Date from which all metrics are aggregated. In the Trade Aggregations table, the day_agg represents the day in which the daily aggregations were built. | DATE | | Yes | |
| asset_a_type | The identifier for type of asset code used for the sold asset within the trade. Notes: XLM is the native asset to the network. XLM has no asset code or issuer representation and will instead be displayed with an asset type of 'native'. | STRING | | Yes | |
| asset_a_code | The 4 or 12 character code of the sold asset within a trade. Notes: Asset codes have no guarantees of uniqueness. The combination of asset code, issuer and type represents a distinct asset. | STRING | | No | |
| asset_a_issuer | The account address of the original asset issuer for the sold asset within a trade. | STRING | | No | |
| asset_a | Hashed id for the selling_asset. | INTEGER | | Yes | |
| asset_b_type | The identifier for type of asset code used for the bought asset within the trade. Notes: XLM is the native asset to the network. XLM has no asset code or issuer representation and will instead be displayed with an asset type of 'native'. | STRING | | Yes | |
| asset_b_code | The 4 or 12 character code of the bought asset within a trade. Notes: Asset codes have no guarantees of uniqueness. The combination of asset code, issuer and type represents a distinct asset. | STRING | | No | |
| asset_b_issuer | The account address of the original asset issuer for the bought asset within a trade. | STRING | | No | |
| asset_b | Hashed id for the buying_asset. | INTEGER | | Yes | |
| trade_count_daily | The count of trades executed against the network in a day. | INTEGER | | Yes | |
| asset_a_volume_daily | The total raw amount of the asset being sold in all trades within that day. | FLOAT | | Yes | |
| asset_b_volume_daily | The total raw amount of the asset being bought in all trades within that day. | FLOAT | | Yes | |
| avg_price_daily | The total amount of the asset being bought in all trades divided by the total amount of the asset being sold in all trades, within that day. | FLOAT | | Yes | |
| high_price_daily | The highest price obtained from the ratio between denominator and numerator for that day, for the selling:buying asset price. | FLOAT | | Yes | |
| low_price_daily | The lowest price obtained from the ratio between denominator and numerator for that day, for the selling:buying asset price. | FLOAT | | Yes | |
| open_n_daily | The opening price of the numerator within that day, for the selling:buying asset prices ratio. | INTEGER | | Yes | |
| open_d_daily | The opening price of the denominator within that day, for the selling:buying asset prices ratio. | INTEGER | | Yes | |
| close_n_daily | The closing price of the numerator within that day, for the selling:buying asset prices ratio. | INTEGER | | Yes | |
| close_d_daily | The closing price of the denominator within that day, for the selling:buying asset prices ratio. | INTEGER | | Yes | |
| trade_count_weekly | The count of trades executed against the network during the past 7 days. | INTEGER | | Yes | |
| asset_a_volume_weekly | The total amount of the asset being sold in all trades during the past 7 days. | FLOAT | | Yes | |
| asset_b_volume_weekly | The total amount of the asset being bought in all trades during the past 7 days. | FLOAT | | Yes | |
| avg_price_weekly | The total amount of the asset being bought in all trades divided by the total amount of the asset being sold in all trades, during the past 7 days. | FLOAT | | Yes | |
| high_price_weekly | The highest price obtained from the ratio between denominator and numerator during the past 7 days, for the selling:buying asset price. | FLOAT | | Yes | |
| low_price_weekly | The lowest price obtained from the ratio between denominator and numerator during the past 7 days, for the selling:buying asset price. | FLOAT | | Yes | |
| open_n_weekly | The opening price of the numerator during the past 7 days, for the selling:buying asset prices ratio. | INTEGER | | Yes | |
| open_d_weekly | The opening price of the denominator during the past 7 days, for the selling:buying asset prices ratio. | INTEGER | | Yes | |
| close_n_weekly | The closing price of the numerator during the past 7 days, for the selling:buying asset prices ratio. | INTEGER | | Yes | |
| close_d_weekly | The closing price of the denominator during the past 7 days, for the selling:buying asset prices ratio. | INTEGER | | Yes | |
| trade_count_monthly | The count of trades executed against the network during the past 30 days. | INTEGER | | Yes | |
| asset_a_volume_monthly | The total amount of the asset being sold in all trades during the past 30 days. | FLOAT | | Yes | |
| asset_b_volume_monthly | The total amount of the asset being bought in all trades during the past 30 days. | FLOAT | | Yes | |
| avg_price_monthly | The total amount of the asset being bought in all trades divided by the total amount of the asset being sold in all trades, during the past 30 days. | FLOAT | | Yes | |
| high_price_monthly | The highest price obtained from the ratio between denominator and numerator during the past 30 days, for the selling:buying asset price. | FLOAT | | Yes | |
| low_price_monthly | The lowest price obtained from the ratio between denominator and numerator during the past 30 days, for the selling:buying asset price. | FLOAT | | Yes | |
| open_n_monthly | The opening price of the numerator during the past 30 days, for the selling:buying asset prices ratio. | INTEGER | | Yes | |
| open_d_monthly | The opening price of the denominator during the past 30 days, for the selling:buying asset prices ratio. | INTEGER | | Yes | |
| close_n_monthly | The closing price of the numerator during the past 30 days, for the selling:buying asset prices ratio. | INTEGER | | Yes | |
| close_d_monthly | The closing price of the denominator during the past 30 days, for the selling:buying asset prices ratio. | INTEGER | | Yes | |
| trade_count_yearly | The count of trades executed against the network during the past 365 days. | INTEGER | | Yes | |
| asset_a_volume_yearly | The total amount of the asset being sold in all trades during the past 365 days. | FLOAT | | Yes | |
| asset_b_volume_yearly | The total amount of the asset being bought in all trades during the past 365 days. | FLOAT | | Yes | |
| avg_price_yearly | The total amount of the asset being bought in all trades divided by the total amount of the asset being sold in all trades, during the past 365 days. | FLOAT | | Yes | |
| high_price_yearly | The highest price obtained from the ratio between denominator and numerator during the past 365 days, for the selling:buying asset price. | FLOAT | | Yes | |
| low_price_yearly | The lowest price obtained from the ratio between denominator and numerator during the past 365 days, for the selling:buying asset price. | FLOAT | | Yes | |
| open_n_yearly | The opening price of the numerator during the past 365 days, for the selling:buying asset prices ratio. | INTEGER | | Yes | |
| open_d_yearly | The opening price of the denominator during the past 365 days, for the selling:buying asset prices ratio. | INTEGER | | Yes | |
| close_n_yearly | The closing price of the numerator during the past 365 days, for the selling:buying asset prices ratio. | INTEGER | | Yes | |
| close_d_yearly | The closing price of the denominator during the past 365 days, for the selling:buying asset prices ratio. | INTEGER | | Yes | |