SELECT `markets_market`.`symbol`,
       `markets_market`.`name`,
       `markets_market`.`currency_id`,
       `markets_market`.`currency_processor`,
       `markets_market`.`desc`,
       `markets_market`.`url`,
       `markets_market`.`update_method`,
       `markets_market`.`update_trade_url`,
       `markets_market`.`update_orders_url`,
       `markets_market`.`order_decimals`,
       `markets_market`.`hide`,
       `markets_market`.`sorting`,
       `markets_market`.`timestamp_trades`,
       `markets_market`.`timestamp_orders`
FROM `markets_market`
WHERE `markets_market`.`hide` = False

SELECT `markets_trade`.`id`,
       `markets_trade`.`symbol_id`,
       `markets_trade`.`timestamp`,
       `markets_trade`.`price`,
       `markets_trade`.`volume`
FROM `markets_trade`
WHERE `markets_trade`.`symbol_id` = bcLREUR
ORDER BY `markets_trade`.`timestamp` DESC, `markets_trade`.`id` DESC LIMIT 1

SELECT `markets_trade`.`id`,
       `markets_trade`.`symbol_id`,
       `markets_trade`.`timestamp`,
       `markets_trade`.`price`,
       `markets_trade`.`volume`
FROM `markets_trade`
WHERE (`markets_trade`.`symbol_id` = bcLREUR
       AND `markets_trade`.`timestamp` >= 1303948800)
ORDER BY `markets_trade`.`timestamp` ASC, `markets_trade`.`id` DESC LIMIT 1

SELECT `markets_trade`.`id`,
       `markets_trade`.`symbol_id`,
       `markets_trade`.`timestamp`,
       `markets_trade`.`price`,
       `markets_trade`.`volume`
FROM `markets_trade`
WHERE (`markets_trade`.`symbol_id` = bcLREUR
       AND `markets_trade`.`timestamp` <= 1303948800)
ORDER BY `markets_trade`.`timestamp` DESC, `markets_trade`.`id` DESC LIMIT 1

select min(price) as low, max(price) as high, sum(volume) as volume, sum(volume*price) as cvolume, count(id)
from markets_trade
where timestamp >= 1303948800
  and symbol_id = bcLREUR
order by timestamp desc, id desc;

SELECT `markets_order`.`timestamp`
FROM `markets_order`
WHERE `markets_order`.`symbol_id` = bcLREUR
ORDER BY `markets_order`.`timestamp` DESC LIMIT 1

SELECT `markets_order`.`price`
FROM `markets_order`
WHERE (`markets_order`.`symbol_id` = bcLREUR
       AND `markets_order`.`timestamp` = 1305151371
       AND `markets_order`.`order` = b)
ORDER BY `markets_order`.`price` DESC LIMIT 1

SELECT `markets_order`.`price`
FROM `markets_order`
WHERE (`markets_order`.`symbol_id` = bcLREUR
       AND `markets_order`.`timestamp` = 1305151371
       AND `markets_order`.`order` = a)
ORDER BY `markets_order`.`price` ASC LIMIT 1

SELECT `markets_currency`.`code`,
       `markets_currency`.`symbol`
FROM `markets_currency`
WHERE `markets_currency`.`code` = EUR

SELECT `markets_trade`.`id`,
       `markets_trade`.`symbol_id`,
       `markets_trade`.`timestamp`,
       `markets_trade`.`price`,
       `markets_trade`.`volume`
FROM `markets_trade`
WHERE `markets_trade`.`symbol_id` = bcEUR
ORDER BY `markets_trade`.`timestamp` DESC, `markets_trade`.`id` DESC LIMIT 1

SELECT `markets_trade`.`id`,
       `markets_trade`.`symbol_id`,
       `markets_trade`.`timestamp`,
       `markets_trade`.`price`,
       `markets_trade`.`volume`
FROM `markets_trade`
WHERE (`markets_trade`.`symbol_id` = bcEUR
       AND `markets_trade`.`timestamp` >= 1304121600)
ORDER BY `markets_trade`.`timestamp` ASC, `markets_trade`.`id` DESC LIMIT 1

SELECT `markets_trade`.`id`,
       `markets_trade`.`symbol_id`,
       `markets_trade`.`timestamp`,
       `markets_trade`.`price`,
       `markets_trade`.`volume`
FROM `markets_trade`
WHERE (`markets_trade`.`symbol_id` = bcEUR
       AND `markets_trade`.`timestamp` <= 1304121600)
ORDER BY `markets_trade`.`timestamp` DESC, `markets_trade`.`id` DESC LIMIT 1

select min(price) as low, max(price) as high, sum(volume) as volume, sum(volume*price) as cvolume, count(id)
from markets_trade
where timestamp >= 1304121600
  and symbol_id = bcEUR
order by timestamp desc, id desc;

SELECT `markets_order`.`timestamp`
FROM `markets_order`
WHERE `markets_order`.`symbol_id` = bcEUR
ORDER BY `markets_order`.`timestamp` DESC LIMIT 1

SELECT `markets_order`.`price`
FROM `markets_order`
WHERE (`markets_order`.`symbol_id` = bcEUR
       AND `markets_order`.`timestamp` = 1304608225
       AND `markets_order`.`order` = b)
ORDER BY `markets_order`.`price` DESC LIMIT 1

SELECT `markets_order`.`price`
FROM `markets_order`
WHERE (`markets_order`.`symbol_id` = bcEUR
       AND `markets_order`.`timestamp` = 1304608225
       AND `markets_order`.`order` = a)
ORDER BY `markets_order`.`price` ASC LIMIT 1

SELECT `markets_currency`.`code`,
       `markets_currency`.`symbol`
FROM `markets_currency`
WHERE `markets_currency`.`code` = EUR

SELECT `markets_trade`.`id`,
       `markets_trade`.`symbol_id`,
       `markets_trade`.`timestamp`,
       `markets_trade`.`price`,
       `markets_trade`.`volume`
FROM `markets_trade`
WHERE `markets_trade`.`symbol_id` = bcLRUSD
ORDER BY `markets_trade`.`timestamp` DESC, `markets_trade`.`id` DESC LIMIT 1

SELECT `markets_trade`.`id`,
       `markets_trade`.`symbol_id`,
       `markets_trade`.`timestamp`,
       `markets_trade`.`price`,
       `markets_trade`.`volume`
FROM `markets_trade`
WHERE (`markets_trade`.`symbol_id` = bcLRUSD
       AND `markets_trade`.`timestamp` >= 1304985600)
ORDER BY `markets_trade`.`timestamp` ASC, `markets_trade`.`id` DESC LIMIT 1

SELECT `markets_trade`.`id`,
       `markets_trade`.`symbol_id`,
       `markets_trade`.`timestamp`,
       `markets_trade`.`price`,
       `markets_trade`.`volume`
FROM `markets_trade`
WHERE (`markets_trade`.`symbol_id` = bcLRUSD
       AND `markets_trade`.`timestamp` <= 1304985600)
ORDER BY `markets_trade`.`timestamp` DESC, `markets_trade`.`id` DESC LIMIT 1

