(stocks) FOR DATA MINER and REAL GEEK'S (no pseudo i was a geek once)

mysql> select symbol from showbreakouts where volumetimesnormal>3 and (typeofbreakout regexp 'upbreak' or typeofbreakout regexp 'rsibreak');
+--------+
symbol
+--------+
ELMG
EVEP
IX
ACFN
RGC
TRLG
VIV
OSBC
AHCI
EDAC
NGSX
STMP
ZOLL
+--------+

select symbol from showbreakouts where volumetimesnormal>1 and (typeofbreakout regexp 'rsibreak');
+--------+
symbol
+--------+
AMN
APAC
BLUD
BTH
CNS
CNU
ELMG
EQT
LVB
NLC
PFBC
TLVT
VRTS
AACC
ARJ
ATHN
CEP
CROX
CSR
DLA
DTLK
EVEP
FEED
FMX
HK
HSII
IX
LGND
LXK
OCNFD
PRS
RGR
SFN
SOHU
USBI
VEC
XTXI
AHCI
BMRC
EDAC
GST
MHH
NGSX
QCRH
SCHP
SIF
SONE
STMP
ZOLL
+--------+

mysql> select symbol from showbreakouts where volumetimesnormal>3 and (typeofbreakout regexp 'rsibreak');
+--------+
symbol
+--------+
ELMG
EVEP
IX
AHCI
EDAC
NGSX
STMP
ZOLL
+--------+
8 rows in set (0.16 sec)

mysql> select symbol from showbreakouts where volumetimesnormal>1 and (typeofbreakout regexp 'rsibreak');
+--------+
symbol
+--------+
AMN
APAC
BLUD
BTH
CNS
CNU
ELMG
EQT
LVB
NLC
PFBC
TLVT
VRTS
AACC
ARJ
ATHN
CEP
CROX
CSR
DLA
DTLK
EVEP
FEED
FMX
HK
HSII
IX
LGND
LXK
OCNFD
PRS
RGR
SFN
SOHU
USBI
VEC
XTXI
AHCI
BMRC
EDAC
GST
MHH
NGSX
QCRH
SCHP
SIF
SONE
STMP
ZOLL
+--------+
49 rows in set (0.16 sec)

mysql> select symbol from showbreakouts where volumetimesnormal>1 and (typeofbreakout regexp 'up');
+--------+
symbol
+--------+
ACFN
AWRE
EEFT
EM
GNC
HURN
ITE
JNY
LOV
MDCA
MSHL
RGC
RNOW
SCBT
SGC
SKX
TRLG
VIV
VOD
VRNG
LIZ
OSBC
AHCI
BMRC
EDAC
GST
MHH
NGSX
QCRH
SCHP
SIF
SONE
STMP
ZOLL
+--------+
34 rows in set (0.15 sec)

mysql> select symbol from showbreakouts where volumetimesnormal>5 and (typeofbreakout regexp 'up');
+--------+
symbol
+--------+
ACFN
TRLG
AHCI
EDAC
STMP
ZOLL
+--------+
6 rows in set (0.16 sec)

mysql> select symbol from showbreakouts where volumetimesnormal>5;
+--------+
symbol
+--------+
WCG
AGP
AMCC
CTCT
DRIV
GOL
HIX
MILL
NLY
REM
STEC
TNAV
VE
VPRT
WHRT
WSTG
ABAX
GIGA
BAYN
CAPS
RAND
RSYS
SCHO
IX
RLD
UPI
ACFN
TRLG
AHCI
EDAC
STMP
ZOLL
+--------+
32 rows in set (0.16 sec)

