Sha256: aeefff07f35ee66ac7e956aa457a765a2c6cd4e36ed800ea9bdd0b9b4038898a

Contents?: true

Size: 1.47 KB

Versions: 7

Compression:

Stored size: 1.47 KB

Contents

class CreateIroPriceItem < ActiveRecord::Migration[6.1]
  def change
    create_table :iro_price_items do |t|

      t.string "putCall", index: true
      t.string "symbol", index: true
      t.string "description"
      t.string "exchangeName"
      t.string "bidAskSize"
      t.string "expirationType"
      t.float "bid"
      t.float "ask"
      t.float "last"
      t.float "mark"
      t.float "lastPrice"
      t.float "highPrice"
      t.float "lowPrice"
      t.float "openPrice"
      t.float "closePrice"
      t.float "netChange"
      t.float "volatility"
      t.float "delta"
      t.float "gamma"
      t.float "theta"
      t.float "vega"
      t.float "rho"
      t.float "timeValue"
      t.float "theoreticalOptionValue"
      t.float "theoreticalVolatility"
      t.float "strikePrice"
      t.float "percentChange"
      t.float "markChange"
      t.float "markPercentChange"
      t.float "intrinsicValue"
      t.float "multiplier"
      t.integer "bidSize"
      t.integer "askSize"
      t.bigint "totalVolume"
      t.integer "openInterest"
      t.integer "daysToExpiration"
      t.bigint "tradeTimeInLong"
      t.bigint "quoteTimeInLong"
      t.bigint "expirationDate", index: true
      t.bigint "lastTradingDay"
      t.boolean "inTheMoney"
      t.boolean "nonStandard"
      t.boolean "isIndexOption"
      t.date "tradeDate"
      t.string "interval"
      t.string "ticker", limit: 32, index: true
      t.timestamp "timestamp"

      t.timestamps
    end
  end
end

Version data entries

7 entries across 7 versions & 1 rubygems

Version Path
iron_warbler-2.0.7.7 db/migrate/20231220223730_create_iro_price_item.rb
iron_warbler-2.0.7.6 db/migrate/20231220223730_create_iro_price_item.rb
iron_warbler-2.0.7.5 db/migrate/20231220223730_create_iro_price_item.rb
iron_warbler-2.0.7.4 db/migrate/20231220223730_create_iro_price_item.rb
iron_warbler-2.0.7.3 db/migrate/20231220223730_create_iro_price_item.rb
iron_warbler-2.0.7.2 db/migrate/20231220223730_create_iro_price_item.rb
iron_warbler-2.0.7.1 db/migrate/20231220223730_create_iro_price_item.rb