select min(price) as low, max(price) as high, sum(volume) as volume, sum(volume*price) as cvolume, count(id)
from markets_trade
where timestamp >= 1304985600
  and symbol_id = bcLRUSD
order by timestamp desc, id desc;

SELECT `markets_order`.`timestamp`
FROM `markets_order`
WHERE `markets_order`.`symbol_id` = bcLRUSD
ORDER BY `markets_order`.`timestamp` DESC LIMIT 1

SELECT `markets_order`.`price`
FROM `markets_order`
WHERE (`markets_order`.`symbol_id` = bcLRUSD
       AND `markets_order`.`timestamp` = 1305187108
       AND `markets_order`.`order` = b)
ORDER BY `markets_order`.`price` DESC LIMIT 1

SELECT `markets_order`.`price`
FROM `markets_order`
WHERE (`markets_order`.`symbol_id` = bcLRUSD
       AND `markets_order`.`timestamp` = 1305187108
       AND `markets_order`.`order` = a)
ORDER BY `markets_order`.`price` ASC LIMIT 1

SELECT `markets_currency`.`code`,
       `markets_currency`.`symbol`
FROM `markets_currency`
WHERE `markets_currency`.`code` = USD

SELECT `markets_trade`.`id`,
       `markets_trade`.`symbol_id`,
       `markets_trade`.`timestamp`,
       `markets_trade`.`price`,
       `markets_trade`.`volume`
FROM `markets_trade`
WHERE `markets_trade`.`symbol_id` = btcexJPY
ORDER BY `markets_trade`.`timestamp` DESC, `markets_trade`.`id` DESC LIMIT 1

SELECT `markets_trade`.`id`,
       `markets_trade`.`symbol_id`,
       `markets_trade`.`timestamp`,
       `markets_trade`.`price`,
       `markets_trade`.`volume`
FROM `markets_trade`
WHERE (`markets_trade`.`symbol_id` = btcexJPY
       AND `markets_trade`.`timestamp` >= 1299283200)
ORDER BY `markets_trade`.`timestamp` ASC, `markets_trade`.`id` DESC LIMIT 1

SELECT `markets_trade`.`id`,
       `markets_trade`.`symbol_id`,
       `markets_trade`.`timestamp`,
       `markets_trade`.`price`,
       `markets_trade`.`volume`
FROM `markets_trade`
WHERE (`markets_trade`.`symbol_id` = btcexJPY
       AND `markets_trade`.`timestamp` <= 1299283200)
ORDER BY `markets_trade`.`timestamp` DESC, `markets_trade`.`id` DESC LIMIT 1

select min(price) as low, max(price) as high, sum(volume) as volume, sum(volume*price) as cvolume, count(id)
from markets_trade
where timestamp >= 1299283200
  and symbol_id = btcexJPY
order by timestamp desc, id desc;

SELECT `markets_order`.`timestamp`
FROM `markets_order`
WHERE `markets_order`.`symbol_id` = btcexJPY
ORDER BY `markets_order`.`timestamp` DESC LIMIT 1

SELECT `markets_currency`.`code`,
       `markets_currency`.`symbol`
FROM `markets_currency`
WHERE `markets_currency`.`code` = JPY

SELECT `markets_trade`.`id`,
       `markets_trade`.`symbol_id`,
       `markets_trade`.`timestamp`,
       `markets_trade`.`price`,
       `markets_trade`.`volume`
FROM `markets_trade`
WHERE `markets_trade`.`symbol_id` = btcexWMR
ORDER BY `markets_trade`.`timestamp` DESC, `markets_trade`.`id` DESC LIMIT 1

SELECT `markets_trade`.`id`,
       `markets_trade`.`symbol_id`,
       `markets_trade`.`timestamp`,
       `markets_trade`.`price`,
       `markets_trade`.`volume`
FROM `markets_trade`
WHERE (`markets_trade`.`symbol_id` = btcexWMR
       AND `markets_trade`.`timestamp` >= 1305072000)
ORDER BY `markets_trade`.`timestamp` ASC, `markets_trade`.`id` DESC LIMIT 1

SELECT `markets_trade`.`id`,
       `markets_trade`.`symbol_id`,
       `markets_trade`.`timestamp`,
       `markets_trade`.`price`,
       `markets_trade`.`volume`
FROM `markets_trade`
WHERE (`markets_trade`.`symbol_id` = btcexWMR
       AND `markets_trade`.`timestamp` <= 1305072000)
ORDER BY `markets_trade`.`timestamp` DESC, `markets_trade`.`id` DESC LIMIT 1

select min(price) as low, max(price) as high, sum(volume) as volume, sum(volume*price) as cvolume, count(id)
from markets_trade
where timestamp >= 1305072000
  and symbol_id = btcexWMR
order by timestamp desc, id desc;

SELECT `markets_order`.`timestamp`
FROM `markets_order`
WHERE `markets_order`.`symbol_id` = btcexWMR
ORDER BY `markets_order`.`timestamp` DESC LIMIT 1

SELECT `markets_order`.`price`
FROM `markets_order`
WHERE (`markets_order`.`symbol_id` = btcexWMR
       AND `markets_order`.`timestamp` = 1305056089
       AND `markets_order`.`order` = b)
ORDER BY `markets_order`.`price` DESC LIMIT 1

SELECT `markets_order`.`price`
FROM `markets_order`
WHERE (`markets_order`.`symbol_id` = btcexWMR
       AND `markets_order`.`timestamp` = 1305056089
       AND `markets_order`.`order` = a)
ORDER BY `markets_order`.`price` ASC LIMIT 1

SELECT `markets_currency`.`code`,
       `markets_currency`.`symbol`
FROM `markets_currency`
WHERE `markets_currency`.`code` = RUB

SELECT `markets_trade`.`id`,
       `markets_trade`.`symbol_id`,
       `markets_trade`.`timestamp`,
       `markets_trade`.`price`,
       `markets_trade`.`volume`
FROM `markets_trade`
WHERE `markets_trade`.`symbol_id` = bcmPPUSD
ORDER BY `markets_trade`.`timestamp` DESC, `markets_trade`.`id` DESC LIMIT 1

SELECT `markets_trade`.`id`,
       `markets_trade`.`symbol_id`,
       `markets_trade`.`timestamp`,
       `markets_trade`.`price`,
       `markets_trade`.`volume`
FROM `markets_trade`
WHERE (`markets_trade`.`symbol_id` = bcmPPUSD
       AND `markets_trade`.`timestamp` >= 1305158400)
ORDER BY `markets_trade`.`timestamp` ASC, `markets_trade`.`id` DESC LIMIT 1

SELECT `markets_trade`.`id`,
       `markets_trade`.`symbol_id`,
       `markets_trade`.`timestamp`,
       `markets_trade`.`price`,
       `markets_trade`.`volume`
FROM `markets_trade`
WHERE (`markets_trade`.`symbol_id` = bcmPPUSD
       AND `markets_trade`.`timestamp` <= 1305158400)
ORDER BY `markets_trade`.`timestamp` DESC, `markets_trade`.`id` DESC LIMIT 1

select min(price) as low, max(price) as high, sum(volume) as volume, sum(volume*price) as cvolume, count(id)
from markets_trade
where timestamp >= 1305158400
  and symbol_id = bcmPPUSD
