| 1 |
select
* from ticker1 where totalvol > 5000 and price > prevprice and bid
> (bid+(price-bid)*.95) and price > 1 and price < 45 |
|
|
|
|
| 2 |
select
* from Ticker1 where Ticker1.price - Ticker1.bid < .05*Ticker1.bid
and ticker1.prevprice < ticker1.price and Ticker1.price > 5 and
Ticker1.price - Ticker1.prevprice <.05*ticker1.price and askminusbid
> 1 and ticker1.price < 45 |
|
|
|
|
| 3 |
select
* from ticker1 where ticker1.price < ((.5*ticker1.askminusbid) +
ticker1.bid) |
|
|
|
|
| 4 |
select
* from ticker1 where ((price-openprice)/openprice) >.75 and ((openprice
-low)/Openprice)*100<.5 |
|
|
|
|
| 5 |
select
* from Ticker1 where Ticker1.price - Ticker1.bid < .05*Ticker1.bid
and ticker1.prevprice < ticker1.price and Ticker1.price > 5 and
Ticker1.price - Ticker1.prevprice <.05*ticker1.price and askminusbid
> 1 |
|
|
|
|
| 6 |
select
* from Ticker1 where Ticker1.price - Ticker1.bid < .05*Ticker1.bid
and ticker1.prevprice < ticker1.price and Ticker1.price > 5 and
Ticker1.price - Ticker1.prevprice <.05*ticker1.price and and totalvol
> 8500 and askminusbid > .74 and price < 46 |
|
|
|
|
|
5008 |
select * from ticker..ticker1 where ticker1.price <
((.42*ticker1.askminusbid) + ticker1.bid) and openprice > 0 and avgvol > 5000
and prevprice < priceand totalvol > 5*avgvol |
|
|
|
|