mysql> select symbol from showbreakouts where volumetimesnormal>1;
+--------+
symbol
+--------+
ABC
ACP
ACW
AEPI
AGNC
AHC
AI
ALM
AON
ARI
AVL
AVP
AZN
BAF
BHD
BHE
BKCC
BME
BNS
BZH
CAW
CCO
CHDX
CHINA
CHRW
CMP
CMS
CPO
CPP
CSBK
CUBA
DG
EAD
ENA
EOS
EPIQ
EQS
ERC
ETV
ETW
EVJ
FCBC
FDP
FEIC
FGE
FO
FVE
GAB
GAIA
GB
GEF
GFY
GPM
GRF
GSAT
HIF
HOLX
HYB
IART
IDG
IHC
IIC
IND
INTL
INZ
IVC
JAH
JDAS
JEC
KHI
LOW
LPL
LRCX
LXU
MASI
MCGC
MD
MFT
MRH
MRT
MSCI
MWW
NEE
NHS
NQI
NQU
NUVA
NVE
NVG
NXZ
OI
OPXT
PCRX
PFD
PFN
PGF
PH
PKI
PLPC
PNNT
PNW
PSEM
PVTB
QLGC
REED
SAI
SEAC
SEH
SIEB
SR
TEI
TICC
TLM
TRR
TRV
UHS
UTI
VCI
VKL
VRSN
WCG
WOOF
WPO
WRB
WWVY
YAVY
ZMH
ASP
CYS
DVOX
ETG
EXAC
FT
HSWI
IGR
MEN
MMT
MRF
MRK
MTS
SBX
SMOD
AB
ACM
ACOM
ACPW
ADPI
AEM
AGP
AHT
AIT
AKAM
ALR
ALU
AMCC
ASPS
BIO
BMC
BRC
BSFT
BSL
CBE
CCMP
CEV
CHUX
CII
CKP
CLH
CLWR
CMO
COLM
COSI
CTCT
CVGI
CVH
CYTR
DEX
DRIV
DUF
EVF
EVR
FBC
FNFG
FRA
FRB
FSC
GDF
GGG
GIL
GOL
HCA
HGR
HIK
HIX
HLIT
HRC
HRS
HSC
HTGC
HTM
HTS
HUM
HW
HWBK
HYF
HYV
IBKC
ICAD
IFSIA
IHS
IPG
IPHI
ISTA
ITRI
ITW
JNPR
KMM
KMR
KST
KVHI
LEG
LIFE
LTXC
MANT
MILL
MYGN
NATI
NIF
NLY
NM
NMRX
NTGR
NXI
NYB
OCLR
OIIM
OKSB
OSTK
PBNY
PFCB
PLL
PNM
PPT
PRXL
PSSI
RBC
RCL
REM
RMTR
ROK
RTEC
S
SAL
SCOR
SHBI
SLRC
SPF
SPH
SPRT
SRCL
SSYS
STAA
STEC
TCAP
TDS
TIGR
TNAV
TNCC
TQNT
UFS
UIS
USTR
UVE
VALU
VAR
VE
VIM
VPRT
WHRT
WLP
WM
WSTG
ABAX
GTY
MAIN
NNB
ANAD
ANDR
BBL
BDT
BFY
CAFI
CERS
CMK
COST
CSU
CXE
CYN
CZA
DFG
DIGI
DOV
DRL
DSM
ELY
EMC
EOI
ESMC
ESSA
ETO
EVBN
FDI
FONR
GAIN
GCAP
GDO
GFIG
GIGA
GLBZ
GLU
GMTC
GRVY
GSX
HBNK
HHS
HIS
JOB
KEY
LEO
LPSB
MCN
MEA
MFD
MHO
MQY
MVC
NC
NINE
NLSN
NOOF
NQN
NSR
NURO
NXN
PCBS
PFBI
PMX
PXLW
RMBS
RNWK
SONS
SWX
TAXI
UBCP
VOQ
WTR
BAYN
BIL
CAPS
CSE
EDUC
ELNK
FCLF
IRE
NVGN
PACR
PSO
RAND
RSYS
SCHO
SPPR
STBA
TOWR
ULGX
WAYN
WIA
AMN
APAC
BLUD
BTH
CNS
CNU
ELMG
EQT
LVB
NLC
PFBC
TLVT
VRTS
AACC
ARJ
ATHN
CEP
CROX
CSR
DLA
DTLK
EVEP
FEED
FMX
HK
HSII
IX
LGND
LXK
OCNFD
PRS
RGR
SFN
SOHU
USBI
VEC
XTXI
AAR
ABH
ABVT
ACFC
ACMR
ACO
ADBE
ADTN
ADVS
AEB
AEIS
AKS
ALSK
AMAG
ARAY
ATSG
AVID
AVY
AWI
AYI
BABY
BAK
BCR
BRO
BTN
CACI
CATY
CHH
CNSL
CVC
CVTI
DDIC
DMD
DTSI
ECH
EIM
EMR
EW
F
FDML
FGP
FII
FLIR
FMAR
FORR
FTNT
GEO
GPRO
HA
HDB
HIMX
HNI
HNT
HS
HSIC
IR
JBLU
KBH
KYE
LFL
LFUS
LNCR
LUV
MAS
MERU
MMM
MOH
MRO
MSM
MTG
MTOR
MXL
NABI
NBS
NKTR
NOC
OKS
OMI
ORI
ORLY
ORRF
OSK
PAYX
PCAR
PEP
PLCM
PSEC
PSS
RLD
SBRA
SEIC
SFG
SFL
SHW
SID
SJI
SMCI
SNA
SNHY
SOCB
SON
SPB
SRI
STM
SUNH
SWC
SWY
TAM
TECH
TKR
TPC
TTC
UPI
USG
USM
UTIW
VDSI
WHR
WIN
WNC
WSO
WSTL
KMP
AMOV
AMR
LCC
SBLK
TGI
TMK
UAL
ACFN
AWRE
EEFT
EM
GNC
HURN
ITE
JNY
LOV
MDCA
MSHL
RGC
RNOW
SCBT
SGC
SKX
TRLG
VIV
VOD
VRNG
LIZ
OSBC
AHCI
BMRC
EDAC
GST
MHH
NGSX
QCRH
SCHP
SIF
SONE
STMP
ZOLL
+--------+
577 rows in set (0.30 sec)

mysql> select symbol from showbreakouts where volumetimesnormal>10;
+--------+
symbol
+--------+
HIX
MILL
VPRT
GIGA
CAPS
RSYS
SCHO
IX
ACFN
AHCI
+--------+