order by timestamp desc, id desc;

SELECT `markets_order`.`timestamp`
FROM `markets_order`
WHERE `markets_order`.`symbol_id` = bcmPPUSD
ORDER BY `markets_order`.`timestamp` DESC LIMIT 1

SELECT `markets_order`.`price`
FROM `markets_order`
WHERE (`markets_order`.`symbol_id` = bcmPPUSD
       AND `markets_order`.`timestamp` = 1305189298
       AND `markets_order`.`order` = b)
ORDER BY `markets_order`.`price` DESC LIMIT 1

SELECT `markets_order`.`price`
FROM `markets_order`
WHERE (`markets_order`.`symbol_id` = bcmPPUSD
       AND `markets_order`.`timestamp` = 1305189298
       AND `markets_order`.`order` = a)
ORDER BY `markets_order`.`price` ASC LIMIT 1

SELECT `markets_currency`.`code`,
       `markets_currency`.`symbol`
FROM `markets_currency`
WHERE `markets_currency`.`code` = USD

SELECT `markets_trade`.`id`,
       `markets_trade`.`symbol_id`,
       `markets_trade`.`timestamp`,
       `markets_trade`.`price`,
       `markets_trade`.`volume`
FROM `markets_trade`
WHERE `markets_trade`.`symbol_id` = mtgoxUSD
ORDER BY `markets_trade`.`timestamp` DESC, `markets_trade`.`id` DESC LIMIT 1

SELECT `markets_trade`.`id`,
       `markets_trade`.`symbol_id`,
       `markets_trade`.`timestamp`,
       `markets_trade`.`price`,
       `markets_trade`.`volume`
FROM `markets_trade`
WHERE (`markets_trade`.`symbol_id` = mtgoxUSD
       AND `markets_trade`.`timestamp` >= 1305158400)
ORDER BY `markets_trade`.`timestamp` ASC, `markets_trade`.`id` DESC LIMIT 1

SELECT `markets_trade`.`id`,
       `markets_trade`.`symbol_id`,
       `markets_trade`.`timestamp`,
       `markets_trade`.`price`,
       `markets_trade`.`volume`
FROM `markets_trade`
WHERE (`markets_trade`.`symbol_id` = mtgoxUSD
       AND `markets_trade`.`timestamp` <= 1305158400)
ORDER BY `markets_trade`.`timestamp` DESC, `markets_trade`.`id` DESC LIMIT 1

select min(price) as low, max(price) as high, sum(volume) as volume, sum(volume*price) as cvolume, count(id)
from markets_trade
where timestamp >= 1305158400
  and symbol_id = mtgoxUSD
order by timestamp desc, id desc;

SELECT `markets_order`.`timestamp`
FROM `markets_order`
WHERE `markets_order`.`symbol_id` = mtgoxUSD
ORDER BY `markets_order`.`timestamp` DESC LIMIT 1

SELECT `markets_order`.`price`
FROM `markets_order`
WHERE (`markets_order`.`symbol_id` = mtgoxUSD
       AND `markets_order`.`timestamp` = 1305198858
       AND `markets_order`.`order` = b)
ORDER BY `markets_order`.`price` DESC LIMIT 1

SELECT `markets_order`.`price`
FROM `markets_order`
WHERE (`markets_order`.`symbol_id` = mtgoxUSD
       AND `markets_order`.`timestamp` = 1305198858
       AND `markets_order`.`order` = a)
ORDER BY `markets_order`.`price` ASC LIMIT 1

SELECT `markets_currency`.`code`,
       `markets_currency`.`symbol`
FROM `markets_currency`
WHERE `markets_currency`.`code` = USD

SELECT `markets_trade`.`id`,
       `markets_trade`.`symbol_id`,
       `markets_trade`.`timestamp`,
       `markets_trade`.`price`,
       `markets_trade`.`volume`
FROM `markets_trade`
WHERE `markets_trade`.`symbol_id` = bcmLRUSD
ORDER BY `markets_trade`.`timestamp` DESC, `markets_trade`.`id` DESC LIMIT 1

SELECT `markets_trade`.`id`,
       `markets_trade`.`symbol_id`,
       `markets_trade`.`timestamp`,
       `markets_trade`.`price`,
       `markets_trade`.`volume`
FROM `markets_trade`
WHERE (`markets_trade`.`symbol_id` = bcmLRUSD
       AND `markets_trade`.`timestamp` >= 1291075200)
ORDER BY `markets_trade`.`timestamp` ASC, `markets_trade`.`id` DESC LIMIT 1

SELECT `markets_trade`.`id`,
       `markets_trade`.`symbol_id`,
       `markets_trade`.`timestamp`,
       `markets_trade`.`price`,
       `markets_trade`.`volume`
FROM `markets_trade`
WHERE (`markets_trade`.`symbol_id` = bcmLRUSD
       AND `markets_trade`.`timestamp` <= 1291075200)
ORDER BY `markets_trade`.`timestamp` DESC, `markets_trade`.`id` DESC LIMIT 1

select min(price) as low, max(price) as high, sum(volume) as volume, sum(volume*price) as cvolume, count(id)
from markets_trade
where timestamp >= 1291075200
  and symbol_id = bcmLRUSD
order by timestamp desc, id desc;

SELECT `markets_order`.`timestamp`
FROM `markets_order`
WHERE `markets_order`.`symbol_id` = bcmLRUSD
ORDER BY `markets_order`.`timestamp` DESC LIMIT 1

SELECT `markets_order`.`price`
FROM `markets_order`
WHERE (`markets_order`.`symbol_id` = bcmLRUSD
       AND `markets_order`.`timestamp` = 1304998699
       AND `markets_order`.`order` = b)
ORDER BY `markets_order`.`price` DESC LIMIT 1

SELECT `markets_order`.`price`
FROM `markets_order`
WHERE (`markets_order`.`symbol_id` = bcmLRUSD
       AND `markets_order`.`timestamp` = 1304998699
       AND `markets_order`.`order` = a)
ORDER BY `markets_order`.`price` ASC LIMIT 1

SELECT `markets_currency`.`code`,
       `markets_currency`.`symbol`
FROM `markets_currency`
WHERE `markets_currency`.`code` = USD

SELECT `markets_trade`.`id`,
       `markets_trade`.`symbol_id`,
       `markets_trade`.`timestamp`,
       `markets_trade`.`price`,
       `markets_trade`.`volume`
FROM `markets_trade`
WHERE `markets_trade`.`symbol_id` = bcmPXGAU
ORDER BY `markets_trade`.`timestamp` DESC, `markets_trade`.`id` DESC LIMIT 1

SELECT `markets_trade`.`id`,
       `markets_trade`.`symbol_id`,
       `markets_trade`.`timestamp`,
       `markets_trade`.`price`,
       `markets_trade`.`volume`
FROM `markets_trade`
WHERE (`markets_trade`.`symbol_id` = bcmPXGAU
       AND `markets_trade`.`timestamp` >= 1289174400)
ORDER BY `markets_trade`.`timestamp` ASC, `markets_trade`.`id` DESC LIMIT 1

