date = Time.now
record_i_want = Price.where(date => :start_date .. :end_date)

Price.where(:date => start_date..end_date)

SELECT `prices`.* FROM `prices` WHERE (`prices`.`date` BETWEEN '2014-03-27' AND '2014-03-28')

Price.where(['start_date < ? AND end_date > ?', date, date])

Price.where([":date >= start_date AND :date <= end_date", {date: Date.today})

Price.where([":date >= start_date AND :date <= end_date", {date: Date.today}).first

":date >= start_date AND :date < end_date"

def get_record_by_date(date)
  Price.where([start_date.to_i < date.to_i] && [end_date.to_i > date.to_i])
end