Sha256: 9d6fcc8a886a7185630a7d6605139bb8aeece2dfe4dc5355a41338972381e931

Contents?: true

Size: 1.24 KB

Versions: 44

Compression:

Stored size: 1.24 KB

Contents

require_dependency "ishapi/application_controller"

module Ishapi
  class OptionPriceItemsController < ApplicationController

    # before_action :soft_check_long_term_token, only: [ :show ]
    # before_action :check_jwt

    ## params: symbol, begin_at, end_at
    def view
      authorize! :view_chain, ::Iro::OptionPriceItem.new
      @opis = ::Iro::OptionPriceItem.where({ ticker: params[:symbol]
      }).where( "timestamp BETWEEN ? and ? ", params[:begin_at], params[:end_at]
      ).limit(100)
    end

    def view_by_symbol
      authorize! :view_chain, ::Iro::OptionPriceItem.new
      @opis = ::Iro::OptionPriceItem.where({ symbol: params[:symbol]
      }).limit(100)
      render 'view'
    end

  end
end

## this is in scratchpadjs / done
=begin

SELECT symbol, bid, ask, MAX(`timestamp`) as a
FROM iwa_option_price_items
where symbol = "GME_021023P20"
GROUP BY symbol, bid, ask, DATE(`timestamp`), HOUR(`timestamp`), Minute(`timestamp`)
order by a desc;

SELECT symbol, MAX(`timestamp`) as a
FROM iwa_option_price_items
where symbol = "GME_021023P20"
GROUP BY symbol, DATE(`timestamp`), HOUR(`timestamp`), Minute(`timestamp`)
order by a desc;

select timestamp as a FROM iwa_option_price_items
where symbol = "GME_021023P20"
order by a desc;

=end


Version data entries

44 entries across 44 versions & 1 rubygems

Version Path
ishapi-0.1.8.265 app/controllers/ishapi/option_price_items_controller.rb
ishapi-0.1.8.264 app/controllers/ishapi/option_price_items_controller.rb
ishapi-0.1.8.263 app/controllers/ishapi/option_price_items_controller.rb
ishapi-0.1.8.262 app/controllers/ishapi/option_price_items_controller.rb
ishapi-0.1.8.261 app/controllers/ishapi/option_price_items_controller.rb
ishapi-0.1.8.260 app/controllers/ishapi/option_price_items_controller.rb
ishapi-0.1.8.259 app/controllers/ishapi/option_price_items_controller.rb
ishapi-0.1.8.256 app/controllers/ishapi/option_price_items_controller.rb
ishapi-0.1.8.254 app/controllers/ishapi/option_price_items_controller.rb
ishapi-0.1.8.253 app/controllers/ishapi/option_price_items_controller.rb
ishapi-0.1.8.251 app/controllers/ishapi/option_price_items_controller.rb
ishapi-0.1.8.250 app/controllers/ishapi/option_price_items_controller.rb
ishapi-0.1.8.249 app/controllers/ishapi/option_price_items_controller.rb
ishapi-0.1.8.248 app/controllers/ishapi/option_price_items_controller.rb
ishapi-0.1.8.247 app/controllers/ishapi/option_price_items_controller.rb
ishapi-0.1.8.246 app/controllers/ishapi/option_price_items_controller.rb
ishapi-0.1.8.244 app/controllers/ishapi/option_price_items_controller.rb
ishapi-0.1.8.243 app/controllers/ishapi/option_price_items_controller.rb
ishapi-0.1.8.242 app/controllers/ishapi/option_price_items_controller.rb
ishapi-0.1.8.241 app/controllers/ishapi/option_price_items_controller.rb