SELECT `markets_trade`.`id`,
       `markets_trade`.`symbol_id`,
       `markets_trade`.`timestamp`,
       `markets_trade`.`price`,
       `markets_trade`.`volume`
FROM `markets_trade`
WHERE (`markets_trade`.`symbol_id` = bcmPXGAU
       AND `markets_trade`.`timestamp` <= 1289174400)
ORDER BY `markets_trade`.`timestamp` DESC, `markets_trade`.`id` DESC LIMIT 1

select min(price) as low, max(price) as high, sum(volume) as volume, sum(volume*price) as cvolume, count(id)
from markets_trade
where timestamp >= 1289174400
  and symbol_id = bcmPXGAU
order by timestamp desc, id desc;

SELECT `markets_order`.`timestamp`
FROM `markets_order`
WHERE `markets_order`.`symbol_id` = bcmPXGAU
ORDER BY `markets_order`.`timestamp` DESC LIMIT 1

SELECT `markets_currency`.`code`,
       `markets_currency`.`symbol`
FROM `markets_currency`
WHERE `markets_currency`.`code` = GAU

SELECT `markets_trade`.`id`,
       `markets_trade`.`symbol_id`,
       `markets_trade`.`timestamp`,
       `markets_trade`.`price`,
       `markets_trade`.`volume`
FROM `markets_trade`
WHERE `markets_trade`.`symbol_id` = btcexRUB
ORDER BY `markets_trade`.`timestamp` DESC, `markets_trade`.`id` DESC LIMIT 1

SELECT `markets_trade`.`id`,
       `markets_trade`.`symbol_id`,
       `markets_trade`.`timestamp`,
       `markets_trade`.`price`,
       `markets_trade`.`volume`
FROM `markets_trade`
WHERE (`markets_trade`.`symbol_id` = btcexRUB
       AND `markets_trade`.`timestamp` >= 1305072000)
ORDER BY `markets_trade`.`timestamp` ASC, `markets_trade`.`id` DESC LIMIT 1

SELECT `markets_trade`.`id`,
       `markets_trade`.`symbol_id`,
       `markets_trade`.`timestamp`,
       `markets_trade`.`price`,
       `markets_trade`.`volume`
FROM `markets_trade`
WHERE (`markets_trade`.`symbol_id` = btcexRUB
       AND `markets_trade`.`timestamp` <= 1305072000)
ORDER BY `markets_trade`.`timestamp` DESC, `markets_trade`.`id` DESC LIMIT 1

select min(price) as low, max(price) as high, sum(volume) as volume, sum(volume*price) as cvolume, count(id)
from markets_trade
where timestamp >= 1305072000
  and symbol_id = btcexRUB
order by timestamp desc, id desc;

SELECT `markets_order`.`timestamp`
FROM `markets_order`
WHERE `markets_order`.`symbol_id` = btcexRUB
ORDER BY `markets_order`.`timestamp` DESC LIMIT 1

SELECT `markets_order`.`price`
FROM `markets_order`
WHERE (`markets_order`.`symbol_id` = btcexRUB
       AND `markets_order`.`timestamp` = 1305054269
       AND `markets_order`.`order` = b)
ORDER BY `markets_order`.`price` DESC LIMIT 1

SELECT `markets_order`.`price`
FROM `markets_order`
WHERE (`markets_order`.`symbol_id` = btcexRUB
       AND `markets_order`.`timestamp` = 1305054269
       AND `markets_order`.`order` = a)
ORDER BY `markets_order`.`price` ASC LIMIT 1

SELECT `markets_currency`.`code`,
       `markets_currency`.`symbol`
FROM `markets_currency`
WHERE `markets_currency`.`code` = RUB

SELECT `markets_trade`.`id`,
       `markets_trade`.`symbol_id`,
       `markets_trade`.`timestamp`,
       `markets_trade`.`price`,
       `markets_trade`.`volume`
FROM `markets_trade`
WHERE `markets_trade`.`symbol_id` = bcPGAU
ORDER BY `markets_trade`.`timestamp` DESC, `markets_trade`.`id` DESC LIMIT 1

SELECT `markets_trade`.`id`,
       `markets_trade`.`symbol_id`,
       `markets_trade`.`timestamp`,
       `markets_trade`.`price`,
       `markets_trade`.`volume`
FROM `markets_trade`
WHERE (`markets_trade`.`symbol_id` = bcPGAU
       AND `markets_trade`.`timestamp` >= 1303171200)
ORDER BY `markets_trade`.`timestamp` ASC, `markets_trade`.`id` DESC LIMIT 1

SELECT `markets_trade`.`id`,
       `markets_trade`.`symbol_id`,
       `markets_trade`.`timestamp`,
       `markets_trade`.`price`,
       `markets_trade`.`volume`
FROM `markets_trade`
WHERE (`markets_trade`.`symbol_id` = bcPGAU
       AND `markets_trade`.`timestamp` <= 1303171200)
ORDER BY `markets_trade`.`timestamp` DESC, `markets_trade`.`id` DESC LIMIT 1

select min(price) as low, max(price) as high, sum(volume) as volume, sum(volume*price) as cvolume, count(id)
from markets_trade
where timestamp >= 1303171200
  and symbol_id = bcPGAU
order by timestamp desc, id desc;

SELECT `markets_order`.`timestamp`
FROM `markets_order`
WHERE `markets_order`.`symbol_id` = bcPGAU
ORDER BY `markets_order`.`timestamp` DESC LIMIT 1

SELECT `markets_order`.`price`
FROM `markets_order`
WHERE (`markets_order`.`symbol_id` = bcPGAU
       AND `markets_order`.`timestamp` = 1304489664
       AND `markets_order`.`order` = b)
ORDER BY `markets_order`.`price` DESC LIMIT 1

SELECT `markets_order`.`price`
FROM `markets_order`
WHERE (`markets_order`.`symbol_id` = bcPGAU
       AND `markets_order`.`timestamp` = 1304489664
       AND `markets_order`.`order` = a)
ORDER BY `markets_order`.`price` ASC LIMIT 1

SELECT `markets_currency`.`code`,
       `markets_currency`.`symbol`
FROM `markets_currency`
WHERE `markets_currency`.`code` = GAU

SELECT `markets_trade`.`id`,
       `markets_trade`.`symbol_id`,
       `markets_trade`.`timestamp`,
       `markets_trade`.`price`,
       `markets_trade`.`volume`
FROM `markets_trade`
WHERE `markets_trade`.`symbol_id` = btcexUSD
ORDER BY `markets_trade`.`timestamp` DESC, `markets_trade`.`id` DESC LIMIT 1

SELECT `markets_trade`.`id`,
       `markets_trade`.`symbol_id`,
       `markets_trade`.`timestamp`,
       `markets_trade`.`price`,
       `markets_trade`.`volume`
FROM `markets_trade`
WHERE (`markets_trade`.`symbol_id` = btcexUSD
       AND `markets_trade`.`timestamp` >= 1305072000)
ORDER BY `markets_trade`.`timestamp` ASC, `markets_trade`.`id` DESC LIMIT 1

SELECT `markets_trade`.`id`,
       `markets_trade`.`symbol_id`,
       `markets_trade`.`timestamp`,
       `markets_trade`.`price`,
       `markets_trade`.`volume`
