Column description for the static.adam4eve.eu CSV export ---- MarketOrderTrades ---- Adam4Eve compares market orderbooks every 15 minutes and checks if the volume in orders has changed or orders have disappeared. From this A4E deducts the trade transactions that have taken place on the market. Since this is very resource intensive, this is only performed for the top trade hubs. ** location_id ** The CCP/ESI ID of a NPC station or player citadel. See https://static.adam4eve.eu/IDs/ for a list. ** region_id ** The CCP/ESI ID of a region in space. See https://static.adam4eve.eu/IDs/ for a list. ** type_id ** The CCP/ESI ID of a tradable type/commodity. See https://static.adam4eve.eu/IDs/ for a list. ** is_buy_order ** Value 1 if a buy order changed, thus someone sold to a buy order. Value 0 if a sell order changed, thos someone bought from a sell order. ** has_gone ** Value 0 if the metrics in this row only count changed orders. Disappeared orders are interpreted as canceled and thus without a trade transaction. Value 1 if the metrics in this row count changed and disappeared orders. Disappeared orders are interpreted as completely filled by one trade transaction. ** scanDate ** The date on which the data was captured. ** amount ** The number of items of that type/commodity that was traded. ** high ** The highest price point in an order with a trade transaction on that day. ** low ** The lowest price point in an order with a trade transaction on that day. ** avg ** The average price point across all orders with a trade transaction on that day weighted by trade volume. ** orderNum ** The number of trade transactions captured. Thus how many orders changed during the day. ** iskValue ** Volume traded multiplied by the price point of the order, summed for all trades seen during that day.