Order CSV Dumps
All orders on EM2 can be retrieved through an extensive set of CSV dumps generated daily at 00:30.
Retrieval
Dumps are stored at the following paths, relative to http://export.eve-metrics.com/
- /orders/full - Complete dump
- /orders/incremental - Changed orders since last day
- /orders/types/:type_id/full - Per-item complete dumps. Incremental item dumps are not currently provided as in most cases, full dumps are not large.
The filename of the dumps is always YYYY-MM-DD.csv.bz2. For example, today would be 2010-07-31.csv.bz2
A magic filename at any directory root is 'latest.csv.bz2' which is a symlink to the most recent file.
Formatting
All dumps are bz2 compressed CSV files with the following columns:
- id - EVE Metrics internal ID field
- type_id
- price
- sell - True if this order is a sell order
- range
- initial_volume
- available_volume
- sale_volume
- station_id
- system_id
- region_id
- issued_at - Last modification time for this order
- expires_at - Time this order will expire if not bought out
- expired - True if this order has expired
- created_at - Time this order was first seen
- updated_at - Last time this order was updated
- trusted - True if this was from a cache source rather than a logfile source
- eve_id - EVE's own pseudounique ID (recycled)
Line endings are \n, seperator is a comma.
Compression
To save bandwidth for consumers and EM, dumps are compressed with bzip2.
These files can be decompressed easily on Unix-style systems with 'bunzip2 filename.bz2'. Windows users can investigate Cygwin, 7-zip or WinRAR.