FROM `markets_trade`
WHERE (`markets_trade`.`symbol_id` = btcexUSD
       AND `markets_trade`.`timestamp` <= 1305072000)
ORDER BY `markets_trade`.`timestamp` DESC, `markets_trade`.`id` DESC LIMIT 1

select min(price) as low, max(price) as high, sum(volume) as volume, sum(volume*price) as cvolume, count(id)
from markets_trade
where timestamp >= 1305072000
  and symbol_id = btcexUSD
order by timestamp desc, id desc;

SELECT `markets_order`.`timestamp`
FROM `markets_order`
WHERE `markets_order`.`symbol_id` = btcexUSD
ORDER BY `markets_order`.`timestamp` DESC LIMIT 1

SELECT `markets_order`.`price`
FROM `markets_order`
WHERE (`markets_order`.`symbol_id` = btcexUSD
       AND `markets_order`.`timestamp` = 1305036102
       AND `markets_order`.`order` = b)
ORDER BY `markets_order`.`price` DESC LIMIT 1

SELECT `markets_order`.`price`
FROM `markets_order`
WHERE (`markets_order`.`symbol_id` = btcexUSD
       AND `markets_order`.`timestamp` = 1305036102
       AND `markets_order`.`order` = a)
ORDER BY `markets_order`.`price` ASC LIMIT 1

SELECT `markets_currency`.`code`,
       `markets_currency`.`symbol`
FROM `markets_currency`
WHERE `markets_currency`.`code` = USD

SELECT `markets_trade`.`id`,
       `markets_trade`.`symbol_id`,
       `markets_trade`.`timestamp`,
       `markets_trade`.`price`,
       `markets_trade`.`volume`
FROM `markets_trade`
WHERE `markets_trade`.`symbol_id` = btcexEUR
ORDER BY `markets_trade`.`timestamp` DESC, `markets_trade`.`id` DESC LIMIT 1

SELECT `markets_trade`.`id`,
       `markets_trade`.`symbol_id`,
       `markets_trade`.`timestamp`,
       `markets_trade`.`price`,
       `markets_trade`.`volume`
FROM `markets_trade`
WHERE (`markets_trade`.`symbol_id` = btcexEUR
       AND `markets_trade`.`timestamp` >= 1305072000)
ORDER BY `markets_trade`.`timestamp` ASC, `markets_trade`.`id` DESC LIMIT 1

SELECT `markets_trade`.`id`,
       `markets_trade`.`symbol_id`,
       `markets_trade`.`timestamp`,
       `markets_trade`.`price`,
       `markets_trade`.`volume`
FROM `markets_trade`
WHERE (`markets_trade`.`symbol_id` = btcexEUR
       AND `markets_trade`.`timestamp` <= 1305072000)
ORDER BY `markets_trade`.`timestamp` DESC, `markets_trade`.`id` DESC LIMIT 1

select min(price) as low, max(price) as high, sum(volume) as volume, sum(volume*price) as cvolume, count(id)
from markets_trade
where timestamp >= 1305072000
  and symbol_id = btcexEUR
order by timestamp desc, id desc;

SELECT `markets_order`.`timestamp`
FROM `markets_order`
WHERE `markets_order`.`symbol_id` = btcexEUR
ORDER BY `markets_order`.`timestamp` DESC LIMIT 1

SELECT `markets_order`.`price`
FROM `markets_order`
WHERE (`markets_order`.`symbol_id` = btcexEUR
       AND `markets_order`.`timestamp` = 1305045332
       AND `markets_order`.`order` = b)
ORDER BY `markets_order`.`price` DESC LIMIT 1

SELECT `markets_order`.`price`
FROM `markets_order`
WHERE (`markets_order`.`symbol_id` = btcexEUR
       AND `markets_order`.`timestamp` = 1305045332
       AND `markets_order`.`order` = a)
ORDER BY `markets_order`.`price` ASC LIMIT 1

SELECT `markets_currency`.`code`,
       `markets_currency`.`symbol`
FROM `markets_currency`
WHERE `markets_currency`.`code` = EUR

SELECT `markets_trade`.`id`,
       `markets_trade`.`symbol_id`,
       `markets_trade`.`timestamp`,
       `markets_trade`.`price`,
       `markets_trade`.`volume`
FROM `markets_trade`
WHERE `markets_trade`.`symbol_id` = btcexWMZ
ORDER BY `markets_trade`.`timestamp` DESC, `markets_trade`.`id` DESC LIMIT 1

SELECT `markets_trade`.`id`,
       `markets_trade`.`symbol_id`,
       `markets_trade`.`timestamp`,
       `markets_trade`.`price`,
       `markets_trade`.`volume`
FROM `markets_trade`
WHERE (`markets_trade`.`symbol_id` = btcexWMZ
       AND `markets_trade`.`timestamp` >= 1305072000)
ORDER BY `markets_trade`.`timestamp` ASC, `markets_trade`.`id` DESC LIMIT 1

SELECT `markets_trade`.`id`,
       `markets_trade`.`symbol_id`,
       `markets_trade`.`timestamp`,
       `markets_trade`.`price`,
       `markets_trade`.`volume`
FROM `markets_trade`
WHERE (`markets_trade`.`symbol_id` = btcexWMZ
       AND `markets_trade`.`timestamp` <= 1305072000)
ORDER BY `markets_trade`.`timestamp` DESC, `markets_trade`.`id` DESC LIMIT 1

select min(price) as low, max(price) as high, sum(volume) as volume, sum(volume*price) as cvolume, count(id)
from markets_trade
where timestamp >= 1305072000
  and symbol_id = btcexWMZ
order by timestamp desc, id desc;

SELECT `markets_order`.`timestamp`
FROM `markets_order`
WHERE `markets_order`.`symbol_id` = btcexWMZ
ORDER BY `markets_order`.`timestamp` DESC LIMIT 1

SELECT `markets_order`.`price`
FROM `markets_order`
WHERE (`markets_order`.`symbol_id` = btcexWMZ
       AND `markets_order`.`timestamp` = 1305055710
       AND `markets_order`.`order` = b)
ORDER BY `markets_order`.`price` DESC LIMIT 1

SELECT `markets_order`.`price`
FROM `markets_order`
WHERE (`markets_order`.`symbol_id` = btcexWMZ
       AND `markets_order`.`timestamp` = 1305055710
       AND `markets_order`.`order` = a)
ORDER BY `markets_order`.`price` ASC LIMIT 1

SELECT `markets_currency`.`code`,
       `markets_currency`.`symbol`
FROM `markets_currency`
WHERE `markets_currency`.`code` = USD

SELECT `markets_trade`.`id`,
       `markets_trade`.`symbol_id`,
       `markets_trade`.`timestamp`,
       `markets_trade`.`price`,
       `markets_trade`.`volume`
FROM `markets_trade`
WHERE `markets_trade`.`symbol_id` = btcexYAD
ORDER BY `markets_trade`.`timestamp` DESC, `markets_trade`.`id` DESC LIMIT 1

