Ticker    Date        price
----------------------------
ABC       01/01/13    100.00
ABC       01/02/13    101.50
ABC       01/03/13     99.80
ABC       01/04/13     95.50
ABC       01/05/13     78.00
XYZ       01/01/13     11.50
XYZ       01/02/13     12.10
XYZ       01/02/13     12.10
XYZ       01/03/13     17.15
XYZ       01/04/13     14.10
XYZ       01/05/13     15.55

SELECT
    Date,
    Price,
    COUNT([Ticker])
FROM
    (SELECT DISTINCT
         Ticker, Date
     FROM
         [Coinmarketcap].[dbo].[temp]
     WHERE
         COUNT[Ticker] > 1) AS dt

SELECT Ticker, Date, Price, COUNT(*)
FROM [Coinmarketcap].[dbo].[temp] t
GROUP BY Ticker, Date, Price
HAVING COUNT(*) > 1;