data.csv

query.rb

scope = Listing.where.not(status: :draft).
  where(year: 1971..2021).
  where(price_currency: "USD").
  where(price_cents: 0..1_500_000_00).
  where(loa: 0..20). # meters
  where(:created_at => 1.year.ago..Time.now); scope.count

scope.find_each do |l|
  puts [
    Date.today.year - l.year,
    l.loa.convert_to( :ft).value.round,
    l.price_cents / 100
  ].join(',') if l.loa && l.year && l.price_cents
end; true