SELECT `markets_trade`.`id`,
       `markets_trade`.`symbol_id`,
       `markets_trade`.`timestamp`,
       `markets_trade`.`price`,
       `markets_trade`.`volume`
FROM `markets_trade`
WHERE (`markets_trade`.`symbol_id` = btcexYAD
       AND `markets_trade`.`timestamp` >= 1305072000)
ORDER BY `markets_trade`.`timestamp` ASC, `markets_trade`.`id` DESC LIMIT 1

SELECT `markets_trade`.`id`,
       `markets_trade`.`symbol_id`,
       `markets_trade`.`timestamp`,
       `markets_trade`.`price`,
       `markets_trade`.`volume`
FROM `markets_trade`
WHERE (`markets_trade`.`symbol_id` = btcexYAD
       AND `markets_trade`.`timestamp` <= 1305072000)
ORDER BY `markets_trade`.`timestamp` DESC, `markets_trade`.`id` DESC LIMIT 1

select min(price) as low, max(price) as high, sum(volume) as volume, sum(volume*price) as cvolume, count(id)
from markets_trade
where timestamp >= 1305072000
  and symbol_id = btcexYAD
order by timestamp desc, id desc;

SELECT `markets_order`.`timestamp`
FROM `markets_order`
WHERE `markets_order`.`symbol_id` = btcexYAD
ORDER BY `markets_order`.`timestamp` DESC LIMIT 1

SELECT `markets_order`.`price`
FROM `markets_order`
WHERE (`markets_order`.`symbol_id` = btcexYAD
       AND `markets_order`.`timestamp` = 1305056447
       AND `markets_order`.`order` = b)
ORDER BY `markets_order`.`price` DESC LIMIT 1

SELECT `markets_order`.`price`
FROM `markets_order`
WHERE (`markets_order`.`symbol_id` = btcexYAD
       AND `markets_order`.`timestamp` = 1305056447
       AND `markets_order`.`order` = a)
ORDER BY `markets_order`.`price` ASC LIMIT 1

SELECT `markets_currency`.`code`,
       `markets_currency`.`symbol`
FROM `markets_currency`
WHERE `markets_currency`.`code` = RUB

SELECT `markets_trade`.`id`,
       `markets_trade`.`symbol_id`,
       `markets_trade`.`timestamp`,
       `markets_trade`.`price`,
       `markets_trade`.`volume`
FROM `markets_trade`
WHERE `markets_trade`.`symbol_id` = bcmBMUSD
ORDER BY `markets_trade`.`timestamp` DESC, `markets_trade`.`id` DESC LIMIT 1

SELECT `markets_trade`.`id`,
       `markets_trade`.`symbol_id`,
       `markets_trade`.`timestamp`,
       `markets_trade`.`price`,
       `markets_trade`.`volume`
FROM `markets_trade`
WHERE (`markets_trade`.`symbol_id` = bcmBMUSD
       AND `markets_trade`.`timestamp` >= 1304726400)
ORDER BY `markets_trade`.`timestamp` ASC, `markets_trade`.`id` DESC LIMIT 1

SELECT `markets_trade`.`id`,
       `markets_trade`.`symbol_id`,
       `markets_trade`.`timestamp`,
       `markets_trade`.`price`,
       `markets_trade`.`volume`
FROM `markets_trade`
WHERE (`markets_trade`.`symbol_id` = bcmBMUSD
       AND `markets_trade`.`timestamp` <= 1304726400)
ORDER BY `markets_trade`.`timestamp` DESC, `markets_trade`.`id` DESC LIMIT 1

select min(price) as low, max(price) as high, sum(volume) as volume, sum(volume*price) as cvolume, count(id)
from markets_trade
where timestamp >= 1304726400
  and symbol_id = bcmBMUSD
order by timestamp desc, id desc;

SELECT `markets_order`.`timestamp`
FROM `markets_order`
WHERE `markets_order`.`symbol_id` = bcmBMUSD
ORDER BY `markets_order`.`timestamp` DESC LIMIT 1

SELECT `markets_order`.`price`
FROM `markets_order`
WHERE (`markets_order`.`symbol_id` = bcmBMUSD
       AND `markets_order`.`timestamp` = 1305151371
       AND `markets_order`.`order` = b)
ORDER BY `markets_order`.`price` DESC LIMIT 1

SELECT `markets_order`.`price`
FROM `markets_order`
WHERE (`markets_order`.`symbol_id` = bcmBMUSD
       AND `markets_order`.`timestamp` = 1305151371
       AND `markets_order`.`order` = a)
ORDER BY `markets_order`.`price` ASC LIMIT 1

SELECT `markets_currency`.`code`,
       `markets_currency`.`symbol`
FROM `markets_currency`
WHERE `markets_currency`.`code` = USD

SELECT `markets_trade`.`id`,
       `markets_trade`.`symbol_id`,
       `markets_trade`.`timestamp`,
       `markets_trade`.`price`,
       `markets_trade`.`volume`
FROM `markets_trade`
WHERE `markets_trade`.`symbol_id` = bcmMLUSD
ORDER BY `markets_trade`.`timestamp` DESC, `markets_trade`.`id` DESC LIMIT 1

SELECT `markets_trade`.`id`,
       `markets_trade`.`symbol_id`,
       `markets_trade`.`timestamp`,
       `markets_trade`.`price`,
       `markets_trade`.`volume`
FROM `markets_trade`
WHERE `markets_trade`.`symbol_id` = bcmBMGAU
ORDER BY `markets_trade`.`timestamp` DESC, `markets_trade`.`id` DESC LIMIT 1

SELECT `markets_trade`.`id`,
       `markets_trade`.`symbol_id`,
       `markets_trade`.`timestamp`,
       `markets_trade`.`price`,
       `markets_trade`.`volume`
FROM `markets_trade`
WHERE `markets_trade`.`symbol_id` = bcmMBUSD
ORDER BY `markets_trade`.`timestamp` DESC, `markets_trade`.`id` DESC LIMIT 1

SELECT `markets_trade`.`id`,
       `markets_trade`.`symbol_id`,
       `markets_trade`.`timestamp`,
       `markets_trade`.`price`,
       `markets_trade`.`volume`
FROM `markets_trade`
WHERE `markets_trade`.`symbol_id` = bcmBMAUD
ORDER BY `markets_trade`.`timestamp` DESC, `markets_trade`.`id` DESC LIMIT 1

SELECT `markets_trade`.`id`,
       `markets_trade`.`symbol_id`,
       `markets_trade`.`timestamp`,
       `markets_trade`.`price`,
       `markets_trade`.`volume`
FROM `markets_trade`
WHERE `markets_trade`.`symbol_id` = britcoinGBP
ORDER BY `markets_trade`.`timestamp` DESC, `markets_trade`.`id` DESC LIMIT 1

SELECT `markets_trade`.`id`,
       `markets_trade`.`symbol_id`,
       `markets_trade`.`timestamp`,
       `markets_trade`.`price`,
       `markets_trade`.`volume`
FROM `markets_trade`
WHERE (`markets_trade`.`symbol_id` = britcoinGBP
       AND `markets_trade`.`timestamp` >= 1305072000)
ORDER BY `markets_trade`.`timestamp` ASC, `markets_trade`.`id` DESC LIMIT 1

