Alpari SQL

alpari.sql

-- scheme
CREATE TABLE `ticks` (
  `id` int(10) UNSIGNED NOT NULL,
  `symbol` varchar(255) NOT NULL,
  `date` date NOT NULL,
  `value` decimal(3,2) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

INSERT INTO `ticks` (`id`, `symbol`, `date`, `value`) VALUES
(1, 'EURUSD', '2014-01-10', '1.34'),
(2, 'GBPUSD', '2014-01-10', '1.67'),
(3, 'EURUSD', '2014-01-09', '1.31'),
(4, 'NZDUSD', '2014-01-09', '0.83'),
(5, 'RUSUSD', '2016-08-23', '1.11'),
(6, 'RUSUSD', '2016-08-24', '1.12'),
(7, 'USDRUS', '2016-08-23', '1.11'),
(8, 'USDRUS', '2016-08-24', '1.12'),
(9, 'USDRUS', '2016-08-24', '1.12'),
(10, 'USDRUS', '2016-08-24', '1.12'),
(11, 'USDRUS', '2016-08-25', '1.13');

ALTER TABLE `ticks`
  ADD PRIMARY KEY (`id`);

ALTER TABLE `ticks`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;
  
  

-- sql
SELECT t.symbol, t.value FROM (
    SELECT DISTINCT symbol, value FROM ticks ORDER BY date DESC
) AS t
GROUP BY t.symbol ORDER BY NULL;