SELECT `markets_trade`.`id`,
       `markets_trade`.`symbol_id`,
       `markets_trade`.`timestamp`,
       `markets_trade`.`price`,
       `markets_trade`.`volume`
FROM `markets_trade`
WHERE (`markets_trade`.`symbol_id` = britcoinGBP
       AND `markets_trade`.`timestamp` <= 1305072000)
ORDER BY `markets_trade`.`timestamp` DESC, `markets_trade`.`id` DESC LIMIT 1

select min(price) as low, max(price) as high, sum(volume) as volume, sum(volume*price) as cvolume, count(id)
from markets_trade
where timestamp >= 1305072000
  and symbol_id = britcoinGBP
order by timestamp desc, id desc;

SELECT `markets_order`.`timestamp`
FROM `markets_order`
WHERE `markets_order`.`symbol_id` = britcoinGBP
ORDER BY `markets_order`.`timestamp` DESC LIMIT 1

SELECT `markets_order`.`price`
FROM `markets_order`
WHERE (`markets_order`.`symbol_id` = britcoinGBP
       AND `markets_order`.`timestamp` = 1305198843
       AND `markets_order`.`order` = b)
ORDER BY `markets_order`.`price` DESC LIMIT 1

SELECT `markets_order`.`price`
FROM `markets_order`
WHERE (`markets_order`.`symbol_id` = britcoinGBP
       AND `markets_order`.`timestamp` = 1305198843
       AND `markets_order`.`order` = a)
ORDER BY `markets_order`.`price` ASC LIMIT 1

SELECT `markets_currency`.`code`,
       `markets_currency`.`symbol`
FROM `markets_currency`
WHERE `markets_currency`.`code` = GBP

SELECT `markets_trade`.`id`,
       `markets_trade`.`symbol_id`,
       `markets_trade`.`timestamp`,
       `markets_trade`.`price`,
       `markets_trade`.`volume`
FROM `markets_trade`
WHERE `markets_trade`.`symbol_id` = bitomatPLN
ORDER BY `markets_trade`.`timestamp` DESC, `markets_trade`.`id` DESC LIMIT 1

SELECT `markets_trade`.`id`,
       `markets_trade`.`symbol_id`,
       `markets_trade`.`timestamp`,
       `markets_trade`.`price`,
       `markets_trade`.`volume`
FROM `markets_trade`
WHERE (`markets_trade`.`symbol_id` = bitomatPLN
       AND `markets_trade`.`timestamp` >= 1305158400)
ORDER BY `markets_trade`.`timestamp` ASC, `markets_trade`.`id` DESC LIMIT 1

SELECT `markets_trade`.`id`,
       `markets_trade`.`symbol_id`,
       `markets_trade`.`timestamp`,
       `markets_trade`.`price`,
       `markets_trade`.`volume`
FROM `markets_trade`
WHERE (`markets_trade`.`symbol_id` = bitomatPLN
       AND `markets_trade`.`timestamp` <= 1305158400)
ORDER BY `markets_trade`.`timestamp` DESC, `markets_trade`.`id` DESC LIMIT 1

select min(price) as low, max(price) as high, sum(volume) as volume, sum(volume*price) as cvolume, count(id)
from markets_trade
where timestamp >= 1305158400
  and symbol_id = bitomatPLN
order by timestamp desc, id desc;

SELECT `markets_order`.`timestamp`
FROM `markets_order`
WHERE `markets_order`.`symbol_id` = bitomatPLN
ORDER BY `markets_order`.`timestamp` DESC LIMIT 1

SELECT `markets_order`.`price`
FROM `markets_order`
WHERE (`markets_order`.`symbol_id` = bitomatPLN
       AND `markets_order`.`timestamp` = 1305198842
       AND `markets_order`.`order` = b)
ORDER BY `markets_order`.`price` DESC LIMIT 1

SELECT `markets_order`.`price`
FROM `markets_order`
WHERE (`markets_order`.`symbol_id` = bitomatPLN
       AND `markets_order`.`timestamp` = 1305198842
       AND `markets_order`.`order` = a)
ORDER BY `markets_order`.`price` ASC LIMIT 1

SELECT `markets_currency`.`code`,
       `markets_currency`.`symbol`
FROM `markets_currency`
WHERE `markets_currency`.`code` = PLN

SELECT `markets_trade`.`id`,
       `markets_trade`.`symbol_id`,
       `markets_trade`.`timestamp`,
       `markets_trade`.`price`,
       `markets_trade`.`volume`
FROM `markets_trade`
WHERE `markets_trade`.`symbol_id` = bitmarketEUR
ORDER BY `markets_trade`.`timestamp` DESC, `markets_trade`.`id` DESC LIMIT 1

SELECT `markets_trade`.`id`,
       `markets_trade`.`symbol_id`,
       `markets_trade`.`timestamp`,
       `markets_trade`.`price`,
       `markets_trade`.`volume`
FROM `markets_trade`
WHERE (`markets_trade`.`symbol_id` = bitmarketEUR
       AND `markets_trade`.`timestamp` >= 1305072000)
ORDER BY `markets_trade`.`timestamp` ASC, `markets_trade`.`id` DESC LIMIT 1

SELECT `markets_trade`.`id`,
       `markets_trade`.`symbol_id`,
       `markets_trade`.`timestamp`,
       `markets_trade`.`price`,
       `markets_trade`.`volume`
FROM `markets_trade`
WHERE (`markets_trade`.`symbol_id` = bitmarketEUR
       AND `markets_trade`.`timestamp` <= 1305072000)
ORDER BY `markets_trade`.`timestamp` DESC, `markets_trade`.`id` DESC LIMIT 1

select min(price) as low, max(price) as high, sum(volume) as volume, sum(volume*price) as cvolume, count(id)
from markets_trade
where timestamp >= 1305072000
  and symbol_id = bitmarketEUR
order by timestamp desc, id desc;

SELECT `markets_order`.`timestamp`
FROM `markets_order`
WHERE `markets_order`.`symbol_id` = bitmarketEUR
ORDER BY `markets_order`.`timestamp` DESC LIMIT 1

SELECT `markets_order`.`price`
FROM `markets_order`
WHERE (`markets_order`.`symbol_id` = bitmarketEUR
       AND `markets_order`.`timestamp` = 1305198842
       AND `markets_order`.`order` = b)
ORDER BY `markets_order`.`price` DESC LIMIT 1

SELECT `markets_order`.`price`
FROM `markets_order`
WHERE (`markets_order`.`symbol_id` = bitmarketEUR
       AND `markets_order`.`timestamp` = 1305198842
       AND `markets_order`.`order` = a)
ORDER BY `markets_order`.`price` ASC LIMIT 1

SELECT `markets_currency`.`code`,
       `markets_currency`.`symbol`
FROM `markets_currency`
WHERE `markets_currency`.`code` = EUR

SELECT `markets_trade`.`id`,
       `markets_trade`.`symbol_id`,
       `markets_trade`.`timestamp`,
       `markets_trade`.`price`,
       `markets_trade`.`volume`
FROM `markets_trade`
WHERE `markets_trade`.`symbol_id` = bitmarketGBP
ORDER BY `markets_trade`.`timestamp` DESC, `markets_trade`.`id` DESC LIMIT 1

SELECT `markets_trade`.`id`,
       `markets_trade`.`symbol_id`,
       `markets_trade`.`timestamp`,
       `markets_trade`.`price`,
       `markets_trade`.`volume`
FROM `markets_trade`
WHERE (`markets_trade`.`symbol_id` = bitmarketGBP
       AND `markets_trade`.`timestamp` >= 1304985600)
ORDER BY `markets_trade`.`timestamp` ASC, `markets_trade`.`id` DESC LIMIT 1

SELECT `markets_trade`.`id`,
       `markets_trade`.`symbol_id`,
       `markets_trade`.`timestamp`,
       `markets_trade`.`price`,
       `markets_trade`.`volume`
FROM `markets_trade`
WHERE (`markets_trade`.`symbol_id` = bitmarketGBP
       AND `markets_trade`.`timestamp` <= 1304985600)
ORDER BY `markets_trade`.`timestamp` DESC, `markets_trade`.`id` DESC LIMIT 1

select min(price) as low, max(price) as high, sum(volume) as volume, sum(volume*price) as cvolume, count(id)
from markets_trade
where timestamp >= 1304985600
  and symbol_id = bitmarketGBP
order by timestamp desc, id desc;

SELECT `markets_order`.`timestamp`
FROM `markets_order`
WHERE `markets_order`.`symbol_id` = bitmarketGBP
ORDER BY `markets_order`.`timestamp` DESC LIMIT 1

SELECT `markets_order`.`price`
FROM `markets_order`
WHERE (`markets_order`.`symbol_id` = bitmarketGBP
       AND `markets_order`.`timestamp` = 1305187107
       AND `markets_order`.`order` = b)
ORDER BY `markets_order`.`price` DESC LIMIT 1

SELECT `markets_order`.`price`
FROM `markets_order`
WHERE (`markets_order`.`symbol_id` = bitmarketGBP
       AND `markets_order`.`timestamp` = 1305187107
       AND `markets_order`.`order` = a)
ORDER BY `markets_order`.`price` ASC LIMIT 1

SELECT `markets_currency`.`code`,
       `markets_currency`.`symbol`
FROM `markets_currency`
WHERE `markets_currency`.`code` = GBP

SELECT `markets_trade`.`id`,
       `markets_trade`.`symbol_id`,
       `markets_trade`.`timestamp`,
       `markets_trade`.`price`,
       `markets_trade`.`volume`
FROM `markets_trade`
WHERE `markets_trade`.`symbol_id` = bitmarketPLN
ORDER BY `markets_trade`.`timestamp` DESC, `markets_trade`.`id` DESC LIMIT 1

SELECT `markets_trade`.`id`,
       `markets_trade`.`symbol_id`,
       `markets_trade`.`timestamp`,
       `markets_trade`.`price`,
       `markets_trade`.`volume`
FROM `markets_trade`
WHERE (`markets_trade`.`symbol_id` = bitmarketPLN
       AND `markets_trade`.`timestamp` >= 1303344000)
ORDER BY `markets_trade`.`timestamp` ASC, `markets_trade`.`id` DESC LIMIT 1

SELECT `markets_trade`.`id`,
       `markets_trade`.`symbol_id`,
       `markets_trade`.`timestamp`,
       `markets_trade`.`price`,
       `markets_trade`.`volume`
FROM `markets_trade`
WHERE (`markets_trade`.`symbol_id` = bitmarketPLN
       AND `markets_trade`.`timestamp` <= 1303344000)
ORDER BY `markets_trade`.`timestamp` DESC, `markets_trade`.`id` DESC LIMIT 1

select min(price) as low, max(price) as high, sum(volume) as volume, sum(volume*price) as cvolume, count(id)
from markets_trade
where timestamp >= 1303344000
  and symbol_id = bitmarketPLN
order by timestamp desc, id desc;

SELECT `markets_order`.`timestamp`
FROM `markets_order`
WHERE `markets_order`.`symbol_id` = bitmarketPLN
ORDER BY `markets_order`.`timestamp` DESC LIMIT 1

SELECT `markets_order`.`price`
FROM `markets_order`
WHERE (`markets_order`.`symbol_id` = bitmarketPLN
       AND `markets_order`.`timestamp` = 1305187107
       AND `markets_order`.`order` = b)
ORDER BY `markets_order`.`price` DESC LIMIT 1

SELECT `markets_order`.`price`
FROM `markets_order`
WHERE (`markets_order`.`symbol_id` = bitmarketPLN
       AND `markets_order`.`timestamp` = 1305187107
       AND `markets_order`.`order` = a)
ORDER BY `markets_order`.`price` ASC LIMIT 1

SELECT `markets_currency`.`code`,
       `markets_currency`.`symbol`
FROM `markets_currency`
WHERE `markets_currency`.`code` = PLN

SELECT `markets_trade`.`id`,
       `markets_trade`.`symbol_id`,
       `markets_trade`.`timestamp`,
       `markets_trade`.`price`,
       `markets_trade`.`volume`
FROM `markets_trade`
WHERE `markets_trade`.`symbol_id` = virwoxSLL
ORDER BY `markets_trade`.`timestamp` DESC, `markets_trade`.`id` DESC LIMIT 1

SELECT `markets_trade`.`id`,
       `markets_trade`.`symbol_id`,
       `markets_trade`.`timestamp`,
       `markets_trade`.`price`,
       `markets_trade`.`volume`
FROM `markets_trade`
WHERE (`markets_trade`.`symbol_id` = virwoxSLL
       AND `markets_trade`.`timestamp` >= 1305158400)
ORDER BY `markets_trade`.`timestamp` ASC, `markets_trade`.`id` DESC LIMIT 1

SELECT `markets_trade`.`id`,
       `markets_trade`.`symbol_id`,
       `markets_trade`.`timestamp`,
       `markets_trade`.`price`,
       `markets_trade`.`volume`
FROM `markets_trade`
WHERE (`markets_trade`.`symbol_id` = virwoxSLL
       AND `markets_trade`.`timestamp` <= 1305158400)
ORDER BY `markets_trade`.`timestamp` DESC, `markets_trade`.`id` DESC LIMIT 1

select min(price) as low, max(price) as high, sum(volume) as volume, sum(volume*price) as cvolume, count(id)
from markets_trade
where timestamp >= 1305158400
  and symbol_id = virwoxSLL
order by timestamp desc, id desc;

SELECT `markets_order`.`timestamp`
FROM `markets_order`
WHERE `markets_order`.`symbol_id` = virwoxSLL
ORDER BY `markets_order`.`timestamp` DESC LIMIT 1

SELECT `markets_order`.`price`
FROM `markets_order`
WHERE (`markets_order`.`symbol_id` = virwoxSLL
       AND `markets_order`.`timestamp` = 1305198840
       AND `markets_order`.`order` = b)
ORDER BY `markets_order`.`price` DESC LIMIT 1

SELECT `markets_order`.`price`
FROM `markets_order`
WHERE (`markets_order`.`symbol_id` = virwoxSLL
       AND `markets_order`.`timestamp` = 1305198840